{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["القيود اليوميه 0","شرح"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":20,"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":"القيود اليوميه 0","index":0,"n_rows":143,"n_cols":13,"rows_kept":143,"cut":false,"hidden":false,"merged":[[0,1,0,3],[1,1,1,3],[2,1,2,3]]}
[]
[]
[]
[]
[]
[]
["مسلسل القيد","رقم السند","كود الملف","موسم متنوع عمرة حج","التاريخ","اسم العميل / اسم الشركة","اسم الفندق/اسم الحساب","التفاصيــــــــــل / البيـــــــــــــان ( القيود اليومية لجميع الحسابات )","قبض ( مدين )","صرف( دائن ) متنوع","صرف ( دائن ) ايجار-مؤسسة","اجمالي الصندوق","عمود1"]
["ر القيد","السند","كود","موسم عمرة حج","التاريخ","عميل / شركة","جهه / فندق","بيان","قبض","صرف 1","صرف 2",0]
[9999,1,7,"2ص عمرة","2020-08-20","salim","قندق 1","سداد رواتب العاملين عن شهر يناير2020",0,18500,0,{"$f":"IF(AND(I9=\"\",J9=\"\"),\"\",L8+I9-J9-K9)","v":-18500}]
[{"$f":"IF(B10=\"\",\"\",ROW()-8)","v":2},2,7,"4ص حج","2020-08-22","ERII","فندق","دفعة تحت الحساب",0,1500,0,-20000]
[3,3,7,"2ص عمرة","2020-08-25","ISPM","فندق 8","دفعة تحت الحساب",0,3500,0,-23500]
[4,4,7,"2ص عمرة","2020-08-25","ERGW","فندق 8","سداد فاتورة الكهرباء عن شهر يناير2020",0,18500,0,-42000]
[5,5,7,"1ق عمرة","2020-08-26","RPYA","فندق 9","دفعة تحت الحساب",33000,0,0,-9000]
[6,6,7,"2ص عمرة","2020-08-27","PFIF","فندق 9","سداد فاتورة المياه عن شهر قبراير 2020",0,18500,0,-27500]
[7,7,7,"4ص حج","2020-08-28","BGAE","فندق 10","شراء 2 وايت مياه",0,18500,0,-46000]
[8,8,7,"3ق حج","2020-08-29","UCRW","فندق 10","دفعة تحت الحساب",21000,0,0,-25000]
[9,9,7,"1ق عمرة","2020-08-30","PKMY","فندق 11","دفعة تحت الحساب",2500,0,0,-22500]
[10,10,7,"2ص عمرة","2020-08-30","FMIH","فندق 11","سداد الدفعة الاولى من عقد صيانة المصاعد",0,18500,0,-41000]
[11,11,7,"3ق حج","2020-08-22","AAOB","فندق 7","سداد رواتب العاملين عن شهر يناير2021",3000,0,0,-38000]
[12,12,7,"1ق عمرة","2020-08-25","POEW","فندق 8","دفعة تحت الحساب",3500,0,0,-34500]
[13,13,7,"2ص عمرة","2020-08-25","DKRV","فندق 8","دفعة تحت الحساب",0,18500,0,-53000]
[14,14,7,"1ق عمرة","2020-08-26","ZNVJ","فندق 9","سداد فاتورة الكهرباء عن شهر يناير2021",4000,0,0,-49000]
[15,15,7,"2ص عمرة","2020-08-27","SHTQ","فندق 9","دفعة تحت الحساب",0,18500,0,-67500]
[16,16,7,"4ص حج","2020-08-28","YWCR","فندق 10","سداد فاتورة المياه عن شهر قبراير 2021",0,18500,0,-86000]
[17,17,7,"1ق عمرة","2020-08-29","MIOG","فندق 10","شراء 2 وايت مياه",4100,0,0,-81900]
[18,18,7,"3ق حج","2020-08-30","UTDE","فندق 11","دفعة تحت الحساب",4200,0,0,-77700]
[19,19,7,"2ص عمرة","2020-08-30","YWMK","فندق 11","دفعة تحت الحساب",0,18500,0,-96200]
[20,20,7,"3ق حج","2020-08-22","BJQS","فندق 7","سداد الدفعة الاولى من عقد صيانة المصاعد",4300,0,0,-91900]
[21,21,7,"1ق عمرة","2020-08-25","PINP","فندق 8","سداد رواتب العاملين عن شهر يناير2022",4400,0,0,-87500]
[22,22,7,"2ص عمرة","2020-08-25","HMVZ","فندق 8","دفعة تحت الحساب",0,18500,0,-106000]
[23,23,7,"1ق عمرة","2020-08-26","XJIA","فندق 9","دفعة تحت الحساب",5500,0,0,-100500]
[24,24,7,"2ص عمرة","2020-08-27","FLDA","فندق 9","سداد فاتورة الكهرباء عن شهر يناير2022",0,18500,0,-119000]
[25,25,7,"4ص حج","2020-08-28","MKHN","فندق 10","دفعة تحت الحساب",0,18500,0,-137500]
[26,26,7,"3ق حج","2020-08-29","AIRW","فندق 10","سداد فاتورة المياه عن شهر قبراير 2022",7500,0,0,-130000]
[27,27,7,"1ق عمرة","2020-08-30","OZMM","فندق 11","شراء 2 وايت مياه",9000,0,0,-121000]
[28,28,7,"2ص عمرة","2020-08-30","RPZE","فندق 11","دفعة تحت الحساب",0,18500,0,-139500]
[29,20,7,"3ق حج","2020-08-22","GBIW","فندق 7","دفعة تحت الحساب",1000,0,0,-138500]
[30,21,7,"1ق عمرة","2020-08-25","JNAZ","فندق 8","سداد الدفعة الاولى من عقد صيانة المصاعد",1500,0,0,-137000]
[31,22,7,"2ص عمرة","2020-08-25","TRNA","فندق 8","سداد رواتب العاملين عن شهر يناير2023",0,18500,0,-155500]
[32,23,7,"3ق حج","2020-08-26","FZDG","فندق 9","دفعة تحت الحساب",24000,0,0,-131500]
[33,24,7,"2ص عمرة","2020-08-27","TUTO","فندق 9","دفعة تحت الحساب",0,18500,0,-150000]
[34,25,7,"4ص حج","2020-08-28","DXHN","فندق 10","سداد فاتورة الكهرباء عن شهر يناير2023",0,18500,0,-168500]
[35,26,7,"1ق عمرة","2020-08-29","ERAO","فندق 10","دفعة تحت الحساب",24000,0,0,-144500]
[36,27,7,"3ق حج","2020-08-30","AFUQ","فندق 11","سداد فاتورة المياه عن شهر قبراير 2023",24000,0,0,-120500]
[37,28,7,"2ص عمرة","2020-08-30","KGSP","فندق 11","شراء 2 وايت مياه",0,18500,0,-139000]
[38,20,7,"1ق عمرة","2020-08-22","FEMG","فندق 7","دفعة تحت الحساب",24000,0,0,-115000]
[39,21,7,"3ق حج","2020-08-25","IMLL","فندق 8","دفعة تحت الحساب",24000,0,0,-91000]
[40,22,7,"2ص عمرة","2020-08-25","OYTY","فندق 8","سداد الدفعة الاولى من عقد صيانة المصاعد",0,18500,0,-109500]
[41,23,7,"1ق عمرة","2020-08-26","MBMP","فندق 9","سداد رواتب العاملين عن شهر يناير2024",24000,0,0,-85500]
[42,24,7,"2ص عمرة","2020-08-27","JOCC","فندق 9","دفعة تحت الحساب",0,18500,0,-104000]
[43,25,7,"4ص حج","2020-08-28","ALPX","فندق 10","دفعة تحت الحساب",0,18500,0,-122500]
[44,26,7,"1ق عمرة","2020-08-29","UDHH","فندق 10","سداد فاتورة الكهرباء عن شهر يناير2024",24000,0,0,-98500]
[45,27,7,"3ق حج","2020-08-30","GKUD","فندق 11","دفعة تحت الحساب",24000,0,0,-74500]
[46,28,7,"2ص عمرة","2020-08-30","TXCA","فندق 11","سداد فاتورة المياه عن شهر قبراير 2024",0,18500,0,-93000]
[47,26,7,"4ص حج","2020-08-29","JFNP","فندق 10","سداد فاتورة الكهرباء عن شهر يناير2024",0,10000,0,-103000]
[48,27,7,"2ص عمرة","2020-08-30","FLPJ","فندق 11","دفعة تحت الحساب",0,12000,0,-115000]
[49,25,7,"2ص عمرة","2020-09-01","HTFZ","فندق 11","سداد فاتورة الكهرباء عن شهر يناير2024",0,500,0,-115500]
[50,25,7,"2ص عمرة","2020-09-01","FNXG","فندق 11","سداد فاتورة الكهرباء عن شهر يناير2024",0,600,0,-116100]
[51,26,7,"4ص حج","2020-09-25","YILX","فندق 11","سداد",0,15000,0,-131100]
[52,26,7,"2ص عمرة","2020-09-25","WZOL","فندق 11","سداد",0,500,0,-131600]
[53,27,7,"4ص حج","2020-07-26","AYHF","فندق 11","صرف",0,1500,0,-133100]
[54,27,7,"2ص عمرة","2020-07-26","JSQT","فندق 11","صرف",0,1500,0,-134600]
[55,28,7,"1ق عمرة","2020-07-28","GUUH","فندق 11","قبض",155000,0,0,20400]
[56,29,7,"3ق حج","2020-07-30","QGLT","فندق 11","قبض",190000,0,0,210400]
[57,30,7,"متنوع-ايجار","2020-08-01","LSDZ","فندق 15","قبض",135000,0,0,345400]
[58,31,7,"2ص عمرة","2020-08-02","AYYK","فندق 16","صرف",0,0,44000,301400]
[59,32,7,"2ص عمرة","2020-08-03","WSJA","فندق 17","صرف",0,0,35000,266400]
[60,1,8,"2ص عمرة","2020-08-20","DYYO","فندق 7","سداد رواتب العاملين عن شهر يناير2020",0,18500,0,247900]
[61,2,8,"4ص حج","2020-08-22","EMWU","فندق 7","دفعة تحت الحساب",0,1500,0,246400]
[62,3,8,"2ص عمرة","2020-08-25","LEBI","قندق 1","دفعة تحت الحساب",0,3500,0,242900]
[63,4,8,"4ص حج","2020-08-25","GHDM","فندق","سداد فاتورة الكهرباء عن شهر يناير2020",0,18500,0,224400]
[64,5,8,"1ق عمرة","2020-08-26","SKMM","فندق 8","دفعة تحت الحساب",33000,0,0,257400]
[65,6,8,"4ص حج","2020-08-27","KOJX","فندق 8","سداد فاتورة المياه عن شهر قبراير 2020",0,18500,0,{"$f":"IF(AND(I73=\"\",J73=\"\"),\"\",L72+I73-J73-K73)","v":238900}]
[{"$f":"IF(B74=\"\",\"\",ROW()-8)","v":66},7,8,"2ص عمرة","2020-08-28","CNUQ","فندق 9","شراء 2 وايت مياه",0,18500,0,220400]
[67,8,8,"3ق حج","2020-08-29","MPTJ","فندق 9","دفعة تحت الحساب",21000,0,0,241400]
[68,9,8,"1ق عمرة","2020-08-30","RWUY","فندق 10","دفعة تحت الحساب",2500,0,0,243900]
[69,10,8,"2ص عمرة","2020-08-30","MYPW","فندق 10","سداد الدفعة الاولى من عقد صيانة المصاعد",0,18500,0,225400]
[70,11,8,"3ق حج","2020-08-22","GRMK","فندق 11","سداد رواتب العاملين عن شهر يناير2021",3000,0,0,228400]
[71,12,8,"1ق عمرة","2020-08-25","HCIA","فندق 11","دفعة تحت الحساب",3500,0,0,231900]
[72,13,8,"2ص عمرة","2020-08-25","HDEQ","فندق 7","دفعة تحت الحساب",0,18500,0,213400]
[73,14,8,"3ق حج","2020-08-26","ALJI","فندق 8","سداد فاتورة الكهرباء عن شهر يناير2021",4000,0,0,217400]
[74,15,8,"4ص حج","2020-08-27","GHSB","فندق 8","دفعة تحت الحساب",0,18500,0,198900]
[75,16,8,"2ص عمرة","2020-08-28","TXOG","فندق 9","سداد فاتورة المياه عن شهر قبراير 2021",0,18500,0,180400]
[76,17,8,"1ق عمرة","2020-08-29","MYXO","فندق 9","شراء 2 وايت مياه",4100,0,0,184500]
[77,18,8,"3ق حج","2020-08-30","LEGI","فندق 10","دفعة تحت الحساب",4200,0,0,188700]
[78,19,8,"2ص عمرة","2020-08-30","OHAD","فندق 10","دفعة تحت الحساب",0,18500,0,170200]
[79,20,8,"1ق عمرة","2020-08-22","CJWZ","فندق 11","سداد الدفعة الاولى من عقد صيانة المصاعد",4300,0,0,174500]
[80,21,8,"3ق حج","2020-08-25","UGRC","فندق 11","سداد رواتب العاملين عن شهر يناير2022",4400,0,0,178900]
[81,22,8,"4ص حج","2020-08-25","XIKA","فندق 7","دفعة تحت الحساب",0,18500,0,160400]
[82,23,8,"1ق عمرة","2020-08-26","XIPT","فندق 8","دفعة تحت الحساب",5500,0,0,165900]
[83,24,8,"2ص عمرة","2020-08-27","ZDJZ","فندق 8","سداد فاتورة الكهرباء عن شهر يناير2022",0,18500,0,147400]
[84,25,8,"4ص حج","2020-08-28","EKYZ","فندق 9","دفعة تحت الحساب",0,18500,0,128900]
[85,26,8,"1ق عمرة","2020-08-29","IOFY","فندق 9","سداد فاتورة المياه عن شهر قبراير 2022",7500,0,0,136400]
[86,27,8,"3ق حج","2020-08-30","IIGB","فندق 10","شراء 2 وايت مياه",9000,0,0,145400]
[87,28,8,"2ص عمرة","2020-08-30","KYMG","فندق 10","دفعة تحت الحساب",0,18500,0,126900]
[88,20,8,"1ق عمرة","2020-08-22","MGSM","فندق 11","دفعة تحت الحساب",1000,0,0,127900]
[89,21,8,"3ق حج","2020-08-25","RPKI","فندق 11","سداد الدفعة الاولى من عقد صيانة المصاعد",1500,0,0,129400]
[90,22,8,"4ص حج","2020-08-25","MYJK","فندق 7","سداد رواتب العاملين عن شهر يناير2023",0,18500,0,110900]
[91,23,8,"1ق عمرة","2020-08-26","BECF","فندق 8","دفعة تحت الحساب",24000,0,0,134900]
[92,24,8,"2ص عمرة","2020-08-27","NAPE","فندق 8","دفعة تحت الحساب",0,18500,0,116400]
[93,25,8,"4ص حج","2020-08-28","SIIS","فندق 9","سداد فاتورة الكهرباء عن شهر يناير2023",0,18500,0,97900]
[94,26,8,"3ق حج","2020-08-29","ZHFM","فندق 9","دفعة تحت الحساب",24000,0,0,121900]
[95,27,8,"1ق عمرة","2020-08-30","NFPU","فندق 10","سداد فاتورة المياه عن شهر قبراير 2023",24000,0,0,145900]
[96,28,8,"4ص حج","2020-08-30","CTXN","فندق 10","شراء 2 وايت مياه",0,18500,0,127400]
[97,20,8,"3ق حج","2020-08-22","GODP","فندق 11","دفعة تحت الحساب",24000,0,0,151400]
[98,21,8,"1ق عمرة","2020-08-25","UGQX","فندق 11","دفعة تحت الحساب",24000,0,0,175400]
[99,22,8,"2ص عمرة","2020-08-25","VNAP","فندق 7","سداد الدفعة الاولى من عقد صيانة المصاعد",0,18500,0,156900]
[100,23,8,"3ق حج","2020-08-26","TZDM","فندق 8","سداد رواتب العاملين عن شهر يناير2024",24000,0,0,180900]
[101,24,8,"2ص عمرة","2020-08-27","JOII","فندق 8","دفعة تحت الحساب",0,18500,0,162400]
[102,25,8,"2ص عمرة","2020-08-28","VXJL","فندق 9","دفعة تحت الحساب",0,18500,0,143900]
[103,26,8,"1ق عمرة","2020-08-29","IXLH","فندق 9","سداد فاتورة الكهرباء عن شهر يناير2024",24000,0,0,167900]
[104,27,8,"3ق حج","2020-08-30","ONTI","فندق 10","دفعة تحت الحساب",24000,0,0,191900]
[105,28,8,"2ص عمرة","2020-08-30","RCUF","فندق 10","سداد فاتورة المياه عن شهر قبراير 2024",0,18500,0,173400]
[106,26,8,"4ص حج","2020-08-29","WWPU","فندق 11","سداد فاتورة الكهرباء عن شهر يناير2024",0,10000,0,163400]
[107,27,8,"2ص عمرة","2020-08-30","DIWZ","فندق 11","دفعة تحت الحساب",0,12000,0,151400]
[108,25,8,"2ص عمرة","2020-09-01","NUXE","فندق 10","سداد فاتورة الكهرباء عن شهر يناير2024",0,500,0,150900]
[109,25,8,"4ص حج","2020-09-01","KPCQ","فندق 11","سداد فاتورة الكهرباء عن شهر يناير2024",0,600,0,150300]
[110,26,8,"2ص عمرة","2020-09-25","KGQF","فندق 11","سداد",0,15000,0,135300]
[111,26,8,"2ص عمرة","2020-09-25","PBAK","فندق 11","سداد",0,500,0,134800]
[112,27,8,"4ص حج","2020-07-26","CQCS","فندق 11","صرف",0,1500,0,133300]
[113,27,8,"4ص حج","2020-07-26","GAAZ","فندق 11","صرف",0,1500,0,131800]
[114,28,8,"1ق عمرة","2020-07-28","OMVO","فندق 11","قبض",155000,0,0,286800]
[115,29,8,"3ق حج","2020-07-30","XNRY","فندق 11","قبض",190000,0,0,476800]
[116,30,8,"متنوع-ايجار","2020-08-01","PNDT","فندق 11","قبض",137500,0,0,614300]
[117,31,8,"4ص حج","2020-08-02","QCWK","فندق 11","صرف",0,0,44000,570300]
[118,32,8,"4ص حج","2020-08-03","EYKF","فندق 15","صرف",0,0,35000,535300]
[119,33,8,"1ق عمرة","2020-09-04","JOZZ","فندق 16","دفعة تحت الحساب",20000,0,0,555300]
[120,34,8,"4ص حج","2020-09-05","TGKJ","فندق 17","صرف",0,17500,0,537800]
[121,35,8,"2ص عمرة","2020-09-06","SUPM","فندق 7","ضريبة القيمة المضافة حج",0,8900,0,528900]
[122,36,7,"2ص عمرة","2020-09-07","BFIP","فندق 7","صرف",0,1500,0,527400]
[123,37,7,"4ص حج","2020-09-08","EOXU","قندق 1","صرف",0,175000,0,352400]
[124,38,8,"2ص عمرة","2020-09-09","ODAZ","فندق","20ص مصروفات صيانة الفندق",0,5650,0,346750]
[125,39,7,"متنوع-ايجار","2020-09-10","GWAC","فندق 8","قبض",37000,0,0,383750]
[126,40,1,"1ق عمرة","2020-09-15","GEFW","فندق 8","مخالصه عن حساب ارباحه",0,150000,0,233750]
[127,41,8,"4ص حج","2020-09-16","VBCN","فندق 9","دفعه من حساب القيمة المضافة",0,12000,0,221750]
[128,42,7,"3ق حج","2020-09-17","WGTF","فندق 9","دفعه من حساب ايجار الحج",66000,0,0,287750]
[129,43,8,"1ق عمرة","2020-09-18","USCK","فندق 10","دفعة تحت الحساب",25000,0,0,{"$f":"IF(AND(I137=\"\",J137=\"\"),\"\",L136+I137-J137-K137)","v":312750}]
[{"$f":"IF(B138=\"\",\"\",ROW()-8)","v":130},44,7,"2ص عمرة","2020-09-19","MTGX","فندق 10","شراء 2 وايت مياه",0,17500,0,295250]
[131,45,5,"3ق حج","2020-09-20","RDNH","فندق 11","دف",155000,0,0,450250]
[132,46,5,"1ق عمرة","2020-09-21","ICFU","فندق 11","دفع",166000,0,0,616250]
[133,47,8,"2ص عمرة","2020-09-22","LCJW","فندق 7","دفع",0,35000,0,581250]
[134,48,7,"متنوع-ايجار","2020-09-23","UXYE","فندق 8","دفع",30000,0,0,611250]
[135,49,9,"متنوع-ايجار","2020-09-24","DCJD","فندق 8","مخالصه عن حساب ارباحه",45000,0,0,656250]

{"sheet":"شرح","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}