Kunal.shah
New Member
Hi,
I have data in multiple line item as per below & need ageing in against each line item but on account receipts & advance amount should be adjusted old overdue amount of each customer. Required formula to get data in Column from T to AD.
I have data in multiple line item as per below & need ageing in against each line item but on account receipts & advance amount should be adjusted old overdue amount of each customer. Required formula to get data in Column from T to AD.
O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Report Date | 30-09-23 | ||||||||||||||
Account | Doc. Date | Amt in loc.cur. | Net due dt | Customer Name | Outstanding | OD | 0 to 7 | 7 to 15 | 15 to 30 | 30 to 45 | 45 to 90 | 90 to 120 | 120 to 150 | 150 to 180 | >180 |
190175 | 02-Aug-23 | 37,400.00 | 12-Aug-23 | Global Trading Company | 37,400.00 | 37,400.00 | - | - | - | - | 37,400.00 | - | - | - | - |
190175 | 08-Aug-23 | 2,57,600.00 | 18-Aug-23 | Global Trading Company | 2,57,600.00 | 2,57,600.00 | - | - | - | 2,57,600.00 | - | - | - | - | - |
190175 | 14-Aug-23 | (3,740.00) | 14-Aug-23 | Global Trading Company | (3,740.00) | (3,740.00) | - | - | - | - | (3,740.00) | - | - | - | - |
190175 | 28-Aug-23 | 22,484.00 | 07-Sep-23 | Global Trading Company | 22,484.00 | 22,484.00 | - | - | 22,484.00 | - | - | - | - | - | - |
190175 | 29-Aug-23 | (1,00,000.00) | 29-Aug-23 | Global Trading Company | (1,00,000.00) | (1,00,000.00) | - | - | - | (66,340.00) | (33,660.00) | - | - | - | - |
190175 | 31-Aug-23 | 15,696.00 | 10-Sep-23 | Global Trading Company | 15,696.00 | 15,696.00 | - | - | 15,696.00 | - | - | - | - | - | - |
190175 | 13-Sep-23 | (1,00,000.00) | 13-Sep-23 | Global Trading Company | (1,00,000.00) | (1,00,000.00) | - | - | - | (1,00,000.00) | - | - | - | - | - |
196054 | 10-Nov-22 | 17,071.00 | 10-Dec-22 | JALONGI RETAIL PRIVATE LIMITED - KOL | 17,071.00 | 17,071.00 | - | - | - | - | - | - | - | - | 17,071.00 |
196054 | 28-Nov-22 | (18,480.00) | 28-Nov-22 | JALONGI RETAIL PRIVATE LIMITED - KOL | (18,480.00) | (18,480.00) | - | - | - | - | - | - | - | - | (18,480.00) |
196054 | 07-Dec-22 | (27,720.00) | 07-Dec-22 | JALONGI RETAIL PRIVATE LIMITED - KOL | (27,720.00) | (27,720.00) | - | - | - | - | - | - | - | - | (27,720.00) |
196054 | 08-Dec-22 | 30,203.00 | 07-Jan-23 | JALONGI RETAIL PRIVATE LIMITED - KOL | 30,203.00 | 30,203.00 | - | - | - | - | - | - | - | - | 30,203.00 |
196369 | 31-Aug-23 | 7,30,911.00 | 30-Sep-23 | BEST SOUPS & SNACKS | 7,30,911.00 | - | - | - | - | - | - | - | - | - | - |
196369 | 28-Sep-23 | (5,298.00) | 28-Sep-23 | BEST SOUPS & SNACKS | (5,298.00) | - | - | - | - | - | - | - | - | - | - |
196369 | 29-Sep-23 | (7,626.00) | 29-Sep-23 | BEST SOUPS & SNACKS | (7,626.00) | - | - | - | - | - | - | - | - | - | - |
196369 | 29-Sep-23 | (10,477.00) | 29-Sep-23 | BEST SOUPS & SNACKS | (10,477.00) | - | - | - | - | - | - | - | - | - | - |
196451 | 16-Sep-23 | (6,300.00) | 16-Sep-23 | Anish Amin | (6,300.00) | (6,300.00) | (6,300.00) | - | - | - | - | - | - | - | - |
196451 | 26-Sep-23 | 6,300.00 | 28-Sep-23 | Anish Amin | 6,300.00 | 6,300.00 | 6,300.00 | - | - | - | - | - | - | - | - |
190190 | 30-Aug-23 | 7,995.00 | 29-Sep-23 | AQUAMARINE SPECIALITY SEAFOOD | 7,995.00 | 7,995.00 | 7,995.00 | - | - | - | - | - | - | - | - |
190190 | 31-Aug-23 | 1,38,319.00 | 30-Sep-23 | AQUAMARINE SPECIALITY SEAFOOD | 1,38,319.00 | - | - | - | - | - | - | - | - | - | - |
190190 | 07-Sep-23 | 22,230.00 | 07-Oct-23 | AQUAMARINE SPECIALITY SEAFOOD | 22,230.00 | - | - | - | - | - | - | - | - | - | - |
190190 | 09-Sep-23 | (11,310.00) | 09-Sep-23 | AQUAMARINE SPECIALITY SEAFOOD | (11,310.00) | (7,995.00) | (7,995.00) | - | - | - | - | - | - | - | - |