{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["يومية الخزينة المجمعة","نموزج الحركات","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"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":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["السنة","الشهر","اليوم","الفرع","رقم المستند","المجموعة الفرعية1","المجموعة الفرعية2","المجموعة الفرعية3","مركز التكلفة","البيان","الرصيد الافتتاحي","مدين","دائن","الرصيد","ملاحظات"]
[2019,"2019-09-01","2019-09-01","المركز الرئيسي","-","ايرادات","ايراد المبيعات","ايراد المبيعات","باب شرقي شيراتون","ايراد المبيعات",null,55000.5,null,29277]
[2019,"2019-09-01","2019-09-01","المركز الرئيسي","-","ايرادات","ايراد خدمة التوصيل","ايراد خدمة توصيل","باب شرقي شيراتون","ايراد خدمة التوصيل",null,1670,null,1008]
[2019,"2019-09-01","2019-09-01","المركز الرئيسي","-","ايرادات","ايراد ضريبة القيمة المضافة","ضريبة القيمة المضافة","باب شرقي شيراتون","ايراد ضريبة القيمة المضافة 14%",null,7933.87,null,4234.0200000000004]
[2019,"2019-09-01","2019-09-01","المركز الرئيسي","-","ايرادات","ايراد نسبة الويتر","ايراد نسبة الويتر","باب شرقي شيراتون","ايراد نسبة الويتر",null,133,null,44]
[2019,"2019-09-01","2019-09-01","المركز الرئيسي","-","ايرادات","ايرادات اخرى","اوفر الخزينة الفرعية","باب شرقي شيراتون","اوفر الفرع",null,50.45,null,0.72]
[2019,"2019-09-01","2019-09-01","المركز الرئيسي","-","مصروفات عمومية","خصم","خصم","باب شرقي شيراتون","مردودات مبيعات",null,null,309.04000000000002,-18.899999999999999]
[2019,"2019-09-01","2019-09-01","المركز الرئيسي","-","مصروفات عمومية","وجبات العاملين","اغذية و مشروبات عاملين","باب شرقي شيراتون","وجبات عاملين",null,null,811.68000000000006,-31.92]
[2019,"2019-09-01","2019-09-01","المركز الرئيسي","-","مصروفات عمومية","نسبة الطيار","نسبة طيارين","باب شرقي شيراتون","نسبة طيار",null,null,850,-504]
[2019,"2019-09-01","2019-09-01","المركز الرئيسي","-","مشتريات نقدا","مخزن اغذية ومشروبات","مخزن اغذية ومشروبات","باب شرقي شيراتون","مشتريات نقدية مباشرة",null,null,536,-838]
[2019,"2019-09-01","2019-09-01","المركز الرئيسي","-","تحويلات نقدية","تحويلات نقدية","تحويل نقدى للخزينة الرئيسية","المركز الرئيسي","تحويل نقدي للخزينة الرئيسية",null,null,62197,-32568]
[2019,"2019-09-01","2019-09-01","المركز الرئيسي","-","مصروفات عمومية","انتقالات","انتقالات","باب شرقي شيراتون","مصاريف صيانة",null,null,10,-114]
[2019,"2019-09-01","2019-09-01","المركز الرئيسي",1610,"مصروفات عمومية","مياه","مياه الفرع","باب شرقي شيراتون","علي عبد الرحيم - سي ال",null,null,39.9,-217.4]
[2019,"2019-09-01","2019-09-01","المركز الرئيسي",1915,"مصروفات عمومية","اكراميات","اكراميات","باب شرقي شيراتون","احمد محمد محمود - سي ال",null,null,34.200000000000003,-32.6]

{"sheet":"نموزج الحركات","index":1,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[1,null,null,null,null,null,"القيمة","الفئة","العدد"]
[1,null,"المركز الرئيسي",null,null,null,0,200]
[1,null,null,null,null,null,0,100]
[1,null,{"$f":"A15","v":"2019-09-02"},null,null,null,0,50]
[1,null,"ملخص الحركة اليومية",null,null,null,0,20]
[1,null,"رصيد اول اليوم",0,null,null,0,10]
[1,null,"اجمالي المقبوضات",{"$f":"SUM(Table3[المدين])","v":64787.82},null,null,0,5]
[1,null,"اجمالي المدفوعات",{"$f":"SUM(Table3[الدائن])","v":64787.82},null,null,0,1]
[1,null,"تحويل للخزينة الرئيسية",{"$f":"F19","v":62197},null,null,0,0.5]
[1,null,"الجرد الفعلي",0,null,null,0,0.25]
[1,null,"الفرق",0,null,null,0,null,"النقدية الفعلية"]
[1]
[1,null,"مقبوضــــــــــــــــــــــــــــــــــــــــــــــــات",null,null,null,"المدفوعــــــــــــــــــــات"]
["التاريخ","المدين","بيـــــــان المقبوضات","رقم المستند","ملاحظات","الدائن","بيان المدفوعات","رقم المستند ","الملاحظات"]
["2019-09-02",55000.5,"ايراد المبيعات","-",null,309.04000000000002,"مردودات مبيعات","-"]
[{"$f":"A15","v":"2019-09-02"},1670,"ايراد خدمة التوصيل","-",null,811.68000000000006,"وجبات عاملين","-"]
[{"$f":"A16","v":"2019-09-02"},7933.87,"ايراد ضريبة القيمة المضافة 14%","-",null,850,"نسبة طيار","-"]
["2019-09-02",133,"ايراد نسبة الويتر","-",null,536,"مشتريات نقدية مباشرة","-"]
["2019-09-02",50.45,"اوفر الفرع","-",null,62197,"تحويل نقدي للخزينة الرئيسية","-"]
["2019-09-02",null,null,null,null,10,"مصاريف صيانة","-"]
["2019-09-02",null,null,null,null,39.9,"علي عبد الرحيم - سي ال",1610]
[{"$f":"A21","v":"2019-09-02"},null,null,null,null,34.200000000000003,"احمد محمد محمود - سي ال",1915]
["2019-09-02"]
["2019-09-02"]
["2019-09-02"]
["2019-09-02"]
["2019-09-02"]
["2019-09-02"]
["2019-09-02"]
["2019-09-02"]
["2019-09-02"]
["2019-09-02"]
["2019-09-02"]
["2019-09-02"]
["Total",{"$f":"SUBTOTAL(109,Table3[المدين])","v":64787.82},null,null,null,{"$f":"SUBTOTAL(109,Table3[الدائن])","v":64787.82},null,null,{"$f":"SUBTOTAL(103,Table3[الملاحظات])","v":0}]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}