Sales Summary

One row per Sales invoice: gross, discounts, tax, rewards, expenses, total, and what has been paid. The daily report for matching invoices to money received.

Questions It Answers

Filters

Filter What it does
Transaction Date Date range of the invoices. Empty means the whole history - slow on years of data, so always fill it.
Division Pre-filled from the user role's default division. A role locked to one division cannot change it.
Currency Only transactions in that currency. Amounts are still shown in the company default currency.
Sales Representative One sales rep only; pre-filled from the role's default when set.
Customer Group Only invoices of customers in that group; pre-filled from the role default when set.

How To Read It

Column Meaning
Sales Invoice, Sales Date, Customer Name Invoice identity. Order: division, then date and time.
Gross Sum of price x quantity over all lines, before discounts.
Discount Value Total line discount.
Invoice Discount Discount at the foot of the invoice, separate from line discounts.
Tax Line VAT plus invoice extra tax.
Reward, Reward tax Value of reward products that went out (from Reward Rules) and their tax. Not billed to the customer.
Expenses Sales expenses charged to the invoice (freight, stamp duty).
Net Final invoice total billed to the customer.
Payment Amount already paid for that invoice, from the invoice Payments tab or Receivable Collection.
TOP String Terms: 2/10 n/30 means 2% discount if paid within 10 days, due in 30 days.

Why The Numbers May Differ

Menu Location