Cash Flow Budget
Project the cash your business will receive and pay out, period by period, so you can spot shortfalls before the bills land.
A business can look profitable on paper and still go broke — because profit and cash are not the same thing. Acash flow budgetfixes that blind spot. It forecasts the actual money expected to come in and go out over a set period, so you can see today whether your account will cover next month’s bills, payroll, and supplier payments.
This guide teaches you what a cash flow budget is, why it differs from a profit plan, how the math works, and how to build one in Excel — with a worked example you can adapt.
Quick Answer: What Is a Cash Flow Budget?
A cash flow budget (or cash flow forecast) predicts yourcash inflowsandoutflowsover a period of weeks, months, or quarters. The core math is simple:
Opening balance + cash inflows − cash outflows = closing balance
Net cash flow each period is inflows minus outflows. The closing balance rolls forward to become the next period’s opening balance. A negative closing balance tells you a shortfall is coming in time to do something about it.
Why Cash Flow Is Different From Profit
This is the single most important idea in cash flow planning.
A profit & loss statement records revenue when it isearnedand costs when they areincurred(accrual accounting). A cash flow budget records money only when itactually moves.
- You might invoice$50,000in March — and be profitable that month.
- But if the customer pays in May, you have$0 newcash in March.
Meanwhile payroll, rent, and taxes leave the account on their own schedule. That gap between profit and cash is where healthy-looking businesses fail. An U.S. Bank study cited by SCORE found82% of small businesses fail due to cash flow problems— not because they were unprofitable, but because they couldn’t see the gap coming. A cash flow budget exists to expose it.
The Structure: Four Lines per Period
Every period (usually a month) has four sections:
- Opening balance— cash on hand at the start.
- Cash inflows— money expected to arrive, such as customer payments, sales receipts, loans, investment income, and grants.
- Cash outflows— money expected to leave, such as payroll, rent, supplies, taxes, loan repayments, and marketing.
- Net cash flow and closing balance— net flow equals inflows minus outflows; closing equals opening plus net flow.
Chain twelve of these together and you have a 12-month forecast. The value is timing: you record each inflow and outflow in the period you expect the money to move, not when you issue the invoice.
How to Build a Cash Flow Budget in Excel
Step 1: Choose your forecast period
Decide how far ahead and how often. Aweeklyforecast suits tight cash (many businesses run a 13-week version when cash gets scarce). Amonthlyforecast gives a wide view for planning. Many businesses do both.
Step 2: Lay out the grid
Put the time periods across the top as columns, and categories down the rows: Opening balance, each inflow line, each outflow line, Net cash flow, and Closing balance.
Step 3: Add the three core formulas
- Net cash flow=SUM(inflows) − SUM(outflows)
- Closing balance=Opening balance + Net cash flow
- Next period’s opening=Previous period’s closing
These three formulas are the engine. Let the closing balance roll itself forward automatically.
Step 4: Enter realistic inflows
List every source of cash, and place each amount in theperiod you expect to receive it— not when you send the invoice. If your payment terms are 30 days, lag sales receipts accordingly. Include customer payments, sales receipts, loan proceeds, and any grants or investment income.
Step 5: Enter realistic outflows
List every payment with its timing: payroll, rent, utilities, suppliers, stock, taxes (often paid a month later), loan repayments, and marketing. Where a cost like depreciation exists on paper but no cash moves, leave it out.
Step 6: Add scenario rows
Forecasts are estimates, so build three views where useful:best, base, and worst. Compare how the closing balance moves in each. Sensitivity like this tells you how much risk rides on your assumptions.
Step 7: Set a minimum-cash alert
Conditionally format (highlight) any month where the closing balance falls below your minimum comfortable cash level. When headroom is under roughly three months of outgoings, switch to the 13-week weekly view.
Worked Example: A Small Business Forecast
A small bakery forecasts one month (July) with these numbers:
| Item | Expected | Actual |
| Inflows | ||
| Sales | $18,000 | $17,400 |
| Interest | $50 | $45 |
| Total inflows | $18,050 | $17,445 |
| Outflows | ||
| Salaries | $6,500 | $6,500 |
| Supplies | $4,200 | $4,650 |
| Overheads (rent, utilities) | $2,800 | $2,800 |
| Stock | $2,500 | $2,900 |
| Net cash flow | +$2,050 | +$595 |
| Closing balance (start + net) | +$2,050 | +$595 |
Here the business started from zero and net cash flow turned positive, but theactualresult ($595) was far thinner than expected ($2,050) — supplies and stock cost more. Comparing expected vs. actual each month is how you improve next month’s accuracy.
Limitations and Best Practices
What it can’t do:a cash flow budget only helps if your estimates are honest. It cannot create cash that doesn’t exist — it can only warn you earlier. Long-range forecasts become less reliable the further out you project.
Best practices:update your projectionat least monthly(weekly when cash is tight); use historical bank statements to spot typical receipt and payment patterns; build in a buffer for late payments and unexpected costs; and compare projections to actual results each month to sharpen your forecasting.
Common Mistakes to Avoid
- Forecasting cash as if every invoice is paid on time — apply your real payment terms.
- Using accrual profit numbers instead of actual cash timing.
- Forgetting the opening balance each period.
- Ignoring cycles and seasonality.
- Never updating the forecast so it drifts out of date.
- Skipping a worst-case scenario.
FAQ
What is the difference between a cash flow budget and a cash flow statement?A statement records actual past cash movements; a budget/projection estimates future inflows and outflows to plan ahead.
How often should I update a cash flow forecast?At least monthly to stay accurate; weekly (often a 13-week view) when cash is tight.
Do I include depreciation in a cash flow budget?No — it’s a non-cash expense, so no money actually moves. Leave it out.
Why can my business be profitable but out of cash?Because profit uses accrual timing while cash only counts money when it moves — so invoices can be booked before they’re paid, leaving bills due before receipts land.
What if a month shows a negative closing balance?That’s the forecast doing its job: it gives you lead time to delay spending, negotiate supplier terms, or arrange financing before the shortfall hits.
Conclusion
A cash flow budget answers the question accounting reports dodge: will there be enough money in the bank when the bills arrive? Build the simple opening / inflows / outflows / closing grid, apply realistic payment timing, add scenarios, and compare actuals monthly. It turns “hoping” about cash into knowing — before the gap becomes a crisis.
Want to keep the broader spending picture in one place? TheBudget Planner Templatemaps budgets against income, and theExpense Tracker Templatelogs real outflows as they happen. For more Excel planning resources, visitUse Office Toolkit.