Spreadsheet: 880479d1728283493-ledger-closing-balance-int-calculation-btparkhe1920-sample-331-spill-2024-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Required Result
Company Code | Company Name | Customer | Customer Name | Customer Group | Customer Group Desc | State | [NAME] | Doc Type Desc | Doc Date | Delivered Date | [NAME] | Clearing Doc | Reverce Bill No | [NAME] | Profit Center | Profit Center Name | Sales G/L | Sales G/L Name | GST Bill No | Side Days | Int Date | Clearing Date | Text | Reference | Doc Date | Delivered Date | Debit | Credit | Closing |  |  |  | Debit | Credit | Closing |  | Interest Date | Debit | Credit | Closing
12000 | XYZ | 5008569 | XYZ | 01 | Dealer | Maharashtra |  | Opening | 2024-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Opening Balance |  | 2024-04-01 00:00:00 |  | 0 | 2767963.4 | -2767963.4 |  |  | 2024-04-01 00:00:00 | 0 | 2767963.4 | -2767963.4 |  |  | 0 | 2767963.4
12000 | XYZ | 5008569 | XYZ | 01 | Dealer | Maharashtra | DX | Customer Auto Pay | 2024-04-03 00:00:00 |  | [PHONE] | [PHONE] |  |  |  |  |  |  |  | 0 |  |  | MAHBR52024040316975591 | MAHBR52024040316 | 2024-04-03 00:00:00 |  | 0 | 250000 | -3017963.4 |  |  | 2024-04-03 00:00:00 | 0 | 250000 | -3017963.4 |  | 2024-04-03 00:00:00 | 0 | 250000
12000 | XYZ | 5008569 | XYZ | 01 | Dealer | Maharashtra | RV | [NAME].Transfer | 2024-04-06 00:00:00 | 2024-04-07 00:00:00 | [PHONE] | [PHONE] |  |  |  |  | [PHONE] | SALE : TOBACCO | SI8001000072 | 12 | 2024-04-19 00:00:00 |  | Tax Invoice -SI8001000072 | SI8001000072 | 2024-04-06 00:00:00 | 2024-04-07 00:00:00 | 331200 | 0 | -2686763.4 |  |  | 2024-04-06 00:00:00 | 0 | 1450000 | -4136763.4 |  | 2024-04-06 00:00:00 | 0 | 1450000
12000 | XYZ | 5008569 | XYZ | 01 | Dealer | Maharashtra | DX | Customer Auto Pay | 2024-04-06 00:00:00 |  | [PHONE] | [PHONE] |  |  |  |  |  |  |  | 0 |  |  | MAHBR52024040617000480 | [NAME] | 2024-04-06 00:00:00 |  | 0 | 1450000 | -4136763.4 |  |  | 2024-04-07 00:00:00 | 331200 | 0 | -2686763.4 |  | 2024-04-07 00:00:00 | 331200 | 0
12000 | XYZ | 5008569 | XYZ | 01 | Dealer | Maharashtra | RV | [NAME].Transfer | 2024-04-08 00:00:00 | 2024-04-09 00:00:00 | [PHONE] | [PHONE] |  |  |  |  | [PHONE] | SALE : TOBACCO | SI8001000095 | 12 | 2024-04-21 00:00:00 |  | Tax Invoice -SI8001000095 | SI8001000095 | 2024-04-08 00:00:00 | 2024-04-09 00:00:00 | 952200 | 0 | -3184563.4 |  |  | 2024-04-08 00:00:00 | 0 | 900000 | -4084563.4 |  | 2024-04-08 00:00:00 | 0 | 900000
12000 | XYZ | 5008569 | XYZ | 01 | Dealer | Maharashtra | DX | Customer Auto Pay | 2024-04-08 00:00:00 |  | [PHONE] | [PHONE] |  |  |  |  |  |  |  | 0 |  |  | MAHBR52024040817011894 | MAHBR52024040817 | 2024-04-08 00:00:00 |  | 0 | 900000 | -4084563.4 |  |  | 2024-04-09 00:00:00 | 952200 | 0 | -3184563.4 |  | 2024-04-09 00:00:00 | 952200 | 0
12000 | XYZ | 5008569 | XYZ | 01 | Dealer | Maharashtra | DX | Customer Auto Pay | 2024-04-12 00:00:00 |  | [PHONE] | [PHONE] |  |  |  |  |  |  |  | 0 |  |  | MAHBR52024041217045252 | MAHBR52024041217 | 2024-04-12 00:00:00 |  | 0 | 650000 | -4734563.4 |  |  | 2024-04-12 00:00:00 | 0 | 650000 | -4734563.4 |  | 2024-04-12 00:00:00 | 0 | 650000
12000 | XYZ | 5008569 | XYZ | 01 | Dealer | Maharashtra | DX | Customer Auto Pay | 2024-04-12 00:00:00 |  | [PHONE] | [PHONE] |  |  |  |  |  |  |  | 0 |  |  | MAHBR52024041217052212 | MAHBR52024041217 | 2024-04-12 00:00:00 |  | 0 | 900000 | -5634563.4 |  |  | 2024-04-12 00:00:00 | 0 | 900000 | -5634563.4 |  | 2024-04-12 00:00:00 | 0 | 900000
12000 | XYZ | 5008569 | XYZ | 01 | Dealer | Maharashtra | RV | [NAME].Transfer | 2024-04-13 00:00:00 | 2024-04-14 00:00:00 | [PHONE] | [PHONE] |  |  |  |  | [PHONE] | SALE : TOBACCO | SI8001000215 | 12 | 2024-04-26 00:00:00 |  | Tax Invoice -SI8001000215 | SI8001000215 | 2024-04-13 00:00:00 | 2024-04-14 00:00:00 | 74625 | 0 | -5559938.4 |  |  | 2024-04-14 00:00:00 | 74625 | 0 | -5559938.4 |  | 2024-04-14 00:00:00 | 74625 | 0