By Paras Saini & Shubham Sharma ·
Invoice Dashboard: What to Track, What to Review & How to Build One
You have 47 unpaid invoices totalling $83,000. How much of that is overdue? How much is at risk of becoming bad debt? Which clients need a follow-up today? If answering those questions requires opening a spreadsheet and scrolling through rows, you do not have a dashboard — you have a data entry log. An invoice dashboard gives you the answers in one screen, in under 10 seconds, every morning. This guide covers what it should show, the metrics that actually matter, and how to set one up whether you use a spreadsheet or dedicated software.
Key takeaways
- An invoice dashboard condenses your entire AR picture into five numbers: total outstanding, aging buckets, DSO, overdue percentage, and collection rate.
- Spreadsheet dashboards work below 20 invoices per month but break down at scale due to manual updates, formula fragility, and no automation.
- Review your dashboard daily (who to chase), weekly (are aging buckets growing?), and monthly (collection rate trend and client-level patterns).
- The most common dashboard mistake is tracking too many metrics — five core numbers plus an action list is enough for any small business.
- A dashboard without an action view is just a report. The best dashboards tell you what to do today, not just what happened last month.
What an Invoice Dashboard Shows You
An invoice dashboard is a single-screen summary of your accounts receivable health. It replaces the need to scroll through an invoice list, manually count overdue items, or run ad-hoc calculations every time you want to know where your cash stands.
A well-built dashboard answers three questions at a glance: (1) How much money is outstanding and how much is overdue? (2) Is the situation getting better or worse compared to last week and last month? (3) What specific invoices need action today?
The first two are summary metrics. The third is an action list. Most dashboard failures happen because businesses build the summary view but skip the action view. Knowing your total outstanding is $83,000 is useful context. Knowing that $12,000 of that is 45+ days overdue and three specific clients need a follow-up this morning is what actually gets invoices paid.
If you are currently tracking invoices in a spreadsheet, this is likely the gap. Your spreadsheet stores data but does not surface what to do next. See why spreadsheet tracking breaks down for the full breakdown of where this approach fails.
Five Essential Dashboard Metrics
You do not need 20 charts. You need five numbers, updated in real time or at least weekly, that tell you the full AR story.
1. Total Outstanding
The sum of all unpaid invoices. This is your headline number — the total amount of money owed to you right now. Track it weekly. If it is climbing while revenue is flat, invoices are going out but payments are not coming back.
2. Aging Buckets (0–30, 31–60, 61–90, 90+ Days)
Outstanding amounts grouped by how long they have been overdue. This is the most actionable metric on the dashboard because it tells you where to focus. A $50,000 total outstanding sounds alarming until you see that $45,000 is in the 0–30 day bucket (normal) and only $5,000 is 60+ days (needs action). Use the accounts receivable aging report tool to generate this breakdown instantly. For a deeper understanding of what each bucket means, read the aging report walkthrough.
3. Days Sales Outstanding (DSO)
The average number of days it takes to collect payment after invoicing. DSO = (AR Balance / Revenue over period) x Days in period. A DSO of 38 on Net 30 terms means clients pay 8 days late on average. Track this monthly and watch the trend — a rising DSO over three consecutive months signals a structural collections problem. Calculate yours with the DSO calculator and read the full DSO guide for benchmarks by industry.
4. Overdue Percentage
The share of total outstanding that is past its due date. Formula: (Overdue amount / Total outstanding) x 100. An overdue percentage under 20% is healthy for most businesses. Above 40%, you are carrying significant collection risk. This metric is more immediately useful than total outstanding alone because it accounts for invoices that are not yet due.
5. Collection Rate
The percentage of invoiced revenue that you actually collect. Formula: (Payments received / Total invoiced) x 100 over a given period. A collection rate below 95% means you are writing off more than 5% of revenue — a problem that compounds. Track this monthly and quarterly. If it is declining while revenue is steady, invoices are aging into bad debt. The cash flow forecasting tool helps you model the dollar impact.
These five metrics cover the full picture: how much is owed (total outstanding), how old it is (aging), how fast you collect (DSO), how much is at risk (overdue %), and how much you actually keep (collection rate). Anything beyond these five is secondary.
Spreadsheet Dashboards vs. Software Dashboards
A Google Sheets or Excel dashboard is where most small businesses start. You list invoices in rows, add formulas for aging and totals, and maybe build a pivot chart. This works when you have a low invoice volume and one person managing AR.
When a Spreadsheet Works
- Fewer than 20 invoices per month
- One person responsible for invoicing and follow-up
- Simple payment terms (one term for all clients)
- You are disciplined about updating the sheet after every payment
When a Spreadsheet Breaks Down
- Data goes stale — you mark an invoice paid on Tuesday but the dashboard formula still counts it outstanding until someone edits the right cell
- No automated reminders — the dashboard shows what is overdue but you still have to open email and write the follow-up manually
- Formula fragility — adding rows, deleting columns, or pasting data in the wrong place breaks aging calculations silently
- No chase history — you cannot see when you last followed up on an invoice or what you said, leading to duplicate or missed follow-ups
A dedicated invoice tracking tool like InvoiceGrid solves these problems: metrics update automatically when invoice statuses change, follow-up history is logged per invoice, and you get a “who to chase today” action list without building it yourself. For a broader comparison of options, see the invoice tracking software comparison.
How to Set Up Your First Invoice Dashboard
Whether you use a spreadsheet or software, the setup process follows the same steps.
Step 1: Centralize Your Invoice Data
Every invoice needs to live in one place with consistent fields: client name, invoice number, amount, date issued, due date, status (unpaid/paid/overdue), and date paid (when applicable). If your invoices are scattered across emails, PDFs, and accounting software, consolidate them. The dashboard is only as useful as the data behind it.
Step 2: Define Your Aging Buckets
Standard buckets are 0–30, 31–60, 61–90, and 90+ days past due. In a spreadsheet, add a “Days Overdue” column (=MAX(0, TODAY()-DueDate)) and a bucket column with a nested IF formula. In software, this is typically built in. Age by due date, not invoice date — aging from the invoice date includes your normal payment window and inflates the numbers.
Step 3: Build Summary Metrics
Add the five metrics from the section above: total outstanding (SUMIF on unpaid status), aging bucket totals (SUMIFS on bucket column), DSO (formula or use the DSO calculator), overdue percentage (overdue total / outstanding total), and collection rate (payments received / total invoiced over the period).
Step 4: Add an Action List
Filter for invoices that are overdue or due within the next 3 days. Sort by days overdue descending, then by amount descending. This is your daily chase list. In a spreadsheet, create a filtered view. In InvoiceGrid, the Today View generates this automatically.
Step 5: Set a Review Schedule
A dashboard you do not check is useless. Set a recurring calendar event: 2 minutes every morning for the action list, 10 minutes every Monday for the weekly trend review, 30 minutes on the first of each month for the full strategic review.
What to Review Daily, Weekly & Monthly
A dashboard with no review cadence is a report that collects dust. Here is what to look at and when.
| Frequency | What to Check | Time Required |
|---|---|---|
| Daily | Which invoices are due today or went overdue yesterday. Send reminders or first follow-ups. Check for incoming payments. | 2 minutes |
| Weekly (Monday) | Aging bucket totals vs. last week. Is the 31-60 or 61-90 bucket growing? DSO trend. Any invoices about to cross into the next aging bucket. | 10 minutes |
| Monthly (1st of month) | Collection rate for the past 30 and 90 days. Client-level breakdown: which clients are consistently late? DSO vs. payment terms gap. Total outstanding trend. Whether current payment terms are working. | 30 minutes |
The daily check is the one that drives results. Weekly and monthly reviews inform strategy, but it is the daily two-minute scan that catches overdue invoices before they age into expensive problems. If you are only checking your AR once a month, an invoice can go from “5 days overdue” to “35 days overdue” without a single follow-up sent.
Six Common Invoice Dashboard Mistakes
Building a dashboard is the easy part. Keeping it useful is where most businesses fail.
1. Tracking Too Many Metrics
A dashboard with 15 charts and 30 numbers is a report, not a dashboard. You stop looking at it because it takes too long to parse. Five core metrics plus an action list is enough for any business with fewer than 500 invoices per month.
2. Not Updating the Data
A spreadsheet dashboard that was last updated three days ago is worse than no dashboard — it gives you false confidence. If you use a spreadsheet, update it the same day you receive a payment or issue an invoice. This is the single biggest argument for software: updates happen automatically when you change an invoice status.
3. No Action View
A dashboard that shows totals and trends but does not tell you which invoices to follow up on today is a monitoring tool, not a management tool. Every dashboard should answer: “What do I need to do right now?”
4. Aging by Invoice Date Instead of Due Date
If you age from the invoice date, a Net 30 invoice is already “30 days old” before it is even overdue. This inflates your aging numbers and makes everything look worse than it is. Always age from the due date to measure actual delinquency.
5. Ignoring Client-Level Patterns
Your dashboard might show a healthy overall DSO of 32 days while one client consistently pays at 60+ days. Aggregate metrics hide problem clients. Review client-level data at least monthly to catch repeat offenders before they become bad debt risks.
6. Building the Dashboard but Not the Follow-Up Process
A dashboard tells you what is overdue. A follow-up process determines what happens next. Without a defined escalation sequence — friendly reminder at 3 days overdue, firm follow-up at 14, formal notice at 30 — the dashboard just shows you problems without solving them. The dashboard and the chase process are two halves of the same system.
Ready to Track Your Invoices Visually?
Stop losing track of who owes you money. InvoiceGrid gives you a visual Kanban board, chase history, and professional email reminders.
Frequently Asked Questions
What is an invoice dashboard?+
An invoice dashboard is a single-screen view of your outstanding invoices, overdue amounts, and collection metrics. Instead of scrolling through a list of invoices to figure out where you stand, a dashboard summarizes your accounts receivable health with numbers like total outstanding, overdue percentage, Days Sales Outstanding, and aging bucket breakdowns. It answers the question 'how is my cash collection doing right now?' in under 10 seconds.
What metrics should an invoice dashboard show?+
The five core metrics are: (1) Total outstanding — all unpaid invoices combined; (2) Aging buckets — outstanding amounts grouped by 0-30, 31-60, 61-90, and 90+ days overdue; (3) Days Sales Outstanding (DSO) — your average collection time; (4) Overdue percentage — what share of outstanding invoices are past their due date; (5) Collection rate — the percentage of invoiced revenue you actually collect. These five give you a complete picture of AR health without information overload.
Can I build an invoice dashboard in Google Sheets or Excel?+
Yes, but with significant limitations. You can build a basic dashboard using pivot tables, conditional formatting, and formulas like SUMIFS to bucket invoices by age. The problem is maintenance: every time you issue, update, or receive payment on an invoice you need to manually update the spreadsheet. Formulas break when rows are added or deleted. There is no automation, no alerts, and the data is only as current as the last time someone edited the file. For fewer than 20 invoices per month, a spreadsheet can work. Beyond that, dedicated software saves meaningful time.
How often should I check my invoice dashboard?+
Daily for the 'action' view: which invoices are due today, which went overdue yesterday, and which reminders need to go out. Weekly for the trend view: how did DSO and overdue percentage move compared to last week? Are aging buckets growing or shrinking? Monthly for the strategic view: collection rate over the past 30 and 90 days, client-level patterns, and whether your payment terms are working. The daily check should take under two minutes.
What is the difference between an invoice dashboard and an AR aging report?+
An AR aging report is one component of a dashboard. It shows outstanding invoices grouped by how long they have been overdue (0-30, 31-60, 61-90, 90+ days). A dashboard includes the aging view plus summary metrics (DSO, total outstanding, collection rate, overdue percentage), trend lines over time, and ideally an action list of what needs follow-up today. Think of the aging report as a detailed table and the dashboard as the overview screen that contains that table alongside other key numbers.
Do I need a separate dashboard if I already use accounting software?+
Most accounting tools (QuickBooks, Xero, FreshBooks) have built-in AR reports, but they are designed for bookkeeping — not for daily collections management. They show you what is owed but do not prioritize what to chase, when to follow up, or track reminder history. A dedicated invoice tracking dashboard like InvoiceGrid complements your accounting software by focusing on the action side: who to chase, what stage each invoice is in, and whether your follow-ups are working.