{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["الحركه","الارصده","ورقة3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"الحركه","index":0,"n_rows":177,"n_cols":19,"rows_kept":177,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"سعودي","دولار","درهم","سعودي","دولار","درهم"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ايرادات",{"$f":"SUMIFS(الجدول1[مدين],الجدول1[الحساب],M3,الجدول1[العملة],N2)","v":0},{"$f":"SUMIFS(الجدول1[مدين],الجدول1[الحساب],M3,الجدول1[العملة],O2)","v":0},{"$f":"SUMIFS(الجدول1[مدين],الجدول1[الحساب],M3,الجدول1[العملة],P2)","v":0},{"$f":"SUMIFS(الجدول1[دائن],الجدول1[الحساب],M3,الجدول1[العملة],Q2)","v":92030},{"$f":"SUMIFS(الجدول1[دائن],الجدول1[الحساب],M3,الجدول1[العملة],R2)","v":1730000},{"$f":"SUMIFS(الجدول1[دائن],الجدول1[الحساب],M3,الجدول1[العملة],S2)","v":0}]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(9,الجدول1[مدين])","v":1818830},{"$f":"SUBTOTAL(9,الجدول1[دائن])","v":1822030},null,null,null,null,"احمد",{"$f":"SUMIFS(الجدول1[مدين],الجدول1[الحساب],M4,الجدول1[العملة],N2)","v":88830},{"$f":"SUMIFS(الجدول1[مدين],الجدول1[الحساب],M4,الجدول1[العملة],O2)","v":1730000},{"$f":"SUMIFS(الجدول1[مدين],الجدول1[الحساب],M4,الجدول1[العملة],P2)","v":0},{"$f":"SUMIFS(الجدول1[دائن],الجدول1[الحساب],M4,الجدول1[العملة],Q2)","v":0},{"$f":"SUMIFS(الجدول1[دائن],الجدول1[الحساب],M4,الجدول1[العملة],R2)","v":0},{"$f":"SUMIFS(الجدول1[دائن],الجدول1[الحساب],M4,الجدول1[العملة],S2)","v":0}]
[null,"الرقم","التاريخ","نوع المستند","البيان","العملة","مدين","دائن","الحساب"]
[null,1,"2020-02-29","رصيد افتتاحي",null,"سعودي",null,1200,"ايرادات"]
[null,1,"2020-03-01","فاتورة مبيعات",null,"سعودي",null,300,"ايرادات"]
[null,1,"2020-03-01","فاتورة مبيعات",null,"سعودي",300,null,"احمد"]
[null,2,"2020-03-01","فاتورة مبيعات",null,"سعودي",null,300,"ايرادات"]
[null,2,"2020-03-01","فاتورة مبيعات",null,"سعودي",300,null,"احمد"]
[null,1,"2020-03-01","فاتورة شراء",null,"سعودي",null,130,"ايرادات"]
[null,1,"2020-03-01","فاتورة شراء",null,"سعودي",130,null,"احمد"]
[null,2,"2020-03-01","فاتورة شراء",null,"سعودي",null,130,"ايرادات"]
[null,2,"2020-03-01","فاتورة شراء",null,"سعودي",130,null,"احمد"]
[null,16,"2020-03-01","فاتورة مبيعات",null,"سعودي",null,1600,"ايرادات"]
[null,16,"2020-03-01","فاتورة مبيعات",null,"سعودي",1600,null,"احمد"]
[null,16,"2020-03-01","فاتورة شراء",null,"سعودي",null,0,"احمد"]
[null,16,"2020-03-01","فاتورة شراء",null,"سعودي",0,null,"احمد"]
[null,17,"2020-03-01","فاتورة مبيعات",null,"سعودي",null,1450,"ايرادات"]
[null,17,"2020-03-01","فاتورة مبيعات",null,"سعودي",1450,null,"احمد"]
[null,18,"2020-03-01","فاتورة مبيعات",null,"سعودي",null,1450,"ايرادات"]
[null,18,"2020-03-01","فاتورة مبيعات",null,"سعودي",1450,null,"احمد"]
[null,17,"2020-03-01","فاتورة شراء",null,"سعودي",null,1300,"ايرادات"]
[null,17,"2020-03-01","فاتورة شراء",null,"سعودي",1300,null,"احمد"]
[null,18,"2020-03-01","فاتورة شراء",null,"سعودي",null,1300,"ايرادات"]
[null,18,"2020-03-01","فاتورة شراء",null,"سعودي",1300,null,"احمد"]
[null,56,"2020-03-01","فاتورة مبيعات",null,"سعودي",null,3200,"ايرادات"]
[null,56,"2020-03-01","فاتورة مبيعات",null,"سعودي",3200,null,"احمد"]
[null,57,"2020-03-01","فاتورة مبيعات",null,"سعودي",null,4200,"ايرادات"]
[null,57,"2020-03-01","فاتورة مبيعات",null,"سعودي",4200,null,"احمد"]
[null,58,"2020-03-01","فاتورة مبيعات",null,"سعودي",null,1600,"ايرادات"]
[null,58,"2020-03-01","فاتورة مبيعات",null,"سعودي",1600,null,"احمد"]
[null,59,"2020-03-01","فاتورة مبيعات",null,"سعودي",null,3200,"ايرادات"]
[null,59,"2020-03-01","فاتورة مبيعات",null,"سعودي",3200,null,"احمد"]
[null,1,"2020-03-01","سند قبض",null,"سعودي",0,0,"احمد"]
[null,1,"2020-03-01","سند قبض",null,"سعودي",0,0,"احمد"]
[null,60,"2020-03-01","فاتورة مبيعات",null,"سعودي",null,2900,"ايرادات"]
[null,60,"2020-03-01","فاتورة مبيعات",null,"سعودي",2900,null,"احمد"]
[null,62,"2020-03-01","فاتورة مبيعات",null,"دولار",null,170000,"ايرادات"]
[null,62,"2020-03-01","فاتورة مبيعات",null,"دولار",170000,null,"احمد"]
[null,5,"2020-03-01","سند قبض",null,"دولار",0,0,"احمد"]
[null,5,"2020-03-01","سند قبض",null,"دولار",0,0,"احمد"]
[null,65,"2020-03-01","فاتورة مبيعات",null,"سعودي",null,1200,"ايرادات"]
[null,65,"2020-03-01","فاتورة مبيعات",null,"سعودي",1200,null,"احمد"]
[null,66,"2020-03-01","فاتورة مبيعات",null,"سعودي",null,1200,"ايرادات"]
[null,66,"2020-03-01","فاتورة مبيعات",null,"سعودي",1200,null,"احمد"]
[null,69,"2020-03-01","فاتورة مبيعات",null,"سعودي",null,1200,"ايرادات"]
[null,69,"2020-03-01","فاتورة مبيعات",null,"سعودي",1200,null,"احمد"]
[null,70,"2020-03-01","فاتورة مبيعات",null,"سعودي",null,1200,"ايرادات"]
[null,70,"2020-03-01","فاتورة مبيعات",null,"سعودي",1200,null,"احمد"]
[null,71,"2020-03-01","فاتورة مبيعات",null,"سعودي",null,1200,"ايرادات"]
[null,71,"2020-03-01","فاتورة مبيعات",null,"سعودي",1200,null,"احمد"]
[null,72,"2020-03-01","فاتورة مبيعات",null,"سعودي",null,1200,"ايرادات"]
[null,72,"2020-03-01","فاتورة مبيعات",null,"سعودي",1200,null,"احمد"]
[null,62,"2020-03-01","فاتورة شراء",null,"دولار",null,120000,"ايرادات"]
[null,62,"2020-03-01","فاتورة شراء",null,"دولار",120000,null,"احمد"]
[null,63,"2020-03-01","فاتورة شراء",null,"دولار",null,120000,"ايرادات"]
[null,63,"2020-03-01","فاتورة شراء",null,"دولار",120000,null,"احمد"]
[null,64,"2020-03-01","فاتورة شراء",null,"دولار",null,120000,"ايرادات"]
[null,64,"2020-03-01","فاتورة شراء",null,"دولار",120000,null,"احمد"]
[null,65,"2020-03-01","فاتورة شراء",null,"دولار",null,120000,"ايرادات"]
[null,65,"2020-03-01","فاتورة شراء",null,"دولار",120000,null,"احمد"]
[null,73,"2020-03-01","فاتورة مبيعات",null,"سعودي",null,1100,"ايرادات"]
[null,73,"2020-03-01","فاتورة مبيعات",null,"سعودي",1100,null,"احمد"]
[null,74,"2020-03-01","فاتورة مبيعات",null,"سعودي",null,1000,"ايرادات"]
[null,74,"2020-03-01","فاتورة مبيعات",null,"سعودي",1000,null,"احمد"]
[null,75,"2020-03-01","فاتورة مبيعات",null,"سعودي",null,1000,"ايرادات"]
[null,75,"2020-03-01","فاتورة مبيعات",null,"سعودي",1000,null,"احمد"]
[null,76,"2020-03-01","فاتورة مبيعات",null,"سعودي",null,1000,"ايرادات"]
[null,76,"2020-03-01","فاتورة مبيعات",null,"سعودي",1000,null,"احمد"]
[null,77,"2020-03-01","فاتورة مبيعات",null,"سعودي",null,1000,"ايرادات"]
[null,77,"2020-03-01","فاتورة مبيعات",null,"سعودي",1000,null,"احمد"]
[null,66,"2020-03-01","فاتورة شراء",null,"دولار",null,120000,"ايرادات"]
[null,66,"2020-03-01","فاتورة شراء",null,"دولار",120000,null,"احمد"]
[null,70,"2020-03-01","فاتورة شراء",null,"دولار",null,120000,"ايرادات"]
[null,70,"2020-03-01","فاتورة شراء",null,"دولار",120000,null,"احمد"]
[null,71,"2020-03-01","فاتورة شراء",null,"دولار",null,120000,"ايرادات"]
[null,71,"2020-03-01","فاتورة شراء",null,"دولار",120000,null,"احمد"]
[null,72,"2020-03-01","فاتورة شراء",null,"دولار",null,120000,"ايرادات"]
[null,72,"2020-03-01","فاتورة شراء",null,"دولار",120000,null,"احمد"]
[null,73,"2020-03-01","فاتورة شراء",null,"دولار",null,120000,"ايرادات"]
[null,73,"2020-03-01","فاتورة شراء",null,"دولار",120000,null,"احمد"]
[null,74,"2020-03-01","فاتورة شراء",null,"دولار",null,120000,"ايرادات"]
[null,74,"2020-03-01","فاتورة شراء",null,"دولار",120000,null,"احمد"]
[null,75,"2020-03-01","فاتورة شراء",null,"سعودي",null,2600,"ايرادات"]
[null,75,"2020-03-01","فاتورة شراء",null,"سعودي",2600,null,"احمد"]
[null,76,"2020-03-01","فاتورة شراء",null,"سعودي",null,3900,"ايرادات"]
[null,76,"2020-03-01","فاتورة شراء",null,"سعودي",3900,null,"احمد"]
[null,77,"2020-03-01","فاتورة شراء",null,"سعودي",null,1300,"ايرادات"]
[null,77,"2020-03-01","فاتورة شراء",null,"سعودي",1300,null,"احمد"]
[null,78,"2020-03-01","فاتورة شراء",null,"سعودي",null,2600,"ايرادات"]
[null,78,"2020-03-01","فاتورة شراء",null,"سعودي",2600,null,"احمد"]
[null,87,"2020-03-01","فاتورة مبيعات",null,"سعودي",null,1200,"ايرادات"]
[null,87,"2020-03-01","فاتورة مبيعات",null,"سعودي",1200,null,"احمد"]
[null,88,"2020-03-01","فاتورة مبيعات",null,"سعودي",null,1200,"ايرادات"]
[null,88,"2020-03-01","فاتورة مبيعات",null,"سعودي",1200,null,"احمد"]
[null,85,"2020-03-01","فاتورة شراء",null,"دولار",null,120000,"ايرادات"]
[null,85,"2020-03-01","فاتورة شراء",null,"دولار",120000,null,"احمد"]
[null,86,"2020-03-01","فاتورة شراء",null,"دولار",null,120000,"ايرادات"]
[null,86,"2020-03-01","فاتورة شراء",null,"دولار",120000,null,"احمد"]
[null,87,"2020-03-01","فاتورة شراء",null,"دولار",null,120000,"ايرادات"]
[null,87,"2020-03-01","فاتورة شراء",null,"دولار",120000,null,"احمد"]
[null,8,"2020-03-01","سند صرف",null,"سعودي",130,null,"احمد"]
[null,8,"2020-03-01","سند صرف",null,"سعودي",null,130,"ايرادات"]
[null,9,"2020-03-01","سند صرف",null,"سعودي",130,null,"احمد"]
[null,9,"2020-03-01","سند صرف",null,"سعودي",null,130,"ايرادات"]
[null,10,"2020-03-01","سند صرف",null,"سعودي",25,null,"احمد"]
[null,10,"2020-03-01","سند صرف",null,"سعودي",null,25,"ايرادات"]
[null,9,"2020-03-01","سند قبض",null,"سعودي",null,500,"ايرادات"]
[null,9,"2020-03-01","سند قبض",null,"سعودي",500,null,"احمد"]
[null,19,"2020-03-02","فاتورة مبيعات",null,"سعودي",null,1600,"ايرادات"]
[null,19,"2020-03-02","فاتورة مبيعات",null,"سعودي",1600,null,"احمد"]
[null,20,"2020-03-02","فاتورة مبيعات",null,"سعودي",null,1800,"ايرادات"]
[null,20,"2020-03-02","فاتورة مبيعات",null,"سعودي",1800,null,"احمد"]
[null,19,"2020-03-02","فاتورة شراء",null,"سعودي",null,1300,"ايرادات"]
[null,19,"2020-03-02","فاتورة شراء",null,"سعودي",1300,null,"احمد"]
[null,20,"2020-03-02","فاتورة شراء",null,"سعودي",null,1300,"ايرادات"]
[null,20,"2020-03-02","فاتورة شراء",null,"سعودي",1300,null,"احمد"]
[null,44,"2020-03-02","فاتورة مبيعات",null,"سعودي",null,1150,"ايرادات"]
[null,44,"2020-03-02","فاتورة مبيعات",null,"سعودي",1150,null,"احمد"]
[null,45,"2020-03-02","فاتورة مبيعات",null,"سعودي",null,1150,"ايرادات"]
[null,45,"2020-03-02","فاتورة مبيعات",null,"سعودي",1150,null,"احمد"]
[null,46,"2020-03-02","فاتورة مبيعات",null,"سعودي",null,1150,"ايرادات"]
[null,46,"2020-03-02","فاتورة مبيعات",null,"سعودي",1150,null,"احمد"]
[null,47,"2020-03-02","فاتورة مبيعات",null,"سعودي",null,300,"ايرادات"]
[null,47,"2020-03-02","فاتورة مبيعات",null,"سعودي",300,null,"احمد"]
[null,48,"2020-03-02","فاتورة مبيعات",null,"سعودي",null,600,"ايرادات"]
[null,48,"2020-03-02","فاتورة مبيعات",null,"سعودي",600,null,"احمد"]
[null,49,"2020-03-02","فاتورة مبيعات",null,"سعودي",null,100,"ايرادات"]
[null,49,"2020-03-02","فاتورة مبيعات",null,"سعودي",100,null,"احمد"]
[null,10,"2020-03-02","سند قبض",null,"سعودي",50,null,"احمد"]
[null,10,"2020-03-02","سند قبض",null,"سعودي",null,50,"ايرادات"]
[null,11,"2020-03-02","سند صرف",null,"سعودي",283,null,"احمد"]
[null,11,"2020-03-02","سند صرف",null,"سعودي",null,283,"ايرادات"]
[null,12,"2020-03-02","سند صرف",null,"سعودي",50,null,"احمد"]
[null,12,"2020-03-02","سند صرف",null,"سعودي",null,50,"ايرادات"]
[null,13,"2020-03-02","سند صرف",null,"سعودي",32,null,"احمد"]
[null,13,"2020-03-02","سند صرف",null,"سعودي",null,32,"ايرادات"]
[null,14,"2020-03-02","سند صرف",null,"سعودي",20,null,"احمد"]
[null,14,"2020-03-02","سند صرف",null,"سعودي",null,20,"ايرادات"]
[null,2,"2020-03-03","سند قبض",null,"سعودي",5000,0,"احمد"]
[null,2,"2020-03-03","سند قبض",null,"سعودي",0,5000,"ايرادات"]
[null,3,"2020-03-03","فاتورة مبيعات",null,"سعودي",null,1500,"ايرادات"]
[null,3,"2020-03-03","فاتورة مبيعات",null,"سعودي",1500,null,"احمد"]
[null,4,"2020-03-03","فاتورة مبيعات",null,"سعودي",null,1500,"ايرادات"]
[null,4,"2020-03-03","فاتورة مبيعات",null,"سعودي",1500,null,"احمد"]
[null,3,"2020-03-03","فاتورة شراء",null,"سعودي",null,1300,"ايرادات"]
[null,3,"2020-03-03","فاتورة شراء",null,"سعودي",1300,null,"احمد"]
[null,4,"2020-03-03","فاتورة شراء",null,"سعودي",null,1300,"ايرادات"]
[null,4,"2020-03-03","فاتورة شراء",null,"سعودي",1300,null,"احمد"]
[null,7,"2020-03-03","فاتورة مبيعات",null,"سعودي",null,1600,"ايرادات"]
[null,7,"2020-03-03","فاتورة مبيعات",null,"سعودي",1600,null,"احمد"]
[null,8,"2020-03-03","فاتورة مبيعات",null,"سعودي",null,1600,"ايرادات"]
[null,8,"2020-03-03","فاتورة مبيعات",null,"سعودي",1600,null,"احمد"]
[null,9,"2020-03-03","فاتورة مبيعات",null,"سعودي",null,1400,"ايرادات"]
[null,9,"2020-03-03","فاتورة مبيعات",null,"سعودي",1400,null,"احمد"]
[null,10,"2020-03-03","فاتورة مبيعات",null,"سعودي",null,1400,"ايرادات"]
[null,10,"2020-03-03","فاتورة مبيعات",null,"سعودي",1400,null,"احمد"]
[null,11,"2020-03-03","فاتورة مبيعات",null,"سعودي",null,1400,"ايرادات"]
[null,11,"2020-03-03","فاتورة مبيعات",null,"سعودي",1400,null,"احمد"]
[null,8,"2020-03-03","فاتورة شراء",null,"سعودي",null,1300,"ايرادات"]
[null,8,"2020-03-03","فاتورة شراء",null,"سعودي",1300,null,"احمد"]
[null,9,"2020-03-03","فاتورة شراء",null,"سعودي",null,1300,"ايرادات"]
[null,9,"2020-03-03","فاتورة شراء",null,"سعودي",1300,null,"احمد"]
[null,10,"2020-03-03","فاتورة شراء",null,"سعودي",null,1300,"ايرادات"]
[null,10,"2020-03-03","فاتورة شراء",null,"سعودي",1300,null,"احمد"]
[null,11,"2020-03-03","فاتورة شراء",null,"سعودي",null,1300,"ايرادات"]
[null,11,"2020-03-03","فاتورة شراء",null,"سعودي",1300,null,"احمد"]
[null,12,"2020-03-03","فاتورة مبيعات",null,"سعودي",null,1600,"ايرادات"]
[null,12,"2020-03-03","فاتورة مبيعات",null,"سعودي",1600,null,"احمد"]
[null,13,"2020-03-03","فاتورة مبيعات",null,"سعودي",null,1600,"ايرادات"]
[null,13,"2020-03-03","فاتورة مبيعات",null,"سعودي",1600,null,"احمد"]
[null,12,"2020-03-03","فاتورة شراء",null,"سعودي",null,1300,"ايرادات"]
[null,12,"2020-03-03","فاتورة شراء",null,"سعودي",1300,null,"احمد"]
[null,13,"2020-03-03","فاتورة شراء",null,"سعودي",null,1300,"ايرادات"]
[null,13,"2020-03-03","فاتورة شراء",null,"سعودي",1300,null,"احمد"]
[null,14,"2020-03-03","فاتورة مبيعات",null,"سعودي",null,2000,"ايرادات"]

{"sheet":"الارصده","index":1,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[8,2,8,4],[8,5,8,7]]}
[]
[]
[]
[]
[null,"الحساب","سعودي","دولار","درهم"]
[null,"ايرادات"]
[null,"احمد"]
[]
[null,null,"مدين",null,null,"دائن"]
[null,null,"سعودي","دولار","درهم","سعودي","دولار","درهم"]
[null,"ايرادات"]
[null,"احمد",null,null,null,null,null,null,null,null,null,null,null,"نفذ"]

{"sheet":"ورقة3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}