A daily cash report is one page, ready before the day starts, that says how much cash you have this morning, what came in yesterday, what went out, what is due out this week, and whether that leaves you short. The corporate version runs to twenty lines and a treasury team. The owner's version is five lines: opening cash across every account, receipts yesterday, payments yesterday, committed payments through Friday, and cash after commitments. A bookkeeper who is current can build it in twenty minutes; a tool builds it in none. It is the only report worth reading every day.
What most templates get wrong
Search for a daily cash report template and you get two kinds of document, and neither is for you. The first is a till sheet: opening float, cash sales, card sales, over and short, signed by the closing manager. That is a control for a shop with a register, and it says nothing about whether the company can pay anyone. The second is a treasury dashboard. Nilus, which sells to enterprise treasury teams, listed six must-haves in March 2026: reconciled opening and closing balances, inflows by source, categorized outflows, net movement, variance against forecast, and exception notes. All sensible for a company with a treasury team. An owner with 32 staff and an outside bookkeeper will not maintain a forecast variance column, and the report will stop being produced within a month.
The version worth keeping is closer to what Strategic CFO describes in its guide to developing a daily cash report: prepared in the morning of each workday, taking no more than thirty minutes, with ending cash equal to the reconciled balance plus deposits minus disbursements, and a weekly section for what is expected in and committed out. Strip that to five lines and it survives.
The five lines
On a Tuesday morning in October, a 32-person electrical contractor with three bank accounts, an operating account, a payroll account and a small savings account, opens a report that reads like this.
| Line | Tuesday morning |
|---|---|
| Opening cash, all accounts | $184,600 |
| Receipts yesterday | $23,150 |
| Payments yesterday | $41,900 |
| Committed payments through Friday | $96,400 |
| Cash after commitments | $69,450 |
The first three lines are history and the bank already knows them. The fourth line is the one that earns the report its place. It holds Friday's payroll of $58,200 with the payroll tax deposit that goes with it, a $14,700 loan payment on Thursday, the $9,300 sales tax deposit due Friday, and $14,200 of vendor bills the bookkeeper has already scheduled. The fifth line is arithmetic: $184,600 plus $23,150, less $41,900, less $96,400, leaves $69,450.
Committed payments are the amounts that will leave the accounts this week whether or not anything comes in: payroll and its taxes, loan payments, tax deposits, and bills already approved or set to pay. They are not a forecast. They are things already decided.
Cash after commitments is opening cash plus yesterday's receipts, less yesterday's payments, less committed payments. It is the number the owner reads first, because it answers whether the company can get to Friday without collecting anything.
For this contractor, $69,450 after commitments is about eleven days of outflow at his run rate, which is thin. It is also the honest number, and it is not the one his banking app showed him at 6:40 that morning, which was $184,600 and felt fine.
Where each line comes from, and why the bank balance lies
The bank balance is the least useful number on the page, which is the opposite of what most owners are told. It is true as of this second and wrong about the week. It does not know about the $12,400 of checks the office manager mailed on Friday that have not cleared. It does not know that Friday's sales tax deposit is money the company collected for the state and never owned, a point covered in the cash in your account that is not yours. It does not know payroll is Friday. A balance of $184,600 and a balance of $69,450 look identical on a banking app.
In QuickBooks Online the pieces are spread across four places. Opening cash comes from the bank register balances, which are only right if the bookkeeper has posted last week's transactions; an unposted week makes the report wrong by exactly that week. Receipts come from yesterday's deposits and customer payments. Payments come from yesterday's bill payments, checks and card charges. Committed payments come from the Bills Due report filtered to Friday, plus the payroll schedule and the tax deposit dates, which live outside the general ledger and have to be added by someone who knows them. Strategic CFO's point about the daily report is that it exists partly to force this: a report that has to be produced every morning keeps the posting current, because a stale file shows up immediately as a wrong number.
If you want the five rows and the formulas without building them, the daily cash report template is one sheet with a column per weekday.
The multi-entity version
An owner with three companies gets one report, not three. One line per company, then the total, for each of the five rows. The total is what most owners want on a Tuesday, but the per-company lines are where the trouble shows, because the group can be fine while one company is not, and the bank will not transfer between LLCs on its own.
On Monday, HoldCo moved $40,000 to OpCo so OpCo could make payroll. OpCo's report shows $40,000 of receipts. HoldCo's report shows $40,000 of payments. Both companies look like something happened; the group total is unchanged, and if the receipts line is read as customer money, OpCo looks like it had a good day. The report should show the transfer as a transfer, on its own line or netted out, so that receipts means outside money only. This is the same error that inflates a stacked P&L, which intercompany eliminations explained walks through on the income side.
Reading it in ninety seconds
The number is cash after commitments. The direction is whether it is higher or lower than it was on the same weekday last week, which the sheet shows by keeping the columns. The one thing to do is whichever of three follows: nothing, because the number is fine; call the two customers whose invoices would close the gap, because the number is short and collectible; or draw on the line, because the number is short and the invoices are not due yet. Ninety seconds. If it takes longer, the report has too many lines.
This is where the daily report and the forecast divide the work. The 13-week cash flow forecast answers whether March is safe and gets rebuilt weekly. The daily report answers whether Friday is safe and does not get rebuilt, because it contains almost nothing that is estimated.
When cash is tight, and when daily is too often
The Bluevine survey published in October 2025, of 774 US owners with revenue between $50,000 and $5 million, found 39% holding under one month of operating expenses and 51.3% saying they would tap reserves within 48 hours to cover payroll. Among businesses under two years old, 20.7% held under seven days in checking. The QuickBooks 2026 Late Payments Report found 39% of small businesses had a single late payment make payroll or bills hard to cover. For those owners the five lines are not enough on their own, and the fix is a weekly commitments column: the same rows, but the committed line split into this week and next, with the receipts line joined by "invoices due this week". That is the beginning of a forecast without the estimates, and it is the version to run for the eight or ten weeks it takes to get out of the tight spot.
The morning brief on the Navigator base plan is this report, sent by email before the day starts: opening cash in every bank account in every connected QuickBooks Online company, yesterday's receipts and payments, and the intercompany transfer shown as a transfer rather than as receipts, with each figure opening to the company and entry it came from. It reads the files as the bookkeeper left them, so a file three weeks behind produces a report three weeks behind, and the committed line depends on bills actually being entered.
Daily is too often for some owners. The test is arithmetic. If cash after commitments covers more than about 60 days of operating outflow, payroll never waits on a customer, and there is no loan payment that lands in the same week as taxes, a weekly version on Monday morning is enough and the daily one will be ignored by week three. A 2016 JPMorgan Chase Institute study of 597,000 firms put the median small business at 27 days of cash and the median construction business at 20, so the group that can skip daily is smaller than it thinks, and how much cash reserve a business should hold sets out how to work out which group you are in. What the report cannot do, at either frequency, is tell you why cash is short; it shows the gap, and the P&L and the AR aging have to explain it.
Questions owners ask
What is a daily cash report?
A one-page report, prepared before the workday starts, showing cash in every bank account this morning, what came in and went out yesterday, and what is committed to go out over the coming days. The corporate version adds forecast variances and exception notes. The owner's version is five lines and takes ninety seconds to read.
What should a daily cash report include?
Opening cash across every account, receipts yesterday, payments yesterday, committed payments through the end of the week, and cash after commitments. Committed payments should include payroll, payroll tax, the sales tax deposit, loan payments and any bills already scheduled. If you own more than one company, one line per company and then the total.
How do I make a daily cash report in Excel?
Five rows, one column per day. Type the bank balances from each account in row one, yesterday's deposits in row two, yesterday's payments in row three, and everything scheduled through Friday in row four; row five is arithmetic. Twenty minutes for a bookkeeper who is current. The template linked above has the rows and formulas set up.
What is the difference between a daily cash report and a cash flow forecast?
The daily report is about this morning and this week, built from balances and payments already scheduled. A 13-week cash flow forecast is about the next quarter, built from expected receipts and expected payments, most of which are estimates. The daily report tells you whether Friday is safe. The forecast tells you whether March is.
Should a small business track cash daily?
If cash after commitments is under about 60 days of operating outflow, or payroll ever depends on a customer paying on time, yes. A 2016 JPMorgan Chase Institute study of 597,000 firms put the median small business at 27 days, so most should. With cover well over 60 days and no payroll gap, a weekly version is enough.
Related
If the gap between a healthy P&L and a thin account is what brought you here, start with why net income does not match your bank balance. For the version that looks a quarter ahead instead of a week, the cash flow forecast that takes an hour is the place to begin. And for how the daily report fits with the weekly and monthly reads, see how often a business owner should review the financials. If the team lives in chat, finance questions in Slack or Teams is the same report delivered where they already are.
If you would rather have the five lines arrive by email each morning than build them, the trial connects to QuickBooks Online in two clicks and needs no card: navigatorhq.ai.
You're on the list.
The next post goes to . While you wait, the free Accounting Health Check scores your own books.
Published . Last updated . Reviewed by a CFO on the Navigator team.