Paste open items from any ledger, whether receivables, payables, advances or deposits. Set the as-of date and your own ageing buckets, and see the totals by bucket and by party.
With limits of 30, 60 and 90 the buckets are 0 to 30, 31 to 60, 61 to 90 and over 90 days. Credit notes and receipts on account can be entered as negative amounts or in brackets. Items dated after the as-of date go to a separate first bucket.
| Party | Total | In oldest bucket |
|---|---|---|
| Bharat Steel | 2,95,500.00 | 0.00 |
| Arun Traders | 2,09,000.00 | 0.00 |
| Kaveri Foods | 56,200.00 | 0.00 |
| Lakshmi Agencies | 42,000.00 | 0.00 |
A standard set of buckets suits a standard report. Audit and credit control questions are often different: how much is more than 45 days past due, how much of this advance is older than six months, which suppliers are held beyond the agreed terms. Setting your own limits answers the question you actually have. The party view then shows who sits in the oldest bucket, which is usually where follow-up begins.
For each item the tool counts the days from the date in your data to the as-of date. The item goes into the first bucket whose upper limit is not less than the days. Items older than your last limit go into an "over" bucket.
If the date is the document date, the age is the time since the document. If it is the due date, the age is how long the item is past due, and items not yet due go in their own bucket.
Totals are then shown by bucket and by party. Negative amounts, such as credit notes, reduce the bucket they fall into.
An invoice dated 2 June 2026 for 84,000, as of 17 October 2026, with limits of 30, 60, 90, 180 and 365 days.
