Skip to content
Sales

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.

GroupSales
Periodtakes a date range
FiltersCustomer and User
Columns8

Columns

ColumnKindTotalled
Customertext—
InvoicescountYes
SubtotalamountYes
TaxamountYes
Sales incl. taxamountYes
DiscountamountYes
TotalamountYes
PaidamountYes

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.

CustomerInvoicesSubtotalTaxSales incl. taxDiscountTotalPaid
شركة المستقبل للتجارة (تجريبي)773501.7411025.2684527.000.0084527.0058126.00
مؤسسة البناء الحديث (تجريبي)544112.186616.8250729.000.0050729.0038467.00
مؤسسة الإبداع للتسويق (تجريبي)541141.746171.2647313.000.0047313.0041176.00
شركة الواحة اللوجستية (تجريبي)327899.134184.8732084.000.0032084.0020509.00
مصنع الجودة للبلاستيك (تجريبي)225049.573757.4328807.000.0028807.000.00
شركة النخبة للمقاولات (تجريبي)115070.432260.5717331.000.0017331.0017331.00
شركة الصفوة الطبية (تجريبي)17665.221149.788815.000.008815.008815.00
مجموعة الأفق القابضة (تجريبي)14501.74675.265177.000.005177.005177.00
Total25238941.7535841.25274783.000.00274783.00189601.00

Sample data, for illustration only.

Reports read with it

The 60 reportsJooDax

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.