Which Overdue Invoice Should You Chase First?
An aging report tells you who is late. It doesn't tell you whose payment matters most. A plain-English way to rank overdue invoices by cash impact, with a worked example.
By OpsIQ · Published
Short answer: Not automatically the oldest one. Xero's guide to chasing invoices names four things to weigh: how much is owed, how old the invoice is, your relationship with the client, and their payment history. We'd add one more lens: how much of your own 30-day cash gap the payment would close. Then use the answers to decide who to call first, and how.
If you have read Profitable but Short on Cash?, you know a business can be profitable and still run short because customers haven't paid yet. This guide is the practical next step: you have a list of unpaid invoices and limited time to chase them. Where do you start?
What an aging report actually tells you
An accounts receivable (AR) aging report "groups unpaid customer invoices into date ranges to show how long each amount has been outstanding," in the words of Xero's guide to the report. The usual ranges are Current, 1 to 30 days, 31 to 60 days, 61 to 90 days and 90+ days overdue; QuickBooks lists the same buckets and notes the ranges can be customised. It shows, in QuickBooks' phrasing, "who owes you money, how much, and how late it is."
In the FDIC and SBA's Money Smart for Small Business materials, accounts receivable is "money owed to a business by its customers for goods or services delivered but not yet paid for," and cash flow is "the inflow and outflow of cash within a business over a specific period." An aging report is a picture of the first, taken to help you manage the second.
What it does not show is how much each payment matters to your cash position. A $650 invoice that is 105 days overdue sits in the scariest-looking bucket. It may still be the wrong first call if you have $6,500 of bills to cover.
What to weigh when ranking overdue invoices
Xero's guide to chasing outstanding invoices (published 17 June 2026) lists four factors and says to prioritise on a combination of them rather than a rigid hierarchy:
- Amount owed. "Larger invoices have a bigger impact on your cash flow, so they deserve attention first."
- Age. "The older an invoice gets, the harder it is to collect. Focus on invoices that are about to cross into the next aging bucket."
- Client relationship. "A long-term client who's a few days late is different from a new client who's 30 days overdue."
- Payment history. "If a client has a pattern of paying late, you may want to follow up sooner than you would with a typically reliable payer."
Our addition (editorial judgment, not from Xero or any cited source): measure "amount owed" against your own 30-day cash gap, meaning what you must pay in the next 30 days minus the cash you already have. An invoice that closes 70% of the gap outranks one that closes 10%, all else equal. Also ask why an invoice is late (a dispute, a missing purchase-order number, a slow approver, or a customer with its own cash problem), because each calls for a different conversation, and notice if one customer accounts for a large share of everything you're owed.
A worked example (illustrative numbers, not real data)
A small design studio has $3,000 in the bank and $9,500 of bills due in the next 30 days. Its gap is $6,500.
Its aging report (total outstanding $12,850):
| Customer | Amount | Status | Bucket |
|---|---|---|---|
| A | $1,200 | 12 days overdue | 1-30 |
| B | $4,800 | 38 days overdue | 31-60 |
| C | $2,100 | 70 days overdue | 61-90 |
| D | $650 | 105 days overdue | 90+ |
| E | $3,200 | due in 9 days | Current |
| F | $900 | 25 days overdue | 1-30 |
By bucket: Current $3,200 (24.9%), 1-30 days $2,100 (16.3%), 31-60 days $4,800 (37.4%), 61-90 days $2,100 (16.3%), 90+ days $650 (5.1%). The largest slice sits in 31-60 days, a bucket that looks less alarming than 90+ but contains the one invoice that matters most.
Oldest-first: call D ($650, about 10% of the gap), then C ($2,100). After two successful collections you have recovered $2,750, or about 42% of the gap.
Amount-against-the-gap first: call B ($4,800). One successful collection covers about 74% of the gap. Add A ($1,200) and you are at about 92%. Add F ($900) and you have collected $6,900, enough to cover the $6,500 gap with $400 to spare.
C and D still matter. C ($2,100 at 70 days) gets a firm call the same week because it is heading toward the 90+ bucket, the situation Xero's "about to cross into the next aging bucket" advice describes. D is small and very old, so it needs a decision: a final written request, a payment plan, or writing it off. Neither should get in the way of the call to B.
This is one simple case. Real invoices have disputes, partial payments and customers you can't afford to upset, and a collected invoice doesn't always arrive on the day you expect.
A weekly routine that takes 20 minutes
This routine is our own suggestion, not taken from a cited source.
- Update your cash balance and the next 30 days of bills to find your gap.
- Sort overdue invoices by amount, then by age.
- Mark the two or three that close the gap, and note why each is late and what you know about the client's relationship and payment history.
- Make those calls before sending routine reminders to the rest.
- Write down what happened: promised date, dispute raised, paid. Next week, start from that list rather than from zero.
How common is this problem?
Intuit QuickBooks' 2025 Small Business Late Payments Report, based on a January 2025 survey of 2,487 U.S. small businesses with 0 to 100 employees, found that 47% reported that a portion of their invoices were overdue by more than 30 days; 56% reported being owed money from unpaid invoices overall. That is one survey of U.S. small businesses, not a universal figure. Results for your industry, size or country may differ. What matters is your own list.
Where a tool can help
OpsIQ is a business diagnostic tool built to read your business numbers, show what needs attention and why, and give an ordered plan with an owner and a time frame. Findings are ranked by severity and urgency, with the evidence shown, and you decide which actions to take. On the OpsIQ homepage, an illustrative bakery example flags overdue receivables as a critical cash risk. OpsIQ is in free beta, and you can request access on the beta page.
Self-check
- What is my 30-day gap today?
- Which two or three invoices would close it?
- For each, do I know why it's late?
- Does any single customer make up an outsized share of what I'm owed?
- Who is checking that this list gets worked every week?
Sources
- Xero, "How to chase outstanding invoices and get paid faster" (published 17 June 2026, Lena Hanna): https://www.xero.com/us/guides/chasing-outstanding-invoices/ (the four prioritisation factors and the "combination of factors" caveat)
- Xero, "Accounts receivable aging report: how to use it to get paid faster" (published 3 July 2026): https://www.xero.com/us/guides/accounts-receivable-aging-report/ (definition and buckets)
- QuickBooks (Intuit), "AR aging report: What it is & how to use": https://quickbooks.intuit.com/r/payments/accounts-receivable-aging-report/ (buckets; "who owes you money, how much, and how late it is")
- Intuit QuickBooks, "2025 Small Business Late Payments Report": https://quickbooks.intuit.com/r/small-business-data/small-business-late-payments-report-2025/ (47% and 56% figures; survey of 2,487 U.S. small businesses, January 2025)
- FDIC and U.S. Small Business Administration, Money Smart for Small Business, Module 10 "Managing Cash Flow" participant guide (FDIC-029-2025): https://www.fdic.gov/consumer-resource-center/mssb-m10-pg.pdf (definitions of cash flow and accounts receivable); program page: https://www.fdic.gov/consumer-resource-center/money-smart-small-business
See what OpsIQ finds in your business.
OpsIQ reads your business numbers, tells you what needs attention and why, and gives you an ordered plan for what to do next. Free during the invite-only beta, no credit card required.