Customer statements
What each customer, with their tax number, bought, paid and still owes in a period.
What it shows
One row per customer with Tax ID, Sales including tax, Paid and Balance, from the same sales as Customer balances: on the desktop the invoices, the till and programs' documents; in the cloud workspace, the invoices. Balance is Sales − Paid less what credit notes set against invoices and write-offs took off, as of today.
How it ties to the books
Sales and Balance equal Sales incl. tax and Balance in Customer balances for the same period; from the first day of the books, the Balance total agrees with Invoice ageing's Total.
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 | 5 |
Columns
| Column | Kind | Totalled |
|---|---|---|
| Customer | text | — |
| Tax ID | text | — |
| Sales | 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 | Tax ID | Sales | Paid | Balance |
|---|---|---|---|---|
| مصنع الجودة للبلاستيك (تجريبي) | — | 28807.00 | 0.00 | 28807.00 |
| مؤسسة الإبداع للتسويق (تجريبي) | — | 47313.00 | 41176.00 | 6137.00 |
| شركة المستقبل للتجارة (تجريبي) | — | 84527.00 | 58126.00 | 26401.00 |
| شركة الواحة اللوجستية (تجريبي) | — | 32084.00 | 20509.00 | 11575.00 |
| مؤسسة البناء الحديث (تجريبي) | — | 50729.00 | 38467.00 | 12262.00 |
| شركة النخبة للمقاولات (تجريبي) | — | 17331.00 | 17331.00 | 0.00 |
| مجموعة الأفق القابضة (تجريبي) | — | 5177.00 | 5177.00 | 0.00 |
| شركة الصفوة الطبية (تجريبي) | — | 8815.00 | 8815.00 | 0.00 |
| Total | 274783.00 | 189601.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.
- Invoice ageingWhich customers are late and by how long, so collection can start with the oldest debts.
- Payment listWhat came in from customers, when, by which method and against which invoice.
- Sales by customerWhich customers bought the most in a period, before and after tax and discount, and how much of it has been paid.
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.