Supplier balances
What the business still owes each supplier from the purchases of a period.
What it shows
One row per supplier, from every purchase dated in the period: Purchases before tax, Taxes, Purchases incl. tax, Paid, and Balance = Purchases incl. tax − Paid, less purchase returns set against the bills. Paid and Balance are as of today. On the desktop, what is left on goods bought on credit at the till or on a program's document is what the supplier is still owed on the account it raised, the retention held from them included, after their open bills, the oldest settled first.
How it ties to the books
Run from the first day of the books, its Balance total agrees with Bill ageing's Total. Against the payables account, an advance paid before any bill lowers the account but not this report, and retention held from a subcontractor counts here whichever liability account holds it.
From everything the company bought: bills, the till’s goods-in and the programs’ documents. What is left on goods bought on credit at the till or on a program’s document is what the supplier is still owed on their account, the retention held from them included, after their open bills, the oldest settled first.
| Group | Payables |
|---|---|
| Period | takes a date range |
| Filters | Supplier |
| Columns | 6 |
Columns
| Column | Kind | Totalled |
|---|---|---|
| Supplier | text | — |
| Purchases | amount | Yes |
| Taxes | amount | Yes |
| Purchases incl. tax | amount | Yes |
| Paid | amount | Yes |
| Balance | amount | Yes |
A sample from the demo data
Drawn by the program’s report engine on the demo company, 30 July 2026 to 28 October 2026, in SAR. The first 1 of 1 rows.
| Supplier | Purchases | Taxes | Purchases incl. tax | Paid | Balance |
|---|---|---|---|---|---|
| شركة الأثاث المكتبي (تجريبي) | 60000.00 | 0.00 | 60000.00 | 60000.00 | 0.00 |
| Total | 60000.00 | 0.00 | 60000.00 | 60000.00 | 0.00 |
Sample data, for illustration only.
Reports read with it
- Supplier statementsWhat each supplier, with their tax number, sold to the business, was paid and is still owed.
- Bill ageingWhich suppliers have been waiting longest to be paid, to plan the payments.
- Purchases by supplierWho the business buys from and how much, before and after tax and discount.
- Purchase payment logWhat was paid to suppliers, when, by which method and against which bill.
- Trial balanceWhether the books balance, and where every account stands.
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.