Which overdue invoices are the most urgent to collect?

Why chasing the right invoices first makes a real difference

You have 11 overdue invoices totaling $34,000. You have maybe 90 minutes this week to make collection calls. Do you start from the top of the list and work down? Call the oldest ones first? The biggest ones?

Most owners either chase the squeakiest wheel (the client who owes the most) or the lowest-hanging fruit (the smallest, newest invoice that's easy to resolve). Neither approach is optimal.

The best collection strategy considers three factors together: how much is owed, how many days overdue it is, and what you know about the client's likelihood of paying. A $12,000 invoice at 55 days is more urgent than a $2,000 invoice at 15 days. But a $3,000 invoice at 85 days from an unresponsive client might be the most time-sensitive of all because the window for collection is closing.

How to score and rank overdue invoices by urgency

A practical prioritization framework uses three criteria:

• Amount owed. Larger invoices have more cash impact. Collecting one $10,000 invoice frees more cash than collecting five $500 invoices.
• Days overdue.Invoices in the 45-75 day range are in the critical window. They're old enough that collection probability is dropping, but young enough that intervention still works. Beyond 90 days, the effort-to-recovery ratio gets worse fast.
• Client relationship and history. A first-time late payment from a loyal client needs a different approach (and lower urgency) than a third-time offense from a client who ignores your emails.

A simple urgency score: multiply the invoice amount by a weight based on its age bracket (1x for 1-30 days, 2x for 31-60, 3x for 61-90, 4x for 90+). Sort by this score descending and you have your priority list.

How to prioritize overdue invoices for collection in QuickBooks Online (5 steps)

QuickBooks gives you the raw data. You need to export and sort it to create a prioritized collection list.

1. 1
   Pull the A/R Aging Detail report

   Go to Reports→ search “A/R Aging Detail.” This lists every open invoice with customer name, invoice number, date, due date, days past due, and open balance.

2. 2
   Export to a spreadsheet

   Click Export at the top of the report. Save as Excel or CSV. This gives you a workable list you can sort and annotate.

3. 3
   Filter for overdue invoices only

   Remove any invoices that are still current (not yet past their due date). You want a list of only the invoices that need action.

4. 4
   Add an urgency score column

   Create a new column. Multiply the open balance by a weight: 1x for 1-30 days overdue, 2x for 31-60, 3x for 61-90, 4x for 90+. Sort by this column descending.

5. 5
   Add client context and start calling

   For your top 5-10 priority invoices, note any context you have about the client. Are they usually late? Have they been responsive? Is there a dispute? This helps you tailor your approach for each call.

How to prioritize overdue invoices for collection in Xero (5 steps)

The same approach works in Xero. Pull the detail report, export it, and apply your prioritization framework.

1. 1
   Pull the Aged Receivables Detail report

   Go to Accounting → Reports → Aged Receivables Detail. This shows every open invoice by contact with dates, amounts, and aging buckets.

2. 2
   Export the report

   Click Export and save as CSV or Excel. Open it in your spreadsheet application.

3. 3
   Filter for past-due invoices

   Remove current (not yet due) invoices from the list. Keep only invoices with amounts in the 1-30, 31-60, 61-90, or 90+ day columns.

4. 4
   Calculate urgency scores

   Add a column that multiplies the invoice amount by an age weight (1x, 2x, 3x, or 4x based on aging bucket). Sort by this score to see your most urgent invoices first.

5. 5
   Plan your outreach

   For your top priorities, review the contact details in Xero. Check if there are credit notes or disputes logged. Then start your collection calls with the highest-impact invoices first.

What it takes to run a collection priority review every week

For collection to be effective, you need to do this more often than monthly:

• Weekly is the minimum cadence. Invoices age fast. An invoice that was a low priority last week can become urgent this week as it crosses the 30 or 60-day mark. Weekly reviews keep your list current.
• You need to track follow-up status.Knowing which invoices are urgent is step one. You also need to track whether you've called, emailed, or received a promise to pay. Most owners use a spreadsheet or sticky notes, and things fall through the cracks.
• The emotional resistance is real. Nobody enjoys calling clients about overdue bills. It feels awkward, confrontational, and time-consuming. But every week you delay, the probability of collection drops. A quick, professional follow-up at day 35 is far more effective than an uncomfortable call at day 75.

Or get a prioritized collection list automatically

Bottomline connects to your QuickBooks or Xero account and builds a prioritized collection list in every monthly report. It ranks overdue invoices by urgency so you know exactly where to focus:

Bottomline factors in each client's payment history when calculating urgency. A 30-day-overdue invoice from a client who always pays at 35 days is flagged differently than a 30-day-overdue invoice from a client who has two previous write-offs. You get smart prioritization, not just a sorted list.