Blog

How to Make a Small Business Monthly Budget (Budget vs Actual, Step by Step)

Last updated: 9 October 2026

By Bolde team

Digital tools & templates · Based in Finland

A budget for a small business does not have to be a forecast for the whole year or a document only an accountant understands. The version that actually gets used is much simpler: one page per month that says what you expected to earn and spend, what really happened, and the difference. That comparison, budget vs actual, is where the useful decisions come from. This guide shows how to set one up, which categories to use, and a 30-minute monthly review routine.

What “budget vs actual” means

For every line in your budget you keep three numbers:

• Budget: what you planned at the start of the month.
• Actual: what really came in or went out, taken from your bank account or bookkeeping.
• Difference (variance): actual minus budget.

The budget itself is just a guess. The difference is the part that teaches you something: which costs keep creeping up, which income you overestimate, and which months are always quieter than you think. After three or four months your guesses get noticeably better, and that alone makes planning calmer.

Step 1: Pick categories you will actually use

Too many categories and you will stop filling it in. Too few and you cannot see where money goes. For most freelancers and small shops, 8–12 expense lines and 2–3 income lines are plenty. Group them like this:

Two practical rules: name categories the same way every month so the sheet can add them up, and put anything rare into “Other” until it happens often enough to deserve its own line.

Step 2: Set this month’s budget

1. Start with fixed costs. Rent, software, insurance and accounting barely change. Copy them from last month.
2. Estimate income conservatively. Count confirmed work and a realistic share of likely work. If you have open invoices, the invoice tracker guide shows how to see what is actually due this month.
3. Estimate variable costs from income. If materials are usually about 20% of product sales, budget them that way instead of picking a round number.
4. Decide set-asides before owner pay. Tax and a small buffer come first; what is left is what you can safely pay yourself.
5. Adjust for the season. Holiday months, summer breaks and big yearly bills belong in the month they happen, not spread evenly.

Step 3: Log actuals as they happen

Keep a simple transaction log on a second tab: date, description, category, amount in, amount out. Once a week, copy from your bank app or download the statement and categorise each line. Then the budget tab can total each category automatically. If the log is on a tab called Log, with categories in column C and amounts out in column E, the actual for an expense category in A5 for October 2026 is:

=SUMIFS(Log!E:E,Log!C:C,A5,Log!A:A,">="&DATE(2026,10,1),Log!A:A,"<"&DATE(2026,11,1))

And the difference column is simply =C5-B5 (actual minus budget), with a percentage next to it: =IF(B5=0,"",(C5-B5)/B5). Add conditional formatting so expense lines more than 10% over budget turn amber. Remember that for income, a negative difference is the warning sign.

Worked example: a fictional ceramics studio

Kettu Ceramics is an invented one-person studio that sells online and runs small workshops. All numbers below are made up for the example. Here is its October budget vs actual:

The totals look almost on plan, but the lines tell a more useful story:

• Workshops beat the plan by 25%, and materials and kiln electricity went up with them. That is a healthy overspend: it bought income.
• Online sales were 9% under budget, and marketing was €90 under. Those two may be connected. Next month’s question is whether the planned marketing should actually happen.
• Fixed costs were exactly on budget. Good: no need to look at them again until something changes.

The 30% tax set-aside is only a placeholder for the example. Your real share depends on your country, business form and income, so ask your tax office or accountant for a sensible percentage.

The 30-minute monthly review

Put a recurring half hour in your calendar for the first working day of each month. Go through the same five steps every time:

1. Close the month (10 min). Make sure every bank transaction is in the log and categorised. Mark paid invoices as paid.
2. Read the differences (5 min). Look only at lines more than about 10% or €50 off budget. Everything else is noise.
3. Write one sentence per big difference (5 min). “Workshops sold out, more clay needed.” “Marketing paused, sales dipped.” Short notes are what you will thank yourself for in a year.
4. Move the money (5 min). Transfer the tax set-aside and the buffer to a separate account, then pay yourself.
5. Set next month’s budget (5 min). Copy this month, adjust for what you learned and for the season ahead.

That is it. Thirty minutes, once a month, is enough to notice a creeping subscription, a price that no longer covers materials, or a quiet season coming before it hurts.

Common budgeting mistakes

• Budgeting income from hope. Use confirmed work and a cautious share of likely work. Surprises should be pleasant ones.
• Mixing personal and business money. A separate business account makes the log ten times easier.
• Forgetting yearly bills. Insurance, domain names and software renewals hit once a year. Either budget them in their month or save a twelfth each month.
• Only looking at totals. A business can hit its total while one product quietly loses money. The lines are where the information is.
• Prices that never move. If materials and fees keep rising, the budget will show it. That is the moment to revisit your prices; the freelance pricing guide walks through the maths for service work.

Where the budget fits

A budget is one piece of a simple system that just runs, an idea we wrote about in what Finland’s data center boom teaches small businesses. Income comes from your paid invoices, upcoming income from the deals in your client tracker, and if you sell physical products, stock levels from a simple Excel inventory tracker.

If you would like a finished version, the Bolde Small Business Budget Spreadsheet has a monthly budget vs actual for the whole year, a transaction log that fills the categories for you, profit and cash balance, and a dashboard with your top expenses and an income vs expenses chart. It works in Excel, Google Sheets and LibreOffice, with no macros.

Questions

How do I make a monthly budget for a small business?

Pick 8–12 expense categories and 2–3 income lines, set a budget for each at the start of the month, log actual income and costs as they happen, and compare budget vs actual at the end of the month. Use what you learn to set next month’s budget.

What is a budget vs actual report?

It is a table that shows, for each category, what you planned, what really happened and the difference between them. The differences show where your plan was off and where to act.

How often should a small business review its budget?

Once a month is enough for most small businesses: a short review on the first working day of the month. Log transactions weekly so the monthly review only takes about half an hour.

Bolde · hello@bolde.fi