Debtor Aging
Also known in accounting as the receivables aging report.
Debtors broken down by "how long their debt has been open": fresh (<7 days), 7–15, 15–30, and over 30 days. The older the balance, the higher the risk of it going bad — chase the red band first.
Notes
- Debit balances of all customers are shown, including inactive or archived ones — usually the ones that need chasing most.
- Debt age is worked out first-in, first-out: each payment settles the oldest debt in that currency first, and whatever is still open sits in the band of its own date — so one customer's debt may be split across several bands. The "Oldest open debt" column is the date of the oldest open part in that band.
- A reversed (storno) document and its reversal are left out of the age calculation: reversing an old payment does not make an old debt look "fresh".
- The reference-currency equivalent is calculated at today's rate.
- From the Statement, you can send the balance to the customer's WhatsApp group as a reminder.
- The currency selector on this page is searchable: type part of the name or code (e.g. usd, dirham) to filter the list.
Debt reminder queue
With the «Send debt reminders in bulk» permission (managers by default) the Reminder queue section opens above the table. Set the criteria: debt above an amount (in the reference currency), age above a number of days and the minimum gap between reminders. The currency and customer group filters at the top also apply. Build queue only shows the list with each customer's message and sends nothing. Untick anyone you don't want and press Send reminder; after one confirmation the messages go to the WhatsApp queue, at most 100 customers each time. A customer with no group or number, or one reminded within the gap, can't be ticked. The text is the «Debt reminder» template, sent in each customer's message language. No reminder is ever sent without confirmation.
A customer who owes in one currency but is in net credit can't be ticked. Messages in a queue go 10 seconds apart so working messages don't wait behind them.