Customers & sales · Guide 18 of 53
Sending customer and supplier statements
Produce a statement of account for any customer or supplier — opening balance, the invoices, credit notes and payments in between, a running balance and a closing balance — email it to a customer, and tie the totals back to your ledger with aged debtors and creditors.
A statement is a plain summary of everything a customer owes you (or you owe a supplier) over a chosen window: what was outstanding at the start, every invoice, credit note and payment since, and where the balance stands now. It is the polite, unambiguous way to chase money — and IQ Books builds it straight from your posted ledger, so it always agrees with the rest of your books.
What A Statement Shows
Every statement is built the same way, whether it is for a customer or a supplier:
- Opening balance — the net amount outstanding on the day before your ‘from’ date, rolling up everything that happened earlier.
- In-period movements — each invoice, credit note and receipt (for a customer) or payment (for a supplier) that falls inside your date window, listed as individual documents.
- Running balance — a column that climbs with each new invoice and drops with each credit note or payment, so the reader can follow exactly how the balance moved.
- Closing balance — the net amount outstanding on your ‘to’ date. This is the figure you are really asking them to settle.
Send A Customer Statement
- Open the report. Go to
Reports → Customer Statementand pick the customer from the list. - Set the date window. Choose a ‘from’ and ‘to’ date. If you leave ‘from’ alone it defaults to 90 days before your ‘to’ date, which suits most monthly chasing.
- Review it. Check the opening balance, the invoices, credit notes and receipts in between with their running balance, and the closing balance at the foot.
- Email it. Click
Email Statement. It goes to the customer’s address on file, but you can override the recipient at send time — handy for a client’s accounts inbox that differs from their main contact.
Supplier Statements
A supplier statement works identically — Reports → Supplier Statement, pick the supplier, set the dates — and shows your bills and the payments you have made against them. Use it to check your own position against a statement the supplier has sent you.
Choosing The Right Date Window
The window only controls which documents are itemised. Anything before the ‘from’ date is folded into a single opening balance, so a short window still tells the whole story — the reader is never left wondering where a balance came from. Widen the window to include older unpaid invoices explicitly; narrow it to a single month for a clean monthly chase.
Aged Debtors And Aged Creditors: The Companion Report
A statement covers one contact. To see everyone at once — who owes you and how overdue they are — use the ageing reports.
- Open the report. Go to
Reports → Aged Debtors(money owed to you) orReports → Aged Creditors(money you owe). - Set the as-at date. It defaults to today. Change it to age your book as at a period-end.
- Read the buckets. Each contact’s open balance is split into Current, 1–30, 31–60, 61–90 and 90+ days.
The buckets are driven by each invoice’s due date, so an invoice only falls into an overdue bucket once it is genuinely late. An invoice with no due date is treated as Current. Only invoices that have been issued and still have something outstanding appear — fully paid and voided ones drop off — and everything is shown in your organisation’s base currency.
Tying The Numbers Back To The Ledger
The totals block on each ageing report also shows the balance on your debtors or creditors control account in the general ledger, so you can prove the report agrees with your books. When they differ, IQ Books shows the gap as an unallocated residue rather than hiding it.
For the same reason, an aged total can differ slightly from a naive sum of the invoices you can see. Currency conversion to your base currency and those brought-forward opening balances both account for the difference — the control account is the number to trust.
Analysing Spend And Sales
If you want totals rather than a chase, the summary reports sit alongside the statements: Reports → Purchases by Supplier and Reports → Sales by Customer. Each gives net, VAT and gross, the count of invoices and credit notes, how much has been paid or received, and what is still outstanding for a period — the quick way to see your biggest suppliers or customers.
Chasing A Single Invoice
For one overdue invoice you often do not need a whole statement. Open the issued invoice and email it with an online pay button attached: the customer pays by card, Apple Pay or Google Pay, and IQ Books records the receipt against that invoice automatically and marks it paid. That receipt then flows through to the next statement you send.
Worked Example: Reading The Running Balance
A customer statement for May might read:
- Opening balance, 1 May — £400.00 (an April invoice still unpaid).
- 8 May, invoice INV-1012 £1,200.00 → running balance £1,600.00.
- 19 May, receipt £400.00 → running balance £1,200.00.
- 24 May, credit note CN-0007 £150.00 → running balance £1,050.00.
- Closing balance, 31 May — £1,050.00.
The £1,050 closing figure is exactly what the customer owes you, and it will match that customer’s line on the aged debtors report as at 31 May.
Common Questions
- Why is the closing balance not the sum of the listed invoices? Because it includes the opening balance and every credit note and payment too. Follow the running-balance column to see how it was reached.
- Can I email a supplier their statement? Not from this screen — supplier statements are view or print only. Email is for customer statements.
- My statement and my aged debtors disagree by a few pounds. Check the as-at date matches the statement’s ‘to’ date, then look for an unallocated residue or a foreign-currency invoice — both are legitimate reasons the two views round differently.
- Do I have to send statements to keep the numbers right? No. The statement and ageing reports are read-only views of your ledger; sending one changes nothing. Send when you want to chase or confirm a balance.