AP & AR
Aged receivables report
A monthly accounts receivable aging report breaks out what customers owe into current, 30, 60 and 90 plus day buckets, reconciled to the underlying invoices and payments, so collection risk and slow paying accounts show up clearly before a shortfall reaches your bank balance.
Aged receivables
Illustrative client · August 2026
CAD
| Customer | Current | 1-30 | 61+ | |
|---|---|---|---|---|
| Customer A | 18,400 | - | - | - |
| Customer B | 9,250 | 4,100 | - | - |
| Customer C | - | 6,780 | 2,200 | - |
| Customer D | 12,600 | - | - | - |
| Customer E | - | - | - | 1,450 |
| Total | 40,250 | 10,880 | 2,200 | 1,450 |
Illustrative. An example of the document, not a client's figures.
What the report shows
A monthly aging report breaks customer balances into current, 30, 60 and 90 plus day buckets, reconciled to the invoices and payments behind each figure. It is prepared as part of monthly close and available sooner on request if you need to check a specific customer.
Watching the trend, not just the snapshot
A single month's aging report tells you where things stand today. What matters more is which accounts are sliding into a worse bucket month over month, since that pattern is the early warning a cash shortfall is building before an invoice is technically overdue enough to worry about on its own.
Notes that make the numbers usable
An aging report full of unexplained balances is not much use to you. Each aged balance carries notes on any invoice under dispute or on a payment plan, so a customer paying late by agreement is not mistaken for a customer avoiding you.
Flagging write off candidates
Where a balance has aged past the point of realistic collection, it is flagged as a bad debt candidate for your review, along with the history behind it. We do not decide to write off a balance on your behalf. That is a call for you or your tax adviser, since a write off has GST/HST and income tax consequences that sit outside bookkeeping.
Built on GST/HST registration status
Because your GST/HST position depends on your revenue staying under or moving past the C$30,000 small supplier threshold, the aging report also gives you a clean view of realized, collected revenue rather than just invoiced amounts, which matters once that threshold is close.
Questions
Frequently asked questions: Aged receivables report
How often is the aging report updated?
Monthly as part of close, with an updated view available on request if you need to check a specific customer sooner.
What counts as at-risk on the aging report?
An invoice significantly past its terms with no response to reminders, flagged separately from one that is simply a few days late.
Does the aging report account for disputed invoices?
Yes. Any invoice under dispute or on an agreed payment plan is noted so it is not read as an account simply refusing to pay.
What exactly is included in aged receivables report?
Monthly aged receivables report broken into current, 30, 60 and 90-plus day buckets, and customer balances reconciled to invoices and payments received. This work runs inside QuickBooks Online or Xero, whichever your business already has in place, and it rolls into your regular monthly close rather than sitting off to the side as a separate, unreconciled process.
What happens to our aged receivables report records if we switch providers?
Everything stays inside your own QuickBooks Online or Xero account, so the full history transfers with the subscription, not with Finbryn. You can hand aged receivables report to another provider or bring it in-house at any point without losing a reconciliation or having to rebuild the file first.
How often is the aged receivables report updated?
Monthly as part of close, with an updated view available on request if you need to check a specific customer sooner.
Do you decide when to write off a bad debt?
No. We flag the candidates and the history behind them. Writing off a balance is a decision you or your tax preparer make.
Who reviews the work before it reaches us?
Every deliverable under aged receivables report is reviewed by a senior principal before it reaches you. You keep access to the underlying file at every stage, so nothing about the work happens somewhere you cannot see it.
What is included in aged receivables report?
Aged receivables report covers monthly aged receivables report broken into current, 30, 60 and 90-plus day buckets and customer balances reconciled to invoices and payments received. The exact scope is agreed and set out in writing before work starts, so you know precisely what is and is not covered before the first deliverable arrives.
Related services
- AP & ARCollectionsOverdue invoices are followed up on a set cadence, with reminders sent and calls logged, so slow-paying customers get consistent attention without you having to chase them yourself.
- AP & ARCash applicationIncoming customer payments are matched to the right invoice and posted to the correct account, so accounts receivable reflects what is actually still owed.
Next step
Talk to the team that would run your books
A short call covers your setup, your software and what a first month would look like. You get a written scope and price after it.