iBill.ca
Start free
Accounts receivable aging

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

Sample iBill report: accounts receivable aging
Accounts receivable aging report in iBill (sample data)

How it works

  1. Open AR Aging

    From Reports, or the AR Aging button on the Invoices page. It shows today's position.

  2. 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.

  3. 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.

ClientCurrent1 to 3031 to 60Over 90Total
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?

It is on the accrual basis, the default: invoices not yet paid appear there as money owed to you. If you switch the balance sheet to Cash, unpaid invoices are left out until they're paid. The aging report lists every unpaid invoice by client and how late it is.

How is 'days late' worked out?

From the invoice's due date. An invoice due on receipt starts aging the day it's issued.

Can I send clients what they owe?

Yes. Open the client's statement of account and email it, or send a reminder from any overdue invoice.

Do voided or cancelled invoices show up?

No. Only invoices that are still owed are included: sent, unpaid, overdue and partly paid. Paid invoices drop off as soon as you record the payment, and a credit note applied to an invoice lowers its balance.

Know who owes you, today

Receivables aging from the invoices you already send. See the rest of the accounting tools.

Start free

Free · No credit card · All features included · Join 1,200+ Canadian Businesses