{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["قواعد بيانات","كشف حساب","تصدير بيانات اكسيل","الطباعة"],"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":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":17,"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":6242.89},379065.38]
[null,null,null,null,null,null,null,null,null,null,"من 1 : 30 يوم",null,null,{"$f":"I251","v":2209.8999999999851},"الرصيد",{"$f":"P1-Q1","v":-372822.49}]
["رقم\nالمستند","الـتـاريــخ","نوع المستند","اسم الصنف","اسم العميل","الــــشـــــرح","مديــن","دائن","الرصيد","عمر الدين","المبيعات","التحصيل"]
[1,"2023-11-15","قيد","منتج 1","حسن احمد","رصيد مرحل",77054.460000000006,null,{"$f":"G4","v":77054.460000000006},{"$f":"TODAY()-B4","v":239},{"$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},238,{"$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},237,"",""]
[84,"2023-11-18","سند قيد","منتج 1","حسن احمد","خصم مسموح به |  |",null,500.01,75259.450000000012,236,"",""]
[307,"2023-11-19","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,458.5,74800.950000000012,235,"",""]
[1264,"2023-11-20","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",852.7,null,75653.650000000009,234,"",""]
[96,"2023-11-21","سند قبض","منتج 1","حسن احمد","دفعة من الحساب | شيك | 3282",null,40000,35653.650000000009,233,"",""]
[1272,"2023-11-22","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",2645.3,null,38298.950000000012,232,"",""]
[1273,"2023-11-23","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",9290,null,47588.950000000012,231,"",""]
[1274,"2023-11-24","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",6400,null,53988.950000000012,230,"",""]
[1275,"2023-11-25","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",742,null,54730.950000000012,229,"",""]
[1276,"2023-11-26","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",666,null,55396.950000000012,228,"",""]
[1277,"2023-11-27","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1700,null,57096.950000000012,227,"",""]
[1278,"2023-11-28","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",714,null,57810.950000000012,226,"",""]
[1279,"2023-11-29","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",59.35,null,57870.30000000001,225,"",""]
[1283,"2023-11-30","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",139.01,null,58009.310000000012,224,"",""]
[1411,"2023-12-01","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",143,null,58152.310000000012,223,"",""]
[1412,"2023-12-02","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1325.01,null,59477.320000000014,222,"",""]
[1419,"2023-12-03","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",283,null,59760.320000000014,221,"",""]
[1553,"2023-12-04","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",20,null,59780.320000000014,220,"",""]
[755,"2023-12-05","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",14,null,59794.320000000014,219,"",""]
[1681,"2023-12-06","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",214.4,null,60008.720000000016,218,"",""]
[1910,"2023-12-07","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1335,null,61343.720000000016,217,"",""]
[2080,"2023-12-08","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",10,null,61353.720000000016,216,"",""]
[2081,"2023-12-09","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",78.75,null,61432.470000000016,215,"",""]
[2082,"2023-12-10","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",262.5,null,61694.970000000016,214,"",""]
[2083,"2023-12-11","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",262.5,null,61957.470000000016,213,"",""]
[2255,"2023-12-12","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",440,null,62397.470000000016,212,"",""]
[2256,"2023-12-13","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",880,null,63277.470000000016,211,"",""]
[2261,"2023-12-14","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",825,null,64102.470000000016,210,"",""]
[2262,"2023-12-15","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",374,null,64476.470000000016,209,"",""]
[620,"2023-12-16","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,165,64311.470000000016,208,"",""]
[212,"2023-12-17",null,"منتج 1","حسن احمد","عميل رقم 101174",null,null,64311.470000000016,207,"",""]
[2381,"2023-12-18","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1738,null,66049.470000000016,206,"",""]
[2389,"2023-12-19","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",17,null,66066.470000000016,205,"",""]
[629,"2023-12-20","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,10,66056.470000000016,204,"",""]
[650,"2023-12-21","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,740,65316.470000000016,203,"",""]
[2499,"2023-12-22","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",962,null,66278.470000000016,202,"",""]
[2500,"2023-12-23","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1588,null,67866.470000000016,201,"",""]
[2501,"2023-12-24","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1799,null,69665.470000000016,200,"",""]
[2545,"2023-12-25","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",75,null,69740.470000000016,199,"",""]
[2548,"2023-12-26","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",699,null,70439.470000000016,198,"",""]
[2549,"2023-12-27","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",699,null,71138.470000000016,197,"",""]
[2807,"2023-12-28","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",455,null,71593.470000000016,196,"",""]
[2808,"2023-12-29","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",360,null,71953.470000000016,195,"",""]
[3013,"2023-12-30","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1519,null,73472.470000000016,194,"",""]
[3192,"2023-12-31","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",380,null,73852.470000000016,193,"",""]
[870,"2024-01-01","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,97,73755.470000000016,192,"",""]
[3226,"2024-01-02","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",75,null,73830.470000000016,191,"",""]
[3237,"2024-01-03","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",26084,null,99914.470000000016,190,"",""]
[3250,"2024-01-04","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",183.8,null,100098.27000000002,189,"",""]
[223,"2024-01-05","سند قبض","منتج 1","حسن احمد","قيمة فاتورة 3237| شيك | 3395",null,26084,74014.270000000019,188,"",""]
[3438,"2024-01-06","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",100,null,74114.270000000019,187,"",""]
[255,"2024-01-07","سند قيد","منتج 1","حسن احمد","خصم مسموح به على الفواتير  |  |",null,94,74020.270000000019,186,"",""]
[3685,"2024-01-08","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",5,null,74025.270000000019,185,"",""]
[3686,"2024-01-09","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",73,null,74098.270000000019,184,"",""]
[3687,"2024-01-10","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",29,null,74127.270000000019,183,"",""]
[3730,"2024-01-11","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",3915,null,78042.270000000019,182,"",""]
[3744,"2024-01-12","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",165,null,78207.270000000019,181,"",""]
[1034,"2024-01-13","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,39,78168.270000000019,180,"",""]
[3880,"2024-01-14","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",11058,null,89226.270000000019,179,"",""]
[389,"2024-01-15","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,null,89226.270000000019,178,"",""]
[4047,"2024-01-16","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",145,null,89371.270000000019,177,"",""]
[4139,"2024-01-17","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",91,null,89462.270000000019,176,"",""]
[1133,"2024-01-18","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,830,88632.270000000019,{"$f":"TODAY()-B68","v":175},"",""]
[4196,"2024-01-19","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",475,null,89107.270000000019,174,{"$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},173,"",""]
[4806,"2024-01-21","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",732,null,90025.270000000019,172,"",""]
[373,"2024-01-22","سند قيد","منتج 1","حسن احمد","خصم مسموح به على الفواتير2807&2808 |  |",null,25.27,90000.000000000015,171,"",""]
[5246,"2024-01-23","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",30,null,90030.000000000015,170,"",""]
[5248,"2024-01-24","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",4329.5,null,94359.500000000015,169,"",""]
[381,"2024-01-25","سند قبض","منتج 1","حسن احمد","دفعة من الحساب | شيك | 3538",null,40000,54359.500000000015,168,"",""]
[391,"2024-01-26","سند قيد","منتج 1","حسن احمد","خصم قيمة الفاتورة رقم 5246 |  |",null,30,54329.500000000015,167,"",""]
[1449,"2024-01-27","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,1200,53129.500000000015,166,"",""]
[5296,"2024-01-28","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",780,null,53909.500000000015,165,"",""]
[5344,"2024-01-29","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",45,null,53954.500000000015,164,"",""]
[5345,"2024-01-30","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",126,null,54080.500000000015,163,"",""]
[5400,"2024-01-31","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",260,null,54340.500000000015,162,"",""]
[1484,"2024-02-01","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,320,54020.500000000015,161,"",""]
[5450,"2024-02-02","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",876,null,54896.500000000015,160,"",""]
[1497,"2024-02-03","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,48,54848.500000000015,159,"",""]
[5451,"2024-02-04","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",25.6,null,54874.100000000013,158,"",""]
[5493,"2024-02-05","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",315,null,55189.100000000013,157,"",""]
[5536,"2024-02-06","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",45,null,55234.100000000013,156,"",""]
[5594,"2024-02-07","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",60.5,null,55294.600000000013,155,"",""]
[5595,"2024-02-08","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",187,null,55481.600000000013,154,"",""]
[1554,"2024-02-09","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,60.5,55421.100000000013,153,"",""]
[1555,"2024-02-10","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,187,55234.100000000013,152,"",""]
[5646,"2024-02-11","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",150,null,55384.100000000013,151,"",""]
[5647,"2024-02-12","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",51,null,55435.100000000013,150,"",""]
[5651,"2024-02-13","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1,null,55436.100000000013,149,"",""]
[5677,"2024-02-14","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",29112,null,84548.1,148,"",""]
[5708,"2024-02-15","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",33,null,84581.1,147,"",""]
[5734,"2024-02-16","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",74,null,84655.1,146,"",""]
[1597,"2024-02-17","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,3877,80778.100000000006,145,"",""]
[5812,"2024-02-18","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",4062,null,84840.1,144,"",""]
[1608,"2024-02-19","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,528,84312.1,143,"",""]
[5924,"2024-02-20","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",45,null,84357.1,142,"",""]
[5952,"2024-02-21","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1295,null,85652.1,141,"",""]
[6035,"2024-02-22","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1300,null,86952.1,140,"",""]
[6086,"2024-02-23","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",405,null,87357.1,139,"",""]
[6333,"2024-02-24","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",167,null,87524.1,138,"",""]
[6334,"2024-02-25","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",49,null,87573.1,137,"",""]
[535,"2024-02-26","سند قيد","منتج 1","حسن احمد","خصم مسموح به 1% على الفاتورة رقم 5677 |  |",null,291,87282.1,136,"",""]
[7044,"2024-02-27","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",2590,null,89872.1,135,"",""]
[531,"2024-02-28","سند قبض","منتج 1","حسن احمد","دفعة من الحساب | شيك | 3730",null,35000,54872.100000000006,134,"",""]
[7254,"2024-02-29","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",56,null,54928.100000000006,133,"",""]
[7306,"2024-03-01","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",8170,null,63098.100000000006,132,"",""]
[7357,"2024-03-02","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",40,null,63138.100000000006,131,"",""]
[7362,"2024-03-03","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",375,null,63513.100000000006,130,"",""]
[7397,"2024-03-04","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",333,null,63846.100000000006,129,"",""]
[1935,"2024-03-05","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,4270,59576.100000000006,128,"",""]
[7426,"2024-03-06","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",3185,null,62761.100000000006,127,"",""]
[7640,"2024-03-07","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",414,null,63175.100000000006,126,"",""]
[7689,"2024-03-08","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",425,null,63600.100000000006,125,"",""]
[7785,"2024-03-09","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",480,null,64080.100000000006,124,"",""]
[7808,"2024-03-10","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",4202,null,68282.100000000006,123,"",""]
[7913,"2024-03-11","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",580,null,68862.100000000006,122,"",""]
[7914,"2024-03-12","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1728,null,70590.100000000006,121,"",""]
[7987,"2024-03-13","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",99,null,70689.100000000006,120,"",""]
[7988,"2024-03-14","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",145,null,70834.100000000006,119,"",""]
[7989,"2024-03-15","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",145,null,70979.100000000006,118,"",""]
[8082,"2024-03-16","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",2116,null,73095.100000000006,117,"",""]
[2071,"2024-03-17","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,2116,70979.100000000006,116,"",""]
[8084,"2024-03-18","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",2156,null,73135.100000000006,115,"",""]
[8085,"2024-03-19","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",3100,null,76235.100000000006,114,"",""]
[8086,"2024-03-20","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",3909,null,80144.100000000006,113,"",""]
[8087,"2024-03-21","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",2116,null,82260.100000000006,112,"",""]
[2103,"2024-03-22","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,128,82132.100000000006,{"$f":"TODAY()-B132","v":111},"",""]
[2104,"2024-03-23","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,128,82004.100000000006,110,{"$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},109,"",""]
[2106,"2024-03-25","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,232,81588.100000000006,108,"",""]
[8170,"2024-03-26","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",198,null,81786.100000000006,107,"",""]
[8245,"2024-03-27","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",625,null,82411.100000000006,106,"",""]
[740,"2024-03-28","سند قيد","منتج 1","حسن احمد","خصم مسموح به (فرق الخصم) |  |",null,46.1,82365,105,"",""]
[8445,"2024-03-29","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",97,null,82462,104,"",""]
[813,"2024-03-30",null,"منتج 1","حسن احمد","عميل رقم 101174",null,null,82462,103,"",""]
[8480,"2024-03-31","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",890,null,83352,102,"",""]
[8481,"2024-04-01","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",990,null,84342,101,"",""]
[8487,"2024-04-02","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1902,null,86244,100,"",""]
[763,"2024-04-03","سند قيد","منتج 1","حسن احمد","خصم مسموح به على الفاتورة رقم 1275 |  |",null,50,86194,99,"",""]
[667,"2024-04-04","سند قبض","منتج 1","حسن احمد","دفعة من الحساب | شيك | 3872",null,15709,70485,98,"",""]
[9191,"2024-04-05","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",140,null,70625,97,"",""]
[9192,"2024-04-06","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",188,null,70813,96,"",""]
[9193,"2024-04-07","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",372,null,71185,95,"",""]
[9213,"2024-04-08","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1100,null,72285,94,"",""]
[683,"2024-04-09","سند قبض","منتج 1","حسن احمد","دفعة من الحساب | شيك | 3937",null,35000,37285,93,"",""]
[861,"2024-04-10","سند قيد","منتج 1","حسن احمد","صرف شيك رقم 3938 الرياض بالخطأ قبل تاريخه |  |",null,35485,1800,92,"",""]
[9443,"2024-04-11","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",135,null,1935,91,"",""]
[9448,"2024-04-12","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",600,null,2535,90,"",""]
[877,"2024-04-13","سند قيد","منتج 1","حسن احمد","صرف شيك رقم 835 مقابل الشيك 3938 |  |",35485,null,38020,89,"",""]
[9496,"2024-04-14","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",792,null,38812,88,"",""]
[9497,"2024-04-15","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1144,null,39956,87,"",""]
[9519,"2024-04-16","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",9092,null,49048,86,"",""]
[9525,"2024-04-17","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",7658,null,56706,85,"",""]
[9526,"2024-04-18","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",50,null,56756,84,"",""]
[9696,"2024-04-19","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",140,null,56896,83,"",""]
[9697,"2024-04-20","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",22.5,null,56918.5,82,"",""]
[9835,"2024-04-21","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",68,null,56986.5,81,"",""]
[9836,"2024-04-22","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",68,null,57054.5,80,"",""]
[9837,"2024-04-23","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",68,null,57122.5,79,"",""]
[9838,"2024-04-24","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1729,null,58851.5,78,"",""]
[9839,"2024-04-25","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",2375.0100000000002,null,61226.51,77,"",""]
[9840,"2024-04-26","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1729,null,62955.51,76,"",""]
[9844,"2024-04-27","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",9360,null,72315.510000000009,75,"",""]
[9908,"2024-04-28","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",650,null,72965.510000000009,74,"",""]
[9909,"2024-04-29","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",3099,null,76064.510000000009,73,"",""]
[9910,"2024-04-30","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",385,null,76449.510000000009,72,"",""]
[9962,"2024-05-01","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1246,null,77695.510000000009,71,"",""]
[10064,"2024-05-02","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",233,null,77928.510000000009,70,"",""]
[10219,"2024-05-03","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",5030,null,82958.510000000009,69,"",""]
[10237,"2024-05-04","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",493,null,83451.510000000009,68,"",""]
[986,"2024-05-05","سند قيد","منتج 1","حسن احمد","خصم فرق القزاز على الفاتورة رقم 9839 بسعر 1.8 |  |",null,856.8,82594.710000000006,67,"",""]
[987,"2024-05-06","سند قيد","منتج 1","حسن احمد","خصم فرق القزاز على الفاتورة رقم 9840بسعر 1.8 |  |",null,624,81970.710000000006,66,"",""]
[988,"2024-05-07","سند قيد","منتج 1","حسن احمد","خصم فرق القزاز على الفاتورة رقم 9838بسعر 1.8 |  |",null,624,81346.710000000006,65,"",""]
[10450,"2024-05-08","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",70,null,81416.710000000006,64,"",""]
[10451,"2024-05-09","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",437,null,81853.710000000006,63,"",""]
[10453,"2024-05-10","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1000,null,82853.710000000006,62,"",""]
[10528,"2024-05-11","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",6.4,null,82860.11,61,"",""]
[10529,"2024-05-12","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",6.4,null,82866.509999999995,60,"",""]
[10530,"2024-05-13","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",14.4,null,82880.909999999989,59,"",""]
[10531,"2024-05-14","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",6.4,null,82887.309999999983,58,"",""]
[773,"2024-05-15","سند قبض","منتج 1","حسن احمد","سداد دفعة من الحساب | شيك | 3965",null,35485,47402.309999999983,57,"",""]
[10566,"2024-05-16","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",29362,null,76764.309999999983,56,"",""]
[11106,"2024-05-17","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1052,null,77816.309999999983,55,"",""]
[11431,"2024-05-18","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",4875,null,82691.309999999983,54,"",""]
[816,"2024-05-19","سند قبض","منتج 1","حسن احمد","دفعة من الحساب | شيك | 4065",null,34705,47986.309999999983,53,"",""]
[11620,"2024-05-20","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1268,null,49254.309999999983,52,"",""]
[11913,"2024-05-21","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",518,null,49772.309999999983,51,"",""]
[3106,"2024-05-22","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,4875,44897.309999999983,50,"",""]
[11981,"2024-05-23","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",23,null,44920.309999999983,49,"",""]
[12102,"2024-05-24","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",68,null,44988.309999999983,48,"",""]
[12103,"2024-05-25","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",231,null,45219.309999999983,{"$f":"TODAY()-B196","v":47},"",""]
[12163,"2024-05-26","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",28,null,45247.309999999983,46,{"$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":45257.309999999983},45,"",""]
[12303,"2024-05-28","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",17,null,45274.309999999983,44,"",""]
[12414,"2024-05-29","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",92.4,null,45366.709999999985,43,"",""]
[12435,"2024-05-30","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",2518,null,47884.709999999985,42,"",""]
[875,"2024-05-31","سند قبض","منتج 1","حسن احمد","دفعة من الحساب | شيك | 4154",null,42036,5848.7099999999846,41,"",""]
[12581,"2024-06-01","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",150,null,5998.7099999999846,40,"",""]
[12630,"2024-06-02","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",20,null,6018.7099999999846,39,"",""]
[12743,"2024-06-03","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",505,null,6523.7099999999846,38,"",""]
[12811,"2024-06-04","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",45,null,6568.7099999999846,37,"",""]
[12956,"2024-06-05","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",106,null,6674.7099999999846,36,"",""]
[13308,"2024-06-06","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",232,null,6906.7099999999846,35,"",""]
[13350,"2024-06-07","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",696,null,7602.7099999999846,34,"",""]
[13351,"2024-06-08","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",26.65,null,7629.3599999999842,33,"",""]
[13378,"2024-06-09","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1740,null,9369.3599999999842,32,"",""]
[13420,"2024-06-10","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",139.65,null,9509.0099999999838,31,"",""]
[13421,"2024-06-11","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",8.6999999999999993,null,9517.7099999999846,30,8.6999999999999993,0]
[13487,"2024-06-12","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",185,null,9702.7099999999846,29,185,0]
[13580,"2024-06-13","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",100,null,9802.7099999999846,28,100,0]
[3550,"2024-06-14","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,100,9702.7099999999846,27,0,100]
[13582,"2024-06-15","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",100,null,9802.7099999999846,26,100,0]
[13701,"2024-06-16","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",25,null,9827.7099999999846,25,25,0]
[13761,"2024-06-17","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",90,null,9917.7099999999846,24,90,0]
[13910,"2024-06-18","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",41,null,9958.7099999999846,23,41,0]
[13911,"2024-06-19","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",48,null,10006.709999999985,22,48,0]
[13912,"2024-06-20","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",303,null,10309.709999999985,21,303,0]
[13914,"2024-06-21","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",32,null,10341.709999999985,20,32,0]
[13970,"2024-06-22","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",297,null,10638.709999999985,19,297,0]
[14137,"2024-06-23","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",520,null,11158.709999999985,18,520,0]
[14361,"2024-06-24","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",355,null,11513.709999999985,17,355,0]
[3760,"2024-06-25","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,355,11158.709999999985,16,0,355]
[14362,"2024-06-26","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",218,null,11376.709999999985,15,218,0]
[14454,"2024-06-27","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",48,null,11424.709999999985,14,48,0]
[988,"2024-06-28","سند قبض","منتج 1","حسن احمد","دفعة من الحساب | شيك | 4298",null,6674,4750.7099999999846,13,0,6674]
[15310,"2024-06-29","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",1259,null,6009.7099999999846,12,1259,0]
[15311,"2024-06-30","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",46,null,6055.7099999999846,11,46,0]
[3997,"2024-07-01","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,1080,4975.7099999999846,10,0,1080]
[15408,"2024-07-02","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",23.25,null,4998.9599999999846,9,23.25,0]
[15617,"2024-07-03","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",44.64,null,5043.5999999999849,8,44.64,0]
[15625,"2024-07-04","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",150,null,5193.5999999999849,7,150,0]
[15626,"2024-07-05","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",72,null,5265.5999999999849,6,72,0]
[15698,"2024-07-06","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",387,null,5652.5999999999849,5,387,0]
[15699,"2024-07-07","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",93,null,5745.5999999999849,4,93,0]
[16413,"2024-07-08","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",584,null,6329.5999999999849,3,584,0]
[16506,"2024-07-09","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",392,null,6721.5999999999849,2,392,0]
[16620,"2024-07-10","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",142,null,6863.5999999999849,1,142,0]
[16621,"2024-07-11","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",108,null,6971.5999999999849,0,108,0]
[16622,"2024-07-12","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",108,null,7079.5999999999849,-1,108,0]
[16682,"2024-07-13","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",61,null,7140.5999999999849,-2,61,0]
[16866,"2024-07-14","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",9.3000000000000007,null,7149.8999999999851,-3,9.3000000000000007,0]
[16867,"2024-07-15","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",30,null,7179.8999999999851,-4,30,0]
[17109,"2024-07-16","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",195,null,7374.8999999999851,-5,195,0]
[4472,"2024-07-17","مردودات مبيعات","منتج 1","حسن احمد","عميل رقم 101174",null,584,6790.8999999999851,-6,0,584]
[1872,"2024-07-18","سند قبض","منتج 1","حسن احمد","دفعة من الحساب | شيك | 4410",null,4749,2041.8999999999851,-7,0,4749]
[17864,"2024-07-19","مبيعات","منتج 1","حسن احمد","عميل رقم 101174",168,null,2209.8999999999851,-8,168,0]

{"sheet":"تصدير بيانات اكسيل","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

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