Budgeting for a company: how to build a budget that actually works

Budgeting for a company: how to build a budget that actually works

A step-by-step process, the right structure, and the typical mistakes that make budgets drift from reality by the end of Q1.

Most companies build a budget. Few companies actually use it.

The pattern usually looks like this: at year-end the finance manager or the owner pulls the numbers together, builds a 12-month spreadsheet, and approves the plan. By February a few assumptions have already failed. By May the budget no longer matches reality. By August everyone has forgotten about it.

The problem isn't that budgeting doesn't work. The problem is how it's built. This article walks through the process, the correct structure, and the mistakes that turn a budget into a formality.

Why a budget if you already do plan/actual analysis?

The first question small business owners ask: why spend time on a budget if I can just watch the actuals?

Because without a budget there's no benchmark to compare actuals against. You see revenue of $15,000 — is that good or bad? Without a plan you can't tell. If the plan was $20,000, that's a signal to dig into a 25% shortfall.

A budget serves three functions nothing else replaces.

Resource planning. When to hire, when to launch a marketing push, when you can afford new equipment — every one of those decisions has a financial footprint. A budget lets you see whether the cash will be there in advance, not the day the invoice is due.

Team alignment. An approved budget is a contract between the owner and the management team: how much can be spent, on what, and when. Without that contract every function pulls in its own direction, and the owner keeps discovering new unplanned costs.

Deviation control. A budget gives you the baseline for plan/actual analysis. You don't just see "costs went up" — you see "marketing is 30% over budget because we launched an extra campaign." That's the difference between managing and reacting.

A budget doesn't start with numbers

The typical mistake is opening Excel and starting to fill in rows: "revenue," "salaries," "rent." What you get is a set of numbers with no logic behind them.

The right sequence is different.

Step 1. Define this year's strategic priorities

Before any number lands in the spreadsheet, answer this: what is the company planning to do this year?

Launch a new product? Enter a new market? Build a sales team? Reduce dependency on one large client? Break even?

Every strategic goal leaves a financial footprint. If the goal is to build a sales team, the budget will need lines for "SDR and AE salaries," "CRM," "training," and "lead-gen marketing." No goal — no rows, or rows that appear chaotically.

Write down 3–5 strategic priorities. Each becomes the anchor for a section of the budget.

Step 2. Build the revenue budget bottom-up

The revenue budget is the most important and hardest part. Everything else depends on it.

Two approaches: top-down and bottom-up.

Top-down: the owner says "I want $300,000 next year" and splits that number across months and channels. Easy to do, dangerous to trust — the number is pulled out of thin air.

Bottom-up: you start from specifics — how many leads current marketing generates, what the conversion rate is, the average deal size, the pipeline in progress. Then you build the forecast from there. Takes longer, delivers realistic numbers.

For SMBs we recommend bottom-up, at least for the first year of detailed budgeting.

Structure of a revenue budget:

Channel 1: Direct sales
  New deals per month: 8
  Average deal size: $1,800
  New-deal revenue: $14,400/mo

Channel 2: Existing clients (renewals + upsell)
  Starting MRR: $22,000
  Expected upsell growth: +$1,500/mo
  Churn: −$800/mo
  End-of-month MRR: $22,700

Total revenue: $37,100/mo

If there's seasonality — don't spread evenly, use the real historical shape.

Step 3. Build the cost budget by category

Costs split into fixed and variable — and the planning approach differs.

Fixed costs — don't depend on sales volume: rent, base salaries, subscriptions, loan payments. Easy to plan precisely: you know the amount and the date.

Variable costs — depend on activity level: cost of goods sold, sales bonuses, variable marketing spend, logistics. Planned as a percentage of revenue or per unit.

Practical cost budget structure:

COGS:
  Materials and goods: % of revenue or fixed cost per unit
  Production / delivery payroll
  Direct project costs

OpEx:
  Personnel (admin, sales, marketing)
    – salaries
    – bonuses and KPI payouts
    – payroll taxes
  Marketing and advertising
    – paid ads
    – content and SEO
    – events and conferences
  Infrastructure
    – office rent
    – IT and subscriptions
    – utilities
  Administrative
    – accounting and legal
    – banking fees
    – insurance
  Other

CapEx:
  Equipment
  Fit-out and improvements
  Product development (if capitalised)

Step 4. Build a forecast P&L

Once revenue and cost budgets exist, the forecast P&L falls out of them. It isn't a separate table — it's the result of the two previous steps.

Metric	Q1	Q2	Q3	Q4	Year
Revenue	$105,000	$118,000	$130,000	$147,000	$500,000
COGS	$42,000	$47,200	$52,000	$58,800	$200,000
Gross profit	$63,000	$70,800	$78,000	$88,200	$300,000
Gross margin	60%	60%	60%	60%	60%
OpEx	$48,000	$51,000	$54,000	$57,000	$210,000
EBITDA	$15,000	$19,800	$24,000	$31,200	$90,000
EBITDA margin	14%	17%	18%	21%	18%
D&A	$2,000	$2,000	$2,000	$2,000	$8,000
Interest	$1,500	$1,500	$1,500	$1,500	$6,000
Taxes	$1,150	$1,615	$2,025	$2,785	$7,575
Net income	$10,350	$14,685	$18,475	$24,915	$68,425

Step 5. Build the cash flow budget

The forecast P&L shows planned profit. It doesn't answer: will there be enough cash in February to make payroll?

For that you need a Cash Flow budget — a month-by-month plan of inflows and outflows. Build it from the P&L, adjusted for:

• customer payment terms (30-day terms shift inflows);
• supplier payment terms;
• large one-off outflows (capex, quarterly tax, insurance);
• loan repayments.

Even a simple monthly cash flow — opening balance, inflows, outflows, closing balance — already shows which months will hit a cash gap and gives you time to prepare.

Step 6. Define the KPIs the budget will be measured by

A budget isn't just a table of numbers — it's a set of targets you track against. Pick 5–7 KPIs that will be the "pulse" of the budget:

• revenue plan vs actual (monthly);
• gross margin %;
• EBITDA %;
• key cost lines vs budget;
• Cash Flow (bank balance vs plan);
• key operational metrics (deals, average check, CAC — depending on the business).

Typical budgeting mistakes

Mistake 1. Building the budget as "last year + X%"

"Last year revenue was $200,000 — let's set $240,000, that's 20% growth." Sounds reasonable, but hides the real question: why 20%? What will change in the way you operate to deliver it? Which channels bring the uplift?

A "last year + %" budget is a forecast without a strategy. It doesn't force you to think about how to reach the goal and doesn't tie spending to specific initiatives.

Do it right: build the revenue budget from drivers — number of customers, average check, conversion, new channels. Then 20% growth is a consequence of concrete actions, not a wish.

Mistake 2. An optimistic scenario without a conservative one

Owners tend to plan optimistically: "if everything goes well." But a budget isn't a dream. If the optimistic plan doesn't hit, the company can end up with the costs already committed (people hired, contracts signed, ads live) and no revenue to cover them.

Do it right: build three scenarios.

• Base case — realistic, based on current trajectory without major changes.
• Conservative — what happens if revenue lands 20–30% below base. Does the business survive? Which cost lines get cut first?
• Optimistic — what happens if things go better than plan. What resources are needed to handle the growth? (Uncontrolled growth without resources is also a problem.)

Approve the base case as the working budget, but keep the conservative case as your "what if" playbook.

Mistake 3. Ignoring seasonality

Average monthly revenue is $30,000, so every month is $30,000 — that's how most owners do it. If your business has seasonality, that flat split distorts the picture: in summer you'll show "underperformance," in winter "overperformance," even though both results were exactly what you should have expected.

Do it right: look at historical seasonality and spread the revenue budget accordingly. If Q4 traditionally delivers 35% of the year — plan 35%, not 25%.

Same for costs: if a season requires stocking up on inventory or launching a campaign, costs peak ahead of the season, not evenly.

Mistake 4. Missing capex and one-off payments

Recurring costs are easy to plan because they repeat. One-off and capital costs often get forgotten: new equipment, office fit-out, annual licences paid once a year, an offsite team event, recruiter fees.

The result: the budget looks on track, but monthly cash flow is worse — because "unexpected" costs keep showing up that were actually entirely predictable.

Do it right: list every one-off and non-recurring cost and pin each to a specific month. Fit-out — March. Annual licence — June. Team event — December. It takes an hour and removes most of the cash-flow surprises.

Mistake 5. Ignoring the owner's salary or dividends

The owner "lives off the business," but the budget doesn't show it. EBITDA looks great — until you realise all of it is effectively the owner's salary, and there's nothing left for growth.

Do it right: build the market-rate cost of the owner's role into the budget as a line item. If the business is still profitable after that — it really is profitable. If not — that's a signal the current model doesn't scale without the owner in the operational role.

Mistake 6. A budget without owners

The spreadsheet is filled in, the numbers approved — but it's not clear who is accountable for each line. Marketing budget $15,000 for the quarter: who decides how to spend it? Who reports if it goes over?

Do it right: for each material cost line assign an owner and a limit within which they can approve spend on their own. Anything above the limit needs escalation.

Mistake 7. Building a budget once and never updating it

A budget built in November can lose meaning by June. A new big client landed in March. A supplier raised prices in April. A key employee left in May. All of those change the financial picture — but the budget stays static and the plan-vs-actual comparison becomes less and less useful.

Do it right: run a reforecast once a quarter — review the forecast for the next 2–3 quarters using the latest data. Keep the original budget frozen as the baseline for measuring against strategic goals, and use the reforecast as your operating reference.

Mistake 8. Budget in Excel with no link to the accounting

If the budget lives in one file and the actuals in another, plan/actual becomes manual work. Every month someone re-keys the numbers, hits classification mismatches, and burns a day sorting it out.

Do it right: the budget's structure must match the management accounting structure. Same line items, same names, same allocation logic. Then plan/actual takes an hour, not a day.

How to run plan/actual analysis against the budget

A budget is a tool, not an archive document. To make it work you need regular variance analysis.

When: monthly, no later than the 7th–10th of the following month (after month-end close).

What to analyse: for each key line — three columns: plan, actual, deviation in % and in absolute terms. Deviations above 10% on material lines are worth investigating.

Line	Plan	Actual	Deviation
Revenue	$37,000	$31,500	−$5,500 / −15%
COGS	$14,800	$13,200	−$1,600 / −11%
Gross profit	$22,200	$18,300	−$3,900 / −18%
OpEx	$16,500	$17,800	+$1,300 / +8%
EBITDA	$5,700	$500	−$5,200 / −91%

Immediately visible: revenue is 15% below plan and OpEx is 8% above. Combined, EBITDA is 91% below plan. Without plan/actual, those two isolated deviations could easily have been missed.

What to do with deviations: for every material deviation add a one-line explanation and an action: fix, replan, or accept as the new normal.

Not every deviation is a problem. Revenue 15% below plan can be a problem (client lost) or a decision (you deliberately walked away from a low-margin segment). What matters isn't the number itself — it's understanding the cause.

The budgeting process: when and how

An effective budgeting process is not one meeting or one week of work. Here's a minimum calendar for an SMB:

• September–October. Review the current year: where the deviations are, what surprised you, what to build into next year's plan.
• October–November. Set strategic priorities and align with the team. Collect operational inputs for the revenue budget (sales forecasts, pipeline, marketing plans).
• November. Build the budget: revenues, costs, P&L, Cash Flow. Align with function heads.
• December. Finalise and approve. Communicate to the team: what's planned, what the priorities are, what the limits are.
• Every month during the year. Month-end close, plan/actual analysis, a short deviation report.
• Every quarter. Reforecast for the coming quarters. Adjust plans where material changes have occurred.

Free budget template

We've prepared a Google Sheets budget template that includes:

• revenue budget split by channels and months;
• cost budget by category (COGS, OpEx, CapEx);
• forecast P&L with automatic margin calculations;
• monthly Cash Flow budget;
• plan/actual analysis table with automatic variance calculations;
• three scenarios: base, conservative, optimistic.

The template structure matches management-accounting logic — so comparing actuals to plan doesn't require any manual re-keying.

👉 Download the free budget template →

Other articles in the series: «How to build a P&L: data, structure and common mistakes», «Cash Flow without gaps: 3 rules of a payment calendar», «How to build a P&L that actually helps you make decisions».