Annual Budget Template
A full-year grid: every category across twelve months with per-month totals, per-category annual totals, and a grand total — all SUM formulas.
Preview
The workbook ships with the example values below plus blank rows — every total is a live formula.
| Category | Jan | Feb | Mar–Dec | Year |
|---|---|---|---|---|
| INCOME | ||||
| Salary | $4,200.00 | $4,200.00 | … | $50,400.00 |
| Side income | $450.00 | $600.00 | … | $6,300.00 |
| Total income | $4,650.00 | $4,800.00 | … | $56,700.00 |
| EXPENSES | ||||
| Housing | $1,400.00 | $1,400.00 | … | $16,800.00 |
| Groceries | $550.00 | $610.00 | … | $6,960.00 |
| Transportation | $320.00 | $280.00 | … | $3,600.00 |
| Everything else | $1,110.00 | $1,120.00 | … | $13,380.00 |
| Total expenses | $3,380.00 | $3,410.00 | … | $40,740.00 |
| Annual savings (income − expenses) | $15,960.00 | |||
How to use it
- Enter each month’s budgeted amount per category; January and February carry example values.
- The Year column sums each category automatically (=SUM(B:M)).
- The bottom row totals each month across all categories in that section.
- Keep income and expenses separated as marked — the grand summary references both totals.
Related online calculators
Free for personal use. The file contains no macros — just data, formatting, and standard spreadsheet formulas that work in Excel, Google Sheets, and LibreOffice.