Accounts Receivable Aging Report for Small Business: Template and Collections Workflow

Overview

An accounts receivable aging report groups unpaid invoices by how long they have been outstanding. The report gives an owner or finance manager a practical view of expected cash, overdue exposure, and the customers who require action.

A useful report should show more than a total balance. It should identify the customer, invoice, due date, amount, payment status, dispute status, assigned collector, and next action. This makes the report a working collections tool rather than a static accounting export.

Use the following aging buckets as a repeatable starting structure:

Most accounting and invoicing platforms can produce an aging report, although the menu names and settings vary. If you use a spreadsheet, export open invoices regularly and confirm that credits, partial payments, disputed amounts, and unapplied cash are handled correctly before contacting customers.

What to track

Build the report from reliable invoice data

For each open invoice, record the original amount, payments received, credits issued, remaining balance, invoice date, agreed payment terms, due date, and currency where relevant. The due date should come from the approved quote, contract, purchase order, or invoice terms—not from an assumption made after the invoice becomes overdue.

A basic formula for days outstanding is:

Days outstanding = Report date − Invoice due date

For an invoice that is not yet due, show it as current rather than assigning a negative aging value. In a spreadsheet, a simple bucket rule can be written as:

• Current: Days outstanding is less than or equal to zero.
• 1–30: Days outstanding is 1 through 30.
• 31–60: Days outstanding is 31 through 60.
• 61–90: Days outstanding is 61 through 90.
• 90+: Days outstanding is greater than 90.

Use one report date for every invoice in the review. Otherwise, the buckets may mix different points in time and make trends difficult to interpret.

Track collection performance

Alongside balances, monitor a small set of operational measures:

• Total accounts receivable: The sum of all unpaid invoice balances.
• Overdue receivables: The sum of balances in the 1–30, 31–60, 61–90, and 90-plus buckets.
• Overdue percentage: Overdue receivables divided by total accounts receivable, multiplied by 100.
• Collection rate: Amount collected during the period divided by the amount that was due or targeted for collection, multiplied by 100. Define the denominator consistently so week-to-week comparisons are meaningful.
• Disputed balance: The portion of receivables held up by a documented billing, delivery, quality, or contract issue.
• Promise-to-pay completion: Payments received by the promised date divided by total promises made.

Do not treat every overdue invoice as a collection failure. A valid dispute may require a credit, corrected invoice, or internal investigation. The report should separate administrative problems from customers who have received a correct invoice and have simply not paid.

Prioritize customers deliberately

Start with accounts that combine high financial exposure and a strong likelihood of recovery. A practical priority order is:

1. Large balances that are more than 30 days overdue.
2. Invoices approaching or exceeding 90 days overdue.
3. Customers with several overdue invoices, even if each balance is modest.
4. Accounts with a broken payment promise or no response to earlier contact.
5. Disputed invoices that can be resolved quickly by correcting documentation.
6. Current customers whose payment pattern has recently changed.

Add an owner and next-action date to every priority account. An unassigned balance is unlikely to receive consistent follow-up.

Cadence and checkpoints

Use a weekly collections review

A weekly review is frequent enough for most small businesses to catch problems before they become severe, while remaining manageable for a lean finance team. Set a fixed day and use the same sequence each time:

1. Reconcile the report: Match recent bank receipts and payment-processor deposits to invoices. Remove paid items, apply credits, and investigate unapplied cash.
2. Refresh aging buckets: Recalculate days outstanding using the current report date.
3. Review new overdue items: Identify invoices that moved from current to 1–30 days and confirm that reminders were sent.
4. Assign actions: Give each priority account a named owner, contact method, and deadline.
5. Resolve disputes: Record the issue, responsible internal person, customer contact, and expected resolution date.
6. Update the cash forecast: Move expected receipts into the appropriate week and mark uncertain payments separately.
7. Escalate exceptions: Discuss material balances, repeated broken promises, and accounts nearing 90 days with the owner or manager.

Connect the aging report to a broader 13-week cash flow forecast. A receivable should not be treated as available cash until the timing and likelihood of payment are reasonably clear.

Follow a consistent contact sequence

Collections work best when messages are factual, timely, and consistent with the customer relationship. Before contacting a customer, verify the invoice number, balance, due date, payment instructions, and any open dispute.

• Initial reminder: Send a short email when the invoice is due or shortly afterward. Attach or link to the invoice and ask whether the customer needs anything to process payment.
• First overdue follow-up: For a 1–30-day balance, state the amount due, the original due date, and a specific request for the expected payment date.
• Phone follow-up: For larger or repeatedly overdue balances, call the accounts-payable contact. Confirm the invoice was received, ask whether there is a dispute, and document the agreed next step.
• Manager escalation: For 31–60-day balances, involve the account owner or manager when a commercial relationship may help resolve the issue.
• Formal escalation: For 61–90 and 90-plus-day balances, review the contract, credit terms, service status, and approved escalation options before suspending work or referring the matter for professional advice.

A useful reminder is direct without being accusatory: “Our records show invoice [number] for [amount] was due on [date]. Please confirm the expected payment date, or let us know if there is an issue with the invoice.”

How to interpret changes

Read the report as a trend, not just a list of late invoices. A rising 1–30-day balance may indicate slower customer processing, weak reminder timing, or a recent change in payment terms. Growth in the 61–90 or 90-plus buckets is more concerning because balances are aging without resolution.

Compare the current report with prior weekly or monthly versions. Look for:

• A higher overdue percentage despite stable sales.
• One customer representing an unusually large share of total receivables.
• Repeated disputes linked to the same product, delivery process, or invoice format.
• Payments arriving only after multiple reminders.
• Customers changing from predictable payment behavior to unexplained delays.
• Strong collections in one period caused by a single large receipt rather than a lasting improvement.

Separate operational causes from customer credit risk. If invoices are sent late, contain incorrect purchase-order details, or lack required documentation, improve the billing process. If invoices are accurate and customers still delay payment, review credit limits, deposits, milestone billing, payment methods, and contract terms.

For cross-border sales, also check currency, bank-transfer instructions, tax documentation, and local payment practices. Keep the commercial terms and any late-payment language consistent with the applicable contract and local requirements. Rules on interest, fees, collection notices, tax treatment, and debt recovery can vary by jurisdiction, so obtain qualified local advice before applying charges or escalating formally.

When to revisit

Revisit the accounts receivable aging report every week, even if the business has few overdue invoices. Perform a deeper monthly review to compare aging totals, collection rates, customer concentration, dispute causes, and cash-flow assumptions. A quarterly review is useful for reassessing payment terms, credit limits, deposits, invoice timing, and software workflows.

Update the report process whenever the business changes its accounting or invoicing system, adds a payment channel, enters a new country, changes standard terms, or begins selling to larger customers. Recheck templates and escalation procedures when contracts, tax rules, late-payment regulations, or internal approval requirements change. Software instructions may also change, so confirm that exports include credits, partial payments, unapplied receipts, and the correct due-date logic.

To put the workflow into practice, create one aging report today, reconcile it to the ledger and bank activity, and mark every open invoice with a bucket, owner, and next action. Contact the highest-priority accounts first, record promised payment dates, and carry unresolved items into the next weekly review. Over time, the report will show whether collections are improving—and where changes to billing, customer terms, or cash-flow planning are needed.

For related planning, see the small business recession planning checklist and the guide to invoicing software for freelancers and small businesses.