Cash Flow Budget

A cash flow budget is a period-by-period plan of the cash a business expects to receive and spend over a defined future timeframe. It translates revenue and expense targets into actual cash timing, showing when money will arrive and when it will leave, not just how much, but which week or month.

How It's Built

A cash flow budget follows the same structure as a cash flow projection, but with one important distinction: the figures come from planned targets rather than from live accounting data or historical actuals. The core calculation for each period is:

Budgeted Closing Balance = Opening Balance + Budgeted Inflows - Budgeted Outflows

The closing balance rolls forward as the opening balance for the next period.

Budgeted inflows are derived from the sales budget, adjusted for expected payment timing. If the sales budget projects $90,000 in revenue for March on 30-day terms, most of that cash arrives in April, not March. The cash flow budget has to reflect that lag, revenue recognition and cash collection happen in different periods.

Budgeted outflows come from the expense budget, payroll plan, capital expenditure plan, and debt repayment schedule. Fixed costs are straightforward; variable costs are tied to sales volume and need to move in line with the revenue assumptions.

The value of the cash flow budget is not the figures themselves, it is the timing. An annual operating budget might show the business breaking even over twelve months. A cash flow budget shows that it runs a significant deficit in Q1 and Q2 because costs are front-loaded before revenue picks up. Those are different problems requiring different responses, and the cash flow budget is what reveals the distinction.

A software consultancy is building its cash flow budget for Q1. It has agreed contracts covering most of its expected revenue, payroll is fixed, and it is planning one significant capital expenditure. All amounts in USD.

January

ItemAmountOpening balance$58,000Client payments expected (invoices from Dec)+$72,000Payroll-$38,000Software subscriptions and tools-$4,200Office rent-$6,500Closing balance$81,300

February

ItemAmountOpening balance$81,300Client payments expected+$65,000Payroll-$38,000Software subscriptions and tools-$4,200Office rent-$6,500New server equipment (CapEx)-$22,000Closing balance$75,600

March

ItemAmountOpening balance$75,600Client payments expected+$88,000Payroll-$38,000Software subscriptions and tools-$4,200Office rent-$6,500Estimated tax payment-$14,000Closing balance$100,900

The quarter ends in a stronger position than it started. February is the tightest month because the capital expenditure and fixed costs land against a lower-than-average collections month. The budget shows that in advance, which means the business knows going into February that it is not a month for discretionary spending, not because February surprises it, but because the budget already mapped it out.

It exposes cash timing problems that an income budget misses

An income budget says the business will earn $X and spend $Y over the year. A cash flow budget says when those transactions will actually affect the bank account. The consultancy example above could show a profitable Q1 on the income statement while the cash flow budget reveals February is tight because of the equipment purchase and a slower collections month. Profit and cash timing are not the same thing, and the income budget does not translate one into the other.

It gives variances meaning

At the end of each month, the actual cash position can be compared to the budgeted position. A closing balance that is lower than budgeted is either an inflow that came in later than planned, an outflow that was larger than expected, or both. Without the budget, there is no baseline to compare against, just a cash balance with no reference point. The budget creates that reference point and turns end-of-month cash reporting from a description into a diagnostic.

It coordinates decisions across the business

When the operations team is evaluating whether to hire in March and the finance team is planning a capital expenditure in February, a shared cash flow budget makes the combined impact visible. Each decision in isolation may look affordable; together they may strain the March opening balance in a way neither team anticipated. The cash flow budget is the tool that puts all planned cash movements on the same timeline so they can be evaluated as a whole.

A cash flow budget plans expected inflows and outflows period by period. It turns a target into a week-by-week cash map you track against.

That last phrase is the operative one. A budget that is built and then filed is just a planning exercise. A budget that is reviewed monthly against actuals, where every variance between budgeted and actual cash is identified and explained, is a management tool. When February's closing balance comes in below budget, the question is not whether to be concerned; it is which line caused the gap. Was a client payment late? Did an unbudgeted cost appear? Did the capital expenditure come in over estimate? Each of those explanations has a different implication for March's budget, and the variance analysis is what surfaces the right one.

The cash flow budget also sets the standard against which the forecast is tested. If the budget projected a certain level of Q1 collections and the rolling forecast, built from live data, is now showing less, something in the sales pipeline has changed and the budget needs to be understood in that light. The two tools are not in competition, the budget sets the plan, the forecast tracks the trajectory, and the gap between them is where the most useful management information lives.

Cash Flow Frog connects to QuickBooks Online, QuickBooks Desktop, Xero, and Sage Intacct and builds a rolling cash flow forecast automatically from your accounting data. QuickBooks records what happened. Cash Flow Frog projects what is coming.

The forecast built from live accounting data is the actuals side of the equation. When that is compared against the cash flow budget, the planned side, the variances become visible in the same view. Rather than maintaining a separate budget spreadsheet and manually reconciling it against accounting data each month, the comparison runs from the same source. If a specific transaction is driving a variance in a particular period, the tool drills down to the transaction level to identify it. For businesses with multiple entities or currencies, that planned-versus-actual view runs natively across all of them. You can explore how planned versus actual works in Cash Flow Frog at cashflowfrog.com/features/planned-vs-actual/.

Frequently Asked Questions

A budget is a fixed plan built at the start of a period, based on targets and assumptions. It does not change as the period progresses, even if reality diverges from it. A forecast is a rolling projection that updates as actual data comes in, it reflects what is likely to happen given current conditions, not what was originally planned. The two are used together: the budget is the benchmark, the forecast is the current best estimate, and the gap between them is the variance to be explained. Building one does not replace the other.

How granular should a cash flow budget be?

For most small businesses, monthly periods across a 12-month horizon give enough detail to be useful without requiring more precision than the underlying assumptions can support. Weekly budgets are appropriate for businesses where cash timing is tight and predictable enough to plan at that level, retailers, for example, or businesses with regular weekly payment cycles. Annual budgets with no monthly breakdown are too coarse to catch the timing problems a cash flow budget exists to reveal. The right granularity is whatever matches the frequency at which cash decisions actually need to be made.

Who should be involved in building a cash flow budget?

At minimum, the people responsible for revenue, costs, and payments. In a small business that is often one person, but in a business with separate operations, sales, and finance functions, the cash flow budget cannot be built by finance alone without input from the teams who drive the underlying activity. A payroll figure that does not reflect confirmed headcount plans, or a revenue figure that sales has not signed off on, produces a budget that no one believes and no one manages against.

How often should a cash flow budget be revised?

The budget itself is typically fixed for the year, changing it mid-year makes variance analysis meaningless because you are then comparing actuals to a moving target. What should be revised regularly is the forecast, which sits alongside the budget and incorporates current information. If conditions change so materially that the budget is no longer a useful reference point, a major contract is lost, or a significant opportunity accelerates revenue well beyond plan, a formal budget reforecast can be done, but it should be treated as a distinct exercise rather than a quiet update.

What happens when actual cash flow consistently beats or misses the budget?

Consistent outperformance means the assumptions were too conservative: revenue is coming in faster, or costs are running below plan. That is useful information about the quality of the budgeting process, and it should inform next year's assumptions. Consistent underperformance means either the targets were too aggressive or execution is falling short. The variance analysis is what distinguishes between the two: if revenue is on plan but cash is short, the issue is timing or cost; if revenue is below plan, the issue is commercial. A budget that is never compared to actuals cannot answer that question.

Is a cash flow budget different from a master budget?

A master budget is the complete set of interlinked financial plans for a business: the sales budget, expense budget, capital budget, and the financial statements projected from them. The cash flow budget is one component of the master budget, the part that converts all the other plans into a cash timeline. In a small business without a formal master budget process, the cash flow budget is often built directly from revenue estimates and known costs without the full interlocking structure, which is entirely workable as long as the timing assumptions are grounded in how customers actually pay and suppliers actually get paid.

• Cash Flow Forecast
• Cash Flow Projection
• Operating Budget
• Variance Analysis
• Opening Balance
• Rolling Forecast