How do I prioritize which overdue invoices to chase first?

Weight by a combination of dollar amount, days overdue, and customer risk signals — a large balance moves the total AR number most, an old balance is hardest to collect the longer it ages, and a risk signal (payment history, a known dispute) can override both. A weighted score generates a daily worklist automatically; sorting a spreadsheet by eye doesn't scale.

By Zuny Fester, Head of Operations and Marketing

Reviewed by Zuny Fester

Published September 10, 2026Last reviewed September 10, 2026Editorial policy

Part of the accounts receivable and collections guide.

Factor 1	Dollar amount — moves the total AR number most
Factor 2	Days overdue — collectibility drops the longer it ages
Factor 3	Customer risk signal — can override amount and age
How mature teams do this	A weighted score generating a worklist, not manual sorting

Why no single factor is enough on its own

Sorting purely by dollar amount misses a small but chronically late customer sliding toward write-off. Sorting purely by days overdue can bury a large, recently-overdue balance under a stack of small, older ones that are individually less urgent. Combining all three — amount, age, and a risk signal like payment history or a known dispute — produces a prioritization that reflects actual business risk, not just one dimension of it.

Building a simple weighted score

A straightforward version assigns points for amount (higher balances score higher), age (older buckets score higher), and a manual risk flag (a known dispute or late-payment history adds points regardless of amount or age), then sorts the worklist by total score. This doesn't need to be sophisticated to be far better than sorting by a single column — the value comes from combining factors, not from the specific scoring formula.

Next step

Map the finance workflow with the most exposure and prove the automation path.

Bring the invoice, contract, payment reconciliation, or customer finance workflow you have to defend at audit. Loopfour can map the trigger, controls, integrations, and approval loop.

Book a workflow review

Worked example

Three invoices, one worklist

Invoice	Amount	Days overdue	Risk flag	Priority
A	$40,000	10 days	None	High (amount-driven)
B	$3,000	95 days	Prior late payment	High (age + risk-driven)
C	$8,000	5 days	None	Low (small, recent, no risk)

Frequently Asked Questions

Not necessarily — a strategic or high-value customer relationship might warrant a different prioritization approach than a standard transactional account, even at the same dollar amount and age.

Daily is common for active collections operations, since payments post and invoices age continuously.

Not strictly, but a manual weighted score becomes harder to maintain accurately as invoice volume grows, which is when automating the scoring itself starts to pay off.

Sources

Topic

AR & Collections

Accounts receivable is the money customers owe a business for goods or services already delivered on credit — a current asset on the balance sheet until it's collected. AR and collections, as a practi…

Role guide

Why do CFOs analyze the aging of accounts receivable?

AR aging is one of the earliest reliable signals of cash flow and credit risk problems — a growing share of receivables in older buckets predicts a future cash shortfall and rising bad debt before either shows up in the income statement. CFOs track it as a leading indicator, not just a collections operations metric.

How-to

How do I automate dunning and collections reminders?

Schedule reminders relative to the due date (a few days before, then at set intervals after), with escalating tone and channel, and add a suppression check before each send confirming the invoice is still genuinely open and undisputed. Most accounting systems support scheduling this natively; the suppression check is what prevents the most damaging automation failure.