You open a spreadsheet, you stare at a blank first row, and you freeze. I know that feeling. The first time I built a budget for a real business — a two-person consulting outfit running on one personal credit card and a lot of hope — I typed "Revenue" in cell A1 and then sat there for twenty minutes like the spreadsheet owed me an answer.
It didn't. A budget is not a document you find. It's a set of guesses you commit to, then correct. That's the whole secret, and it's the part most guides skip because it doesn't sound authoritative.
So let's do this properly: how to create a business budget from scratch, when you have no history, no accounting software, no bookkeeper, and no idea whether your revenue assumptions are sane. By the end you'll have a working structure you can build in an afternoon.
Key takeaways
- Starting from zero means you build a bottom-up forecast from real unit assumptions, not a guess at a total.
- Your accounting budget and your cash flow budget are two different documents. Confusing them is the most common early mistake.
- Plan in three scenarios — low, realistic, high — and run the business on the low one.
- Build it in a spreadsheet first. Software comes later, once you know what you actually need to track.
- Review monthly, adjust quarterly. A budget you never touch is decoration.
- Leave a cash buffer. If your plan has no slack, one late client payment breaks it.
Why building a budget from scratch is a different animal
Most budgeting advice assumes you already have something to work with. Twelve months of bank statements, a profit and loss report, a rough sense of what a normal month looks like. If you have that, budgeting is mostly arithmetic.
From scratch, you have none of it. And that changes the job.
What you actually lack at the start
You're missing three things, and each one needs a different workaround:
- Historical data — no past months to average. You replace it with unit-level assumptions.
- Category structure — you don't know what to call your expenses yet. You borrow a starter chart of accounts and adapt it.
- Confidence — you'll second-guess every number. That's fine. The point of round one is to be approximately right, not precise.
Here's what I got wrong early on: I tried to build a "complete" budget in one sitting, with every line item perfected. I spent a weekend on it, produced something beautiful, and abandoned it in three weeks because reality didn't match my spreadsheet and I had no mechanism for handling that.
The version that worked was uglier. Roughly twenty line items, half of them estimates I flagged in yellow, revised every month for the first quarter. That one survived.
The one decision that matters most
Before you type anything, decide what your budget is for. There are two honest answers:
- To know whether you can pay yourself and stay solvent.
- To decide where to spend next.
Almost every founder says the second and actually needs the first. If you're pre-revenue or in your first eighteen months, build a survival budget: revenue, fixed costs, cash runway. Nothing else. You can add marketing allocations and departmental budgets once you have a month or two of real numbers behind you.
How to create a business budget from scratch, step by step
This is the sequence I use now. It takes about three hours for a small business, and most of that is spent thinking, not typing.
Step 1: list your fixed costs first, not your revenue
Counter-intuitive, but it works. Revenue is the number you're least able to predict and most tempted to inflate. Fixed costs are knowable today, to the cent.
Write down everything you must pay regardless of whether you sell anything:
- Rent or coworking desk
- Software subscriptions — and be honest, that's probably more than you think
- Insurance, accounting fees, bank charges
- Minimum loan or lease payments
- Your own minimum draw, if you're paying yourself
That total is your monthly survival number. It's the most useful single figure in your entire business. Everything else is built around it.
Step 2: build revenue bottom-up, not top-down
This is where from-scratch budgets either work or fall apart.
A top-down forecast says: "The market is worth X, we'll capture 2%." It feels strategic and it's nearly useless at your stage, because you have no way to test the 2%.
A bottom-up forecast says: "I need 12 clients at an average of €2,400 per project, delivered over four months, with a close rate of about one in five conversations." Now every assumption is falsifiable. You can test your close rate in a week.
My rule of thumb: if you can't name the unit — clients, orders, hours, seats — your revenue line is a wish, not a forecast.
| Approach | How it works | When it fits | Main risk |
|---|---|---|---|
| Top-down | Market size × target share | Pitching investors, mature markets | Unfalsifiable assumptions |
| Bottom-up | Units × price × frequency | From-scratch budgets, early-stage | Tedious, needs unit clarity |
| Historical | Last year ± growth adjustment | Established businesses | Useless if you have no history |
Step 3: separate variable costs from fixed ones
Fixed costs you pay anyway. Variable costs scale with activity — payment processing, raw materials, contractor hours, shipping, ad spend.
Why the split matters: variable costs should be expressed as a percentage of revenue, not a flat amount. If your payment processor takes 2.4% of every transaction, that line moves with sales, and a fixed euro figure will mislead you every single month.
Here's a rough shape that holds up for a lot of small service and product businesses starting out. Treat it as a starting point to argue with, not a law:
- Direct delivery costs: 20–35% of revenue
- People: 30–45%
- Premises and admin: 5–12%
- Marketing: 5–15%, higher if you're buying growth
- Everything left over is your margin — and if it's under 10%, the model probably doesn't work yet
Step 4: add a cash flow budget, separately
This is the section most from-scratch guides skip entirely, and it's the one that kills businesses.
Your accounting budget is based on when money is earned. Your cash flow budget is based on when money arrives in the bank. For a business invoicing clients on 30- or 60-day terms, those two calendars can be a month and a half apart.
I watched a small agency with a healthy-looking profit line nearly miss payroll because two invoices landed eleven days late. The P&L said fine. The bank account said otherwise.
Build the cash flow view as a simple grid: months across the top, cash in and cash out down the side, closing balance at the bottom. If any month's closing balance goes negative, you've found your real problem — and you found it before it happened, which is the entire point.
Quick check: is your cash buffer big enough?
A common starting benchmark is three to six months of fixed costs held as cash. If your fixed costs are €6,000 a month, that's €18,000 to €36,000 sitting accessible. If you're nowhere near it, that gap becomes your first budget priority — ahead of hiring, ahead of marketing spend.
How to create a business budget from scratch in Excel
You don't need software. A spreadsheet is genuinely the right tool for year one, because it forces you to understand your own numbers instead of accepting whatever a dashboard shows you.
The sheet layout that works
Five tabs is enough:
- Assumptions — units, prices, close rates, cost percentages. Every other tab references this one.
- Revenue — monthly, built from the assumptions.
- Costs — fixed and variable, split into two blocks.
- Cash flow — the timing view, with payment delays built in.
- Dashboard — budget versus actual, updated monthly.
The single most valuable habit: put every assumption on its own tab and reference it. When your close rate turns out to be one in eight instead of one in five, you change one cell and the whole model updates. I built my first budget with hardcoded numbers scattered across four sheets and updating it took an entire evening. Never again.
The formulas you actually need
That's it. If you're reaching for nested lookups and dynamic arrays, you're overbuilding. From-scratch budgets fail from complexity far more often than from missing features.
Common errors when you start from zero
These are the ones I've made personally, plus a few I've watched others make repeatedly.
Error 1: forecasting revenue optimistically, then spending against it
Revenue guesses tend to be 30–50% too high in year one. Not because founders are dishonest, but because delays compound: the client who said yes in March signs in May and pays in July.
Fix: run the business on your low scenario. If the realistic case shows up, you have a surplus. If the low case shows up, you survive.
Error 2: forgetting the annual costs
Insurance renewals, accounting packages, domain and software annual plans, tax filings, equipment replacements. They don't appear in a typical month and then they all arrive together. Spread them across twelve months in your budget so no single month takes the hit.
Error 3: treating the budget as a finished document
A budget built in January and never opened again is a historical artifact. The useful version gets a fifteen-minute review every month: what did I predict, what actually happened, why the gap?
Track the variance. If your marketing line is consistently 40% over, either your estimate was wrong or your spending is. Both are worth knowing.
Error 4: budgeting profit instead of cash
Covered above, but it deserves repeating because it's the one that closes businesses that look profitable on paper.
Which tools should you actually use?
Start with what you have. My honest ranking for a business building its first budget:
- Spreadsheet (Excel, Google Sheets, LibreOffice) — free to near-free, fully transparent, and you learn your own model. Best choice for months one through twelve.
- Accounting software with a budgeting module — worth it once you're processing more than roughly fifty transactions a month, or once you have staff to pay.
- Dedicated FP&A tools — genuinely useful, genuinely premature for a business with no historical data. Revisit when you have at least a year of actuals.
One practical note on formats: export to PDF only when you need to share the plan with a bank, an accountant, or a partner. PDFs are for reading. Keep the working file in a spreadsheet, or you'll be retyping numbers forever.
How often should you review and revise?
Monthly review, quarterly reforecast. That rhythm has held up for me across very different businesses.
The monthly review is short: enter actuals, compare to budget, note the three biggest gaps, decide whether each is a timing issue or a real change. Fifteen minutes if your spreadsheet is built properly.
The quarterly reforecast is longer. You update your assumptions — close rates, prices, costs — and roll the next twelve months forward. This is what people mean by a rolling budget: it never ends, it just keeps extending.
If a quarter goes badly, resist the urge to rebuild everything from scratch. Adjust the assumptions that were wrong. Most of your structure is still valid, and rebuilding from zero every three months is how budgets get abandoned.
What to do in your first week
Don't aim for a finished budget. Aim for a first draft with visible seams.
Block two hours. Open a blank spreadsheet. List your fixed costs. Build one revenue line bottom-up with units you can actually count. Add a cash flow tab with payment delays. Mark every number you're unsure about in yellow. Then stop.
The yellow cells are your real to-do list for the next month — each one is an assumption you can go out and test with a real conversation, a real quote, a real sale. By the time you've replaced half of them with observed numbers, you'll have something better than a plan. You'll have a model of your own business that updates itself as you learn.
And the blank first row? It stops being scary around the third month, when you realise the number in it was wrong and the business survived anyway.
