How to Build a Zero-Based Budget for a Small Business in Excel
Zero-based budgeting (ZBB) means every expense starts at zero and must be justified before the period begins. For a small business in Excel: list all income streams, list every expense from scratch (not from last year), assign a rand or dollar figure to each line, and build a formula where income minus expenses equals zero. Every cent gets a job. Nothing carries over from habit. This guide walks you through the full build — step by step.
Meet Sipho. He runs a small events equipment hire business out of Cape Town. Every January, he opens last year's Excel budget, bumps the numbers up by 10%, and calls it planning. By March, he's staring at a bank balance that doesn't match anything on his spreadsheet — because the budget was never a plan. It was just a slightly edited copy of the past.
Marcus does the same thing from Austin. So does Adaeze in Lagos. So, probably, do you.
The fix isn't a bigger spreadsheet. The fix is a different method. It's called zero-based budgeting, and it works exactly like it sounds: you start from zero, every time.
What Zero-Based Budgeting Actually Means
Traditional budgeting is basically archaeology. You dig up last year's numbers, add a percentage for inflation, nod at the total, and move on. Zero-based budgeting (ZBB) is the opposite. You justify every single line item from scratch — every month, every quarter, or every year, depending on your setup.
- Rolls over last year's figures
- Assumes recurring costs are still valid
- Rarely questions existing spend
- Bloat hides in line items nobody reviews
- Fast to do, slow to catch problems
- Every expense starts at R0 / $0
- Every cost must be justified
- Forces intentional spending decisions
- Catches zombie subscriptions and stale spend
- Takes more effort, produces better numbers
The core principle: income minus expenses must equal zero. Not because you're spending every rand — but because every rand is assigned a purpose. Savings is a budget line. Tax is a budget line. Emergency fund is a budget line. If it's not on the sheet, it doesn't exist.
"The budget that says 'R3,500 on marketing, same as last year' is not a plan. It's a habit. Habits don't care if the business changed."
Before You Open Excel: The Two Lists You Need
Before you touch a spreadsheet, you need two things written down. Not typed. Written. On paper if necessary. Because the act of thinking through this properly is the budget — Excel is just where you record it.
List 1: Every income stream your business has
Not what you wish you had. What you actually earn. Product sales, service retainers, once-off project fees, affiliate income, rental income, interest on a business account — every stream gets its own line. Then you estimate what each stream brings in per month, realistically. Not best-case. Not worst-case. Your honest middle.
List 2: Every expense the business has
This is where you start from zero. Not from last year's list. Ask yourself: if this business had to rebuild its expense list from nothing today, what would go on it? That question catches the R450/month software subscription nobody's used since 2024. It catches the insurance policy with duplicate coverage. It catches the "marketing budget" that's really just boosted Instagram posts that don't convert.
Pull three months of bank statements before you start. Not to copy the numbers — to remind yourself what the business actually spends money on. Your memory is optimistic. Your bank statements are not.
Building the Zero-Based Budget in Excel: Step by Step
Here's the exact structure. This is how the DocxDrop Annual Budget Workbook is laid out — and how you'd build it from scratch if you wanted to go the manual route. (We'll get to why you might not want to at the end.)
Open a new Excel workbook. Create a tab for each month (Jan, Feb, Mar... Dec) plus one Year Summary tab that pulls totals from each month. If 13 tabs feels like a lot, a single sheet with 12 column groups works too — but separate tabs make the monthly review easier when you're busy and not in the mood.
At the top of each monthly tab, create a REVENUE section. List every income stream in its own row. Add a Budget column and an Actual column. At the bottom of this section: =SUM(budget range) for Total Projected Income and =SUM(actual range) for Total Actual Income. Leave the Actual column blank for now — you'll fill it at month end.
Below Revenue, create an EXPENSES section. Group your expenses logically: Fixed Costs (rent, salaries, insurance, loan repayments), Variable Costs (stock, fuel, utilities, commission), and Irregular Costs (annual subscriptions, tax instalments, equipment). Every line item gets its own row. Do not start with last year's numbers. Start with what this month actually needs.
Create a REMAINING row at the bottom: =Total Income - Total Expenses. Your goal is to get this to R0 or $0. If you have money left over, allocate it — to an emergency fund line, a reinvestment line, a tax savings line. If you're in negative territory, something has to give. ZBB forces that conversation before the month starts, not after.
Add a third column next to each Actual column: Variance = =Actual - Budget. Positive variance on expenses = you overspent. Negative variance = you came in under. At month end, colour-code it with conditional formatting: red for over budget, green for under. You'll know in 10 seconds where the month went sideways.
On the Year Summary tab, link each month's Total Income and Total Expenses using =Jan!B_totalrow style references. This tab gives you a 12-month view at a glance — which months were planned tight, which carried surplus, and whether the annual numbers add up the way you assumed they would in January. Spoiler: they usually don't. That's the point.
=E5-D5 // Variance: Actual minus Budget
=D20-D35 // Remaining: Income minus Expenses
=Jan!D20 // Pull January total into Year Summary
The Expense Categories Every Small Business Budget Needs
Here's a reference table of standard expense categories for a small business zero-based budget. This isn't every category — your business might have more, or fewer. But if a category exists on this list and you haven't thought about it, add it to your sheet and justify why it's zero.
| Category | Type | Examples | ZBB Question |
|---|---|---|---|
| Payroll & Contractor Fees | Fixed | Salaries, freelancer invoices, owner drawings | Is headcount right for this period? |
| Rent & Facilities | Fixed | Office rent, storage, coworking | Do we still need this space? |
| Stock & Raw Materials | Variable | Inventory, packaging, components | What do projected sales actually require? |
| Marketing & Advertising | Variable | Paid ads, print, agency fees, sponsored posts | What's the ROI on each channel? |
| Software & Subscriptions | Fixed | Accounting software, CRM, communication tools | Is every subscription active and used? |
| Transport & Fuel | Variable | Vehicle running costs, courier, delivery | What's the projected travel this month? |
| Professional Services | Variable | Accountant, lawyer, consultant | What engagements are scheduled? |
| Insurance | Fixed | Business, vehicle, equipment, liability | Are all policies still necessary and competitive? |
| Tax Provision | Irregular | Provisional tax, VAT, PAYE, income tax | How much to set aside this period? |
| Emergency / Contingency | Irregular | Equipment failure, gap cover, cash buffer | What's the minimum buffer we need? |
| Business Reinvestment | Irregular | New equipment, training, product development | What growth spend is planned this period? |
| Loan Repayments | Fixed | Business loans, vehicle finance, credit | Contractual — confirm the exact amount. |
All of this — 12 monthly tabs, year summary, variance tracker, pre-built expense categories, ZAR and multi-currency support — is already done. For Excel and Google Sheets. You open it, type your numbers, and start.
Get the Annual Budget WorkbookInstant download · Excel & Google Sheets · ZAR + multi-currency · No subscription
The Mistakes That Kill a Zero-Based Budget Before February
Sipho built his zero-based budget. He felt great about it. By the third week of February, it was already irrelevant. Here's why — and what to do instead.
Mistake 1: Only doing it once a year
A zero-based budget built in January and forgotten until December is just a traditional budget with extra steps. The power of ZBB is in the monthly review. At the start of each month: update your income projections, re-justify any variable expenses that changed, and reconcile last month's variances. It takes 20 minutes once you have the structure. It's the 20 minutes that stops February's surprise from becoming March's crisis.
Mistake 2: Forgetting irregular expenses
Annual insurance premiums, provisional tax payments, December bonuses, quarterly PAYE reconciliations — these don't arrive every month, so they're easy to leave off the budget. Then October arrives and R18,000 leaves your account and you're back to the bank balance confusion. The fix: add every annual or irregular expense to the months when they actually hit. Your Year Summary tab will show you the cash flow impact across the year.
Mistake 3: Not including owner drawings
This one's especially common in South Africa where many small business owners pay themselves inconsistently. If your drawings aren't a line item, your budget doesn't reflect reality. Budget your drawings as a fixed cost — even if the amount varies month to month. You are a business expense. Act like it.
Mistake 4: Tracking to the category but not the line
"Marketing: R5,000 budget, R4,800 actual" looks fine. But if R3,000 of that was on a Facebook ad campaign that generated zero leads, the variance isn't your problem — the line item is. The more granular your expense lines, the more useful your variance review. "Digital Ads — Facebook" and "Digital Ads — Google" are more useful than "Marketing" as a single bucket.
If you'd be embarrassed to explain a line item to a sensible friend at a braai — "yeah, I spent R1,200 on software we stopped using in March" — it shouldn't be on next month's budget. That's the filter. That simple.
How ZBB Works for Different Types of Small Businesses
Zero-based budgeting isn't one-size-fits-all — but the core logic applies everywhere. Here's how it adapts across common small business models in South Africa and globally:
| Business Type | Income Variability | Key ZBB Consideration |
|---|---|---|
| Product-based business (retail, manufacturing) | Seasonal / variable | Budget stock separately per sales forecast; don't assume flat monthly demand |
| Service-based business (consulting, agency) | Project-driven / lumpy | Budget by confirmed retainers + conservative project pipeline; over-estimating is the enemy |
| Trades and construction | Contract-based | Budget per active contract; include material cost, subcontractor fees, and retention provisions |
| Freelancer / solopreneur | Variable | Use a conservative monthly floor rate; treat everything above it as bonus that gets allocated |
| Hospitality / events | Highly seasonal | Model shoulder season and peak season separately; don't average a tourist-season month with July |
When Zero-Based Budgeting Makes the Most Sense
ZBB isn't always the right tool. It requires more time than rolling over last year's numbers. Here's when the effort earns its keep:
- → Start of a new financial year. Best time to clear the slate and build a fresh plan without the weight of past assumptions.
- → Cash flow is tight. When there's no slack in the system, every rand has to justify its place. ZBB makes that non-negotiable.
- → After a significant business change. New staff, new product line, new premises, new market — your old budget structure doesn't apply anymore.
- → You've never had a real budget. If your current "budget" is a rough mental model and a feeling, ZBB is the fastest path to financial visibility.
Build It Yourself vs Using a Pre-Built Template: The Honest Answer
You can build everything described in this article from scratch. It'll take a few hours — longer if you're new to Excel. You'll probably rebuild it once when you realize the structure doesn't work the way you thought, and once more when the formula references break.
Or: you download a template that's already built, formatted, formula-checked, and laid out for 12 months with a Year Summary. You open it, replace the placeholder numbers with your own, and you're done in 30 minutes.
Neither choice is wrong. But one of them has you doing budget admin on a Tuesday evening instead of running your business. Worth thinking about.
12 monthly budget tabs · Year Summary with annual totals · Pre-built expense categories (editable) · Budget vs Actual vs Variance columns built in · Conditional formatting on variances · ZAR default with multi-currency support · Google Sheets compatible · Works out of the box.
Common Questions
12 monthly tabs. Year Summary. Budget vs Actual vs Variance. Pre-built expense categories. ZAR default with multi-currency. Excel and Google Sheets. Open it, type your numbers, done.
Download the Annual Budget WorkbookInstant download · No subscription · Works on PC, Mac, and mobile · South Africa & Global
Built by DocxDrop — professional templates for people who have actual work to do. Drop in. Get to work.