Accounts Receivable Aging Report Template
Free accounts receivable aging report template: download the Excel workbook with invoices auto-bucketed into 0 to 30, 31 to 60, 61 to 90 and 90 plus days past due from your as-of date.
What this worksheet does
This is a blank aging report, not a calculator. One row is one open invoice: you fill in the customer name, invoice number, invoice date, due date, amount, and amount paid. Four columns are computed: the balance due (amount minus paid), the aging bucket (0 to 30, 31 to 60, 61 to 90, or 90 plus days past due, measured from the due date to the as-of date at the top of the sheet), the days past due count, and the days outstanding (as-of date minus invoice date, the days-to-pay figure). The eleventh column is a dropdown of next-action values that name the escalation stages in the past-due invoice letter template.
No money is pre-filled. The sample tab carries three fictional rows so you can see the layout; every amount is illustrative. No rate, no fee, no interest calculation: the aging report tells you how late each invoice is and suggests what to do next, and that is all.
Organizational worksheet only. This template is a planning aid, not accounting or legal advice. Confirm balances against your own records before acting on them.
One sheet to see who owes you and how late
An accounts receivable aging report puts every open invoice on one page, sorted by how far past due the balance is. This template does the bucketing for you: enter the customer name, invoice number, invoice date, due date, amount, what has been paid and the balance, and the sheet drops each row into one of four columns (0 to 30, 31 to 60, 61 to 90 and 90 plus days past due) based on an as-of date you set. A days-to-pay figure shows how long each invoice has been outstanding, and a next-action column names the past-due letter stage that fits: friendly reminder, second notice, final notice, or refer to collections.
Download the Excel workbook and fill it offline, or print it to fill by hand. The sample tab shows three clearly fictional example rows so you can see the intended layout before you start. No signup, no account, nothing uploaded.
What each column does
The sheet has eleven columns per row. The first six are yours to fill: Customer name, Invoice #, Invoice date, Due date, Invoice amount and Amount paid. The next four are computed: Balance due (amount minus paid), Aging bucket (which of the four past-due windows the balance falls into, measured from the due date to the as-of date at the top of the sheet), Days past due (how many days past the due date, floored at zero) and Days outstanding (how many days since the invoice date, which is the days-to-pay figure). The eleventh column, Next action, is a dropdown whose values track the escalation stages in the past-due invoice letter template: no action needed, friendly reminder, second notice, final notice, or refer to collections.
No pre-filled money appears anywhere. The sample rows are labelled as examples and carry round illustrative figures only.
How the aging buckets work
The four buckets are a standard receivables breakdown:
- Current (0 to 30 days): the invoice is not yet due, or fewer than 31 days past due.
- 31 to 60 days: a month late. Time for the friendly reminder.
- 61 to 90 days: two months late. The second notice, with any late fee your terms provide for.
- 90 plus days: three months or more. The final notice, and then the decision to refer or write off.
Those windows are the most common AR aging brackets. They also map directly to the three letter stages in the past-due invoice letter template, which is the point: the aging report tells you which customers need a letter, and the letter template gives you the letter.
Where this fits in a collection workflow
An aging report is the dashboard. It answers “who owes me money and how long have they owed it?” in one glance. The tools around it handle the next steps:
- The past-due invoice letter template builds the reminder, second notice or final notice for an overdue balance.
- The invoice late fee calculator prices the fee your terms allow, so you know what number goes into the second-notice letter.
- The how to get paid faster guide covers the upstream habits (invoice at completion, deposits, card-on-file, net-30 terms) that keep the aging report short in the first place.
What it is, and what it is not
This is an organizational worksheet only. It is a planning aid, not accounting or legal advice. Confirm balances against your own records before acting on any figure here.