The sales register and sales reports

The sales register lists every invoice with its quantity, basic amount, adjustments and net amount, grouped the way you ask. The detail report goes down to each line. Cancelled invoices show as zero under the company's Cancel customer.

Accounting Sales reports
3 min read
Updated October 20, 2026

For Accountant Owner or manager Sales clerk

The reports

Report (title)	What it answers
Sales Invoice Summary Report	What did we sell, by date, agent, area, customer, product, user or product group? One row per invoice
Sales invoice detail report	The same, line by line: each product on each invoice
Sales Return Summary Report	What came back
Sales Reverse / Return Report	Cancelled invoices and returns together
Day book	Every voucher of the day, all kinds

Open them from the Sales Reports group of the reports menu, or from the report links on the Sales Invoice list.

Use the Sales Invoice Summary Report

Open Sales Invoice Summary Report
Who
Accountant or manager
Where
The Sales Reports group of the reports menu
What changes
The grid opens for the period you set with From date.
Narrow it
What changes
From date, User, Project/Business Unit, Agent, Area, Customer, Product, Product group, Parent product group, and bounds on Qty, Net amount, Basic amount and Bill wise adjustment. Your branch applies.
Choose how to group
What changes
Group by Date, Agent, Area, Customer, Product, User, Product Group or Parent Product Group. Each group shows its subtotal.
Read, export or print
What changes
The columns are the date, customer, voucher number, agent, area, Qty, Basic amount, Bill wise adjustment and Net amount. Export to Excel or PDF.

Where each number comes from

Column	Source
Basic amount	The total of the invoice's lines before bill-level adjustments
Bill wise adjustment	The invoice's bill-level adjustments (VAT, discounts), signed
Net amount	The invoice total: what the customer owes
Qty	The total quantity of the lines
Customer	The customer, or the walk-in name if one was entered

A cancelled invoice stays in the list so every number is accounted for, but its amounts show as 0 and its customer is the company's Cancel customer (Cancel an invoice). A returned invoice is not reduced here: returns are on the Sales Return Summary Report.

Worked example: a day of three invoices, one of them cancelled

VAT at 13% and a 10% bill discount are the values set up for this example; both are bill-level adjustments.

Voucher	Customer	Basic amount	Bill wise adjustment	Net amount
SB-00101	ABC Traders	10,000	1,300 (VAT)	11,300
SB-00102	The company's Cancel customer	0	0	0
SB-00103	XYZ Stores	5,000	85 (discount −500, then VAT +585)	5,085
Day total		15,000	1,385	16,385

SB-00102 was cancelled: it stays in the list so the numbers run on, with zero amounts. A return made the same day does not lower these figures; look for it on the Sales Return Summary Report.