Small business budget template
A small business budget is your plan for the year: what you expect to sell and spend, month by month. This free template has a column for each month and a yearly total. In Excel it works out gross profit, net profit and margin as you type, so you can test a price change or a hire first.
Updated November 2026
What does the template look like?
Type your numbers in the white cells. Totals and results add themselves in Excel. Here it is with sample figures, so you can see how it fills in.
| Line | Jan | Feb | Mar | More |
|---|---|---|---|---|
| Income | ||||
| Product sales | $18,000.00 | $17,000.00 | $21,000.00 | ... |
| Service sales | $6,000.00 | $6,000.00 | $6,000.00 | ... |
| Other income | $0.00 | $0.00 | $0.00 | ... |
| Total income | $24,000.00 | $23,000.00 | $27,000.00 | ... |
| Cost of sales | ||||
| Materials and inventory | $7,200.00 | $6,800.00 | $8,400.00 | ... |
| Direct labor | $2,500.00 | $2,500.00 | $2,500.00 | ... |
| Total cost of sales | $9,700.00 | $9,300.00 | $10,900.00 | ... |
| Gross profit | $14,300.00 | $13,700.00 | $16,100.00 | ... |
| Expenses | ||||
| Payroll and taxes | $5,400.00 | $5,400.00 | $5,400.00 | ... |
| Owner salary | $4,000.00 | $4,000.00 | $4,000.00 | ... |
| Rent | $2,200.00 | $2,200.00 | $2,200.00 | ... |
| Marketing | $900.00 | $900.00 | $1,200.00 | ... |
| Software and phone | $420.00 | $420.00 | $420.00 | ... |
| Insurance | $380.00 | $380.00 | $380.00 | ... |
| Professional fees | $650.00 | $650.00 | $650.00 | ... |
| Vehicle and travel | $500.00 | $500.00 | $500.00 | ... |
| Other | $300.00 | $300.00 | $300.00 | ... |
| Total expenses | $14,750.00 | $14,750.00 | $15,050.00 | ... |
| Net profit | -$450.00 | -$1,050.00 | $1,050.00 | ... |
| Net margin | -1.9% | -4.6% | 3.9% | ... |
How do I build a budget?
Start with last year's monthly profit and loss. Copy each line into the month it happened, then adjust: a price increase from April, a new hire in June, a lease renewal in September. Seasonality matters more than people expect, so budget each month, not one twelfth of the year.
What should I do with it during the year?
Compare it with actual results every month. Big gaps tell you something: a cost creeping up, a slow season longer than planned, a price that isn't holding. Re-forecast the remaining months when something big changes. A budget that's never compared with actuals is just a guess.
Budget or cash flow forecast?
The budget plans profit. The 13-week cash flow forecast plans cash, including loan payments, owner draws, tax payments and the gap between invoicing and getting paid. Most businesses need both. Our tax planning and CFO service builds them with you.
General information, not tax advice for your situation.
Want a plan for this year?
We run your numbers and show you the options.
See our tax planning and CFO serviceWhat percentage of revenue should go to each expense?
It varies a lot by industry. Use your own history first, then compare with industry figures from a trade group or your lender.
Should I include taxes in my budget?
Include payroll taxes and sales tax costs. Plan income tax payments in your cash forecast, since they're paid quarterly.
How often should I update the budget?
Compare monthly and re-forecast quarterly, or sooner if something big changes.
Tell us what's messy. We'll tell you what it takes.
Tell us what you need and get a fixed price before any work starts. No pressure and no contract.