Bill ageing
Which suppliers have been waiting longest to be paid, to plan the payments.
What it shows
What the business owes each supplier today, whenever it bought, 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 bills less what was paid and returned; on the desktop also what is left on goods bought on credit at the till 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 Supplier balances run from the first day of the books; against the payables account, an advance paid before any bill can make the two part.
By days past the due date; what is not yet due sits in the first column. Beside the bills, what is left on goods bought on credit at the till and on the programs’ documents, each due the day it was written.
| Group | Payables |
|---|---|
| Period | as at one date |
| Filters | Supplier |
| Columns | 5 |
Columns
| Column | Kind | Totalled |
|---|---|---|
| Supplier | 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 2 of 2 rows.
| Supplier | 1–15 days | 16–30 days | Over 30 days | Total |
|---|---|---|---|---|
| مطاحن ومؤن الخليج (تجريبي) | 5565.00 | 6129.85 | 7751.00 | 19445.85 |
| شركة توريدات المقاهي التجريبية | 16889.41 | 0.00 | 0.00 | 16889.41 |
| Total | 22454.41 | 6129.85 | 7751.00 | 36335.26 |
Sample data, for illustration only.
Reports read with it
- Supplier balancesWhat the business still owes each supplier from the purchases of a period.
- Supplier statementsWhat each supplier, with their tax number, sold to the business, was paid and is still owed.
- Purchase payment logWhat was paid to suppliers, when, by which method and against which bill.
- Purchases by supplierWho the business buys from and how much, before and after tax and discount.
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.