{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["قواعد بيانات","كشف حساب","تصدير بيانات اكسيل","الطباعة","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,"نوع المستند","اسم الصنف","اسم العميل"]
[null,"قيد","منتج 1","حسن احمد"]
[null,"مردودات مبيعات","منتج 2","سيد احمد"]
[null,"مبيعات","منتج 3","محمد احمد"]
[null,"سند قيد","منتج 4","اسماعيل احمد"]
[null,"سند قبض","منتج 5","يوسف احمد"]

{"sheet":"كشف حساب","index":1,"n_rows":251,"n_cols":25,"rows_kept":251,"cut":false,"hidden":false,"merged":[[1,15,1,16],[0,10,0,11],[1,10,1,11],[0,0,1,9]]}
["كشف حساب عميل تفصيلي حتي 01/08/2024",null,null,null,null,null,null,null,null,null,null,null,null,null,"الاجمالي",{"$f":"SUM(K4:K251)","v":5342.19},379065.38,null,null,null,null,null,null,null,"2023-11-15"]
[null,null,null,null,null,null,null,null,null,null,"من 1 : 30 يوم",null,null,{"$f":"I251","v":-68760.100000000006},"الرصيد",{"$f":"P1-Q1","v":-373723.19}]
["رقم\nالمستند","الـتـاريــخ","نوع المستند","اسم الصنف","اسم العميل","الــــشـــــرح","مديــن","دائن","الرصيد","عمر الدين","المبيعات","التحصيل"]
[1,"2023-11-15","قيد","منتج 1","حسن احمد","رصيد مرحل",77054.460000000006,null,{"$f":"G4","v":77054.460000000006},{"$f":"TODAY()-B4","v":249},{"$f":"IF(J4<=30,G4,\"\")","v":""},{"$f":"IF(J4<=30,H4,\"\")","v":""}]
[176,"2023-11-16","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,2385.1999999999998,{"$f":"+I4+G5-H5","v":74669.260000000009},248,{"$f":"IF(J5<=30,G5,\"\")","v":""},{"$f":"IF(J5<=30,H5,\"\")","v":""}]
[725,"2023-11-17","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1090.2,null,{"$f":"+I5+G6-H6","v":75759.460000000006},247,"",""]
[84,"2023-11-18","سند قيد","منتج 1","حسن احمد","خصم مسموح به |  |",null,500.01,75259.450000000012,246,"",""]
[307,"2023-11-19","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,458.5,74800.950000000012,245,"",""]
[1264,"2023-11-20","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",852.7,null,75653.650000000009,244,"",""]
[96,"2023-11-21","سند قبض","منتج 1","حسن احمد","دفعة من الحساب | شيك | 3282",null,40000,35653.650000000009,243,"",""]
[1272,"2023-11-22","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",2645.3,null,38298.950000000012,242,"",""]
[1273,"2023-11-23","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",9290,null,47588.950000000012,241,"",""]
[1274,"2023-11-24","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",6400,null,53988.950000000012,240,"",""]
[1275,"2023-11-25","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",742,null,54730.950000000012,239,"",""]
[1276,"2023-11-26","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",666,null,55396.950000000012,238,"",""]
[1277,"2023-11-27","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1700,null,57096.950000000012,237,"",""]
[1278,"2023-11-28","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",714,null,57810.950000000012,236,"",""]
[1279,"2023-11-29","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",59.35,null,57870.30000000001,235,"",""]
[1283,"2023-11-30","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",139.01,null,58009.310000000012,234,"",""]
[1411,"2023-12-01","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",143,null,58152.310000000012,233,"",""]
[1412,"2023-12-02","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1325.01,null,59477.320000000014,232,"",""]
[1419,"2023-12-03","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",283,null,59760.320000000014,231,"",""]
[1553,"2023-12-04","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",20,null,59780.320000000014,230,"",""]
[755,"2023-12-05","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",14,null,59794.320000000014,229,"",""]
[1681,"2023-12-06","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",214.4,null,60008.720000000016,228,"",""]
[1910,"2023-12-07","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1335,null,61343.720000000016,227,"",""]
[2080,"2023-12-08","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",10,null,61353.720000000016,226,"",""]
[2081,"2023-12-09","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",78.75,null,61432.470000000016,225,"",""]
[2082,"2023-12-10","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",262.5,null,61694.970000000016,224,"",""]
[2083,"2023-12-11","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",262.5,null,61957.470000000016,223,"",""]
[2255,"2023-12-12","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",440,null,62397.470000000016,222,"",""]
[2256,"2023-12-13","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",880,null,63277.470000000016,221,"",""]
[2261,"2023-12-14","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",825,null,64102.470000000016,220,"",""]
[2262,"2023-12-15","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",374,null,64476.470000000016,219,"",""]
[620,"2023-12-16","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,165,64311.470000000016,218,"",""]
[212,"2023-12-17","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,null,64311.470000000016,217,"",""]
[2381,"2023-12-18","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1738,null,66049.470000000016,216,"",""]
[2389,"2023-12-19","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",17,null,66066.470000000016,215,"",""]
[629,"2023-12-20","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,10,66056.470000000016,214,"",""]
[650,"2023-12-21","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,740,65316.470000000016,213,"",""]
[2499,"2023-12-22","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",962,null,66278.470000000016,212,"",""]
[2500,"2023-12-23","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1588,null,67866.470000000016,211,"",""]
[2501,"2023-12-24","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1799,null,69665.470000000016,210,"",""]
[2545,"2023-12-25","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",75,null,69740.470000000016,209,"",""]
[2548,"2023-12-26","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",699,null,70439.470000000016,208,"",""]
[2549,"2023-12-27","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",699,null,71138.470000000016,207,"",""]
[2807,"2023-12-28","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",455,null,71593.470000000016,206,"",""]
[2808,"2023-12-29","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",360,null,71953.470000000016,205,"",""]
[3013,"2023-12-30","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1519,null,73472.470000000016,204,"",""]
[3192,"2023-12-31","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",380,null,73852.470000000016,203,"",""]
[870,"2024-01-01","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,97,73755.470000000016,202,"",""]
[3226,"2024-01-02","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",75,null,73830.470000000016,201,"",""]
[3237,"2024-01-03","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",26084,null,99914.470000000016,200,"",""]
[3250,"2024-01-04","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",183.8,null,100098.27000000002,199,"",""]
[223,"2024-01-05","سند قبض","منتج 1","حسن احمد","قيمة فاتورة 3237| شيك | 3395",null,26084,74014.270000000019,198,"",""]
[3438,"2024-01-06","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",100,null,74114.270000000019,197,"",""]
[255,"2024-01-07","سند قيد","منتج 1","حسن احمد","خصم مسموح به على الفواتير  |  |",null,94,74020.270000000019,196,"",""]
[3685,"2024-01-08","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",5,null,74025.270000000019,195,"",""]
[3686,"2024-01-09","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",73,null,74098.270000000019,194,"",""]
[3687,"2024-01-10","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",29,null,74127.270000000019,193,"",""]
[3730,"2024-01-11","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",3915,null,78042.270000000019,192,"",""]
[3744,"2024-01-12","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",165,null,78207.270000000019,191,"",""]
[1034,"2024-01-13","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,39,78168.270000000019,190,"",""]
[3880,"2024-01-14","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",11058,null,89226.270000000019,189,"",""]
[389,"2024-01-15","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,null,89226.270000000019,188,"",""]
[4047,"2024-01-16","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",145,null,89371.270000000019,187,"",""]
[4139,"2024-01-17","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",91,null,89462.270000000019,186,"",""]
[1133,"2024-01-18","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,830,88632.270000000019,{"$f":"TODAY()-B68","v":185},"",""]
[4196,"2024-01-19","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",475,null,89107.270000000019,184,{"$f":"IF(J69<=30,G69,\"\")","v":""},{"$f":"IF(J69<=30,H69,\"\")","v":""}]
[4199,"2024-01-20","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",186,null,{"$f":"+I69+G70-H70","v":89293.270000000019},183,"",""]
[4806,"2024-01-21","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",732,null,90025.270000000019,182,"",""]
[373,"2024-01-22","سند قيد","منتج 1","حسن احمد","خصم مسموح به على الفواتير2807&2808 |  |",null,25.27,90000.000000000015,181,"",""]
[5246,"2024-01-23","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",30,null,90030.000000000015,180,"",""]
[5248,"2024-01-24","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",4329.5,null,94359.500000000015,179,"",""]
[381,"2024-01-25","سند قبض","منتج 1","حسن احمد","دفعة من الحساب | شيك | 3538",null,40000,54359.500000000015,178,"",""]
[391,"2024-01-26","سند قيد","منتج 1","حسن احمد","خصم قيمة الفاتورة رقم 5246 |  |",null,30,54329.500000000015,177,"",""]
[1449,"2024-01-27","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,1200,53129.500000000015,176,"",""]
[5296,"2024-01-28","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",780,null,53909.500000000015,175,"",""]
[5344,"2024-01-29","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",45,null,53954.500000000015,174,"",""]
[5345,"2024-01-30","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",126,null,54080.500000000015,173,"",""]
[5400,"2024-01-31","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",260,null,54340.500000000015,172,"",""]
[1484,"2024-02-01","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,320,54020.500000000015,171,"",""]
[5450,"2024-02-02","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",876,null,54896.500000000015,170,"",""]
[1497,"2024-02-03","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,48,54848.500000000015,169,"",""]
[5451,"2024-02-04","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",25.6,null,54874.100000000013,168,"",""]
[5493,"2024-02-05","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",315,null,55189.100000000013,167,"",""]
[5536,"2024-02-06","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",45,null,55234.100000000013,166,"",""]
[5594,"2024-02-07","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",60.5,null,55294.600000000013,165,"",""]
[5595,"2024-02-08","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",187,null,55481.600000000013,164,"",""]
[1554,"2024-02-09","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,60.5,55421.100000000013,163,"",""]
[1555,"2024-02-10","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,187,55234.100000000013,162,"",""]
[5646,"2024-02-11","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",150,null,55384.100000000013,161,"",""]
[5647,"2024-02-12","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",51,null,55435.100000000013,160,"",""]
[5651,"2024-02-13","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1,null,55436.100000000013,159,"",""]
[5677,"2024-02-14","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",29112,null,84548.1,158,"",""]
[5708,"2024-02-15","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",33,null,84581.1,157,"",""]
[5734,"2024-02-16","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",74,null,84655.1,156,"",""]
[1597,"2024-02-17","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,3877,80778.100000000006,155,"",""]
[5812,"2024-02-18","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",4062,null,84840.1,154,"",""]
[1608,"2024-02-19","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,528,84312.1,153,"",""]
[5924,"2024-02-20","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",45,null,84357.1,152,"",""]
[5952,"2024-02-21","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1295,null,85652.1,151,"",""]
[6035,"2024-02-22","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1300,null,86952.1,150,"",""]
[6086,"2024-02-23","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",405,null,87357.1,149,"",""]
[6333,"2024-02-24","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",167,null,87524.1,148,"",""]
[6334,"2024-02-25","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",49,null,87573.1,147,"",""]
[535,"2024-02-26","سند قيد","منتج 1","حسن احمد","خصم مسموح به 1% على الفاتورة رقم 5677 |  |",null,291,87282.1,146,"",""]
[7044,"2024-02-27","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",2590,null,89872.1,145,"",""]
[531,"2024-02-28","سند قبض","منتج 1","حسن احمد","دفعة من الحساب | شيك | 3730",null,35000,54872.100000000006,144,"",""]
[7254,"2024-02-29","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",56,null,54928.100000000006,143,"",""]
[7306,"2024-03-01","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",8170,null,63098.100000000006,142,"",""]
[7357,"2024-03-02","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",40,null,63138.100000000006,141,"",""]
[7362,"2024-03-03","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",375,null,63513.100000000006,140,"",""]
[7397,"2024-03-04","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",333,null,63846.100000000006,139,"",""]
[1935,"2024-03-05","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,4270,59576.100000000006,138,"",""]
[7426,"2024-03-06","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",3185,null,62761.100000000006,137,"",""]
[7640,"2024-03-07","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",414,null,63175.100000000006,136,"",""]
[7689,"2024-03-08","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",425,null,63600.100000000006,135,"",""]
[7785,"2024-03-09","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",480,null,64080.100000000006,134,"",""]
[7808,"2024-03-10","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",4202,null,68282.100000000006,133,"",""]
[7913,"2024-03-11","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",580,null,68862.100000000006,132,"",""]
[7914,"2024-03-12","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1728,null,70590.100000000006,131,"",""]
[7987,"2024-03-13","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",99,null,70689.100000000006,130,"",""]
[7988,"2024-03-14","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",145,null,70834.100000000006,129,"",""]
[7989,"2024-03-15","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",145,null,70979.100000000006,128,"",""]
[8082,"2024-03-16","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",2116,null,73095.100000000006,127,"",""]
[2071,"2024-03-17","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,2116,70979.100000000006,126,"",""]
[8084,"2024-03-18","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",2156,null,73135.100000000006,125,"",""]
[8085,"2024-03-19","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",3100,null,76235.100000000006,124,"",""]
[8086,"2024-03-20","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",3909,null,80144.100000000006,123,"",""]
[8087,"2024-03-21","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",2116,null,82260.100000000006,122,"",""]
[2103,"2024-03-22","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,128,82132.100000000006,{"$f":"TODAY()-B132","v":121},"",""]
[2104,"2024-03-23","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,128,82004.100000000006,120,{"$f":"IF(J133<=30,G133,\"\")","v":""},{"$f":"IF(J133<=30,H133,\"\")","v":""}]
[2105,"2024-03-24","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,184,{"$f":"+I133+G134-H134","v":81820.100000000006},119,"",""]
[2106,"2024-03-25","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,232,81588.100000000006,118,"",""]
[8170,"2024-03-26","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",198,null,81786.100000000006,117,"",""]
[8245,"2024-03-27","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",625,null,82411.100000000006,116,"",""]
[740,"2024-03-28","سند قيد","منتج 1","حسن احمد","خصم مسموح به (فرق الخصم) |  |",null,46.1,82365,115,"",""]
[8445,"2024-03-29","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",97,null,82462,114,"",""]
[813,"2024-03-30","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,null,82462,113,"",""]
[8480,"2024-03-31","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",890,null,83352,112,"",""]
[8481,"2024-04-01","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",990,null,84342,111,"",""]
[8487,"2024-04-02","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1902,null,86244,110,"",""]
[763,"2024-04-03","سند قيد","منتج 1","حسن احمد","خصم مسموح به على الفاتورة رقم 1275 |  |",null,50,86194,109,"",""]
[667,"2024-04-04","سند قبض","منتج 1","حسن احمد","دفعة من الحساب | شيك | 3872",null,15709,70485,108,"",""]
[9191,"2024-04-05","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",140,null,70625,107,"",""]
[9192,"2024-04-06","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",188,null,70813,106,"",""]
[9193,"2024-04-07","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",372,null,71185,105,"",""]
[9213,"2024-04-08","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1100,null,72285,104,"",""]
[683,"2024-04-09","سند قبض","منتج 1","حسن احمد","دفعة من الحساب | شيك | 3937",null,35000,37285,103,"",""]
[861,"2024-04-10","سند قيد","منتج 1","حسن احمد","صرف شيك رقم 3938 الرياض بالخطأ قبل تاريخه |  |",null,35485,1800,102,"",""]
[9443,"2024-04-11","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",135,null,1935,101,"",""]
[9448,"2024-04-12","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",600,null,2535,100,"",""]
[877,"2024-04-13","سند قيد","منتج 1","حسن احمد","صرف شيك رقم 835 مقابل الشيك 3938 |  |",null,35485,-32950,99,"",""]
[9496,"2024-04-14","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",792,null,-32158,98,"",""]
[9497,"2024-04-15","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1144,null,-31014,97,"",""]
[9519,"2024-04-16","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",9092,null,-21922,96,"",""]
[9525,"2024-04-17","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",7658,null,-14264,95,"",""]
[9526,"2024-04-18","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",50,null,-14214,94,"",""]
[9696,"2024-04-19","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",140,null,-14074,93,"",""]
[9697,"2024-04-20","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",22.5,null,-14051.5,92,"",""]
[9835,"2024-04-21","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",68,null,-13983.5,91,"",""]
[9836,"2024-04-22","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",68,null,-13915.5,90,"",""]
[9837,"2024-04-23","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",68,null,-13847.5,89,"",""]
[9838,"2024-04-24","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1729,null,-12118.5,88,"",""]
[9839,"2024-04-25","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",2375.0100000000002,null,-9743.49,87,"",""]
[9840,"2024-04-26","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1729,null,-8014.49,86,"",""]
[9844,"2024-04-27","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",9360,null,1345.5100000000002,85,"",""]
[9908,"2024-04-28","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",650,null,1995.5100000000002,84,"",""]
[9909,"2024-04-29","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",3099,null,5094.51,83,"",""]
[9910,"2024-04-30","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",385,null,5479.51,82,"",""]
[9962,"2024-05-01","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1246,null,6725.51,81,"",""]
[10064,"2024-05-02","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",233,null,6958.51,80,"",""]
[10219,"2024-05-03","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",5030,null,11988.51,79,"",""]
[10237,"2024-05-04","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",493,null,12481.51,78,"",""]
[986,"2024-05-05","سند قيد","منتج 1","حسن احمد","خصم فرق القزاز على الفاتورة رقم 9839 بسعر 1.8 |  |",null,856.8,11624.710000000001,77,"",""]
[987,"2024-05-06","سند قيد","منتج 1","حسن احمد","خصم فرق القزاز على الفاتورة رقم 9840بسعر 1.8 |  |",null,624,11000.710000000001,76,"",""]
[988,"2024-05-07","سند قيد","منتج 1","حسن احمد","خصم فرق القزاز على الفاتورة رقم 9838بسعر 1.8 |  |",null,624,10376.710000000001,75,"",""]
[10450,"2024-05-08","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",70,null,10446.710000000001,74,"",""]
[10451,"2024-05-09","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",437,null,10883.710000000001,73,"",""]
[10453,"2024-05-10","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1000,null,11883.710000000001,72,"",""]
[10528,"2024-05-11","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",6.4,null,11890.11,71,"",""]
[10529,"2024-05-12","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",6.4,null,11896.51,70,"",""]
[10530,"2024-05-13","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",14.4,null,11910.91,69,"",""]
[10531,"2024-05-14","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",6.4,null,11917.31,68,"",""]
[773,"2024-05-15","سند قبض","منتج 1","حسن احمد","سداد دفعة من الحساب | شيك | 3965",null,35485,-23567.690000000002,67,"",""]
[10566,"2024-05-16","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",29362,null,5794.3099999999977,66,"",""]
[11106,"2024-05-17","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1052,null,6846.3099999999977,65,"",""]
[11431,"2024-05-18","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",4875,null,11721.309999999998,64,"",""]
[816,"2024-05-19","سند قبض","منتج 1","حسن احمد","دفعة من الحساب | شيك | 4065",null,34705,-22983.690000000002,63,"",""]
[11620,"2024-05-20","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1268,null,-21715.690000000002,62,"",""]
[11913,"2024-05-21","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",518,null,-21197.690000000002,61,"",""]
[3106,"2024-05-22","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,4875,-26072.690000000002,60,"",""]
[11981,"2024-05-23","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",23,null,-26049.690000000002,59,"",""]
[12102,"2024-05-24","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",68,null,-25981.690000000002,58,"",""]
[12103,"2024-05-25","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",231,null,-25750.690000000002,{"$f":"TODAY()-B196","v":57},"",""]
[12163,"2024-05-26","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",28,null,-25722.690000000002,56,{"$f":"IF(J197<=30,G197,\"\")","v":""},{"$f":"IF(J197<=30,H197,\"\")","v":""}]
[12164,"2024-05-27","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",10,null,{"$f":"+I197+G198-H198","v":-25712.690000000002},55,"",""]
[12303,"2024-05-28","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",17,null,-25695.690000000002,54,"",""]
[12414,"2024-05-29","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",92.4,null,-25603.29,53,"",""]
[12435,"2024-05-30","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",2518,null,-23085.29,52,"",""]
[875,"2024-05-31","سند قبض","منتج 1","حسن احمد","دفعة من الحساب | شيك | 4154",null,42036,-65121.29,51,"",""]
[12581,"2024-06-01","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",150,null,-64971.29,50,"",""]
[12630,"2024-06-02","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",20,null,-64951.29,49,"",""]
[12743,"2024-06-03","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",505,null,-64446.29,48,"",""]
[12811,"2024-06-04","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",45,null,-64401.29,47,"",""]
[12956,"2024-06-05","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",106,null,-64295.29,46,"",""]
[13308,"2024-06-06","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",232,null,-64063.29,45,"",""]
[13350,"2024-06-07","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",696,null,-63367.29,44,"",""]
[13351,"2024-06-08","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",26.65,null,-63340.639999999999,43,"",""]
[13378,"2024-06-09","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1740,null,-61600.639999999999,42,"",""]
[13420,"2024-06-10","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",139.65,null,-61460.99,41,"",""]
[13421,"2024-06-11","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",8.6999999999999993,null,-61452.29,40,"",""]
[13487,"2024-06-12","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",185,null,-61267.29,39,"",""]
[13580,"2024-06-13","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",100,null,-61167.29,38,"",""]
[3550,"2024-06-14","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,100,-61267.29,37,"",""]
[13582,"2024-06-15","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",100,null,-61167.29,36,"",""]
[13701,"2024-06-16","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",25,null,-61142.29,35,"",""]
[13761,"2024-06-17","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",90,null,-61052.29,34,"",""]
[13910,"2024-06-18","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",41,null,-61011.29,33,"",""]
[13911,"2024-06-19","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",48,null,-60963.29,32,"",""]
[13912,"2024-06-20","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",303,null,-60660.29,31,"",""]
[13914,"2024-06-21","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",32,null,-60628.29,30,{"$f":"IF(J223<=30,G223,\"\")","v":32},0]
[13970,"2024-06-22","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",297,null,-60331.29,29,297,0]
[14137,"2024-06-23","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",520,null,-59811.29,28,520,0]
[14361,"2024-06-24","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",355,null,-59456.29,27,355,0]
[3760,"2024-06-25","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,355,-59811.29,26,0,355]
[14362,"2024-06-26","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",218,null,-59593.29,25,218,0]
[14454,"2024-06-27","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",48,null,-59545.29,24,48,0]
[988,"2024-06-28","سند قبض","منتج 1","حسن احمد","دفعة من الحساب | شيك | 4298",null,6674,-66219.290000000008,23,0,6674]
[15310,"2024-06-29","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1259,null,-64960.290000000008,22,1259,0]
[15311,"2024-06-30","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",46,null,-64914.290000000008,21,46,0]
[3997,"2024-07-01","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,1080,-65994.290000000008,20,0,1080]
[15408,"2024-07-02","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",23.25,null,-65971.040000000008,19,23.25,0]
[15617,"2024-07-03","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",44.64,null,-65926.400000000009,18,44.64,0]
[15625,"2024-07-04","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",150,null,-65776.400000000009,17,150,0]
[15626,"2024-07-05","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",72,null,-65704.400000000009,16,72,0]
[15698,"2024-07-06","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",387,null,-65317.400000000009,15,387,0]
[15699,"2024-07-07","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",93,null,-65224.400000000009,14,93,0]
[16413,"2024-07-08","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",584,null,-64640.400000000009,13,584,0]
[16506,"2024-07-09","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",392,null,-64248.400000000009,12,392,0]
[16620,"2024-07-10","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",142,null,-64106.400000000009,11,142,0]
[16621,"2024-07-11","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",108,null,-63998.400000000009,10,108,0]
[16622,"2024-07-12","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",108,null,-63890.400000000009,9,108,0]
[16682,"2024-07-13","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",61,null,-63829.400000000009,8,61,0]
[16866,"2024-07-14","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",9.3000000000000007,null,-63820.100000000006,7,9.3000000000000007,0]
[16867,"2024-07-15","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",30,null,-63790.100000000006,6,30,0]
[17109,"2024-07-16","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",195,null,-63595.100000000006,5,195,0]
[4472,"2024-07-17","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,584,-64179.100000000006,4,0,584]
[1872,"2024-07-18","سند قبض","منتج 1","حسن احمد","دفعة من الحساب | شيك | 4410",null,4749,{"$f":"+I249+G250-H250","v":-68928.100000000006},3,0,4749]
[17864,"2024-07-19","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",168,null,-68760.100000000006,2,168,0]

{"sheet":"تصدير بيانات اكسيل","index":2,"n_rows":6,"n_cols":12,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["رقم\nالمستند","الـتـاريــخ","نوع المستند","اسم الصنف","اسم العميل","الــــشـــــرح","مديــن","دائن","الرصيد","عمر الدين","المبيعات","التحصيل"]
[176,"2023-11-16","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,2385.1999999999998,74669.260000000009,247]
[725,"2023-11-17","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1090.2,null,75759.460000000006,246]
[84,"2023-11-18","سند قيد","منتج 1","حسن احمد","خصم مسموح به |  |",null,500.01,75259.450000000012,245]
[307,"2023-11-19","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,458.5,74800.950000000012,244]
[1264,"2023-11-20","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",852.7,null,75653.650000000009,243]

{"sheet":"الطباعة","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

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