Sales by customer
Which customers bought the most in a period, before and after tax and discount, and how much of it has been paid.
What it shows
One row per customer, from every sale dated in the period: on the desktop, the invoices, the till's sales (a return taken off) and the documents a program posts to a named customer; in the cloud workspace, the sales invoices. Subtotal is the prices before Discount and tax, so Subtotal + Tax = Sales incl. tax, and Sales incl. tax − Discount = Total. Paid is what has been paid on those sales by today, and Invoices counts every sale but a till return.
How it ties to the books
Its Total agrees with Sales incl. tax in Sales by user and with Sales in Customer statements for the same period. Total − Paid is not what customers owe: credit notes and write-offs come off only in Customer balances.
Sales here are everything the company sold: invoices, the till’s sales whichever program rang them up, and the documents a program posts to a named customer, such as a claim or a cancellation fee. A return at the till is taken off and is no invoice of its own; a sale to no named customer sits under walk-in. What is earned over time, such as a maintenance contract or a membership, counts on the day it was sold.
| Group | Sales |
|---|---|
| Period | takes a date range |
| Filters | Customer and User |
| Columns | 8 |
Columns
| Column | Kind | Totalled |
|---|---|---|
| Customer | text | — |
| Invoices | count | Yes |
| Subtotal | amount | Yes |
| Tax | amount | Yes |
| Sales incl. tax | amount | Yes |
| Discount | amount | Yes |
| Total | amount | Yes |
| Paid | 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 | Invoices | Subtotal | Tax | Sales incl. tax | Discount | Total | Paid |
|---|---|---|---|---|---|---|---|
| شركة المستقبل للتجارة (تجريبي) | 7 | 73501.74 | 11025.26 | 84527.00 | 0.00 | 84527.00 | 58126.00 |
| مؤسسة البناء الحديث (تجريبي) | 5 | 44112.18 | 6616.82 | 50729.00 | 0.00 | 50729.00 | 38467.00 |
| مؤسسة الإبداع للتسويق (تجريبي) | 5 | 41141.74 | 6171.26 | 47313.00 | 0.00 | 47313.00 | 41176.00 |
| شركة الواحة اللوجستية (تجريبي) | 3 | 27899.13 | 4184.87 | 32084.00 | 0.00 | 32084.00 | 20509.00 |
| مصنع الجودة للبلاستيك (تجريبي) | 2 | 25049.57 | 3757.43 | 28807.00 | 0.00 | 28807.00 | 0.00 |
| شركة النخبة للمقاولات (تجريبي) | 1 | 15070.43 | 2260.57 | 17331.00 | 0.00 | 17331.00 | 17331.00 |
| شركة الصفوة الطبية (تجريبي) | 1 | 7665.22 | 1149.78 | 8815.00 | 0.00 | 8815.00 | 8815.00 |
| مجموعة الأفق القابضة (تجريبي) | 1 | 4501.74 | 675.26 | 5177.00 | 0.00 | 5177.00 | 5177.00 |
| Total | 25 | 238941.75 | 35841.25 | 274783.00 | 0.00 | 274783.00 | 189601.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.
- Sales by userHow much each member of the team sold in a period, and which documents make it up.
- Sales invoice summaryWhich customers bring the most profit, not only the most sales.
- Sales by productWhich products sell, at what average price and margin, and who sold them.
- Customer statementsWhat each customer, with their tax number, bought, paid and still owes in a period.
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.