Skip to content
Enjoy complimentary data migration when switching from your existing bookkeeper or CPA to Institution.

Bookkeeping & finance

Accounts receivable aging report: how to read it and collect faster

Read invoice aging, verify customer balances, identify disputes and unapplied cash, and prioritize evidence-based collections.

By Institution4 minute readUpdated View sources
In this guide

What the report shows

An accounts receivable aging report groups unpaid customer invoices by age. For collections, use days past the contractual due date: current, 1 to 30 days overdue, 31 to 60, 61 to 90, and over 90. Check the report settings because an invoice-date report answers a different question. An invoice issued 45 days ago on net-60 terms is still current.

Reconcile the invoice total to the receivables control account on the same date. If the balance sheet presents receivables net of a loss allowance, show that allowance separately in the reconciliation. The aging schedule should explain customer balances before you use it to predict receipts.

A studio's overdue invoices and largest customer

In an illustrative design studio, the $84,000 balance consists of $52,000 current, $18,000 at 1 to 30 days overdue, $9,000 at 31 to 60, $2,000 at 61 to 90, and $3,000 over 90. The oldest $3,000 needs a documented collection review; its age alone does not prove it is uncollectible. One client also accounts for $31,000 of current invoices. Test a delayed receipt from that client in the cash forecast before relying on its expected payment date.

So read the report twice: once by age, and once by customer. Concentration is as important as lateness.

Turn it into a weekly routine

A weekly review gives someone time to act between closes. Start with the oldest invoices, the largest balances, and broken payment promises. A reminder at the due date followed by a call after 15 days is one possible schedule, subject to the contract and the relationship. Check disputes and missing documents before escalating. Record the contact, promised amount, expected date, and next owner on the account.

Fix the cause when the same customers are always late. Invoices sent late, sent to the wrong contact, or missing a purchase order number are common reasons, and they are within your control.

Days sales outstanding

For a period-based collection measure, divide average trade receivables by net credit sales for the same period and multiply by the number of days. If average receivables were $84,000 and net credit sales were $360,000 over 90 days, the result is 21 days. Cash sales do not belong in that credit-sales denominator. Document whether your dashboard uses an average or an ending balance, and keep the convention consistent.

DSO is an estimate influenced by sales timing and customer mix. It does not mean every customer pays on day 21. Read it alongside overdue invoices and actual collection dates, especially after rapid growth or a seasonal sales spike.

References: BDC: Average collection period calculation

Bad debts

Ask the accountant to document the applicable loss-allowance and write-off policy. A write-off against an existing allowance reduces that allowance and the customer balance; it should not automatically create a second expense. Review evidence such as disputes, insolvency information, subsequent receipts, and collection attempts. Being 90 days late can trigger a review without dictating its conclusion.

The book entry and the tax deduction are separate questions. The IRS states that a deductible bad debt generally requires an amount previously included in income or cash actually lent. An unpaid invoice under a cash method may not create a deduction. Send the supporting facts to the tax preparer before treating a write-off as a tax saving.

References: IRS: Bad debt deduction

Keep the report accurate

Apply payments and credit memos to the invoices they settle, investigate unapplied cash, and identify deposits for work not yet earned. Present customer advances according to the accounting policy instead of letting them obscure overdue invoices. Keep the customer-level trail when reclassifying a credit so the next receipt or refund can still be matched.

A collection timeline

Build the timeline from the contract: an invoice or milestone date, due date, reminder, personal follow-up, and an escalation owner. Before each contact, check receipts, credits, disputes, and the customer's latest promise. Put an agreed payment date in the cash forecast with its confidence level. Any service suspension, late fee, or external collection step needs review against the contract and applicable requirements; an aging bucket alone does not authorize it.

Mistakes to avoid

Flag concentration as well as age. A large current balance can affect cash more than several small overdue invoices. Give disputes an owner, reconcile unapplied receipts before sending reminders, and agree how sales should handle customers that exceed their approved credit terms. Document exceptions instead of letting them become invisible extensions of credit.

Frequently asked questions

What is a good days sales outstanding?

Compare a consistently calculated DSO with payment terms, customer mix, seasonality, and actual overdue balances. A change can come from sales timing as well as collections. Avoid treating one universal day count as evidence that the receivables are healthy.

When should I write off an invoice?

Apply the approved accounting policy to documented evidence of collectibility. Review the existing loss allowance so the entry does not double count expense. Tax treatment requires a separate assessment; crossing 90 days does not by itself establish either a book write-off or a tax deduction.

Should I charge late fees?

Check the agreed contract and applicable requirements before charging one. A fee printed only on a later invoice may not settle what was agreed. Keep the calculation, approval, customer communication, and any waiver with the account records.

Sources

Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.

Related reading

Need help with this work?

General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.