Receivables aging and customer statements
Every posted sales invoice adds to what a customer owes. Allocated receipts and posted credit notes reduce it. Accounting keeps this per invoice, so you can see who owes what and how late it is.
Outstanding = invoice total − amounts allocated − credit notes.
Receivables aging
Where: Accounting → Receivables aging.
Who: accounting.ar.aging.view. Covers invoices of every business unit you are assigned to.
- In Age current balances to, choose the date to age to (normally today).
- Select Run aging.
The Aging summary shows the totals; Aging by customer shows one row per customer.
| Column | Days past the due date on the chosen date |
|---|---|
| Current | Not yet due, or due that day |
| 1-30 | 1 to 30 days overdue |
| 31-60 | 31 to 60 days overdue |
| 61-90 | 61 to 90 days overdue |
| Over 90 | More than 90 days overdue |
| Total | Everything outstanding for that customer |
Customers are shown by their partner number, for example Partner #55, not by name. Each row has two actions:
- Invoices for Partner #55 shows Outstanding invoices: each invoice with its invoice date, due date, days overdue and outstanding amount;
- Statement for Partner #55 opens that customer's statement (if you have statement access).
To find a customer's name, open their partner record, or use the statement's Find customer search.
Example: aged to 8 November 2026:
| Customer | Invoice | Due | Invoice total | Settled | Outstanding | Days overdue | Bucket |
|---|---|---|---|---|---|---|---|
| Café Aroma | INV-0039 | 20 Oct | 100.00 | 60.00 | 40.00 | 19 | 1-30 |
| Green Leaf Deli | INV-0044 | 15 Nov | 250.00 | 0.00 | 250.00 | –7 | Current |
| Harbour Bistro | INV-0021 | 30 Jul | 80.00 | 0.00 | 80.00 | 101 | Over 90 |
On screen (Café Aroma is partner 55, Green Leaf Deli 61, Harbour Bistro 23):
| Customer Partner | Current | 1-30 | 31-60 | 61-90 | Over 90 | Total |
|---|---|---|---|---|---|---|
| Partner #23 | 80.00 | 80.00 | ||||
| Partner #55 | 40.00 | 40.00 | ||||
| Partner #61 | 250.00 | 250.00 | ||||
| Total | 250.00 | 40.00 | 80.00 | 370.00 |
This screen ages each invoice's current outstanding amount. Choosing a past date does not rebuild the balance as it was on that date; payments made after it are already deducted. For a true historical aging, use Reports → Accounting → AR aging. Totals may also mix currencies if you invoice in more than one.
Customer statements
Where: Accounting → Customer statements.
Who: accounting.ar.statement.view.
- Under Find customer, type the customer's name or code and select Search customers. Choose the customer. (From an aging row, Statement for Partner #… opens it directly.)
- Optionally enter From date (optional) and Through date (optional, inclusive). Enter both or neither.
- Select Run statement.
The statement lists every receivables movement in date order with a running balance:
Example: Café Aroma, November:
| Date | Type | Document | Debit | Credit | Running balance |
|---|---|---|---|---|---|
| 03 Nov | Invoice | INV-0042 | 327.60 | 327.60 | |
| 10 Nov | Payment | PAY-0007 | 200.00 | 127.60 | |
| 24 Nov | Payment | PAY-0011 | 127.60 | 0.00 |
Statement totals: debit 327.60, credit 327.60, closing balance 0.00.
| Movement type | Created when | Side |
|---|---|---|
| Invoice | A sales invoice is posted | Debit (customer owes more) |
| Payment | A receipt is allocated to an invoice | Credit |
| Credit note | A credit note is posted | Credit |
The running balance starts at zero on the from date. Movements before it are not carried in. To see a customer's full position, run the statement with no dates.
Next: Worked example.