An accounts receivable report template is a reusable format for your monthly AR report: a summary of how the balance moved, an aging breakdown, your key metrics, and the customers to chase. Unlike a one-off example, a template is blank and ready to fill in each period.
This free template gives you four sections: an AR summary (opening, invoiced, collected, closing), an aging summary with automatic percentages, key metrics (DSO, AR turnover, percent over 90 days), and a top-overdue-customers list with next steps. It works in Excel or Google Sheets. If you would rather see a fully worked version first, view our accounts receivable report example.
A consistent monthly AR report keeps everyone aligned on how much is owed, how it is aging, and who needs chasing, in one page.
What is in the report template
| Section | What it covers |
|---|---|
| 1. AR summary | Opening, invoiced, collected, credit notes, closing balance (auto) |
| 2. Aging summary | Current to 90+ days with automatic percentages and total |
| 3. Key metrics | DSO, AR turnover, percent over 90 days, write-offs |
| 4. Top overdue customers | Who to chase, how much, how overdue, next step |
What should an accounts receivable report include?
An AR summary showing how the balance moved (opening, invoices, collections, credit notes, closing), an aging breakdown, key metrics such as DSO and AR turnover, and a list of the largest overdue accounts with actions. The template includes all four.What is the difference between an AR report template and example?
A template is a blank, reusable format you fill in each month; an example is a populated version showing what a finished report looks like. Use the template to produce your report and the example to see how to read one.How often should I produce an AR report?
Monthly is standard, aligned to your period-end close, with a weekly aging view for active collections.How do I calculate the metrics in the report?
DSO is AR divided by average daily credit sales; AR turnover is net credit sales divided by average AR; percent over 90 days is the 90+ bucket divided by total AR. Our calculator works these out for you.Does it work in Google Sheets?
Yes. Import the Excel file into Google Sheets; the summary and aging formulas carry over.Last updated June 9, 2026. This guide is general information, not accounting, tax, or financial advice.