Monthly Budget Template
A simple spreadsheet template for tracking burn, revenue, and runway every month.

A monthly budget is most useful when it connects expectations to actual results and turns the differences into operating decisions.
In short
- • A monthly budget is a planning document: what you expect to receive, what you expect to spend, and what actually happened. Its value comes from comparing plan with actual results and using the differences to decide what needs attention.
- • The FDIC Money Smart for Small Business program treats budgeting, financial statements and cash-flow management as core small-business financial practices. The SBA likewise recommends regular forecasting and plan-versus-actual analysis rather than treating a forecast as a one-time document. [1][2]
- • Start with categories that match the way the business records its actual finances. Typical lines include:
What this template is for
A monthly budget is a planning document: what you expect to receive, what you expect to spend, and what actually happened. Its value comes from comparing plan with actual results and using the differences to decide what needs attention.
The FDIC Money Smart for Small Business program treats budgeting, financial statements and cash-flow management as core small-business financial practices. The SBA likewise recommends regular forecasting and plan-versus-actual analysis rather than treating a forecast as a one-time document. [1][2]
Build the budget from real operating numbers
Start with categories that match the way the business records its actual finances. Typical lines include:
- revenue by major source;
- payroll and contractor costs;
- software and infrastructure;
- marketing and sales;
- rent and utilities;
- taxes and debt service;
- other recurring or planned costs.
For an established business, use recent actuals as the starting point and document the assumptions behind changes. For a new business, use explicit assumptions and revise them as real data arrives.
Do not confuse a budget with a promise. It is a model of what you currently expect to happen.
The monthly operating loop
Use the same cycle every month:
- Set the next month's expected revenue and spending.
- Record actual results as the month progresses.
- Compare actuals with the budget.
- Investigate material variances.
- Update the next forecast when the evidence changes.
- Record the decision made because of the variance.
A variance is not automatically a problem. A lower expense can be useful. A higher expense can be justified. The point is to notice the difference and understand it.
Add a cash-flow view
Profit and cash are not interchangeable. A sale can be recorded before the customer pays, while payroll, suppliers or other obligations may need cash earlier.
The FDIC's cash-flow guidance recommends projecting future cash inflows and outflows and treating the projection as an estimate that can be revised as conditions change. [1]
Add a simple cash section showing:
| Item | Planned | Actual | Variance | Next action |
|---|---|---|---|---|
| Revenue collected | - | - | - | - |
| Payroll | - | - | - | - |
| Suppliers | - | - | - | - |
| Software/infrastructure | - | - | - | - |
| Taxes/debt | - | - | - | - |
| Ending cash | - | - | - | - |
The decision rule
Before approving a new recurring expense, ask:
- Is it already in the budget?
- If not, what assumption changed?
- What cash does it require before the related revenue arrives?
- Which existing priority will change because of it?
- Is the expense reversible if the assumption proves wrong?
That turns the budget from a reporting sheet into an operating tool.
A practical monthly close
At month-end, do not simply overwrite the old forecast. Keep the planned number beside the actual number.
Then write three short notes:
What was different?
Identify the largest useful variances.
Why was it different?
Separate timing, volume, price, one-off events and forecasting errors where possible.
What changes next month?
Update the forecast or operating decision only when the evidence supports the change.
The final answer
The useful monthly budget is not the one that looks most precise. It is the one that makes assumptions visible, compares plan with reality, and leads to a decision.
Use the template as a living operating document. Forecast, record actuals, review variances, update assumptions and keep the cash position visible.
Sources & methodology
[1] FDIC, Money Smart for Small Business, Managing Cash Flow: https://www.fdic.gov/consumer-resource-center/mssb-m10-pg.pdf [2] U.S. Small Business Administration, “5 Classic Fails in Budgets and Forecasts”: https://www.sba.gov/blog/2019/2019-07/5-classic-fails-budgets-forecasts/
SOE methodology: the template is editorial synthesis. The cited institutional sources support the budgeting, forecasting, cash-flow and plan-versus-actual principles. No founder performance claim or unsupported numerical result is asserted.
How to use this tool
Use Monthly Budget Template as a working document, not as a scorecard. Start by defining the decision or problem it is meant to clarify.
1. Set the context
Write the situation, owner, objective, time horizon and constraints. Do not fill a field just because the template has one; mark it unknown when evidence is missing.
2. Gather the inputs
Use the smallest set of real inputs needed to make the decision. Prefer customer evidence, financial records, observed behaviour and documented commitments over assumptions.
3. Complete the tool
Fill each section with a concrete observation or decision. Where two answers conflict, record the conflict instead of averaging it away.
4. Make the decision visible
End with: decision, owner, next action, deadline, risk, and what would change the decision.
5. Review after use
Return to the document after the relevant period and compare the original assumptions with what actually happened. Keep the lesson, not just the completed form.
Common misuse
Do not use a completed template as evidence that the underlying problem has been solved. The tool improves thinking and consistency; the business result still has to be observed.
Take it into your work
Do something with what you just read.
Save it for later, mark the passage that matters, or open your SOE workspace and keep thinking.
Takeaways
What to carry forward
- → Use the template as a living operating document. Forecast, record actuals, review variances, update assumptions and keep the cash position visible.
- → [1] FDIC, Money Smart for Small Business, Managing Cash Flow: https://www.fdic.gov/consumer-resource-center/mssb-m10-pg.pdf [2] U.S. Small Business Administration, “5 Classic Fails in Budgets and Forecasts”: https://www.sba.gov/blog/2019/2019-07/5-classic-fails-budgets-forecasts/
- → SOE methodology: the template is editorial synthesis. The cited institutional sources support the budgeting, forecasting, cash-flow and plan-versus-actual principles. No founder performance claim or unsupported numerical result is asserted.
Forecast, record actuals, investigate meaningful variances, update assumptions and keep cash visible. The budget is working when it changes what the founder does next.