Small business annual budget
Twelve month columns, rows for payroll, rent, software, marketing; chart shows cumulative cash vs plan.
How do you build a budget in Google Sheets?
A budget sheet compares planned spending or revenue to actuals over time. Rows are categories, columns are months or quarters, and formulas SUM detail lines into subtotals. Variance columns show where you are over or under plan.
When to use it
Use Sheets budgets for small business cash planning, department headcount plans, project cost tracking, and personal finance when you want shared editable models with clear formulas.
When to skip it
Skip Sheets when finance must close books in an ERP with strict controls, multi-entity consolidation, and audited change logs. Export summaries to Sheets instead of budgeting in them.
How it works
-
1
List categories in column A and time periods across row 1 (Jan, Feb, or Q1, Q2).
-
2
Enter budget amounts in a Budget input area; pull actuals from imports or manual entry on Actuals tab.
-
3
Calculate variance as Actual minus Budget, optionally percent variance with IFERROR guards.
-
4
Group detail rows under department subtotals for collapse during leadership reviews.
-
5
Add a Settings tab for fiscal year start, currency, and scenario name (Base, Aggressive).
-
6
Protect formula subtotals; let budget owners edit only their input ranges.
Examples in Google Sheets
Project budget tracker
Budget at completion column plus actual spend from expense CSV import; variance flags categories over 90% used.
Personal monthly budget
Categories for fixed and variable costs, actuals from bank CSV, conditional formatting when variable exceeds target.
Build this without starting from a blank cell
Use a Better Sheets tool for budgets in Google Sheets, then watch a walkthrough when you want the full pattern.
Better Sheets resources
Common mistakes
- Mixing budget and actual in one column without labels, confusing SUM ranges.
- Hardcoding twelve copies of the same formula instead of dragging from a consistent row 2 template.
- Forgetting to update fiscal year dates so February actuals land in wrong column.
- Letting someone insert a row inside grouped subtotals without updating SUM ranges.
- Building on merged cells that break copy-paste and pivot exports.
Frequently asked questions
- Budget vs forecast?
- Budget is the original plan. Forecast updates expectations as the year progresses. Many sheets keep both tabs.
- Import bank actuals?
- CSV import to Actuals tab, categorize with XLOOKUP mapping, roll into variance vs Budget.
- Scenario planning?
- Duplicate Budget tab as Scenario B or use a dropdown in Settings to switch drivers via IF.
- Protect budget formulas?
- Data > Protect sheets and ranges on subtotal rows and variance columns while leaving inputs open.
- Chart budget vs actual?
- Summary table with two series per month; column chart for compare or line for trends.
- Shared department budgets?
- One tab per department feeding a master Consolidated tab with IMPORTRANGE or manual links.
- Rollover unused budget?
- Model explicitly with carry rows; do not hide slack inside vague categories without documentation.
- Template for new year?
- File > Make a copy, clear actuals, shift date headers, archive prior year PDF in Drive.
Related blog posts
Guides that explain budgets in Google Sheets in more depth.
5 Advanced Formulas To Build a Simple Monthly Budget Template
Track your expenses, manage your finances, hoping to save money, plan for the future, and generally during the month you want to reduce stress. Use these advanced formulas to get more out of Google Sheets.
Read post →Build Better Budget Templates
Let's build better budget templates with automation, design, and a little magic.
Read post →3 Google Sheet Tips for Budget Analysts
Budget analysts can improve their efficiency, accuracy, and ability to make data-driven financial decisions, enhancing their value in budget planning and analysis roles.
Read post →Related glossary terms
planners
A planner layout helps you schedule work across days, weeks, or project phases inside a spreadsheet. Unlike a one-off todo list, planners emphasize dates, time blocks, and recurring rhythms you copy forward. They work well for personal systems and small teams who already live in Google Workspace.
Read guide →grouping rows in Sheets
Row and column grouping adds outline controls on the left or top edge so readers expand or collapse sections. It is a presentation layer: formulas still see all cells whether collapsed or not. Grouping suits budgets, project plans, and any sheet with detail rows under subtotal headers.
Read guide →reports from Google Sheets
A report turns raw data into a readable snapshot: summary metrics, charts, and tables formatted for an audience. Separate source data tabs from a Report tab that uses QUERY, pivot tables, or SUMIF so you refresh inputs without rebuilding layout every week.
Read guide →KPI tracking
KPI tracking means choosing a small set of numbers that show whether you are winning, then updating them on a rhythm everyone trusts. In Sheets, each KPI usually has a definition, data source, target, and actual cell on a dashboard fed by formulas, not hand-typed guesses.
Read guide →Done reading about budgets in Google Sheets?
Membership unlocks 636+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.