End-of-Year Budget Review Template: A 12-Month Retrospective

Quick answer. A year-end budget review template walks through the 12 months you just lived: monthly variance per category, savings rate by month, irregular expenses that surprised you, and a checklist for what to change in next year’s plan. Best run in November or December for the calendar year, though a mid-year review (May or June) is the same exercise on a 12-month rolling basis. Our Annual Budget Template ships with a Review tab pre-built.

I’m publishing this in May because the most useful budget review isn’t actually December. Mid-year reviews catch problems early and give you 7 months to course-correct. The exercise is identical; only the timing differs.

This post walks through the four sections of a complete budget review, with a worked example and the spreadsheet structure that supports it.

Why review at all

Three reasons.

You can’t plan next year without knowing this year. A budget for 2027 built without looking at 2026 actuals is mostly guessing. The review converts the past 12 months from “stuff that happened” into “data that informs.”

Surprises become categories. The thing that blew your budget twice in 2026 (medical, car repair, family event) deserves its own line in 2027 instead of disappearing into “miscellaneous.”

Habits become visible. Drift in dining spending, growing subscription totals, the slow creep of a category that started small. The annual view shows trends a monthly view hides.

The review takes about 90 minutes to do well. Lighter versions take 30 minutes. Both are worth it.

Section 1: monthly variance per category

The headline section. For each category, compare planned (what you budgeted) vs actual (what you spent) for each of the 12 months.

Categories with the largest variance get the attention. Above, four categories were significantly over (groceries, dining, subscriptions, travel) and three were under. Net: roughly $300 a month over plan.

The interesting question isn’t “why was dining over by 46 percent” in isolation. It’s “what changed?” Did dining go up because life changed (new restaurant nearby, social activity uptick), because the plan was unrealistic from the start, or because tracking discipline slipped?

Each variance has a different remedy. Pattern recognition matters more than aggregate numbers.

Section 2: irregular expenses that surprised you

A row per surprise. The point is to convert one-time annoyances into next-year line items.

Examples from a typical year:

Total surprises: $4,750. None of these were truly unpredictable. Each is a category that should have existed in the plan and didn’t. Next year’s plan adds the lines, sized for what you now know.

This single section often saves more in next year’s stress than the rest of the review combined.

Section 3: savings rate trend

Plot savings rate by month. Look for direction.

Average: around 19 percent. But the trend within the year shows a sag from May through August (summer travel and irregular expenses) and a recovery in fall. The bonus saved most of December.

The interesting work: was the summer sag a planned absorption (you knew travel would lower the rate), or did the rate slip without being noticed? Different answers, different remedies.

Section 4: net worth change for the year

A single number with context.

Net worth, year-over-year:

• January 1: $245,000
• December 31 (or current): $293,500
• Change: +$48,500 (+19.8 percent)

Composition of the change:

• Savings contributions: $32,000
• Investment growth: $14,500
• Real estate appreciation: $5,000
• Debt principal reduction: $3,000
• Less: depreciation on vehicles: -$2,000
• Less: spending from savings (one-time withdrawals): -$4,000

Total: $48,500.

This decomposition tells you whether the net worth growth was driven by saving (great), market returns (good but not under your control), or one-time events (note for next year). The first two are repeatable; the third may not be.

Section 5: next year’s checklist

The output of the review. A concrete list of changes to make in next year’s plan.

Examples from the analysis above:

• Add Home Maintenance reserve at $150/mo (was missing).
• Add Pet emergency reserve at $50/mo (was missing).
• Increase Gifts category to $400/mo for May-Aug (was flat $150/mo).
• Add Vehicle Maintenance reserve at $75/mo (was lumped in transportation).
• Audit subscriptions category: where did the extra $50/mo come from?
• Recalibrate dining target: $280/mo was unrealistic; try $375/mo as a more honest number.
• Plan summer savings rate at 12 to 14 percent (acknowledge the seasonal pattern) instead of pretending it’ll be 20 percent.

Each item is specific and actionable. The new plan starts with these changes incorporated.

How to run the review

Three steps if you have an annual budget already in place.

1. Pull actuals for each month from your transaction log into the Plan vs Actual columns of the annual budget.
2. Calculate variance per category per month.
3. Walk through Sections 1 to 5 above.

If you don’t have an annual budget, the review is a precondition for building one. Use bank statements and credit card downloads to reconstruct monthly spending by category, then run the same analysis.

The Annual Budget Template ships with a Review tab that handles steps 1 to 3 automatically once you’ve logged actuals.

Common mistakes

Reviewing only the bad categories. The categories where you came in under plan also matter. Were you genuinely frugal there, or did you just not engage that part of life this year? A category at $0 spend isn’t always a win.

Treating one bad month as a trend. A single $700 medical month doesn’t mean you need a $700/mo medical line. Look for patterns across multiple months.

Skipping the savings rate decomposition. The headline savings rate hides whether you saved consistently or whether the year was rescued by one bonus. The two suggest very different next-year strategies.

Not capturing the surprises. This is the single most valuable section, and the easiest to skip. Take the time.

Treating the review as a self-evaluation. It isn’t a performance review. Beating yourself up over the dining spend doesn’t change next year. Logging the pattern and adjusting the plan does.

When mid-year vs year-end review

Year-end (December): Best for capturing the full calendar year and feeding directly into January’s new plan. Most aligned with tax-year boundaries.

Mid-year (May or June): Best for course-correcting before patterns harden. Catches drifts early. The categories you’ve been over on for 5 months are more visible than at year-end after 11.

Quarterly (March, June, September, December): Best for people who want continuous tuning. More time investment but smaller changes per cycle.

Most people benefit from at least one mid-year and one year-end. Quarterly is overkill unless your situation changes often.

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

• How to Plan a Yearly Budget in Google Sheets
• One Page Financial Plan Template: 7 Sections That Actually Matter
• Quarterly Estimated Tax Spreadsheet