Statements & reports
Client statements, the monthly client sales report and sales by sales code
The Reporting group in the Invoices sidebar holds Statements, Client sales and Sales by sales code.
Statements
A statement is everything on a client's account over a period: invoices, payments, credit notes, refunds and write-offs, with a running balance. Pick the client and the period. The statement opens on the Opening balance, and each line folds its type into the Description, beside the Reference, Debit, Credit and Balance.
Preview, print or download it as a PDF. Lines from archived years load when the period reaches them.
Monthly client sales
Client sales shows each client's net sales, excluding VAT, month by month. Choose 3 months, 6 months or 12 months. The month before the period is added as a comparative, so 12 months shows 13 columns; the Average covers the period only.
- Search by client code or name, and filter by client category and sales code.
- Hide clients with no sales is a toggle.
- Choose columns adds or removes the client's Code, Sales code, Price list, Outstanding, On order and Average.
- Sort by any column. The client and info columns stay put while the months scroll.
- Click a client to open their page.
Totals run across the whole list, not just what's on screen. Export it with Preview, Export CSV or Export PDF; the PDF prints the code, sales code and average rather than every client detail, so all the months fit.
Sales by sales code
Quotes sent and won, and what was invoiced less credit notes, excluding VAT, per sales code (your sales reps). Tick By client to split each sales code by client. Pick the period, and export it with Preview, Export CSV or Export PDF.
Commission by sales code
Turn on Commission by sales code under Settings › General and a Commission button appears on Sales by sales code. It shows, per sales code and for the period, what was invoiced less credit notes on lines that earn commission and on lines that don't, excluding VAT. A line earns commission when its Inventory item has Earns commission ticked (the default); typed lines do too. Looped doesn't work out the commission itself.
Sales codes are set up in Invoices settings; see Settings.
Dispatch
Dispatch lists the open sales orders to deliver in a date range, grouped by where they're going. Nobody keeps a list of areas: each order's address is looked up and grouped by town and suburb, with neighbouring suburbs next to each other, starting from your company's own address. A new client's suburb shows up by itself.
The address an order goes to is the order's own delivery address, else the client's delivery address, else the client's billing address. An address that can't be found shows under Address not found, with a link to fix it on the client.
Tick the groups that make up a run and choose Export PDF to print the driver's sheet, or Export CSV. With nothing ticked, the sheet has every group.
Audit trail
Audit trail in the sidebar lists who created, edited, sent, converted or changed the status
of quotes, invoices, credit notes and sales orders, and who added, edited or deleted clients,
newest first. An edit shows each change in words, such as Email: old → new for a client.
Filter by what it was (invoice, quote, credit note, sales order or client), by person and by
date, or search by number or client name. Download CSV downloads every matching event.
Quotes and sales orders only show for people who can see quotes, and clients for people who
can see clients. The assistant reads the same trail with list_invoices_history.
Are you an AI? Visit llms.txt — these docs as plain markdown.