What a statement shows
A statement lists, for one customer and a period, an opening balance, every movement in the period with a running balance, and a closing balance. The movements are invoices, credit notes, payments received, refunds paid, and cancellations, each on its own date.
Every amount on the screen shows $ (or the currency code, on a statement in another currency), because the statement is a document you send the customer, not a report. A line with nothing in a column shows a dash.
A credit note applied to an invoice appears as a note with no amount, because both documents already sit in the customer's balance. The closing balance agrees with what the customer owes in Trade Debtors on that date.
While something is owing, the statement shows where to pay: the customer's own Pay into account when their record names one (a donor with an account of its own), otherwise your company's Pay to account. A statement covers several invoices, so it shows the customer's account even if one invoice named another.
What is outstanding, with ageing
Under Edit report, Statement chooses between Activity in a period (the statement above) and What is outstanding. The second is as at one date: every invoice still unpaid on that date, each with its due date, how many days overdue it is and what is left to pay (an invoice part paid shows what is left), and each credit note not yet used, as a minus. At the foot the balance is split by age as the aged receivables report splits it: Current (not yet due, and unused credit), 1–30 days, 31–60 days, 61–90 days and Over 90 days overdue, then the Total outstanding. Its total is the customer's balance on that date.
The choice stays in the page's address, and Export (PDF), Print and Email statement send the statement you are looking at.
One customer
Open Reports → Sales → Customer statements. It opens on the customer who owes you the most; choose another customer or other dates under Edit report, and the statement changes as you do. From the statement you can Export (PDF), Print it, or Email statement. Each reference on the statement opens the invoice, credit note, receipt or refund behind it, and the page trail brings you back to the same statement. A customer's name on the aged receivables, overdue or register report opens their statement too.
The email is filled in from the customer's record and you can edit the recipient, subject and message before it goes. The PDF uses the theme assigned to statements in your document themes.
Everyone who owes you
Send in bulk lists every customer who owes at least the amount you choose on the statement date. The amount owing is invoices less credit notes, net of what has been paid.
| Field | What it does |
|---|---|
| Statement date | The date the balances and statements are worked out as at. |
| Activity from | The start of the period each statement lists. |
| Owing at least | Customers owing less than this are left out. The lowest value is 0.01. |
Everyone with an email address is ticked, except customers who have already been emailed a statement for that same date. You can tick or untick anyone. A customer with no email address can't be ticked and is skipped.
A customer who has been marked Leave out of bulk statement emails on their record is listed but can't be ticked, and is skipped even if a run was started from an older list. You can still email them a statement by hand from the Customer Statements page.
Review and send shows who will receive one before anything is sent. Each customer gets their own statement as a PDF, with the standard message. Up to 50 customers are sent per run, so run it again for the rest.
Statements are sent from the platform address, and replies go to your business Reply-To address. Sending needs email to be set up on the server, and a role that can create and edit records.
What is recorded
Each statement that is emailed is recorded in the audit trail against the customer. That is what fills the Last emailed column and the Sent for this date mark, so a second run doesn't mail the same statement twice unless you tick the customer again. Sent statements also appear under Email activity in Mail.