Skip to main content

Frac CFO

By Jonas Tyrone Lobaton, MSc Quantitative Finance, FMVA®
Founder, Frac CFO · Updated October 27, 2026

Zero-based budgeting in Excel means building next period’s budget from a blank sheet. Every cost has to earn its place, and income minus planned spending must land on exactly zero. You can do it with a handful of formulas, three tabs and one rule: nothing carries over just because it was there last year.

This guide shows the layout, the formulas, how to track actuals against the plan, and how to allocate shared costs so each line is justified by what drives it.

Fraccfo
Build a Budget That Guides Decisions
Fraccfo helps spreadsheet-based businesses build financial models, forecasts and dashboards for clearer cash flow and more informed decisions.

Explore Fraccfo’s finance support

TL;DR

  • Zero-based budgeting starts every period at zero. Each expense is justified again instead of copied from last year plus a percentage.
  • In Excel, you need an income block, a spending block grouped by purpose, and one check cell: total income minus total planned uses of funds equals zero.
  • Add Actual and Variance columns so the budget becomes a monthly control tool, not a one-time exercise.
  • Shared costs need a sensible allocation driver, or the budget hides which products or customers actually make money.
  • Expect it to take more time than an incremental budget. Do it fully once a year and review it lightly each month.

Table of Contents

What zero-based budgeting means for a business

Traditional budgeting takes last year’s numbers and adjusts them. Zero-based budgeting (ZBB) is a technique where every expense must be justified from scratch for each new period. Nothing is assumed.

For a household, the idea is simple: assign every dollar a job until nothing is left unassigned. ExcelDemy describes it as total income minus total expenses equals zero. For a business, the same arithmetic applies, but “expenses” includes wages, contractors, debt payments, taxes, savings and reinvestment. The Federation of Small Businesses, a UK body, argues the method works because every cost has to be tied to performance, compliance or strategy. That exposes cheaper alternatives and frees money for higher priorities.

A zero balance does not mean you spend everything. Savings, a cash reserve and owner distributions are lines in the budget too. The point is that every dollar is a decision, not a leftover.

What zero-based budgeting means for a business — overview diagram

When it fits, and when it does not

ZBB suits you when:

  • costs have crept up and nobody can say why;
  • revenue is uncertain and you need to rank spending by importance;
  • you are preparing for a lender or investor and want a budget you can defend line by line;
  • you are starting a new year after a big change, such as a new product line or a lost client.

It has costs. Oracle notes it can be time-consuming and may favor short-term savings over long-term investment if handled poorly. ACCA makes the same point about the annual cycle. The fix is to mark strategic spending, such as hiring, product development and marketing, as protected categories that you justify against goals, not against this quarter’s cash.

How to set up a zero-based budget in Excel

Keep the workbook small. Three tabs are enough for most small businesses: Inputs, Budget and Tracking.

Step 1: List every income source

On the Budget tab, create an income table with columns for Category, Expected, Actual and Difference, as ExcelDemy lays it out. Break revenue into streams: product sales, service retainers, one-off projects, other income. Use conservative amounts. If a client has not signed, either leave it out or put it in a separate “upside” row that is excluded from the total.

Total it with a plain SUM, for example =SUM(C6:C8).

Step 2: Build the spending list from zero

This is the step that makes it zero-based. Do not paste last year’s actuals. Start with an empty list and add a line only when you can answer: what does this cost buy, and what happens if we stop?

The FSB’s small-business guide suggests categorizing every outgoing, including wages, contractors, debt, savings and reinvestment. A practical grouping:

  1. Must-pay: payroll, taxes, rent, insurance, loan payments.
  2. Required to deliver: cost of goods, subcontractors, software you cannot operate without.
  3. Required to grow: marketing, sales tools, product development.
  4. Reserves: emergency cash, tax set-aside, owner pay.
  5. Discretionary: everything else, justified one by one.

Add a Justification column next to each amount. One sentence is enough: “Ad spend: $4,000, because paid search produced 40 leads at a known close rate.” The written reason is the real discipline.

Step 3: Add the balance check

At the bottom, add total planned spending and an unassigned balance. A common version of the formula is =SUM(B9:B20) for total allocations and =B5-B21 for the unassigned amount. ExcelDemy’s equivalent is total income minus total expenses, such as =C9-C19.

  • If the result is negative, cut or defer spending until it reaches zero.
  • If it is positive, assign the surplus to savings, marketing or growth rather than leaving it idle, as the FSB advises.

Add conditional formatting so the check cell turns red when it is anything other than 0. That small cue prevents most errors.

A worked example

Take a service business with $50,000 of expected monthly revenue. This is an illustration, not a benchmark.

Category Planned Why it is there
Payroll and taxes $24,000 Four staff, committed
Contractors $5,000 Overflow delivery on two accounts
Rent and utilities $3,500 Lease through next year
Software $1,200 Only tools used weekly
Marketing $4,000 Tied to lead targets
Insurance and fees $1,300 Required
Loan payment $2,500 Contractual
Tax set-aside $4,500 Quarterly estimates
Cash reserve $3,000 Building toward three months of payroll
Owner distribution $1,000 Agreed draw
Total $50,000

The unassigned balance is $0. If a client slips and revenue falls to $46,000, you know the first lines to trim, because each one already has a stated reason. If you want a ready structure, our Budgeting & Cash Flow templates follow this layout.

Tracking actuals and variances

A zero-based budget that nobody checks is a wish list. On the Tracking tab, copy the category list and add Actual and Variance columns.

The variance formula can be planned minus actual, =B9-C9. Another convention is =Actual - Budget, where, for costs, a positive result means overspending and, for revenue, it means a better-than-expected result. Pick one convention and label it clearly at the top of the sheet. Mixed signs cause more confusion than any formula error.

A monthly routine that works:

  1. Paste or type actuals from your bookkeeping by the fifth business day.
  2. Sort variances by absolute size and look only at the top five.
  3. For each, decide: timing, a one-off, or a real change in the run rate.
  4. If it is a real change, rebuild the remaining months from zero for that category instead of nudging the total.

A tip from FP&A practice: match the structure of your budget to your accounting chart of accounts so actuals drop in without remapping. For deeper variance work, see our guide to variance analysis in Excel, and for a full twelve-month view, our annual budget in Excel walkthrough. If you sell physical goods, standard costing in Excel explains how to split price and volume variances.

Allocating shared costs so the budget tells the truth

Zero-based budgeting asks why a cost exists. Cost allocation asks who or what it serves. Without allocation, rent, software and management time sit in one overhead pile and every product looks equally profitable.

Choose drivers with cause and effect

IFAC experts advocate that allocation and activity-based costing models rely on strong cause-and-effect relationships, not weak factors, to avoid misleading profitability signals. In practice:

Shared cost Weak driver Stronger driver
Warehouse rent Revenue Pallet positions or square feet used
Customer support Headcount Tickets handled per customer
Payment processing Even split Transaction count
Project management Revenue Hours logged per project

Model it with pools, activities and drivers

Activity-based costing (ABC) in Excel follows three steps. Group overhead into cost pools, such as support, fulfillment and administration. Divide each pool by its driver volume to get a rate, for example $18 per ticket. Multiply the rate by the volume each product or customer consumes.

Three steps for allocating activity costs

The payoff is practical. ACCA explains that operational activity-based management aims to raise efficiency by reducing or removing activities that add no value, while the strategic side informs product and customer focus. That is the same question your zero-based budget asks, applied to activities instead of departments.

For formulas and a full example, use our cost allocation model in Excel guide. If your largest shared cost is purchased components, the principles in this piece on reducing bill of materials costs show how unit costs flow into the P&L. To see the result, feed allocated costs into a profit and loss statement in Excel.

Our perspective: keep the spreadsheet, add the discipline

Most small businesses do not need new software to budget well. They need a clear structure and a habit. We work exclusively in Excel and Google Sheets, and what we see is that the spreadsheet is rarely the problem. The problem is a budget built by copying last year’s tab, with no reasons attached and no link to cash.

Our advice:

  • Run the full zero-based exercise once a year, or after a major change. Do not repeat it monthly. Review variances monthly instead.
  • Protect growth spending. Zero-based does not mean smallest possible.
  • Pair the budget with a cash view. A budget can balance on paper while cash runs short in week six, which is why a 13-week cash forecast is a natural companion.
  • Keep one owner for the file and one version of the truth.

A workbook you understand and control beats a platform nobody opens.

– frac

Get a budget built for you

If you would rather start with a working structure, our Excel templates include budgeting and cash tools, and the Inventory & Budget Tracker suits product businesses. For a one-time build, our Budget Build project sets up a zero-based budget around your numbers. The Launch Kit is $650 one-off. If you want ongoing help with monthly reviews, our fractional CFO plans start at $600 per month (STARTER), with GROWTH at $1,750 per month and SCALE at $3,500 per month, and annual billing is also available.

Inventory  Budget Tracker Excel template

Common mistakes to avoid

  • Copying last year’s actuals into the “zero” budget. It looks zero-based but is not.
  • Forcing zero on an unrealistic revenue number. Budget income you can defend, then size spending to it.
  • No reserve line. A budget that spends every dollar with no cash cushion is fragile.
  • Too many categories. Twenty to thirty lines are easier to justify and review than a hundred.
  • Never revisiting. Set a monthly variance review and a quarterly reforecast.

FAQ

Is zero-based budgeting the same as a zero-sum budget?

The terms are used loosely, but in practice both mean income minus planned spending equals zero. In a business, the zero-based label also carries the idea of justifying every cost from scratch each period, not just balancing the total.

How long does a zero-based budget take to build in Excel?

The first one takes longer than an incremental budget because every line needs a reason, and sources note ZBB can be time-consuming. Later cycles are faster because the justifications already exist. Many small teams can reuse the structure and only challenge the lines that changed.

What formulas do I need?

Three cover most of it: SUM for totals, income minus total spending for the balance check, and planned minus actual (or actual minus budget) for variances. Conditional formatting on the check cell adds a useful visual alarm.

Can I use Google Sheets instead?

Yes. The same formulas work in Google Sheets, and shared access can make monthly updates easier for a team. Our templates come in both Excel and Google Sheets versions.

About the author

Jonas Tyrone Lobaton is the founder of Frac CFO. He holds a Master’s degree in Quantitative Finance and the FMVA® certification, with work spanning financial modeling, forecasting, optimization, dashboards, business finance, and spreadsheet automation.

Sources

Leave a Reply