Spreadsheet: 816794d1675841172-formula-help-need-for-a-table-for-customer-with-monthwise-sample-customer-details
Sheet: Apr22-Mar23

[NAME], April 2022-Mar 2023
 |  |  | Total Amount | Cash Receipt | Bank Deposit
 |  |  | Balance
Date | [NAME] | Name | Total Amount | Cash Receipt | Bank Deposit
2022-03-31 00:00:00 | [NAME] | A3 PET INDUSTRIES | 103193
2022-03-31 00:00:00 | [NAME] | G1 PET INDUSTRIES | 66875
2022-03-31 00:00:00 | [NAME] | K1 PET INDUSTRIES | -109115 |  |  |  |  | [NAME] | Month details
2022-04-01 00:00:00 | 1 | L1 PET INDUSTRIES | 31152 |  |  |  |  | Customer Name
2022-04-01 00:00:00 | 2 | L1 PET INDUSTRIES | 31152 |  |  |  |  | 2022-04-01 00:00:00 | Total Amount | Cash Receipt | Bank Deposit
2022-04-04 00:00:00 | 10 | H1 PET INDUSTRIES | 31152 |  |  |  |  | 2022-08-01 00:00:00 | 91868 | 0 | 92150
2022-04-04 00:00:00 | 13 | K1 PET INDUSTRIES | 62304 |  |  |  |  | 2022-09-01 00:00:00 | 145750 | 0 | 114200
2022-04-04 00:00:00 | 16 | V1 PET INDUSTRIES | 77880 |  |  |  |  | 2022-10-01 00:00:00 | 72500 | 0 | 104000 |  | Need formula for the table
2022-04-04 00:00:00 |  | A3 PET INDUSTRIES | 0 |  | 55000 |  |  | 2022-11-01 00:00:00 | 147264 | 0 | 136400
2022-04-05 00:00:00 | 20 | A3 PET INDUSTRIES | 77880 | 7000 | 37000 |  |  | 2023-01-01 00:00:00 | 139089 | 0 | 150000
2022-04-05 00:00:00 | 21 | A3 PET INDUSTRIES | 15576 |  |  |  |  | 2023-02-01 00:00:00
2022-04-05 00:00:00 | 22 | A3 PET INDUSTRIES | 46728 |  |  |  |  | 2023-03-01 00:00:00
2022-04-06 00:00:00 |  | V1 PET INDUSTRIES | 0 |  | 50000 |  |  | For Example
2022-04-08 00:00:00 | O080401 | G1 PET INDUSTRIES | 0 | 10000 |  |  |  | 2022-05-01 00:00:00
2022-04-08 00:00:00 |  | V1 PET INDUSTRIES | 0 |  | 25000 |  |  | 2022-06-01 00:00:00
2022-04-10 00:00:00 | 33 | V1 PET INDUSTRIES | 62304 | 40000 |  |  |  | 2022-08-01 00:00:00 | 91868 | 0 | 92150
2022-04-12 00:00:00 |  | A3 PET INDUSTRIES | 0 |  | 50000 |  |  | 2022-12-01 00:00:00 | 75626 | 0 | 77000
2022-04-13 00:00:00 | 44 | T1 PET INDUSTRIES | 77880 | 200000 |  |  |  | 2023-01-01 00:00:00 | 139089 | 0 | 150000
2022-04-13 00:00:00 | 45 | T1 PET INDUSTRIES | 77880 |  |  |  |  | 2023-02-01 00:00:00
2022-04-13 00:00:00 | 46 | T1 PET INDUSTRIES | 62304 |  |  |  |  | 2023-03-01 00:00:00
2022-04-15 00:00:00 |  | V1 PET INDUSTRIES | 0 |  | 25184
2022-04-15 00:00:00 | O150401 | A3 PET INDUSTRIES | 0 | 30000
2022-06-14 00:00:00 | 232 | A1 PET INDUSTRIES | 32100 |  | 32100
2022-06-17 00:00:00 | 254 | A2 PET INDUSTRIES | 79650 | 80000
2022-06-29 00:00:00 | 303 | A1 PET INDUSTRIES | 35306 |  | 35036
2022-07-09 00:00:00 | 345 | A1 PET INDUSTRIES | 31152 |  | 62280
2022-07-13 00:00:00 | 355 | A1 PET INDUSTRIES | 30916 |  | 270
2022-07-25 00:00:00 | 394 | A1 PET INDUSTRIES | 29800 |  | 29600
2022-08-02 00:00:00 | 424 | J1 PET INDUSTRIES | 68310 |  | 68310
2022-08-05 00:00:00 | 436 | A1 PET INDUSTRIES | 74250 |  | 74200
2022-08-22 00:00:00 | 498 | K1 PET INDUSTRIES | 56640
2022-08-27 00:00:00 | 523 | A1 PET INDUSTRIES | 71500 |  | 40000
2022-09-03 00:00:00 |  | A1 PET INDUSTRIES | 0 |  | 31500
2022-09-16 00:00:00 | 609 | A1 PET INDUSTRIES | 72500 |  | 55000
2022-09-21 00:00:00 |  | A1 PET INDUSTRIES | 0 |  | 17500
2022-10-06 00:00:00 | 664 | A1 PET INDUSTRIES | 76464
2022-10-06 00:00:00 |  | A1 PET INDUSTRIES | 0 |  | 66000
2022-10-17 00:00:00 |  | A1 PET INDUSTRIES | 0 |  | 10400
2022-10-29 00:00:00 | 735 | A1 PET INDUSTRIES | 70800 |  | 60000
2022-12-15 00:00:00 |  | A1 PET INDUSTRIES | 0 |  | 46000
2022-12-15 00:00:00 | 878 | A1 PET INDUSTRIES | 65195
2022-12-28 00:00:00 |  | A1 PET INDUSTRIES | 0 |  | 31000
2022-12-30 00:00:00 | 908 | A1 PET INDUSTRIES | 10431
2022-12-31 00:00:00 | ADJ | T1 PET INDUSTRIES |  | 1596
2023-01-02 00:00:00 | 914 | A1 PET INDUSTRIES | 7873
2023-01-04 00:00:00 | 916 | A1 PET INDUSTRIES | 65608
2023-01-06 00:00:00 | 923 | A1 PET INDUSTRIES | 65608 |  | 110000
2023-01-25 00:00:00 |  | H1 PET INDUSTRIES | 0 |  | 26479
2023-01-25 00:00:00 |  | J1 PET INDUSTRIES | 0 |  | 112368
2023-01-26 00:00:00 | 975 | G1 PET INDUSTRIES | 21655
2023-01-30 00:00:00 |  | U1 PET INDUSTRIES | 0 |  | 50000
2023-01-31 00:00:00 |  | A3 PET INDUSTRIES | 0 |  | 10000
2023-01-31 00:00:00 |  | A1 PET INDUSTRIES | 0 |  | 40000
2023-02-06 00:00:00 | 1000 | K1 PET INDUSTRIES | 81915.99999999999
2023-02-08 00:00:00 | 1002 | L1 PET INDUSTRIES | 136526
 |  | Total sales Amount
 |  | Cash received
 |  | Bank Transfer
 |  | Total Balance as on date