Aged Receivables Balance
The aged balance lists all customer invoices with an outstanding balance, grouped by how overdue they are relative to their due date. It lets you quickly identify at-risk receivables and prioritise follow-up on the oldest outstanding amounts.
”As of” Date
Section titled “”As of” Date”The As of date field sets the reference date for the calculation. It defaults to today.
By changing this date you can reconstruct the balance as it stood on any past date: only payments received before the chosen date are counted; later payments are excluded.
Typical use case: enter your period-end closing date to obtain the exact balance at that date.
Aging Brackets
Section titled “Aging Brackets”Each unpaid invoice is assigned to one of five brackets:
| Bracket | Definition |
|---|---|
| Not yet due | Due date not yet reached as of the reference date |
| 1 – 30 days | 1 to 30 days overdue |
| 31 – 60 days | 31 to 60 days overdue |
| 61 – 90 days | 61 to 90 days overdue |
| > 90 days | More than 90 days overdue |
Receivables Table
Section titled “Receivables Table”The table shows one summary row per customer. Click a row to expand it and display the individual invoices for that customer.
Sub-totals per currency are shown separately. A grand total converted to the company currency appears at the bottom of the table.
Summary Indicators
Section titled “Summary Indicators”Four key indicators are displayed at the top of the page:
- Total due: total outstanding receivables, with the number of customers involved
- On time: amount of invoices not yet due (the “Not yet due” bracket)
- Overdue: combined amount across all overdue brackets
- High risk > 30 d: amount overdue by more than 30 days (brackets 31-60, 61-90 and > 90)
Each indicator also shows what percentage of the total due that amount represents. Amounts are expressed in the company currency (with automatic conversion for multi-currency invoices).
Multi-Currency Support
Section titled “Multi-Currency Support”Each invoice is displayed in its original currency. Per-currency sub-totals let you track receivables currency by currency. The grand total at the bottom of the table provides a converted figure in the company currency for a consolidated view.
Note: The supplier aged balance is not yet available in this version.
Best Practices
Section titled “Best Practices”- Review the aged balance weekly to stay ahead of customer follow-ups
- Prioritise collection actions on receivables in the > 90 days bracket
- Use the “As of” date to prepare your period-end financial statements
Troubleshooting
Section titled “Troubleshooting”No receivables appear in the table
- Verify you have an active Pro or Premium subscription
- Make sure there are customer invoices with a positive outstanding balance
- Check the “As of” date: if it is earlier than all invoice issue dates, the balance will be empty
Indicator amounts differ from the table
- Indicators are always shown in the company currency (with automatic conversion)
- The table keeps each invoice amount in its original currency
A partially paid invoice appears in the balance
- Only the remaining outstanding balance is shown, not the full invoice amount
- A partial payment reduces the displayed balance but does not remove the invoice from the table as long as an amount remains due
Need help? Contact our support team.