Written by Bryan Martin, CPA, Managing Partner and Founder of Taxstra. Last updated July 17, 2026.
How to use this accounts receivable aging template
An accounts receivable aging report answers one question fast: who owes you money and how overdue is it? Every unpaid invoice lands in one bucket based on days past its due date. The template adds three columns most reports omit, next action, action owner, and action date, because a report without an action column is a list of disappointments, not a collections tool.
Run it weekly. Most accounting platforms, including QuickBooks and Xero, generate the aging automatically; the template exists so you can layer the action tracking on top, or run a clean report if your invoicing still lives in spreadsheets. Work the report top down: bucket totals first, concentrated customers second, stale exceptions third. Then execute the collections ladder in the table above, on schedule, without renegotiating it emotionally each time.
One reconciliation habit keeps the whole thing honest: the aging report total must tie to the accounts receivable balance on your balance sheet every month. If they disagree, invoices are being recorded or paid outside the system, and both reports are lying to you. That check is part of a standard month-end close.
Worked example: what slow collections actually cost
Take an illustrative design-build firm billing $900,000 a year on net 30 terms, carrying $110,000 of receivables. Its DSO is about 45 days: on average, cash arrives 15 days later than the terms promise. Fifteen days of revenue at this firm is roughly $37,000 permanently parked in customers' bank accounts instead of the firm's.
That $37,000 is not an abstraction. If the firm runs a line of credit at a 10% illustrative rate to bridge payroll while waiting on customers, the float costs about $3,700 a year in interest. Worse, when a $9,400 invoice slides past 60 days, the firm starts its next project while effectively lending that customer the money, and one more slow payer can turn a profitable quarter into a missed payroll scare.
Now run the fix. The firm tightens intake (50% deposits on new projects), automates the day-minus-3 and day-14 reminders, and assigns the 15-30 day phone call to the office manager every Tuesday. If DSO falls from 45 to 32 days, roughly $32,000 of cash comes off the aging report and into the bank, once, permanently. Nothing about revenue changed. That is why collections is usually the cheapest financing a small business will ever find.
Taxstra Tip
Before year-end, review the over-90 bucket with your CPA. Genuinely uncollectible balances should come off the books, and for accrual-basis businesses a worthless receivable may support a bad debt deduction, while cash-basis businesses generally get no deduction for unpaid invoices because the income was never recognized. Cleaning the bucket also stops stale balances from inflating the receivables your lender sees.
Common AR mistakes
Aging from the invoice date instead of the due date. An invoice sent yesterday on net 30 terms is not late. Measuring from the invoice date makes the report look worse than reality and trains everyone to ignore it.
Invoicing late. The most expensive AR problem happens before the report exists. Work finished on the 3rd and invoiced on the 28th added 25 days to your collection cycle for free. Invoice on delivery, every time.
Continuing work for customers past 60 days. Every additional deliverable for a customer who has not paid increases your loss if they never do. Pausing work is not rude; it is the natural consequence written into your terms.
Letting the owner be the only collector. Owners hate the calls, so the calls do not happen. Scripts plus a named non-owner for routine steps fixes more aging problems than any software.
No payment friction removal. If paying you requires printing a check, you will wait for the check. Electronic payment options routinely shave days off DSO for the cost of processing fees.
If invoicing, aging, and follow-up keep falling through the cracks, that weekly rhythm is exactly what an outsourced bookkeeping engagement runs for you, and an accounting consultation is the fastest way to scope it.