{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Payment Requests","Cash Position"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":11,"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":"Payment Requests","index":0,"n_rows":52,"n_cols":18,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-03-23",null,"المهد"]
["Received date","Ref.No","Proj.code","Project","Subcontractor &\nSuppliers","Description","value","Payment Percentage","Due","Issue Date","Paid","Bank","Transaction","Status","Comment"]
["2022-03-16","invoice","0486","مشروع 1","احمد","تكسير و تشوينات",45358.25,1,45358.25,"2022-03-20",20000,"Misr 298","Check","Due",null,{"$f":"G3-K3","v":25358.25}]
["2022-03-20","invoice","0524","مشروع 2","محمد","Wooden Works ",19794.13,1,19794.13,"2022-03-20",19794.13,"Misr 298","Check","Due","سجل تجاري حديث",0]
["2022-03-20",6667,"0532","مشروع 3","محمود","Electrical works",26755,1,26755,"2022-03-20",26755,"HSBC 007","Check","Cr 45 day","استلام اصل الفاتورة - سجل تجاري ",0]
["2022-03-20","invoice","0567","مشروع 4","مجدى","Hoarding",13735,1,13735,"2022-03-20",13735,"HSBC 005","Check","Due",null,0]
["2022-03-20","invoice",null,"مشروع 5","احمد","ISO 9001",28728,1,28728,"2022-03-20",28728,"Misr 298","Check","Due","استلام اصل الفاتورة مختوم",0]
["2022-03-20",6479,"0553","مشروع 6","محمد","Wood flooring",15900,1,15900,"2022-03-20",15900,"HSBC 005","Check","Due","سجل تجاري حديث",0]
["2022-03-20","Contract","0567","مشروع 7","محمود","mechanical works",1999276,0.2,399855.2,"2022-03-20",100000,"HSBC 009","Check","Due","مقابل شيك بنكي \" صحة توقيع \"",1899276]
["2022-03-17","Memo","0518","مشروع 8","مجدى","supply transitions",2543,1,2543,"2022-03-20",2543,"ABC","Check","Due",null,0]
["2022-03-03","invoice","0517","مشروع 9","محمد","Paints Works ",25518.33,1,25518.33,"2022-03-20",20000,"Misr 298","Check","Due",null,5518.3300000000017]
["2022-03-20","invoice","0532","مشروع 10","محمود","Paints Works ",50000,1,50000,"2022-03-20",50000,"Misr 298","Check","Due",null,0]
["2022-03-20","invoice","0532","مشروع 11","مجدى","Electrical works",15000,1,15000,"2022-03-20",15000,"Cairo 683","Check","Due",null,0]
["2022-03-20","invoice","0532","مشروع 12","احمد","Mechanical Works  ",25000,1,25000,"2022-03-20",25000,"Misr 298","Check","Due",null,0]
["2022-03-20",null,"0553","مشروع 13","محمد","Mechanical Works  ",318237,null,75000,"2022-03-20",75000,"HSBC 009","Check","Due",null,243237]
["2022-03-01","invoice","0486","مشروع 14","محمود"," Gypsum Works",3927.9199999999983,1,3927.9199999999983,"2022-03-23",3927.92,"HSBC 007","Check","Due",null,{"$f":"G16-K16","v":0}]
["2022-03-20","Contract","0567","مشروع 15","مجدى","mechanical works",1999276,0.25,399819,"2022-03-23",399819,"HSBC 009","Check","Due","مقابل شيك ضمان صحة توقيع",{"$f":"G17-K17","v":1599457}]
["2022-03-22",6647,"0567","مشروع 16","محمد","الدفعة الثالثة من الدفعة المقدمة\nCARPET",49250,1,49250,"2022-03-23",49250,"HSBC 009","Check","Due","سجل تجاري حديث",0]
["2022-03-22",6766,"0567","مشروع 17","محمود","Terrazzo tiling",24225,0.5,12112.5,"2022-03-23",12112.5,"Cairo 683","Check","Due",null,12112.5]
["2022-03-22",6751,"0567","مشروع 18","مجدى","toilet accessories",26784.39,1,26784.39,"2022-03-23",26784.39,"HSBC 009","Check","Due","استلام اصل الفاتورة  - سجل تجاري حديث",0]
["2022-03-22","Contract","0567","مشروع 19","احمد","Masonry and Plastering",32270,1,32270,"2022-03-23",32270,"Misr 298","Check","Due","مقابل إيصال امانة",0]
["2022-03-01","invoice","0553","مشروع 20","محمد"," Gypsum Works",41145.4,1,41145.4,"2022-03-23",40000,"ABC","Check","Due",null,1145.4000000000015]
["2022-03-22","invoice","0553","مشروع 21","محمود","Paints Works ",26842.75,1,26842.75,"2022-03-23",25000,"Misr 298","Check","Due",null,1842.75]
["2022-03-20","invoice","0553","مشروع 22","مجدى","Electrical works",228476.79999999999,1,228476.79999999999,"2022-03-23",100000,"HSBC 009","Check","Due",null,128476.79999999999]
["2022-03-22",6421,"0553","مشروع 23","احمد","lighting fixure",218000,1,218000,"2022-03-23",218000,"HSBC 009","Check","Due",null,0]
["2022-03-22","invoice","0517","مشروع 24","محمد","Mechanical works",80111.290000000008,1,80111.290000000008,"2022-03-23",80111.289999999994,"Misr 298","Check","Due",null,0]
["2022-03-22","invoice","0517","مشروع 25","محمود"," Gypsum Works",22371.5,1,22371.5,"2022-03-23",22371.5,"HSBC 009","Check","Due","سجل تجاري حديث",0]
["2022-03-22","invoice","0517","مشروع 26","مجدى","ارضيات",4722.47,1,4722.47,"2022-03-23",4722.47,"Cairo 683","Check","Due",null,0]
["2022-03-22","invoice","0517","مشروع 27","احمد","Paints Works ",52435.54,1,52435.54,"2022-03-23",30000,"Misr 298","Check","Due",null,22435.54]
["2022-03-22","Contract","0517","مشروع 28","محمد","اعمال عزل",7700,1,7700,"2022-03-23",7700,"Cairo 683","Check","Due",null,0]
["2022-03-22",6776,"0517","مشروع 29","محمود","Supply Euroquarzo",42771,1,42771,"2022-03-23",42771,"HSBC 009","Check","Due","استلام فاتورة قديمة + الفاتورة الجديدة - سجل تجاري حديث",0]
["2022-03-22","invoice","0486","مشروع 30","مجدى","زراعات",264098.08,1,130000,"2022-03-23",130000,"Cairo 683","Check","Cr 30 day","استلام شيك ضمان بقيمة 25000 جنية - الشيك بتاريخ 30-04-2022",{"$f":"G32-K32","v":134098.08000000002}]
["2022-03-22","invoice","0486","مشروع 31","احمد","زراعات",264098.08,1,134098.08000000002,"2022-03-23",134098.07999999999,"Cairo 683","Check","Cr 60 day","استلام شيك ضمان بقيمة 25000 جنية - الشيك بتاريخ 30-05-2022"]
["2022-03-22","Contract","0569","مشروع 32","محمد","Paints Works ",14544.25,1,14544.25,"2022-03-23",14544.25,"ABC","Check","Due","مقابل ايصال امانة ",0]
["2022-03-22","invoice","0524","مشروع 33","محمود"," Gypsum Works",5552.27,1,5552.27,"2022-03-23",5552.27,"Cairo 683","Check","Due","بطاقة ضريبية",0]
["2022-03-22",6778,"0532","مشروع 34","مجدى","supply diff pressure",5257.89,1,5257.89,"2022-03-23",5257.89,"Cairo 683","Check","Due","استلام اصل الفاتورة  - سجل تجاري حديث",0]
["2022-03-22","Cash In","0000","مشروع 35","احمد","Cash In",20000,1,20000,"2022-03-23",20000,"Misr 298","Check","Due",null,0]
["2022-03-22","invoice","0000","مشروع 36","محمد",".Feb 2022",1744,1,1744,"2022-03-23",1744,"HSBC 002","Check","Due",null,0]
["2022-03-22","invoice","0000","مشروع 37","محمود","تأجير سيارة جامبو",21230,1,21230,"2022-03-23",21230,"Cairo 683","Check","Due",null,0]
["2022-03-22",6380,"0553","مشروع 38","مجدى","Acoustic ceiling tiles",163155.5,1,163155.5,"2022-03-23",163155.5,"HSBC 007","Check","Cr 60 day","استلام اصل الفاتورة  - الشيك بتاريخ 31-05-2022 - يجل جاري حديث",0]
["2022-03-21",6777,"0552","مشروع 39","احمد","panel boards",188988,1,188988,"2022-03-23",188988,"Misr 298","Check","Due","مقابل شيك صحة توقيع",0]
["2022-03-23",6404,"0553","مشروع 40","محمد","Carpet tiles",1287270,0.25,238145,"2022-03-23",238145,"HSBC 009","Check","Due","سجل تجاري حديث",1049125]
["2022-03-23","retention","0484","مشروع 41","محمود"," Gypsum Works",31348.799999999999,1,31348.799999999999,"2022-03-23",31348.799999999999,"ABC","Check","Due","بطاقة ضريبية",0]
["2022-03-23","Contract","0569","مشروع 42","مجدى","Light current systems",218379,0.25,54594.75,"2022-03-23",54594.75,"HSBC 009","Check","Due",null,163784.25]
["2022-03-23","Contract","0553","مشروع 43","احمد","Wooden works ",109500,0.5,54750,"2022-03-23",54750,"HSBC 009","Check","Due","سجل تجاري حديث",54750]
["2022-03-23","invoice","0552","مشروع 44","محمد","Electrical works",58000,null,0,"2022-03-23",35000,"Misr 298","Check","Due","سجل تجاري حديث",23000]
["2022-03-23","invoice","0532","مشروع 45","محمود","Steel chassis",17319.910000000003,1,17319.910000000003,"2022-03-23",17319.91,"Cairo 683","Check","Due",null,{"$f":"G47-K47","v":0}]
["2022-03-23","invoice","0532","مشروع 46","مجدى","mechanical works",236778.46000000002,null,75000,"2022-03-23",75000,"HSBC 009","Check","Due",null,{"$f":"G48-K48","v":161778.46000000002}]
["2022-03-23","invoice","0532","مشروع 47","احمد","mechanical works",50080.06,null,25000,"2022-03-23",25000,"HSBC 009","Check","Due",null,{"$f":"G49-K49","v":25080.059999999998}]
["2022-03-23","invoice","0532","مشروع 48","مجدى","Marble ",20000,1,20000,"2022-03-23",20000,"ABC","Check","Due",null,0]
["2022-03-23","Contract","0517","مشروع 49","احمد","Electrical works",601000,0.15,90150,"2022-03-23",50000,"Misr 298","Check","Due",null,551000]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(9,G3:G51)","v":9024499.0699999984},null,{"$f":"SUBTOTAL(9,I3:I51)","v":3282805.92},null,{"$f":"SUBTOTAL(9,K3:K51)","v":2793023.65}]

{"sheet":"Cash Position","index":1,"n_rows":1,"n_cols":15,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Issued Date","Beneficiary Name","Transactions Details","In","Out","Due Date","Bank Name","Chq. No.#","Status","Project","Expences Direction","Bank Due Date","Ref.No","Receiver Name","Notes"]