Which unpaid invoice needs attention first? Build a weekly cash action list
Turn an invoice aging report into specific next actions, with a worked example that separates customer promises, disputed work and money actually received.
Share this guide
Start with the payment obstacle
A large receivables balance can hide several different problems: an invoice never reached the right person, a customer is waiting for a correction, or payment is promised but has not arrived. Sorting only by the oldest date will not explain which action could move a particular invoice forward.
SBA's finance guide identifies receivables, available cash and bank reconciliation as responsibilities someone must manage. Its glossary distinguishes recording activity from receiving cash. BGA's workflow below is an original operating exercise for owners reviewing their own business invoices. It does not prescribe tax treatment, collection remedies or a new accounting policy.
Create one reliable invoice list
Choose a review date and reconcile the list with your accounting records. For each invoice, record its identifier, customer, invoice date, agreed due date, original amount, credits, payments and remaining balance. Check for duplicate invoices and payments that were received but not applied. A mistaken reminder can damage an otherwise healthy customer relationship.
Group balances using days past the agreed due date: not yet due, 1–30 days late, 31–60 and more than 60. These are suggested management buckets, not legal deadlines or universal industry standards. An invoice issued a month ago may still be current if the customer has longer agreed payment terms.
Add an explanation column alongside age: missing purchase-order reference, incorrect billing address, disputed scope, awaiting approval, promised payment or unknown. Keep sensitive customer information in the authorized accounting system rather than an unrestricted shared spreadsheet.
Work through a fictional Tuesday review
Assume a business has three unpaid invoices. Invoice A has $4,000 outstanding and is 20 days late because a required purchase-order reference is missing. Invoice B has $2,000 outstanding and is 50 days late with a genuine scope dispute. Invoice C has $3,000 outstanding, is not yet due and has a customer promise to pay Friday. The outstanding total is $9,000.
The first operational action on A is to verify and correct the reference, then confirm receipt with the authorized billing contact. B needs the person responsible for the work to resolve the disputed item; another generic payment reminder would not answer the customer's objection. C needs monitoring against the promise, not an inaccurate overdue warning.
If A pays $4,000 and C pays $3,000, receipts would total $7,000 and the remaining balance would be $2,000, assuming no other changes. That is a scenario, not a prediction. A promise and an accepted card-payment attempt remain separate from confirmed money received. Reconcile actual receipts through the business's normal financial controls.
Assign a next action and a next check
Give each material invoice one responsible person, a dated next action and the evidence needed to close that action. For a corrected invoice, evidence might be confirmation that the billing contact received the corrected version. For a dispute, it might be a documented agreement on the work and amount. Neither is automatically evidence of payment.
Use a factual, specific message through an appropriate existing customer channel: identify the invoice and agreed due date, ask whether a documented issue prevents payment, and state the next step you can actually take. Do not expose other customers' balances or private records in a group message. This article does not authorize an automated reminder campaign.
Review proposed late fees, service suspension, collection-agency referrals or legal action separately against the agreement and applicable requirements. Do not invent a fee or threaten a remedy simply because a balance falls into an older management bucket.
Connect the list to your cash forecast
Bring the evidence into BGA's four-week cash-flow forecast. Put confirmed receipts in the actual column and uncertain expected receipts in the relevant planning scenario. If a disputed invoice is needed to cover a near-term obligation, show the consequence of a later payment rather than hiding it inside an optimistic total.
During the weekly review, record the opening balance, new invoices, credits and receipts so you can explain the closing balance. Watch whether the same billing error returns across multiple customers. Fixing a recurring invoicing defect may be more useful than increasing the number of reminders.
Finish with a short owner decision
The weekly output should be a small action list, not a collection of red cells. Identify which obstacle can be removed now, who will remove it and when the result will be checked. Keep unresolved disputes visible and ask your bookkeeper or qualified adviser about adjustments requiring accounting judgment.
A good review leaves the owner able to distinguish work billed, payment expected and cash received. Measure actual receipts and resolved obstacles over subsequent reviews. Do not claim the process improved cash flow until your own reconciled records show that result.
Original sources
Share this guide