Wauvel
Toolkit

Building next year's operating plan (start now, not in December)

← All posts
By Blake EkelundSeptember 7, 2026 · 8 min read1 views

Most small businesses build next year's budget somewhere between Christmas and New Year's Eve, in about two hours, by taking this year's numbers and adding a growth percentage. Then it goes in a folder and nobody opens it again until someone asks in April why the numbers look nothing like it.

The problem is not the effort. It is the timing. A plan built in late December is a description of what you hope happens, because every decision that could have changed the outcome — hiring, pricing, a lease, a marketing commitment — needed to be made months earlier. Built in September, the same plan is a set of choices you still have time to make.

A plan is not a forecast

These get used interchangeably and they are different documents with different jobs. A forecast is your best guess at what will happen. A plan is what you are committing to make happen, and what you will spend to do it.

The distinction matters because it changes how you respond when reality diverges. A forecast that turns out wrong gets updated. A plan that turns out wrong triggers a decision — you either change what you are doing or you consciously accept the new trajectory. If your annual document cannot produce that moment, it is a forecast wearing a plan's clothes.

Build it in five layers, in this order

Order matters, because each layer constrains the next. Doing it backwards — deciding what you want to earn and reverse-engineering the revenue — is how you end up with a plan nobody believes.

  • 1. Revenue, by driver.Not last year plus 12%. Build it from the terms of your revenue engine — customers and churn, or capacity and utilization, or spend and conversion. If you cannot name the drivers, that is the first thing the exercise has told you.
  • 2. Cost of sales.Usually a margin percentage applied to the revenue build, adjusted for anything you know is changing — a supplier increase, a new product with different economics.
  • 3. People. Every role, its fully loaded cost, and the month it starts. This is the single biggest lever in the plan and the one most often entered as a lump sum, which hides exactly the timing question that matters.
  • 4. Everything else. Rent, software, insurance, marketing, professional fees. Most of it is last year with known changes; do not spend three hours refining a line worth $4,000.
  • 5. Cash and capital. Working capital as revenue grows, capital purchases, loan payments. This is where a plan that looks profitable reveals itself to be unfundable.
The plan · five layers, twelve months
LayerFull year% of revenue
Revenue · built by driver$1,840,000100%
Cost of sales$1,104,00060.0%
= Gross profit$736,00040.0%
People (incl. two new hires)$421,00022.9%
Marketing$92,0005.0%
Facilities and other$148,0008.0%
= Operating income$75,0004.1%
Capital purchases$48,000
Debt service (principal + interest)$54,000
= Cash generated-$27,000The finding
Each layer falls out of the one above it. Gross profit and operating income are computed, never typed - so when you change an assumption, the whole year moves with it.

That last row is the reason to do this in September. The plan is profitable and still consumes $27,000 of cash, because of a truck and a loan that never appear on the income statement. Discovered now, that is a problem with four months of options — delay the truck, finance it, stage the second hire, arrange a facility. Discovered in March, it is an emergency.

Two scenarios, not seven

Build the plan you actually intend to execute, then build one downside case: revenue 15% below plan, everything else unchanged. The only question that case needs to answer is whether you stay solvent and which specific commitments you would pull.

Naming those in advance is most of the value. "If we are 15% light by the end of Q2, the second hire waits and the trade show is cancelled" is a decision made calmly, in advance, rather than under pressure with incomplete information. More than two scenarios is almost always procrastination.

Then actually use it

A plan earns its keep only if reality gets compared to it every month. Set this year's actuals beside the plan, look at the variances that exceed some threshold you set in advance, and ask which are timing and which are trend.

Timing variances resolve themselves — an expense landed a month early. Trend variances do not, and they are the ones that compound. Catch one in February and you have eleven months to respond. That is the entire return on the exercise, and none of it is available if the document was built in the last week of December.

The Annual Operating Plan builder lays these five layers out across twelve months with gross profit and operating income falling out for you — free, and yours as Excel.

See what a report like this looks like on your own numbers.

Meet your AI CFO →

Prefer to run the numbers yourself? Try the free Annual Operating Plan Builder — no signup needed.

Keep reading

ToolkitSeptember 3, 2026 · 7 min read

The 10 KPIs worth watching weekly (and the 40 that aren't)

Most dashboards fail because they show everything, which is the same as showing nothing. Here are the ten numbers that earn a weekly look for a small business, why each one is on the list, and the test for whether a metric deserves your attention at all.

Read it →
ToolkitAugust 24, 2026 · 7 min read

Recurring, capacity, or funnel: which revenue engine are you?

Almost every business makes money in one of three shapes, and the shape determines which numbers you should be forecasting. Pick yours and you stop guessing at revenue - you start building it from drivers you can actually influence.

Read it →
ToolkitJuly 7, 2026 · 8 min read

SUMIFS: turn a raw QuickBooks export into a P&L with one formula

Export your general ledger and you get a flat list of every transaction — not a report. SUMIFS is the one formula that rolls that list up into a P&L: revenue by month, opex by category, all of it. Here's exactly how, plus the traps that quietly return a wrong number.

Read it →
ToolkitJuly 3, 2026 · 8 min read

Cleaning messy data in Excel: the six functions that do it

Exported data almost never arrives clean — names in three different cases, addresses jammed in one cell, trailing spaces that quietly break your lookups. Here are the six Excel functions that turn a messy paste into data you can actually total, match, and trust.

Read it →
ToolkitJuly 1, 2026 · 7 min read

XLOOKUP vs VLOOKUP vs INDEX/MATCH: which lookup should you use?

The one-line answer is XLOOKUP — but VLOOKUP and INDEX/MATCH still earn their keep, and INDEX MATCH MATCH does something none of the others can. Here's each one, side by side, with the exact moment you'd reach for it.

Read it →
ToolkitJune 26, 2026 · 9 min read

The case of the missing cash: a CFO's afternoon in Excel

A wholesale distributor turns a profit every month and still can't make its credit line breathe. Here's the afternoon a fractional CFO spent cracking it — and the dozen Excel formulas she reached for, what each one does, and exactly when you'd use it.

Read it →
ToolkitJune 26, 2026 · 9 min read

Financial modeling best practices: building a model that doesn't break

Models almost never fail on the math — they fail on structure, trust, and rot. Here are the practices CFOs use to build a model a banker (or your future self) can actually follow and believe.

Read it →
Finance 101September 5, 2026 · 8 min read

Can you service the loan? DSCR and covenants in plain English

Before a bank lends you anything it computes one ratio, and you can compute it yourself in about five minutes. Here's what DSCR is, what number you need, and what the covenants buried in your loan agreement can actually do to you.

Read it →
Finance 101September 1, 2026 · 7 min read

Payroll as a percentage of revenue: what's normal?

Payroll is the largest cost in most small businesses and the one owners are least sure about. Here's how to measure it so the number means something, what the ranges look like by business type, and the two ratios that matter more than the headline percentage.

Read it →