--- type: Template title: Accounts Receivable Dashboard Template (Free Excel) description: A free accounts receivable KPI dashboard template for Excel. Tracks DSO, AR turnover, percent overdue and aging, with an automatic chart. Works in Sheets. resource: https://accounting.events/resources/accounts-receivable-dashboard-template/ tags: [accounts receivable dashboard template, accounts receivable kpi dashboard excel, ar dashboard excel template, accounts receivable kpi template] timestamp: 2026-10-19 author: Harry P. Smart fact_checked_by: Julie Turnbridge fact_checked: 2026-10-26 --- AR Dashboard Template # Accounts receivable dashboard template A free Excel KPI dashboard for accounts receivable. Enter your invoices and DSO, AR turnover, percent overdue and an aging chart calculate themselves. By Harry P. Smart, CPA and Lead Reviewer. Fact-checked by Julie Turnbridge on October 26, 2026. Published June 9, 2026. Updated October 19, 2026. 6 min read. Quick answer **An accounts receivable dashboard template is an Excel workbook that turns your open invoices into the key AR metrics: total receivables, percent overdue, days sales outstanding (DSO), AR turnover, and an aging breakdown, with a chart.** You enter invoices on a data tab and the dashboard updates automatically. The free template below calculates 5 KPIs, total AR, percent overdue, 90+ days AR, DSO and AR turnover, and draws an aging bar chart, all from your data. Add your annual net credit sales in one cell to unlock DSO and turnover. It works in Excel and Google Sheets and uses only SUM, SUMIF, IF and TODAY. Preview Xaccounts-receivable-dashboard-template.xlsxAccounts Receivable DashboardTOTAL AR$63,260% OVERDUE38%DSO41 daysAR TURNOVER8.2xAR by aging bucket39kCurrent5k1-303k31-603k61-9013k90+ Free AR KPI dashboard Excel (.xlsx) with automatic KPIs (DSO, turnover, percent overdue) and an aging chart. No sign-up. [Download Excel](https://accounting.events/resources/accounts-receivable-dashboard-template/accounts-receivable-dashboard-template.xlsx) A good AR dashboard answers one question fast: is our cash collection healthy or slipping? These 5 KPIs plus an aging chart give you that picture at a glance. For the weeks ahead, pair it with an [accounts receivable forecast template](https://accounting.events/resources/accounts-receivable-excel-template/) that dates expected receipts. Key facts - The template ages each open invoice from its due date into Current, 1-30, 31-60, 61-90 and 90+ days. - 47% of surveyed small businesses reported some invoices overdue by more than 30 days ([Intuit QuickBooks 2025 Late Payments Report](https://quickbooks.intuit.com/r/small-business-data/small-business-late-payments-report-2025/)). **Video:** [AR Dashboard Template: The 5 KPIs to Track (Free Excel)](https://www.youtube.com/watch?v=yTz0cOCzCpg) ### Video chapters and transcript - 0:00 Short answer - 0:22 Five KPIs and a healthy guide for each - 0:39 DSO = AR / (annual credit sales / 365) - 0:57 Works in Excel and Google Sheets What should an accounts receivable dashboard show? An accounts receivable dashboard turns your open invoices into the key AR metrics: total receivables, percent overdue, days sales outstanding, AR turnover, and an aging breakdown with a chart. You enter invoices on a data tab, and the dashboard updates automatically. The free template on accounting.events shows five KPIs. Keep ninety-plus days AR under ten percent of the total. Aim for days sales outstanding under forty-five days, and an AR turnover of five to ten times a year. Days sales outstanding is total receivables divided by average daily credit sales. Enter your annual net credit sales once, and DSO and turnover calculate for you. The dashboard also charts AR by aging bucket, so you see what is current and what is at risk. It also opens in Google Sheets. The formulas carry over, and in some versions of Sheets you may need to insert the chart again. ## The KPIs in the dashboard | KPI | What it tells you | Healthy guide | | --- | --- | --- | | **Total accounts receivable** | Total cash owed to you | Track the trend | | **% overdue** | Share of AR past due | Lower is better | | **90+ days AR** | Cash at real risk | Under 10% of AR | | **Days sales outstanding (DSO)** | Average days to get paid | Under 45 days | | **AR turnover** | Times a year you collect | 5 to 10x | The dashboard also charts your AR by aging bucket (Current, 1-30, 31-60, 61-90, 90+) so you can see how much is current versus at risk. Benchmarks from our [AR turnover ratio](https://accounting.events/resources/accounts-receivable-turnover-ratio/) guide. ## What KPIs should an accounts receivable dashboard show? The essentials are 5 KPIs, total AR, percent overdue, 90+ days AR, days sales outstanding (DSO) and AR turnover, plus an aging breakdown. Together they show how much you are owed, how much is at risk, and how fast you collect. ## How do I build an AR dashboard in Excel? Keep your invoices on one tab with an aging-bucket formula, then use SUMIF on a dashboard tab to total each bucket and calculate DSO and turnover. Add a bar chart of the aging buckets. The template above does all of this; you just enter invoices and your annual credit sales. ## Does the dashboard work in Google Sheets? The dashboard works in Google Sheets: import the Excel file, and the SUMIF, IF and TODAY formulas and the chart all carry over. You may need to re-insert the chart in some Sheets versions. ## Example: five open invoices Take today as July 1, 2026 and annual net credit sales as $360,000 in cell B4. | Customer | Due date | Outstanding | Days overdue | Bucket | | --- | --- | --- | --- | --- | | **Northwind** | Jul 15 | $20,000 | not due | Current | | **Sunrise** | Jun 21 | $12,000 | 10 | 1-30 | | **Blue Mountain** | May 20 | $1,960 | 42 | 31-60 | | **Harbor** | Apr 15 | $2,200 | 77 | 61-90 | | **Vertex** | Feb 20 | $6,500 | 131 | 90+ | | Total AR | | $42,660 | | | Dashboard result **% overdue = $22,660 ÷ $42,660 = 53.1%. 90+ days AR = $6,500, or 15.2%.** DSO = $42,660 ÷ ($360,000 ÷ 365) = 43.3 days. AR turnover = $360,000 ÷ $42,660 = 8.4x. ## What is a good DSO and aging profile? A healthy DSO is generally under 45 days, and under 30 for many small businesses. On aging, aim for about 80% or more of AR current and under 10% in the 90+ days bucket. Intuit QuickBooks' 2025 Late Payments Report found 47% of US small businesses have invoices more than 30 days overdue. ## How is DSO calculated in the template? DSO in the template equals total accounts receivable divided by average daily credit sales (annual net credit sales divided by 365). Enter your annual net credit sales in the dashboard cell and DSO and AR turnover calculate automatically. See the [turnover calculator](https://accounting.events/resources/accounts-receivable-turnover-ratio-calculator/) to check the math. ## What mistakes should you avoid with this template? - **Leaving the sample sales figure in B4.** The template ships with $600,000. Against the $42,660 of AR, DSO reads 26.0 days instead of 43.3. Replace it with your own annual net credit sales. - **Entering total sales instead of credit sales.** If the $360,000 includes $90,000 of cash sales, true credit sales are $270,000 and DSO is 57.7 days, not 43.3. Use credit sales only. - **Aging from the invoice date.** Harbor's Net 30 invoice is dated Mar 16, so it reads 107 days and 90+ AR jumps from $6,500 to $8,700 (20.4%). Enter the due date. ## More questions about this template ### How often should you update an AR dashboard? Enter invoices and payments as they happen and review weekly. The buckets recalculate daily because the template uses TODAY(). ### Where do you get the invoice data for the dashboard? Export your unpaid invoices or aged receivables report from your accounting software, then paste customer, invoice number, due date, amount and amount paid into the Data tab. [Xero Central](https://central.xero.com/s/article/Aged-receivables-summary-report) explains the aged receivables report. ### How many invoices can the dashboard hold? The Data tab formulas cover rows 4 to 24, which is 21 invoices. To add more, copy the last row down and extend the ranges in the Dashboard formulas. **Bottom line:** This dashboard suits up to about 20 open invoices and one person updating it. Move to accounts receivable software when invoices outgrow the 21-row Data tab or you need reminders sent. ## Related reading Independent software reviews and guides from Accounting.Events. [Calculator ### AR turnover ratio calculator Score your turnover and DSO against your industry. Read more →](https://accounting.events/resources/accounts-receivable-turnover-ratio-calculator/)[Template ### AR aging report template Group unpaid invoices into aging buckets automatically. Read more →](https://accounting.events/resources/accounts-receivable-aging-report-template/)[All resources ### Resources, templates and calculators Every free AR guide, template and calculator we publish. Read more →](https://accounting.events/resources/) **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 October 19, 2026. This guide is general information, not accounting, tax, or financial advice. ## Sources Sources checked by Julie Turnbridge on October 26, 2026: 1. [Intuit QuickBooks 2025 Late Payments Report](https://quickbooks.intuit.com/r/small-business-data/small-business-late-payments-report-2025/) (quickbooks.intuit.com/r/small-business-data/small-busines...) 2. [Xero Central](https://central.xero.com/s/article/Aged-receivables-summary-report) (central.xero.com/s/article/Aged-receivables-summary-report)