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.

Example figures
LineJanFebMarMore
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 service
Questions

Still wondering?

Ask anything else on a free 30-minute call.

Book a call
What 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.

Get started

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.

Get a free quote

Your name, plus an email or a phone number, whichever you prefer.

A sentence or two is plenty. Please don't include Social Security numbers, bank or card numbers, or tax documents here.

Thanks. This is a design preview, so nothing was sent.