Creating a Business Budget: A Step-by-Step Guide for Success

Creating a business budget: a step-by-step guide that actually survives contact with reality

A client called me last March, three weeks before her payroll run, asking why her "profitable" quarter had left her account empty. She had revenue. She had invoices. She did not have a business budget that tracked when money actually moved. That conversation is why I write this guide the way I do.

Most budgeting tutorials teach you to list income, list expenses, subtract one from the other, and call it planning. That approach fails the moment a client pays 60 days late or a supplier raises prices mid-quarter. Below is the process I use with the small businesses I advise, and the process I use on my own one-person operation. It includes the boring parts nobody writes about: cash timing, contingency margins, and the categories you will regret forgetting.

Why most business budgets fail before they are finished

Here is the thing nobody tells you: a budget fails because of what you leave out, not what you put in.

I built my first real company budget in a spreadsheet with 14 tabs. I was proud of it. Six weeks in, it was useless, because I had budgeted €6,000 in consulting revenue for a month when the actual cash landed in the following month. My spreadsheet said profit. My bank said otherwise. The gap between those two numbers is where most small businesses get into trouble.

The projection trap

A budget built on optimistic revenue projections is not a plan, it is a wish. When you estimate income, ask yourself one question for every line: what is the minimum I would bet on receiving this month?

If you are unsure, cut the number. I routinely reduce first-draft revenue projections by 20% before finalizing. That sounds pessimistic. It has saved me from overcommitting on hires twice.

Fixed versus variable: get this wrong and everything breaks

Fixed costs are things you pay whether or not you sell anything. Rent. Software subscriptions. Insurance. Your own salary if you take one. Variable costs move with activity — raw materials, contractor fees, payment processing, shipping.

The reason this distinction matters: fixed costs are what kill businesses in a slow quarter. Variable costs shrink naturally when volume drops. Fixed costs do not.

• Rent and utilities — fixed, usually monthly
• Software subscriptions — mostly fixed, and the category that quietly grows the fastest
• Contractor and freelance payments — variable, tied to project load
• Payment processing fees — variable, roughly 1.5–3% of each transaction depending on your provider
• Insurance — fixed, sometimes annual
• Your own draw or salary — fixed if you commit to it, painful to cut if you do not plan for it

When I audited my own subscriptions last year, I found €340 a month going to tools I had not opened in four months. That is €4,080 a year. Fixed costs have a way of becoming permanent if you do not review them on a schedule.

The step-by-step process for creating a business budget

The eight steps below are the sequence I follow. They are not glamorous, and they will take longer than you expect the first time. Plan for a full afternoon, not an hour.

Step 1: pull twelve months of actual numbers

You cannot budget forward without looking backward. Gather every bank statement, credit card statement, and payment platform export from the past year. Categorize them. If you use accounting software, run a profit and loss report and a cash-flow report side by side.

The point of this step is not to know what you spent. It is to see when you spent it and when your money came in.

Step 2: forecast revenue conservatively

Break revenue into recurring and non-recurring. Recurring revenue — subscriptions, retainers, contracts with renewal dates — is the foundation. Non-recurring revenue, like one-off projects, is the variable layer on top, and it should be discounted heavily.

If you are new and have no history, use your signed contracts plus a modest estimate of what you realistically expect to close. Do not include deals in negotiation.

Step 3: list every fixed cost

Go line by line through your last twelve months and identify anything that appears every month. Add it up. That total is your monthly survival number — the revenue you must generate just to break even before any variable spending.

This number is uncomfortable to look at. Look at it anyway.

Step 4: estimate variable costs against revenue

Variable costs scale with activity, so express them as percentages where possible rather than fixed amounts. If contractor costs run at roughly 25% of project revenue, budget them that way. Percentage-based budgeting means your costs automatically adjust when revenue moves, which keeps your margins stable.

Step 5: add a contingency line

Build in 8–12% of total expenses as a contingency buffer. This is not padding for inefficiency — it is the money that covers the equipment failure, the unexpected legal fee, the client who disputes an invoice. Businesses that skip this line end up funding surprises with debt.

Step 6: map the timing

This is the step most guides skip, and it is the one that matters most. Take your monthly revenue and shift it forward to reflect when payment actually arrives. If your average payment terms are net-30 and clients routinely take 45 days, your January invoice might not hit your account until March. Track your days sales outstanding — the average number of days between invoicing and payment — and apply it to your forecast.

I keep a running figure on this and adjust my budget monthly. When my average crept from 32 to 47 days over one quarter, I knew I had a collections problem, not a sales problem.

Step 7: build the spreadsheet

Start with twelve columns, one per month, and group your rows into four blocks: revenue, fixed costs, variable costs, contingency. Add a running cash position line at the bottom that carries forward each month. That bottom line is the number you check first when something goes wrong.

You do not need a forecasting tool. A spreadsheet with a cash carry-forward row does 90% of what paid software does for a small business.

Step 8: review and adjust on a schedule

Monthly for the first six months, then quarterly. Compare budgeted versus actual for every major line. Do not just look at the totals — look at the variance. A line that is consistently 15% over budget is not a mistake, it is a modeling error, and you should correct the model rather than the spending.

Budget line	Fixed or variable	How to set the figure	Review frequency
Rent and utilities	Fixed	Contract amount, no estimate needed	Quarterly
Subscriptions and software	Fixed	Last 12 months, cut anything unused for 3 months	Monthly at first
Contractor costs	Variable	Percentage of project revenue (roughly 20–30% in service businesses)	Monthly
Payment processing	Variable	1.5–3% of incoming revenue	Quarterly
Contingency	Neither — a buffer	8–12% of total expenses	Quarterly
Your own compensation	Fixed	What you need to live on, not what is left over	Annually

How to prepare a budget for a company in Excel

Excel is still the most practical tool for this, and I say that as someone who has tried the paid alternatives. The reason is simple: you control the structure, and a cash-forward model needs a specific structure that generic templates fight against.

The structure that works

Columns A through M: label column, then twelve months. Rows grouped in four sections with a subtotal row for each. At the bottom, one row called "Closing cash" that reads from the previous month's closing balance plus this month's net.

Three formulas do most of the work:

1. SUM for each category subtotal — keep categories on separate rows so you can see which one is moving.
2. Net cash per month — total revenue minus total costs.
3. Carry-forward — previous closing cash plus this month's net. This single row will tell you more about your business than any other number in the file.

One warning from experience: do not build more than about 40 rows on your first attempt. I once built a 200-row model and spent more time maintaining it than using it. A tight model you update monthly beats an elaborate one you abandon.

Does the process differ for a government budget?

The mechanics are similar but the constraints are different. Public-sector budgeting runs on a fixed fiscal cycle, follows formal appropriation rules, and typically involves public consultation and legislative approval before any spending is authorized. Revenue forecasting is also less flexible, since tax receipts and allocated funds do not adjust quickly to changing conditions.

If you work in or with a public body, expect longer timelines, heavier documentation, and stricter rules on moving money between categories. The core logic — forecast revenue, categorize costs, plan for timing, build a buffer — still holds. The approval process around it does not.

Budget and cash flow are not the same document

This distinction confused me for two years, so if it is confusing you, you are in good company.

Your budget is your plan: what you expect to earn and spend over a period. Your cash-flow forecast is your liquidity map: when money enters and leaves your account. A business can be profitable on its budget and still run out of cash, because profit is an accounting concept and cash is a physical reality.

The rule I follow: keep at least eight weeks of operating expenses in accessible cash. Not in an investment account, not in receivables you expect to collect, but available. That buffer is what lets you make calm decisions when a large client pays late.

Spoiler: that large client will pay late at some point. Plan for it.

Mistakes I made so you do not have to

• Budgeting on best-case revenue. I did this for two quarters and hired ahead of revenue that never arrived. Cost me four months of margin.
• Forgetting annual costs. Insurance, tax filings, software renewals. Divide them by twelve and include a monthly accrual, or they will ambush you.
• Not paying myself a fixed amount. I took whatever was left over, which meant my personal finances absorbed every business fluctuation. That is not a business, it is a gamble.
• Reviewing once a year. Twelve months of drift before you notice a problem is twelve months too long.
• Treating the budget as a ceiling. It is a guide, not a cage. If a channel outperforms, you reallocate. A budget that prevents you from investing in something that works is doing more harm than good.

The habit that matters more than the spreadsheet

Every business owner I know who has stable finances has one thing in common, and it is not a sophisticated model. They look at their numbers on a fixed schedule, without fail, even when the news is bad.

The spreadsheet is just the instrument. The discipline is the skill.

So here is my suggestion: build the rough version this week. Twelve columns, four categories, one carry-forward row. It will take you two hours and it will be wrong in at least three places. Update it next month, fix what broke, and keep going. By the end of the year you will have something more valuable than a perfect template — you will have an accurate picture of how your business actually works.

And the next time someone asks why a profitable quarter left their account empty, you will already know the answer.