--- 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 --- 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 [**Accounting.Events editorial team**](/about/)Updated **September 28, 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](/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](/resources/accounts-receivable-excel-template/) that dates expected receipts. **Video:** [AR Dashboard Template: The 5 KPIs to Track (Free Excel)](https://www.youtube.com/watch?v=yTz0cOCzCpg) ## 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](/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. Essential metrics to include: - **Total receivables:** everything customers owe you. - **% overdue:** the share of AR past its due date. - **90+ days AR:** the cash at real risk. - **Days sales outstanding (DSO):** average days to get paid. - **AR turnover:** how many times a year you collect your average balance. - **Aging chart:** AR split into Current, 1-30, 31-60, 61-90 and 90+ days. ## 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. ## 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. ## 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. ## 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](/resources/accounts-receivable-turnover-ratio-calculator/) to check the math. ## 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 →](/resources/accounts-receivable-turnover-ratio-calculator/)[Template ### AR aging report template Group unpaid invoices into aging buckets automatically. Read more →](/resources/accounts-receivable-aging-report-template/)[All resources ### Resources, templates and calculators Every free AR guide, template and calculator we publish. Read more →](/resources/) AE [Accounting.Events editorial team](/about/) The Accounting.Events editorial team researches and maintains the software comparisons on this site. Comparisons are built from published vendor pricing, verified third-party reviews on the Xero App Store, G2 and Capterra, and primary-source statistics. Every guide carries the date it was last checked. Figures here are drawn from public sources; always confirm with your accountant or the linked source before acting. Last updated September 28, 2026. This guide is general information, not accounting, tax, or financial advice.