--- type: Template title: Accounts Receivable Report Template (Free Excel) description: A free, reusable accounts receivable report template for Excel: AR summary, aging, key metrics and top overdue customers. Download and fill in each month. resource: https://accounting.events/resources/accounts-receivable-report-template/ tags: [accounts receivable report template, ar report template excel, accounts receivable report, monthly ar report template] timestamp: 2026-09-28 author: Harry P. Smart fact_checked_by: Julie Turnbridge fact_checked: 2026-10-26 --- AR Report Template # Accounts receivable report template A free, reusable monthly accounts receivable report: AR summary, aging, key metrics and top overdue customers, ready to fill in. By Harry P. Smart, CPA and Lead Reviewer. Fact-checked by Julie Turnbridge on October 26, 2026. Published June 9, 2026. Updated September 28, 2026. 6 min read. Quick answer **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.** The closing balance and aging percentages calculate automatically, and it works in Excel or Google Sheets. If your invoices are in Xero or QuickBooks Online, Paidnice sends automated reminders and statements on the overdue balances this report shows. ## Key facts about the AR report - Closing AR equals opening AR plus invoices, minus cash collected and credit notes (52,000 + 41,000 - 33,740 = 59,260 below). - Receivables arise under the accrual method, which counts income when earned ([IRS Publication 538](https://www.irs.gov/publications/p538)). - Keep reports 3 years, or 7 years for a bad debt deduction ([IRS](https://www.irs.gov/businesses/small-businesses-self-employed/how-long-should-i-keep-records)). Preview Xaccounts-receivable-report-template.xlsxAccounts Receivable ReportAR summaryOpening AR balance52,000Add: invoices raised41,000Less: cash collected33,740Closing AR balance59,260Aging summaryCurrent1-3031-6061-9090+31,20053% of AR8,40014% of AR3,5006% of AR3,2005% of AR12,96022% of ARA reusable monthly report: AR summary, aging with percentages and key metrics. Free AR report template Excel (.xlsx) with a reusable monthly AR summary, aging and metrics. No sign-up. [Download Excel](https://accounting.events/resources/accounts-receivable-report-template/accounts-receivable-report-template.xlsx) ## 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 | ## Filled-in example | Aging bucket | Amount | % of AR | | --- | --- | --- | | Current | 31,200 | 53% | | 1-30 days | 8,400 | 14% | | 31-60 days | 3,500 | 6% | | 61-90 days | 3,200 | 5% | | 90+ days | 12,960 | 22% | | **Total AR** | **59,260** | **100%** | DSO for a 30-day month is 59,260 ÷ (41,000 ÷ 30) = 43.4 days. ## What should an accounts receivable report include? An AR summary, an aging breakdown, key metrics such as DSO and AR turnover, and 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 format you reuse each month; an example is a populated report. ## 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](https://accounting.events/resources/accounts-receivable-turnover-ratio-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. ## What mistakes should you avoid with this template? - **Reading only the total.** AR rose 7,260, but 12,960 (22%) is over 90 days old. Fix: read the aging first. - **Skipping credit notes.** A missed 1,500 credit note leaves closing AR at 59,260, not 57,760. Fix: enter credit notes first. - **Changing the day count.** Using 31 days instead of 30 turns a DSO of 43.4 into 44.8. Fix: use the real days. ## Should the AR report match the general ledger? Yes. Closing AR should equal the AR control account in your ledger. Use our [reconciliation template](https://accounting.events/resources/accounts-receivable-reconciliation-template/) to find any gap. ## Do credit notes reduce accounts receivable? Yes. A credit note lowers what the customer owes, so deduct it from closing AR. ## Who belongs on the top overdue list? The largest overdue balances, usually the top five or ten, with amount and next step. Bottom line: this template suits a business with a few dozen open invoices. Move to software when you have hundreds or need the report weekly. ## Related reading Independent software reviews and guides from Accounting.Events. [Resource ### AR report example A fully populated, annotated AR aging report. Read more →](https://accounting.events/resources/accounts-receivable-report-example/)[Template ### AR aging report template Group unpaid invoices into aging buckets automatically. Read more →](https://accounting.events/resources/accounts-receivable-aging-report-template/)[Template ### AR KPI dashboard template DSO, turnover, aging and overdue in one Excel dashboard. Read more →](https://accounting.events/resources/accounts-receivable-dashboard-template/) **About the author: Harry P. Smart, CPA and Lead Reviewer.** Harry P. Smart is a CPA based between London and New York City. Harry writes and leads the review of the software guides on Accounting.Events. **Fact-checked by Julie Turnbridge, Freelance writer and bookkeeper**, on October 26, 2026. Checked prices, review counts, awards, integrations and dates against each primary source. Last updated September 28, 2026. This guide is general information, not accounting, tax, or financial advice. ## Sources Sources checked by Julie Turnbridge on October 26, 2026: 1. [IRS Publication 538](https://www.irs.gov/publications/p538) (irs.gov/publications/p538) 2. [IRS](https://www.irs.gov/businesses/small-businesses-self-employed/how-long-should-i-keep-records) (irs.gov/businesses/small-businesses-self-employed/how-lon...)