{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["صندوق الخزينة","إيرادات ومصروفات","Data","تقرير الإيرادات الشهري","تقرير المصروفات الشهري","تحليل الايرادات والمصروفات"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["التاريخ","رصيد سابق","رصيد إجمالي اليوم (مدين للإيرادات)","رصيد إجمالي اليوم (دائن للمصروفات)"]
["2024-12-31",0,8712,0]
["2025-01-01",8712,11737,3040]
["2025-04-17",{"$f":"B3+C3-D3","v":17409},8712,3040]
["2025-04-17",{"$f":"B4+C4-D4","v":23081},3015,0]
["إجمالي شهر ديسمبر",{"$f":"B3","v":8712},8712,0]
["إجمالي شهر يناير",52227,11737,3040]
["إجمالي شهر أبريل",113141,11727,3040]

{"sheet":"إيرادات ومصروفات","index":1,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["رقم المسلسل","التاريخ","نوع السند","كود التوريد","اسم التوريد","المبلغ","الملاحظات"]
[1,"17-04-2025","إيرادات",11,"حسن احمد",5000," توريد نقدية من كودالمندوب 11 اسم المندوب حسن احمد"]
[1,"17-04-2025","إيرادات",12,"مبارك احمد",5556," توريد نقدية من كودالمندوب 12 اسم المندوب مبارك احمد"]
[1,"17-04-2025","إيرادات",10,"بيع مباشر",3000," توريد نقدية من كودالمندوب 10 اسم المندوب بيع مباشر"]
[1,"17-04-2025","إيرادات",12,"مبارك احمد",5025," توريد نقدية من كودالمندوب 12 اسم المندوب مبارك احمد"]
[1,"17-04-2025","إيرادات",11,"حسن احمد",3024," توريد نقدية من كودالمندوب 11 اسم المندوب حسن احمد"]
[1,"17-04-2025","إيرادات",12,"مبارك احمد",3642," توريد نقدية من كودالمندوب 12 اسم المندوب مبارك احمد"]
[1,"17-04-2025","إيرادات",10,"بيع مباشر",3694," توريد نقدية من كودالمندوب 10 اسم المندوب بيع مباشر"]
[1,"17-04-2025","إيرادات",11,"حسن احمد",8712," توريد نقدية من كودالمندوب 11 اسم المندوب حسن احمد"]
[1,"2025-04-17","مصروفات",4,"مرتبات وحوافز",3040," توريد نقدية من كودالمندوب 4 اسم المندوب مرتبات وحوافز"]
[1,"17-04-2025","إيرادات",12,"مبارك احمد",3025," توريد نقدية من كودالمندوب 12 اسم المندوب مبارك احمد"]
[1,"17-04-2025","إيرادات",12,"مبارك احمد",7000," توريد نقدية من كودالمندوب 12 اسم المندوب مبارك احمد"]
[1,"17-04-2025","إيرادات",11,"حسن احمد",3025," توريد نقدية من كودالمندوب 11 اسم المندوب حسن احمد"]
[1,"17-04-2025","إيرادات",10,"بيع مباشر",3015," توريد نقدية من كودالمندوب 10 اسم المندوب بيع مباشر"]

{"sheet":"Data","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["كود الإيرادات","اسم الإيرادات","كود المصروفات","اسم المصروفات"]
[2,"رد سلف",1,"مصروفات"]
[9,"متوقفات",2,"سلف"]
[10,"بيع مباشر",3,"ايداع بالبنك"]
[11,"حسن احمد",4,"مرتبات وحوافز"]
[12,"مبارك احمد",5,"مصروفات السيارة"]
[13,"عصام انور",6,"تعتيق جرار"]
[14,"ابوبكر حسين",7,"الخزينة الرئيسية"]
[15,"عبد الرحمن احمد",8,"ايجار سيارة "]
[16,"مبارك جاد",9,"ايجار مخزن / مكتب"]
[null,null,10,"بوفية"]
[null,null,11,"نت ومكالمات وكرباء وغازومياة"]
[null,null,12,"ورق  وطباعة وستلزمات كمبيوتر"]

{"sheet":"تقرير الإيرادات الشهري","index":3,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["رقم المسلسل","التاريخ","كود التوريد","اسم التوريد","المبلغ","الملاحظات"]
[1,"16-04-2025",11,"حسن احمد",300,"توريد المندوب حسن احمد"]
[null,null,null,"الإجمالي",300]

{"sheet":"تقرير المصروفات الشهري","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"تحليل الايرادات والمصروفات","index":5,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":false,"merged":[[15,1,15,15]]}
["التاريخ","اول المدة","توريدات","مصروفات","سلف","ايداع بالبنك","مرتبات وحوافز","مصروفات السيارة","تعتيق جرار","الخزينة الرئيسية","ايجار سيارة","ايجار مخزن ومكتب","بوفية","نت ومكالمات وكهرباء  ومياة","ورق  وطباعة وستلزمات كمبيوتى","نهاية الرصيد","اجمالى المصروفات"]
["00:00:00",{"$error":"#REF!"},0,10730,20800,1296400,30292,15850,800,0,37800,7200,567,143,205,{"$f":"B2+C2-D2-E2-F2-G2-H2-I2-J2-K2-L2-M2-N2-O2","v":{"$error":"#REF!"}},{"$f":"D2+G2+H2+I2+J2+K2+L2+M2+N2+O2","v":103587}]
[{"$f":"EDATE(A2,1)","v":"1900-01-31"},{"$f":"IF(C3<>0,P2,0)","v":0},0,835,8700,722900,51308,11545,0,0,48040,0,175,50,120,{"$f":"B3+C3-D3-E3-F3-G3-H3-I3-J3-K3-L3-M3-N3-O3","v":-843673},{"$f":"D3+G3+H3+I3+J3+K3+L3+M3+N3+O3","v":112073}]
[{"$f":"EDATE(A3,1)","v":"1900-02-28"},{"$f":"IF(C4<>0,P3,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"B4+C4-D4-E4-F4-G4-H4-I4-J4-K4-L4-M4-N4-O4","v":0},{"$f":"D4+G4+H4+I4+J4+K4+L4+M4+N4+O4","v":0}]
["1900-03-28",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"D5+G5+H5+I5+J5+K5+L5+M5+N5+O5","v":0}]
[{"$f":"EDATE(A5,1)","v":"1900-04-28"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["1900-05-28",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"B7+C7-D7-E7-F7-G7-H7-I7-J7-K7-L7-M7-N7-O7","v":0},0]
["1900-06-28",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"D8+G8+H8+I8+J8+K8+L8+M8+N8+O8","v":0}]
["1900-07-28",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"D9+G9+H9+I9+J9+K9+L9+M9+N9+O9","v":0}]
["1900-08-28",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"B10+C10-D10-E10-F10-G10-H10-I10-J10-K10-L10-M10-N10-O10","v":0},0]
["1900-09-28",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"B11+C11-D11-E11-F11-G11-H11-I11-J11-K11-L11-M11-N11-O11","v":0},{"$f":"D11+G11+H11+I11+J11+K11+L11+M11+N11+O11","v":0}]
["1900-10-28",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["1900-11-28",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"B13+C13-D13-E13-F13-G13-H13-I13-J13-K13-L13-M13-N13-O13","v":0},{"$f":"D13+G13+H13+I13+J13+K13+L13+M13+N13+O13","v":0}]
["الاجمــــالى",{"$f":"SUM($B$5:$B$5)","v":0},{"$f":"SUM(C2:C13)","v":0},{"$f":"SUM(D2:D13)","v":11565},{"$f":"SUM(E2:E13)","v":29500},2019300,81600,27395,800,0,85840,7200,742,193,325,{"$f":"B14+C14-D14-E14-F14-G14-H14-I14-J14-K14-L14-M14-N14-O14","v":-2264460},{"$f":"SUM(Q2:Q13)","v":215660}]
[]
[null,"توريدات المناديب ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1268846.75]
[null,2,9,10,11,12,13,14,15,16,17,18,19,20,21,"الصندوق",{"$f":"Q14-Q16","v":-1053186.75}]
["التاريخ","رد السلف","متوقفات مديونية","بيع مباشر","حسن احمد","سيد احمد عارف","عصام انور","اخرى 2","اخرى 3","اخرى 4","اخرى 5","اخرى 6","اخرى 7","اخرى 8","اخرى 9","اجمالى التوريدات"]
[{"$f":"A2","v":"00:00:00"},0,0,0,728694,452415,155183,0,0,0,0,0,0,0,0,{"$f":"SUM(B19:O19)","v":1336292},23655]
[{"$f":"EDATE(A19,1)","v":"1900-01-31"},20800,0,0,352150,352900,78743,0,0,0,0,0,0,0,0,{"$f":"SUM(B20:O20)","v":804593},{"$f":"Q18-Q19","v":-23655}]
[{"$f":"EDATE(A20,1)","v":"1900-02-28"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1898]
["1900-03-28",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q20-Q21","v":-25553}]
[{"$f":"EDATE(A22,1)","v":"1900-04-28"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["1900-05-28",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["1900-06-28",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["1900-07-28",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["1900-08-28",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B27:O27)","v":0}]
["1900-09-28",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["1900-10-28",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["1900-11-28",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q31+L31","v":2140885}]
["الاجمــــالى",{"$f":"SUM(B19:B30)","v":20800},{"$f":"SUM(C19:C30)","v":0},{"$f":"SUM(D19:D30)","v":0},{"$f":"SUM(E19:E30)","v":1080844},805315,233926,0,0,0,0,0,0,0,0,{"$f":"SUM(P19:P30)","v":2140885},{"$f":"B31+C31+E31+F31+G31+H31+I31+J31+K31+M31+N31+N31+O31","v":2140885}]