Sales summary by user
What a user sold in a period, how much of it is still to collect, and what came in.
What it shows
Three parts for the chosen user, or for everyone. Sales lists each sale of the period with Sales (its total), Sales due (what is still owed on it) and Sales settled (the rest: paid, credited or written off); Earlier invoices falling due lists invoices issued before the period, still open and due within it; Collected in the period lists the payments received on invoices and, on the desktop, what till sales and programs' documents were settled with as they were written. Only the first part makes the totals.
How it ties to the books
With no user chosen, the Sales total equals the Total of Sales by customer for the same period, and Sales due the Balance of Customer balances. The collected part goes by payment date, so it need not match Sales settled.
The user is the person responsible for the invoice, or whoever wrote it when no one is named; the cashier for a till sale; whoever posted a program’s document. Sales are invoices, the till’s sales and returns, and the documents a program posts to a customer.
| Group | Receivables |
|---|---|
| Period | takes a date range |
| Filters | User |
| Columns | 4 |
Columns
| Column | Kind | Totalled |
|---|---|---|
| Invoice | text | — |
| Sales | amount | Yes |
| Sales due | amount | Yes |
| Sales settled | 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 30 rows.
| Invoice | Sales | Sales due | Sales settled |
|---|---|---|---|
| Sales | |||
| POS-2026-000001 | 13213.00 | 13213.00 | 0.00 |
| POS-2026-000002 | 8452.00 | 0.00 | 8452.00 |
| POS-2026-000003 | 11430.00 | 0.00 | 11430.00 |
| POS-2026-000004 | 14838.00 | 0.00 | 14838.00 |
| POS-2026-000005 | 16514.00 | 0.00 | 16514.00 |
| POS-2026-000006 | 9595.00 | 0.00 | 9595.00 |
| POS-2026-000007 | 17331.00 | 0.00 | 17331.00 |
| Total | 274783.00 | 85182.00 | 189601.00 |
Sample data, for illustration only.
Reports read with it
- Sales by userHow much each member of the team sold in a period, and which documents make it up.
- Customer balancesWhat each customer still owes from the sales of a period, and how much of it has been collected.
- Payment listWhat came in from customers, when, by which method and against which invoice.
- Invoice ageingWhich customers are late and by how long, so collection can start with the oldest debts.
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.