Which Overdue Invoice Do You Chase First? A Practical AR Prioritization System

Imagine it is Monday morning. You have six outstanding invoices. Two are slightly overdue by a few days. One is 18 days past due for a large amount. Two more are 35 and 42 days overdue. One has been sitting for 65 days and you have not heard from that client in two weeks.

Which do you chase today? All of them? The newest ones because they are easiest to resolve? The oldest one because it is the most urgent? The biggest one because it affects your cash flow most?

Without a system, you will make a different choice each time depending on your mood, your memory, and which client email you happened to see last. That randomness is expensive. Invoices that should be chased today get left another week. Invoices that are at high risk of becoming uncollectable don't get the urgent treatment they need. And clients who are slightly late — who just need a gentle nudge — get ignored while you focus on the wrong problem.

The solution is a prioritization system: a consistent set of rules you apply to every invoice so that the decision of who to chase first is mechanical, not emotional.

The foundation of any AR prioritization system is the aging bucket. Aging buckets group your outstanding invoices by how long they have been unpaid. The standard breakdown used in accounting and collections is:

The older the bucket, the lower the probability of collection without significant effort — and in some cases, without professional collections help. This is not a technicality: once an invoice passes 90 days, many small businesses and freelancers write it off entirely. Prevention — catching invoices before they age into dangerous territory — is the whole point of a prioritization system.

Generate your own AR aging breakdown using the AR aging report tool. Enter your outstanding invoices and their due dates, and it groups them into buckets automatically so you can see your exposure at each risk level.

Once you understand aging buckets, you need a way to rank invoices within and across those buckets. The simplest effective method is a two-factor priority score.

Priority Score = Invoice Amount × Days Overdue

This formula combines the two factors that matter most: how much money is at risk and how long it has been at risk. Here is how it works in practice with a set of example invoices.

Notice something counterintuitive: Client C (65 days overdue, $3,500) ranks below Client B (18 days overdue, $15,000). The larger amount offsets the shorter overdue period. And Client A, with a moderately large amount at 42 days overdue, tops the list even though it is neither the largest nor the oldest invoice.

This is why the score matters: intuition about which invoice to chase first is often wrong. The math cuts through it. Calculate this score weekly using the AR aging report tool and sort by score to build your weekly chase list.

The priority score gives you a baseline ranking. Client context is the layer you apply on top — but only after the math, not instead of it.

Here are the legitimate reasons to adjust the score-based order:

• New client with no payment history. A new client who is 20 days overdue on a moderate invoice warrants more urgency than the score suggests. You have no track record with them. Move them up, chase quickly, and establish expectations early.
• Long-term client with a consistent payment record. A client who has always paid on time and is currently 10 days late is almost certainly an administrative delay. You can afford to be more patient and gentler in tone. Don't let the score make you heavy-handed with a good client who just had a slow month.
• Client showing financial distress signals. If you have heard from other contacts that a client is struggling, or if they have recently gone quiet after previously being responsive, treat their invoice as higher priority than the score shows — act before the situation worsens.
• Disputed invoice. If a client has raised a question or dispute about an invoice, it does not get a lower priority — it gets a different kind of action. Resolve the dispute first. A disputed invoice that goes unaddressed for 30 days is worse than a clean overdue one.

The key discipline is to apply these adjustments consciously and sparingly. The most common mistake is letting relationship considerations excuse indefinite delay: “Oh, they're a good client, I'll give them another week.” That week becomes a month becomes a write-off.

A prioritization system only works if you actually use it. Here is how to turn the scoring and aging analysis into a practical daily and weekly routine.

Weekly (Monday morning, 30 minutes):

1. Run your AR aging report. Identify any invoices that moved into a worse bucket this week.
2. Calculate priority scores for all overdue invoices. Sort the list.
3. Decide the week's chase targets: which clients get contacted this week and in what order.
4. Draft or queue the reminder emails using a reminder generator for the appropriate tone at each stage.

Daily (morning, 5–10 minutes):

1. Check your Today View (a feature in InvoiceGrid) — which invoices have a follow-up due today?
2. Send any queued reminders from your weekly plan.
3. Log any payments received and move those invoices to Paid.
4. Note any client responses that require a different approach.

The daily check takes less than ten minutes when you have a visual system that surfaces what needs attention. Without a system, it can take twenty minutes of email searching just to figure out what state everything is in — and some invoices still slip through.

The reason most freelancers don't use a prioritization system is not that they don't know they should — it is that running the system manually takes time and effort they don't have. The right tools make the system nearly effortless.

AR aging report tool. The AR aging report tool takes your list of outstanding invoices and instantly groups them into aging buckets with total exposure at each risk level. Instead of building this in a spreadsheet every week, you enter the data once and get the view you need. This is the starting point for calculating priority scores.

DSO calculator. The DSO calculator shows your Days Sales Outstanding and compares it against industry benchmarks. If your DSO is 60 days when your sector average is 35, you can see the exact cash flow opportunity that faster collection would unlock.

Cash flow calculator. The cash flow calculator quantifies exactly how much working capital is tied up in outstanding invoices and what the annual cost of late payments is to your business. Useful context when deciding how aggressively to pursue overdue accounts.

Bad debt calculator. The bad debt calculator applies industry write-off rates to each AR age bucket to estimate your total bad debt reserve. Invoices in the 61–90+ day buckets that aren't being actively chased often need urgent action — this tool flags the risk.

Visual Kanban board. InvoiceGrid's Kanban board shows every invoice as a card in a stage column: Sent, Reminded, Follow-up, Paid. Invoice amounts are visible on the cards. Due dates are visible. You can see at a glance which invoices are in which stage and roughly sort by urgency without any calculation — the visual arrangement does it for you.

Today View. Rather than re-prioritizing from scratch every morning, the Today View surfaces only the invoices that need action today based on their due dates and your follow-up schedule. It answers the daily question — “what do I actually need to do right now?” — without requiring you to review the whole board.

Late fee calculator. When an invoice reaches the 30-day threshold and you are ready to apply a late fee, the late fee calculator computes the exact amount based on your rate and the number of days overdue. You can include the specific number in your follow-up email, which makes the message more concrete and the fee harder to ignore.

Late fees serve two purposes. The obvious one: compensation for the delay in your cash flow. The less obvious one: they are a prioritization signal.

When you calculate that a $6,000 invoice at 45 days overdue has accrued $135 in late fees at 1.5% per month, that number belongs in your follow-up email. It shows the client that the delay has a concrete cost, and it shows you — when you are prioritizing — that this invoice is losing you money every day it stays unpaid.

More practically: any invoice old enough to have accrued a material late fee should automatically rank higher in your priority queue. The fee is a proxy for the combined effect of time and amount — exactly what the priority score measures. Invoices with meaningful late fee accrual are the ones to chase hardest this week.

Use the late charge calculator at your weekly AR review to see the accrued fees for each overdue invoice. Invoices with the highest accrued fees almost always match the ones at the top of your priority score list — and they should be at the top of your chase list this week.

One final point on late fees: enforce them consistently. If you calculate and mention them but then waive them every time a client asks, you teach clients that your late fee policy has no teeth. Apply them, credit them only in genuine hardship situations, and document every decision in your chase history log so the pattern is visible over time.