Cash flow
Do you need a cash flow dashboard? An honest answer
November 20, 2026 · 10 min read

Quick answer
Yes, if your cash ever gets tight, but probably not the expensive kind. Below roughly $1M in revenue a single spreadsheet tab with six numbers is plenty; a dedicated tool starts to earn its fee when you have several bank accounts, a lender watching your balance or a finance person to keep it current. The six numbers are cash today, your cash floor, weeks of runway, receivables due in the next 14 days, bills due in the next 14 days and the next payroll.
Somebody showed you a cash dashboard with dials and a dozen self-updating charts. It looked impressive, and you wondered if you're running half blind without one.
Probably not. But you might be running it with the wrong number in your head. Most owners check one figure, the bank balance, and that single number can look fine right up until the week it doesn't. A good cash dashboard is less about software and more about putting the five or six numbers that surround the bank balance next to it, so you see the next two weeks, not just today.
Here's an honest answer by business size, the six numbers that belong on it, how often to refresh them, and a worked example of what the dashboard catches.
6
Numbers that belong on a cash dashboard. More than that and nobody reads it.
14 days
The look-ahead window for money coming in and going out
Weekly
How often most small businesses should refresh it
What's the difference between a dashboard, a forecast and a KPI scorecard?
A 13-week cash flow forecast is the engine: week-by-week receipts and payments for a quarter. A weekly KPI scorecard covers the whole business, including sales, pipeline, margin and utilization. A cash dashboard is narrower than both. It's the one screen you look at to answer a single question: are we OK for the next couple of weeks, and is the trend getting better or worse?
If you already run a forecast, the dashboard is its front page. If you don't, it's a sensible first step, small enough that you'll keep it up.
Do you need one? An honest answer by business size
It depends on two things more than revenue: how lumpy your cash is, and how close you run to the line. Still, size is a decent first guide.
| Business size (revenue) | What we'd suggest | Why |
|---|---|---|
| Under $1M, one bank account | A tab in a spreadsheet, or nothing extra if cash is never tight | The bank app plus a payroll reminder covers most of it |
| $1M to $5M, payroll every two weeks | A spreadsheet tab with the six numbers, refreshed weekly | Payroll, tax deposits and slow payers start colliding |
| $5M and up, several accounts or a credit line | A dashboard in your accounting or reporting tool, fed by a forecast | More accounts and more people make a manual tab easy to get wrong |
| Any size, cash below one payroll of cushion | The spreadsheet tab, this week | You need visibility now, not a software project |
Honestly, most businesses under $1M with steady customers don't need a dashboard at all. The moment you've had one Thursday night checking if payroll would clear, you need the six numbers.
Spreadsheet tab or a dedicated tool?
Start with the spreadsheet. Seriously. The hard part of a cash dashboard is the habit of updating it and the judgment about what goes in it, and a tool doesn't give you either.
Start here
Spreadsheet tab
- Free, and set up in an afternoon
- You choose exactly which six numbers
- Forces someone to look at each figure while typing it
- Breaks if the person who updates it is away
- Easy to fat-finger a number
When it earns its fee
Dashboard tool
- Pulls bank balances and open invoices automatically
- Handles several accounts and entities
- Shares one view with a partner or lender
- Only as good as the books feeding it
- Tempting to add 30 charts nobody reads
Most accounting software already has a home screen showing bank balances, open invoices and unpaid bills: three of the six numbers, free. What it usually can't show is the cash floor, runway and a payroll that hasn't been run yet. A tool makes sense when updating the tab takes more than 20 minutes a week, or when a lender or partner wants the same view.
Which six numbers belong on a cash dashboard?
These six, in this order, top to bottom.
- Cash today. The total in every operating account, plus money sitting in payment processors that will land in a day or two. Use the bank's balance, not your accounting software's, if the bank feed is behind.
- Cash floor. The minimum you're willing to hold. A common starting point is one payroll plus a week of regular bills. Write it on the dashboard so every other number gets compared to it.
- Weeks of runway. Cash today divided by your average weekly net outflow over the last couple of months. If you're bringing in more than you spend, show "cash positive" instead, or show your runway above the floor. Our burn rate and runway post covers the math in detail.
- Receivables due in the next 14 days. Invoices you expect to be paid in the next two weeks, based on when each customer actually pays, not the terms on the invoice. Your AR aging report is the source.
- Bills due in the next 14 days. Vendor bills, rent, loan payments, card balances and sales tax that leave the bank in the window.
- Payroll coming. The next payroll (or two) in the window, at full cost: net pay, the employer's share of payroll taxes and benefits. If you deposit payroll taxes monthly, IRS Publication 15 says a month's employment taxes are due by the 15th of the following month, so that deposit belongs here too.
Then one line of arithmetic: cash today, plus receivables due, minus bills and payroll due. That's your cash in 14 days, and it's the number to compare with the floor.
Notice what's missing: revenue, profit, margin. They live on the scorecard and the monthly statements. (If profit and cash keep disagreeing, cash flow vs profit explains why.)
A worked example: what the dashboard catches
Say you run a 15-person HVAC service company doing about $2.4 million a year. Payroll runs every other Friday and costs about $62,000 a run with taxes and benefits. A week of regular bills is about $28,000, so you set the cash floor at $90,000.
Here's the bank balance every Monday for 12 weeks:
Monday cash balance vs cash floor
Hypothetical 15-person HVAC company, 12 weeks to November 16
Hypothetical example. The zigzag is payroll every other week; the trend is the problem.
Show the numbers
| Monday cash | |
|---|---|
| Aug 31 | $184,000 |
| Sep 7 | $161,000 |
| Sep 14 | $179,000 |
| Sep 21 | $158,000 |
| Sep 28 | $170,000 |
| Oct 5 | $147,000 |
| Oct 12 | $160,000 |
| Oct 19 | $138,000 |
| Oct 26 | $149,000 |
| Nov 2 | $126,000 |
| Nov 9 | $133,000 |
| Nov 16 | $112,000 |
Any single Monday looks fine. But the line has dropped $72,000 in 11 weeks, about $6,500 a week, and the zigzag hides it because every payroll week looks like the cause.
Now fill in the dashboard for Monday, November 16:
| Number | Value | Where it comes from |
|---|---|---|
| Cash today | $112,000 | Bank balances, all accounts |
| Cash floor | $90,000 | One payroll plus a week of bills |
| Weeks of runway | About 17 | $112,000 ÷ $6,500 average weekly net outflow |
| Receivables due in 14 days | $58,000 | AR aging, by real payment habit |
| Bills due in 14 days | $31,000 | AP aging, rent, card payment |
| Payroll coming | $62,000 | Friday, November 27 run |
Seventeen weeks of runway doesn't sound alarming either. The 14-day line tells a different story:
Cash in 14 days
The same hypothetical HVAC company, from Monday November 16
- Adds cash
- Uses cash
- Total
Hypothetical example: 112,000 + 58,000 − 31,000 − 62,000 = 77,000, which is $13,000 below the $90,000 floor.
Show the numbers
| Cash today | $112,000 |
| Receivables due | +$58,000 |
| Bills due | −$31,000 |
| Payroll | −$62,000 |
| Cash in 14 days | $77,000 |
In two weeks you're $13,000 under the floor, even if every customer pays on time. That's the point of the dashboard: you find out with 11 days to act, not on payroll morning. The fixes are ordinary: chase the two biggest overdue invoices, move a supplier payment a week, hold the equipment purchase. The bigger job is finding out why the trend is down $6,500 a week before it becomes a monthly problem. That's what a weekly cash meeting is for.
How often should you update it?
Weekly, on the same morning. Monday works for most businesses because it sets up the week's collection calls and payment runs.
Every week (15 to 20 minutes)
- Refresh cash today from the bank, not the books
- Update receivables and bills due in the next 14 days
- Check the next payroll amount and date
- Recalculate cash in 14 days and compare it with the floor
Every month (after the close)
- Recalculate the average weekly net outflow behind runway
- Check customers' real payment habits against your 14-day estimates
- Review the floor: did payroll or rent change?
Daily updates sound diligent, but for a healthy business they're mostly noise. Save them for the weeks you're near the line.
How do you set one up in an afternoon?
Put the six numbers in a column with a label, value and source note, like the table above. Add the cash-in-14-days formula and a cell that turns red below the floor. On a second tab, paste Monday's balance each week and chart it with the floor as a flat line. For the full weekly view underneath, our free cash flow forecast template gives you the structure, and the startup runway calculator does the runway math if you're burning cash on purpose.
Common mistakes
Using the accounting software's bank balance. If the feed is three days behind or there are uncleared checks, the number is wrong. Use the bank.
Using invoice terms instead of payment habits. A customer on net 30 who always pays in 52 days doesn't belong in your 14-day receipts just because the due date falls there.
Forgetting the employer's share. Net pay isn't the payroll cost. Add employer taxes, benefits and the tax deposit.
No floor. Without a floor, every number is just a number. With one, the dashboard answers a yes-or-no question.
Too many numbers. Twelve tiles feel thorough. In practice the owner reads the first two and stops. Six is plenty. And a dashboard that's three weeks stale is worse than none, because it looks trustworthy.
When should you get help?
If your books are current and reconciled, you can run this yourself. Get help when the numbers feeding it aren't reliable (receivables you can't trust, bills that live in someone's inbox), when cash in 14 days keeps landing near the floor and you don't know why, or when a lender or investor wants to see a forecast you'd have to defend.
That last case is fractional CFO territory. Fintrix Consulting's fractional CFO service includes a 12-month cash forecast kept up to date and a monthly KPI dashboard with budget vs actual, plus a monthly session on what the numbers mean.
Frequently asked questions
What is a cash flow dashboard?
A single screen showing the handful of numbers that tell you whether you have enough cash for the next couple of weeks: cash today, your cash floor, runway, money due in and out over the next 14 days and the next payroll.
Can I use my accounting software's dashboard?
It's a good start, since most show bank balances, open invoices and unpaid bills. You'll usually need to add the cash floor, runway and upcoming payroll yourself, in a spreadsheet or a forecast.
How do I calculate weeks of runway?
Divide cash today by your average weekly net outflow (cash out minus cash in) over the last eight to twelve weeks. If more comes in than goes out, you're cash positive and runway isn't the right measure; watch cash in 14 days against your floor instead.
How much should my cash floor be?
A common starting point is one full payroll plus a week of regular bills. Seasonal businesses or ones with a few large customers often hold more.
The bottom line
You probably don't need an expensive cash dashboard, but if cash has ever been tight, you do need six numbers on one screen. Cash today, the floor, runway, what's due in, what's due out and the next payroll: refreshed every Monday, with the 14-day result compared to the floor. Start in a spreadsheet tab this week. Move to a tool only when keeping the tab current starts costing you more time than the tool would.
This article is general information, not advice for your situation. Rules change and details matter, so talk to us or your CPA before acting on it.
More articles
- Accounts receivable and the AR aging report
November 19, 2026
- Bookkeeping and cash planning for seasonal businesses
November 19, 2026
- Running a weekly cash meeting
November 19, 2026
Have a question about this article?
Ask us. A real person will reply by email within one business day. Your question isn’t published.
Ready for books you can trust?
Book a free 30-minute consultation. We'll review where your finances stand today and show you exactly how we'd help.