Prioritize overdue invoices for follow-up

01

Clean the report first

Choose an as-of date and calculate days overdue from the agreed due date using the same convention for every invoice. Reconcile open invoices, applied payments and credits to the accounting records. Show unapplied cash and unused credits separately until their allocation is confirmed. They may explain an apparent overdue balance.

Include invoice ID, customer, due date, open amount, age, dispute status and owner. An invoice that is unpaid but not yet due belongs in the current category. A payment promise is an estimate, while a credit reduces the balance and is not a cash receipt. Check the customer record before any outreach.

02

Build a queue from a sample

Hypothetically, invoice A has $4,000 open and is 10 days overdue. The customer reports an unresolved delivery dispute. Invoice B has $1,000 open and is 45 days overdue with no recorded dispute. Invoice C has $2,000 open and is 35 days overdue, but a matching bank receipt is awaiting allocation. Total reported overdue invoices are $7,000 before resolving C. It would be misleading to describe all $7,000 as confirmed collectible cash.

Route A to the person who can investigate delivery, with a date to update the customer. Check B's invoice and contact history before an authorized payment inquiry. Verify and allocate C's receipt using remittance evidence before sending a reminder. If the $2,000 receipt is confirmed and fully applied, the remaining open overdue balance in this example is $5,000, assuming no other changes.

03

Set the next action

Assign each item a reason, owner, next action and review date. Sort by urgency, value and issue, not age alone. A high-value dispute may need operational evidence, while several smaller invoices might share a billing reference error. Escalate sensitive cases according to internal policy and applicable rules.

Use the customer's agreed contact channels and check prior correspondence. Do not demand payment for an amount already settled or ignore a dispute. If a customer offers a payment plan, document the agreed dates and amounts, and treat them as expected receipts until funds clear.

04

Measure the queue over time

Track overdue invoice count, open value, age, disputes, confirmed credits and cash received separately. Compare reports using the same as-of timing and bucket definitions. A growing balance can reflect increased sales, different terms or a changed customer mix, so examine the overdue share and underlying records as well as dollars.

Review repeated causes with billing and delivery teams. Confirm whether a new control reduces the same error in later invoices. Accounting treatment, collection practices and legal requirements vary by jurisdiction. Involve the appropriate professional when a case requires advice.

05

Compare overdue value with the total

Hypothetically, one report has $5,000 overdue out of $20,000 in open receivables, or 25%. A later report has $6,000 overdue out of $60,000, or 10%. The overdue dollars increased even though the share fell. Compare the same aging rules and customer terms, then examine which invoices account for the increase before deciding what changed.