Budget Planner
Plan income and expenses with variance tracking.
A monthly and annual budget workbook with category groups, planned versus actual columns, variance percentages and a rolling twelve-month view. Charts update as you type, so overspending is visible immediately.
- Price
- Free
- Your files
- Never uploaded
- Runs
- In your browser
or drag it here
· up to 50 MB · processed locally, never uploaded
Excel and spreadsheet files only. Export from Google Sheets as .xlsx or .csv.
Files stay on your device
What it does well
- Planned, actual and variance columns with conditional highlighting
- Category groups that roll up to totals automatically
- Twelve-month view with a year-to-date summary and charts
How to use Budget Planner
- 1
Choose personal or business categories as a starting point.
- 2
Set your currency and the budget year.
- 3
Adjust the category list to match your accounts.
- 4
Download the workbook and start entering actuals.
Watch a walkthrough
Common problems and fixes
Group totals do not include a new row.
The row was added below the total rather than inside the group. Insert it above the subtotal line so the range grows.
Variance shows a huge percentage.
The planned value is zero, so the percentage divides by zero. The template wraps this in IFERROR — re-enter a planned amount.
Frequently asked questions
More templates tools
Invoices, payroll, timesheets, budgets and dashboards — every template ships with real formulas, not screenshots, and downloads as a native .xlsx.
Browse Templates