Business Budget Planner

Build an annual operating budget that a small or mid-sized business will actually steer by. The stance is unsentimental: revenue is modeled bottom-up and sanity-checked against history, costs are split by how they behave rather than where they sit in the ledger, and the downside scenario is written before anyone falls in love with the base case. A budget that only exists in its optimistic form is a wish, not a plan.

When to use this skill

• A business needs its first real budget, or the annual planning cycle is starting
• Actuals exist but planning happens by gut feel and the bank balance
• A founder wants to know how many months of runway a plan implies
• Budget-versus-actual reviews keep surprising everyone and nobody knows why
• A hire, a lease, or a big commitment needs to be tested against the numbers first

Required inputs

• Trailing twelve months of actuals by month and category, if they exist at all
• The revenue model: what is sold, at what price, on what cycle (recurring, project, unit sales)
• The headcount plan, including roles already committed but not yet started
• Known commitments: leases, insurance, debt service, contracted spend
• Opening cash position and any credit facilities

Workflow

1. Baseline from actuals, never from aspiration. Lay out the trailing twelve months by category, mark one-off items so they do not silently repeat, and note the run-rate of each category entering the new year.
2. Model revenue bottom-up: drivers times rates — customers times average price, projects times average fee, units times margin. Then check it top-down against history. If the plan implies growth more than about one and a half times the trailing rate, it needs a written justification naming what changed, or it gets cut.
3. Sort costs by behavior, not department:
   • Fixed: rent, salaries, insurance, core tooling — paid regardless of revenue
   • Variable: cost of goods, payment fees, usage-priced services — scale with revenue as a percentage
   • Step: costs that jump at thresholds — the next hire, the bigger space; model each with its trigger, not as a smooth curve
4. Load people costs fully: salary plus payroll taxes, benefits, equipment, and tooling, typically 1.2 to 1.35 times base salary depending on locale. Verify the multiplier locally; it is the most common understatement in first budgets.
5. Build three scenarios from the same model: base, downside (revenue minus 20 percent, costs sticky), and upside (plus 20 percent, watching the step costs it triggers). For the downside, write the pre-committed actions now — what gets cut after two consecutive trigger months — while heads are cool.
6. Add a contingency line of five to ten percent of operating spend, owned by one named person. Contingency smeared invisibly across categories is how budgets lie.
7. Translate to cash, not just profit: opening balance, monthly movements with real payment timing, closing balance, and a marked cash floor. The month the downside scenario crosses the floor is the single most important number in the document.
8. Set the review rhythm: monthly budget-versus-actual, variances beyond ten percent and a materiality threshold get a one-line explanation, and the forecast is re-cut quarterly rather than rewritten every month.

Output format

Deliver the budget as a category skeleton with monthly columns, the three-scenario summary, the cash line with the floor marked, and the review calendar. Skeleton:

REVENUE      recurring | services | other
COGS         direct costs | payment fees
GROSS MARGIN
OPERATING    people (loaded) | facilities | tooling | marketing
             professional services | contingency (named owner)
OPERATING RESULT
CASH         opening | in | out | closing | floor: [amount]

Common failure modes

• Growth targets copied from ambition while costs are copied from history
• Step costs modeled as smooth curves, so the budget misses the cliff months
• One-off items left in the baseline, quietly repeating forever
• Contingency smeared across categories where nobody can see or defend it
• A profit budget with no cash view, discovering the floor breach in real time
• Re-forecasting weekly until the budget stops meaning anything at all

Guardrails

• This is a planning aid, not financial, tax, or accounting advice; tax treatment, payroll obligations, and reporting requirements vary by jurisdiction and must be confirmed with a qualified accountant or adviser
• Never plug revenue to make the bottom line work; if the plan does not close, say so and show the gap
• State precision honestly — round to the hundred or thousand; a budget quoted to the cent is claiming knowledge nobody has
• Every assumption a reviewer might challenge is written down next to the number it produced