Accounts receivable aging for Canadian businesses
One report answers the question every business owner asks: who owes me, how much, and how late is it? Each client's unpaid invoices are grouped by how long they've been due. It's built from your invoices and payments, so there's nothing to update by hand.
Free · No credit card · All features included
How it works
Open AR Aging
From Reports, or the AR Aging button on the Invoices page. It shows today's position.
Read the buckets
Each client's balance owing is split into current, 1 to 30, 31 to 60, 61 to 90 and over 90 days past due.
Act on it
Send a reminder or a statement of account to the clients in the older buckets. Print the report or export it to CSV.
Worked example: a painting contractor's receivables
Five clients owe a painting company money. The aging report shows each balance by age, and the total at the bottom is what's outstanding.
| Client | Current | 1 to 30 | 31 to 60 | Over 90 | Total |
|---|---|---|---|---|---|
| Property manager A | $3,150.00 | $3,150.00 | |||
| Homeowner B | $1,890.00 | $1,890.00 | |||
| Restaurant C | $945.00 | $1,260.00 | $2,205.00 | ||
| Builder D | $4,725.00 | $4,725.00 | |||
| Homeowner E | $630.00 | $630.00 | |||
| Total | $4,095.00 | $3,150.00 | $4,725.00 | $630.00 | $12,600.00 |
Builder D is the call to make this week: the largest balance, now past 30 days. Homeowner E has been overdue for three months; a statement of account and a direct conversation work better than another automatic reminder.
The amount owing on each invoice is its total less payments and applied deposits, plus any refunds, so a partly paid invoice shows only what's left.
Clients billed in US dollars appear with their balances in US dollars and a separate US-dollar total, so the Canadian-dollar total above is never mixed with another currency.
Aging and Client Balances
AR Aging is the position today: unpaid, sent, overdue and partly paid invoices, grouped by how late they are. Client Balances, under Reports, shows each client's invoiced, received and owed amounts for a date range, with search and filters for outstanding or paid.
The income statement's accrual view counts these invoices as revenue; the aging report shows which of them are still unpaid and for how long, so read the two together to understand the business.
A good habit is to read the aging every Monday. Anything moving from current into 1 to 30 days gets a friendly note; anything past 60 days gets a call. Clients who are always in the older buckets may be better on shorter payment terms or a deposit up front.
What’s included, and what isn’t
- Days late are counted from each invoice's due date.
- Balances in US dollars, euros or pounds are kept in that currency, with a total for each currency.
- Every client with money owing is included.
- Print or export to CSV with every bucket for each client.
- Statements of account by client, as a PDF or by email.
- Not included: custom aging buckets in the app, and interest added to overdue balances.
Questions
Why isn't money owed to me on my balance sheet?
How is 'days late' worked out?
Can I send clients what they owe?
Do voided or cancelled invoices show up?
Related
Know who owes you, today
Receivables aging from the invoices you already send. See the rest of the accounting tools.
Start freeFree · No credit card · All features included · Join 1,200+ Canadian Businesses