Small business budget and cash flow: a template you will actually update
By the BizDocs Studio team · Updated
- •A budget plans income and expenses by category for twelve months; a cash flow forecast shows the bank balance month by month.
- •Compare actuals to budget monthly (variance) and adjust the next months, not just the total.
- •Set a minimum cash cushion, often one to three months of fixed costs, and watch for months that drop below it.
- •Keep categories few enough that you will update them: 6–10 income and 15–25 expense lines.
A budget answers “can we afford this?”; a cash flow forecast answers “when will we run out?”. Small businesses usually fail on the second question, which is why the two belong in the same file.
Set up categories
Use income lines that match how you sell (services, products, retainers) and expense lines that match your bank statement. Fewer, clearer categories beat a perfect chart of accounts nobody maintains.
Plan twelve months
Enter a monthly budget for each line. Use last year's actuals for recurring costs and be honest about seasonality. Put annual costs (insurance, software renewals, tax payments) in the month they are paid, not spread evenly, because cash moves that way.
Record actuals and variance
| Report | What it tells you |
|---|---|
| Monthly variance by line | Which categories ran over or under |
| Year-to-date vs budget | Whether the year is on track |
| Income vs expense trend | Margin direction |
Plan the year, track what happens, and see the month cash dips before it does.
Forecast cash
Starting from today's bank balance, add expected receipts and subtract payments month by month. Highlight any month that ends below your minimum cushion. That month is your decision point: chase receivables, delay a purchase, or arrange credit before you need it.
Use a template
Our budget and cash flow template has settings for opening cash, cushion and current month, a 12-month budget, actuals, variance and a forecast that switches from budget to actuals as the year goes. Excel and Google Sheets.
Worked example: spotting a cash crunch
| Month | Cash in | Cash out | End balance |
|---|---|---|---|
| July | $24,000 | $21,500 | $18,400 |
| August | $19,000 | $22,800 | $14,600 |
| September | $17,500 | $26,900 (insurance + tax) | $5,200 |
| October | $25,500 | $21,000 | $9,700 |
With a minimum cushion of $8,000, September is the problem month two months in advance. Options: invoice earlier, chase receivables, move a purchase, or arrange a credit line before you need it.
Fixed vs variable costs
Separate fixed costs (rent, insurance, software, salaries) from variable costs (materials, contractors, card fees). Fixed costs set your break-even; variable costs scale with sales. Knowing both tells you how much revenue you need each month just to stand still.
Monthly review in 15 minutes
- Enter last month's actuals by category
- Check variance lines that are more than 10% off
- Update the next three months of the forecast
- Look for any month below your cash cushion
- Write one action for the month ahead
Frequently asked questions
What is the difference between a budget and a cash flow forecast?
A budget plans income and expenses by category; a cash flow forecast shows the timing of cash in and out and the resulting bank balance each month.
How much cash should a small business keep?
A common target is one to three months of fixed costs, more if revenue is seasonal or lumpy.
How often should I update the budget?
Monthly, when you reconcile the bank. Ten minutes of actuals keeps the forecast honest.
Plan the year, track what happens, and see the month cash dips before it does.