Customer balances
What each customer still owes from the sales of a period, and how much of it has been collected.
What it shows
One row per customer, from every sale dated in the period: Sales before tax, Taxes, Sales incl. tax, Paid, and Balance = Sales incl. tax − Paid, less what credit notes set against invoices and write-offs took off. Paid and Balance are as of today. On the desktop, the sales include the till and the programs' documents, and what is left on a till sale on account or a program's document is what the customer still owes on the account it raised after their open invoices, the oldest settled first.
How it ties to the books
Run from the first day of the books to today, its Balance total agrees with Invoice ageing's Total and with the receivables account in the Trial balance. A shorter period leaves older sales out, and an advance received before any invoice or a credit note not set against an invoice can lower the receivables account without lowering this Balance.
From everything the company sold: invoices, the till and the programs’ documents. What is left on a till sale on account or on a program’s document is what the customer still owes on their account after their open invoices, the oldest settled first.
| Group | Receivables |
|---|---|
| Period | takes a date range |
| Filters | Customer |
| Columns | 6 |
Columns
| Column | Kind | Totalled |
|---|---|---|
| Customer | text | — |
| Sales | amount | Yes |
| Taxes | amount | Yes |
| Sales 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 8 of 8 rows.
| Customer | Sales | Taxes | Sales incl. tax | Paid | Balance |
|---|---|---|---|---|---|
| مصنع الجودة للبلاستيك (تجريبي) | 25049.57 | 3757.43 | 28807.00 | 0.00 | 28807.00 |
| مؤسسة الإبداع للتسويق (تجريبي) | 41141.74 | 6171.26 | 47313.00 | 41176.00 | 6137.00 |
| شركة المستقبل للتجارة (تجريبي) | 73501.74 | 11025.26 | 84527.00 | 58126.00 | 26401.00 |
| شركة الواحة اللوجستية (تجريبي) | 27899.13 | 4184.87 | 32084.00 | 20509.00 | 11575.00 |
| مؤسسة البناء الحديث (تجريبي) | 44112.18 | 6616.82 | 50729.00 | 38467.00 | 12262.00 |
| شركة النخبة للمقاولات (تجريبي) | 15070.43 | 2260.57 | 17331.00 | 17331.00 | 0.00 |
| مجموعة الأفق القابضة (تجريبي) | 4501.74 | 675.26 | 5177.00 | 5177.00 | 0.00 |
| شركة الصفوة الطبية (تجريبي) | 7665.22 | 1149.78 | 8815.00 | 8815.00 | 0.00 |
| Total | 238941.75 | 35841.25 | 274783.00 | 189601.00 | 85182.00 |
Sample data, for illustration only.
Reports read with it
- Customer statementsWhat each customer, with their tax number, bought, paid and still owes in a period.
- Invoice ageingWhich customers are late and by how long, so collection can start with the oldest debts.
- Sales by customerWhich customers bought the most in a period, before and after tax and discount, and how much of it has been paid.
- Payment listWhat came in from customers, when, by which method and against which invoice.
- 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.