How to Plan a Yearly Budget in Google Sheets (6-Step Walkthrough)

Quick answer. A yearly budget in Google Sheets uses a 12-column grid (one per month) plus rows for each income and expense category. The plan-vs-actual approach sets target amounts at the start of the year and compares against actuals each month. The advantage over monthly budgeting: you see seasonal expenses (insurance renewals, holidays, school costs) before they hit. Our Annual Budget Template ships with this layout pre-built.

A yearly budget isn’t twelve monthly budgets stacked on top of each other. The whole point is to plan for things that don’t happen monthly: the November holiday spending, the March car insurance renewal, the August school supply rush, the year-end charitable giving. Monthly budgeting makes those feel like surprises every time. A yearly budget treats them as known events.

This post walks through the six steps of building one and shows what each step looks like in the spreadsheet.

Step 1: list income by month

Most people’s income isn’t perfectly flat. Salaried W-2 workers come closest, but even they have biweekly vs semimonthly pay timing differences and annual bonuses to account for.

Create a row for each income source. Columns are January through December. Fill in expected income per source per month.

Example for a dual-income household:

Notice March (extra paycheck if biweekly) and December (bonus) are higher than baseline. Planning for that variance is the value.

Step 2: list fixed monthly expenses

The non-negotiables that hit every month at the same amount or close to it.

• Rent or mortgage
• Property tax (if escrowed in mortgage; otherwise see Step 3)
• HOA fees
• Health insurance premium
• Auto insurance (if monthly)
• Cell phone
• Internet
• Streaming subscriptions
• Gym membership
• Loan payments (student, car, personal)
• Childcare or tuition (if monthly)

These rows look like:

Same number across all 12 months. Easy to fill, easy to verify.

Step 3: list variable monthly expenses

Things that happen every month but vary in amount: groceries, dining out, gasoline, household supplies, personal care.

Estimate from prior months if you have data. If you don’t, use a national average for your household size (USDA food cost data is one source for groceries) and adjust over time as actuals come in.

These can be flat across all 12 columns initially. As you log actuals each month, the variance will tell you whether your estimates were realistic.

Step 4: plan irregular and seasonal expenses

This is where the yearly budget earns its keep. Things that happen once or twice a year, not every month.

Place each in the month it actually hits. The annual budget shows the spike when it appears.

The two reserves at the bottom (vehicle and home maintenance) are sinking funds: small monthly amounts that build up to cover the irregular larger expenses. Even though no single month has a “vehicle maintenance” charge of $100, setting aside that amount each month means you have $1,200 ready when the brakes fail in October.

Step 5: build savings and goals into the plan

Treat savings as a planned expense, not as “whatever’s left over.” If it’s not a line item, it gets squeezed out.

Total savings line: $4,250/month, or $51,000/year. As a percentage of $144,300 gross income, that’s a 35 percent savings rate. Worth knowing whether that’s the rate you want.

Step 6: reconcile and verify the math

The annual budget needs to balance. Your year-end summary should show:

Total income - Total expenses - Total savings = Year-end residual

If positive: you have flexibility. Either save more, plan to absorb a higher-than-budgeted month, or treat as a buffer.

If negative: something has to change. Either income (raise, side work, bonus assumption), expenses (cut a category), or savings (reduce contributions to one bucket).

Run the year-end summary in a single dashboard cell. The Annual Budget Template ships with this. You can also build it yourself with =SUM(B2:M2) row totals and =SUM(N2:Nn) - SUM(N5:Nn) for the income-expense-savings reconciliation.

A worked example: family of four

Income: $144,300 gross (per the table above).

Expenses (annual totals):

• Fixed: $48,000 (mortgage $28,800, health $10,200, fixed subscriptions/utilities $9,000)
• Variable: $20,500 (groceries, dining, gas, household)
• Irregular and seasonal: $21,500 (insurance renewals, property tax, holidays, travel, school)
• Total expenses: $90,000

Savings: $51,000

Year-end check: $144,300 income - $90,000 expenses - $51,000 savings = $3,300 residual. Healthy buffer.

The interesting work happens before that final number. Adjusting one of the irregular categories ($1,500 less on travel, say) frees up $1,500 elsewhere. That’s the budget being a planning tool, not just a tracking one.

What to do each month

Once the annual plan is set, monthly maintenance is light.

First week of the month:

• Log actuals for the prior month into the same grid (a separate “actuals” row alongside the planned row).
• Calculate variance per category.
• Note any surprises that didn’t appear in the plan; add them as new rows if they’ll recur.

Mid-month:

• Quick check that current spending is on track vs the planned amount for the month.
• If trending over, decide whether to absorb (cut another category) or accept (use the buffer).

End of quarter:

• Update the rest-of-year forecast based on year-to-date actuals.
• Adjust savings allocations if income surprises.

Total time: maybe 30 minutes a month after the initial setup.

Where the spreadsheet helps

The 12-month grid is hard to see clearly without a spreadsheet. Paper budgets force you into either a single month or an unwieldy multi-page document. The spreadsheet shows the year on one screen.

Plan-vs-actual variance is the second value-add. The dashboard can highlight categories where actual is more than 10 percent over plan. That’s where attention should go.

The third value-add: scenario modeling. Copy the workbook, change one assumption (next year’s salary, smaller travel budget, larger emergency contribution), see how the year-end residual changes. Hard to do on paper.

Get the template

• Annual Budget Template — 12-month grid with seasonal expense planning and category rollups.
• Monthly Budget Template — Planned-vs-actual monthly budget with a dashboard and category targets.
• Budgeting Bundle — Annual, Monthly, and Travel budget templates bundled.
• Budgeting Bundle — Annual, Monthly, and Travel budget templates bundled.

Related

• Free Monthly Budget Template for Google Sheets (2026 Edition)
• Aspire Budgeting Alternative: Maintained Templates with Real Updates