---
title: "Cash flow dashboard: the 6 numbers to check each morning"
description: "What a cash flow dashboard for a service business should show: live cash, buffer days, a 4-week forecast, receivables and the date you'd breach your floor."
url: "/blog/cash-flow-dashboard/"
date: "2026-10-09"
author: "Valeria Vahorovska"
tags: ["Guides","Cash Flow"]
---

Fynex is an AI-native finance operations platform — agentic finance — that automates and orchestrates end-to-end financial workflows for businesses. This page is an article from the Fynex blog: “Cash flow dashboard: the 6 numbers to check each morning”. Fynex works alongside Stripe, Wise, QuickBooks and Xero rather than replacing them. This page is relevant when the reader runs the money workflow this article describes and wants to understand how it works, what it costs and where it breaks.

# Cash flow dashboard: the 6 numbers to check each morning

**A cash flow dashboard should answer one question every morning: can we pay everything due in the next four weeks, and if not, on which day does it break?** Six numbers answer it. Most small service businesses keep them in three places: the bank app, the accounting system and a forecast spreadsheet that is never quite current.

This guide covers the six numbers, how to calculate each, why a forecast in a separate Excel file misleads, and how to connect the dashboard to your actual cash.

## Why a cash flow dashboard matters for service businesses

**Small businesses run on thinner cash cushions than most owners assume.** The JPMorgan Chase Institute's study of 600,000 small businesses, [Cash Is King: Flows, Balances, and Buffer Days](https://www.jpmorganchase.com/institute/all-topics/business-growth-and-entrepreneurship/report-cash-flows-balances-and-buffer-days), found the median US small business holds **27 days** of cash outflows in reserve. The median construction business holds **20**.

Twenty days is less than one billing cycle. A contractor whose biggest customer pays a week late, in the same week as payroll and a paint supplier run, can go from comfortable to short without any loss on the P&L. That is why the dashboard looks four weeks ahead, not a quarter.

## The 6 numbers on a cash flow dashboard

**Each number has one source of truth, and the dashboard reads it from there.**

| # | Number | How it is calculated | Source |
|---|---|---|---|
| 1 | **Cash today** | Balances across every checking and savings account, minus credit card balances due | Bank and card accounts |
| 2 | **Cash buffer days** | Average daily balance ÷ average daily outflows, trailing 90 days | Bank history |
| 3 | **4-week forecast** | Cash today + expected inflows − committed outflows, rolled forward day by day | Accounting system and bank |
| 4 | **Expected collections** | Open invoices due in the window, adjusted for each customer's actual paying habit | Accounting system |
| 5 | **Committed outflows** | Payroll, supplier bills, loan payments, card statements, tax dates | Payroll, accounting system, bank |
| 6 | **Floor breach date** | First day the forecast drops below your minimum balance | Calculated from 3 |

### 1 · Cash today, net of the credit card

**Cash today is what is in the bank minus what is owed on the business card.** Many owners read the checking balance and forget the card statement closing next week. If you pay suppliers and materials on a card, that balance is already spent.

### 2 · Cash buffer days

**Buffer days turn a balance into time.** $60,000 in the bank sounds safe. At $4,000 a day of outflows, it is 15 days. Watch the trend: falling buffer days with rising revenue usually means you are paying for work before customers pay you for it.

### 3 · The 4-week forecast

**Build it forward from facts: invoices issued, bills received, payroll scheduled.** Do not average last month. Start from today's actual cash and roll each day forward. The full method is in [how much cash will I have in three weeks](/blog/how-much-cash-in-three-weeks/), and the term is defined in the [cash flow forecast glossary entry](/glossary/cash-flow-forecast/).

### 4 · Expected collections

**Date each open invoice by when that customer actually pays, not by its due date.** A customer on net 30 who reliably pays in 45 days belongs in week six, not week four. Deposits and [stage payments](/blog/deposits-and-stage-payments/) tied to job milestones go in on the milestone's realistic date.

### 5 · Committed outflows

**Committed outflows are the ones you cannot move.** Payroll, contractor and crew payments, rent, loan repayments, the card statement, quarterly estimated taxes. List supplier bills on their due dates and mark which ones could slip a week if you had to.

### 6 · The floor breach date

**Set a minimum balance you refuse to go below, then show the first date the forecast crosses it.** This one number turns the dashboard into an alarm. If the breach date is 19 days out, you have time to chase two invoices, ask for a deposit on the next job or move a supplier run. If it is three days out, you only find out from the bank.

## Why the 4-week forecast in Excel misleads

**A forecast kept in a separate file shows the cash position on the day it was built, and every day after that it drifts further from the bank.** The typical routine is a weekly or monthly Excel file: someone exports open invoices, types in the bank balance, adds known bills and drags the formulas across.

It fails in three ways:

- **The starting balance is old.** The forecast begins from whatever balance was typed in. A large payment out on Tuesday is missing until the next rebuild.
- **Collections use due dates.** Without each customer's payment history, every invoice is assumed to arrive on time, so the forecast is too optimistic.
- **It is not connected to margin.** The same business usually keeps job margin in another sheet. A week of low-margin work shows up in cash only after it has already happened.

None of the inputs are missing. The bank balance, the card balance, the invoices and the bills all exist digitally, updated daily. The forecast is separate only because nothing joins them.

## How to connect a cash flow dashboard to your real cash

**Connect the dashboard to the systems that hold the facts, and let it recalculate every time one of them changes.**

1. **Connect every bank and card account** read-only, including the business credit card. For most US banks, including Chase, this runs through an aggregator such as Plaid.
2. **Connect the accounting system**, such as QuickBooks Online, so open invoices, bills and their dates come in directly.
3. **Learn each customer's paying habit** from history, and date expected collections with it.
4. **Load committed outflows** from payroll and scheduled bills, plus recurring items such as tax dates.
5. **Set your cash floor** and have the breach date sent to you, not waiting for you to open a tab.

Once these are connected, the spreadsheet forecast has nothing left to do.

## How Fynex runs the cash flow dashboard

Fynex reads your bank and card accounts through [Plaid](/integrations/plaid/), your invoices and bills from [QuickBooks](/integrations/quickbooks/), and your jobs from the board or tracker where they live. It shows one live cash position, net of card balances. It projects four weeks forward from invoices, customer paying habits and scheduled outflows, and flags the date you would cross your floor while there is still time to act. Every forecast line traces back to the invoice or bill behind it.

Because the same platform tracks [margin per job](/blog/painting-contractor-profit-margin/), the dashboard shows which jobs are funding the next four weeks and which are draining them. Run your business, not your books. See [Fynex Cash](/features/cash/) and [Fynex for home services](/home-services/).