Invoice ageing
Which customers are late and by how long, so collection can start with the oldest debts.
What it shows
What every customer owes today, whenever the sale was made, by days past the due date: 1–15 days (what is not yet due included), 16–30 days and Over 30 days. It takes the open invoices less what was paid, credited and written off; on the desktop also what is left on till sales on account and on programs' documents, each due the day it was written.
How it ties to the books
Its Total agrees with the Balance total of Customer balances run from the first day of the books, and so with the receivables account, an advance or a credit note not set against an invoice aside.
By days past the due date; what is not yet due sits in the first column. Beside the invoices, what is left on till sales on account and on the programs’ documents, each due the day it was written.
| Group | Receivables |
|---|---|
| Period | as at one date |
| Filters | Customer |
| Columns | 5 |
Columns
| Column | Kind | Totalled |
|---|---|---|
| Customer | text | — |
| 1–15 days | amount | Yes |
| 16–30 days | amount | Yes |
| Over 30 days | amount | Yes |
| Total | amount | Yes |
A sample from the demo data
Drawn by the program’s report engine on the demo company, null to 28 October 2026, in SAR. The first 5 of 5 rows.
| Customer | 1–15 days | 16–30 days | Over 30 days | Total |
|---|---|---|---|---|
| مصنع الجودة للبلاستيك (تجريبي) | 0.00 | 15594.00 | 13213.00 | 28807.00 |
| مؤسسة الإبداع للتسويق (تجريبي) | 0.00 | 6137.00 | 0.00 | 6137.00 |
| شركة المستقبل للتجارة (تجريبي) | 26401.00 | 0.00 | 0.00 | 26401.00 |
| مؤسسة البناء الحديث (تجريبي) | 12262.00 | 0.00 | 0.00 | 12262.00 |
| شركة الواحة اللوجستية (تجريبي) | 11575.00 | 0.00 | 0.00 | 11575.00 |
| Total | 50238.00 | 21731.00 | 13213.00 | 85182.00 |
Sample data, for illustration only.
Reports read with it
- Customer balancesWhat each customer still owes from the sales of a period, and how much of it has been collected.
- Customer statementsWhat each customer, with their tax number, bought, paid and still owes in a period.
- Time to get paidHow long each customer actually takes to pay once invoiced.
- Payment listWhat came in from customers, when, by which method and against which invoice.
Sources
The definition and the sample come from the program’s report library (books/reports.rs) on the demo data; the explanation from its engine.