How to Create a Budget in Excel
Create an Excel budget with income, expense categories, planned vs actual columns, variance formulas, and a review-ready monthly summary.
Reviewed by Griddy
Updated for current Excel and Google Sheets workflows, with examples chosen to map back to real spreadsheet tasks rather than abstract formula syntax.
An Excel budget works best when it separates the plan from what actually happened. The goal is not to list every transaction in one place; it is to make income, spending, variance, and the next decision visible enough to review every month.
For a business workflow, start with a small business budget template. For a household workflow, start with a budget tracker template.
Step 1. Set up the main columns
Use one row per income or expense line and create these columns:
- Category — income, direct cost, payroll, software, rent, marketing, or another useful group
- Line item — the specific revenue stream or cost
- Budget — the planned amount
- Actual — the amount that happened
- Variance — actual minus budget
- Notes — context for anything that needs review
Keep income, direct costs, and overhead in separate sections. That makes a business budget easier to review than one long list of mixed rows.
Step 2. Add variance formulas
If Budget is in column C and Actual is in column D, use this formula in the Variance column:
=D2-C2Copy it down every budget row. For expenses, a positive variance usually means you spent more than planned. For revenue, a positive variance means you beat the plan.
✦ TIP
Step 3. Add section totals
Use SUM to total each section:
=SUM(C2:C12)Then repeat for actuals and variance:
=SUM(D2:D12)=SUM(E2:E12)For small businesses, add separate totals for revenue, direct costs, gross profit, operating expenses, and net income. For personal budgets, use income, fixed expenses, flexible expenses, debt, and savings.
Step 4. Add simple margin or savings formulas
For a business budget, gross margin is:
=GrossProfit/RevenueFor a household budget, monthly savings is:
=TotalIncome-TotalExpensesFormat percentages and currency consistently. A readable budget is easier to use than a spreadsheet with technically correct formulas and messy presentation.
Step 5. Review actuals monthly
The budget becomes useful when you compare actuals to the plan. Update actuals after month-end, sort or filter large variances, and add short notes explaining the real driver: timing, price change, volume change, hiring, supplier cost, or a one-time expense.
If the business has transaction-level detail elsewhere, keep that in an expense tracker and use the budget as the summary view.
Common mistakes
| Mistake | What happens | Fix |
|---|---|---|
| Mixing income and expenses in one block | Totals become harder to audit | Use separate sections |
| Tracking only actuals | No variance insight | Add budget, actual, and variance columns |
| Too many categories | Review becomes noisy | Keep categories tied to decisions |
| No notes column | Month-end context gets lost | Add short variance notes |
The Griddy way
Budget structure is easy to overbuild, especially when you are trying to make the sheet useful for review rather than just record keeping.
"Create a small business budget with revenue, direct costs, operating expenses, gross margin, EBITDA, and a notes section for monthly variance review"
Griddy builds the spreadsheet structure, adds the formulas, and gives you a budget you can edit instead of rebuilding from a blank workbook.
Skip the manual work
Describe it. Griddy does it.
Instead of writing this formula yourself, just tell Griddy what you need in plain English. Works in Excel and Google Sheets.
Use this on real templates
Start from a budget template instead of a blank workbook
Budget spreadsheets are easiest to maintain when planned amounts, actuals, variance, and review notes are built into the structure from the start.
Small Business Budget
Plan revenue, direct costs, overhead, and EBITDA in one compact operating budget. Keep H1 totals, margin, and owner notes visible without building a giant finance model.
Small Business Budget for Consultants
Plan consulting retainers, project revenue, subcontractors, software, travel, marketing, and operating margin in one budget spreadsheet.
Small Business Budget for Service Businesses
Plan service revenue, payroll, contractors, scheduling costs, supplies, software, marketing, and operating margin in one budget spreadsheet.
Budget Tracker
Track income, expenses, and savings in one place. Line items, budgeted vs actual totals, and monthly net savings — free to use in your browser.