• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Debtors ageing based on on account receipts to be adjusted in last ageing bracket

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.

OPQRSTUVWXY
Z​
AAABAC
AD​
Report Date30-09-23
AccountDoc. DateAmt in loc.cur.Net due dtCustomer NameOutstandingOD0 to 77 to 1515 to 3030 to 4545 to 9090 to 120120 to 150150 to 180>180
190175
02-Aug-23​
37,400.00
12-Aug-23​
Global Trading Company37,400.0037,400.00----37,400.00----
190175
08-Aug-23​
2,57,600.00
18-Aug-23​
Global Trading Company2,57,600.002,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 Company22,484.0022,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 Company15,696.0015,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 - KOL17,071.0017,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 - KOL30,203.0030,203.00--------30,203.00
196369
31-Aug-23​
7,30,911.00
30-Sep-23​
BEST SOUPS & SNACKS7,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 Amin6,300.006,300.006,300.00--------
190190
30-Aug-23​
7,995.00
29-Sep-23​
AQUAMARINE SPECIALITY SEAFOOD7,995.007,995.007,995.00--------
190190
31-Aug-23​
1,38,319.00
30-Sep-23​
AQUAMARINE SPECIALITY SEAFOOD1,38,319.00----------
190190
07-Sep-23​
22,230.00
07-Oct-23​
AQUAMARINE SPECIALITY SEAFOOD22,230.00----------
190190
09-Sep-23​
(11,310.00)
09-Sep-23​
AQUAMARINE SPECIALITY SEAFOOD(11,310.00)(7,995.00)(7,995.00)--------
 
Back
Top