Annual Budget Template for Google Sheets (Free, 2026)

A monthly budget is great at one thing: telling you whether you're on track for the next 30 days. But it's blind to everything past the edge of the month. The car insurance that renews in March, the property tax bill in the fall, the holidays in December, the annual subscriptions that quietly hit once a year — none of them live inside a single month, so a monthly budget never warns you they're coming. An annual budget template fixes that by putting all 12 months on one grid, so you can see and plan for the whole year at a glance.

What an annual budget actually is

An annual budget is a plan for a full year of money, laid out so you read it as one picture rather than twelve disconnected snapshots. In the template, every spending category gets a row and every month gets a column. The result is a grid: you fill in a planned amount for each category in each month, the sheet totals every month down the bottom and every category across the year, and it shows your projected surplus or shortfall for the year as a whole.

That structure unlocks three things a monthly budget can't:

1. A full-year view. You see December's expenses in January, so nothing is a surprise.
2. Room for lumpy costs. Once-a-year bills get placed in the exact month they land, then spread back across the year as a monthly set-aside.
3. Yearly goals. A savings target — an emergency fund, a vacation, a down payment — can be split across all 12 months and tracked toward the finish line.

It doesn't replace a monthly budget. It sits above one. You use the annual view to plan the shape of the year, and a monthly view to execute the next four weeks.

Why Google Sheets is the right home for a yearly plan

You could build an annual budget in Excel, in an app, or on paper. Google Sheets hits a sweet spot that matters even more for a yearly plan than a monthly one:

• Free and cloud-based. No license, and it auto-saves — important when a single file is carrying a whole year of planning.
• Built for wide grids. A 12-month layout is naturally wide, and Sheets handles frozen rows, frozen columns, and horizontal scrolling cleanly.
• Easy to share. A partner can edit the same year-long plan in real time, which matters because annual planning is usually a household decision.
• Automatable. It connects to Avery, which imports and categorizes your bank transactions for you, so every month's actuals stay current without 12 months of manual entry.

That last point is the whole game with an annual budget. A yearly plan that you have to update by hand, month after month, is the kind of file that looks beautiful in January and is abandoned by March. More on that below.

How to build an annual budget in Google Sheets (step by step)

You can build one from scratch, but starting from the template means the grid, totals, and goal tracker already work. Here's the full process either way.

Step 1: Lay out the 12-month grid

Put your categories down the left side and the 12 months across the top. Freeze the top row and the first column so the labels stay visible as you scroll. Keep your categories broad — roughly 12 to 18 rows is plenty for a year. A solid starter set:

• Housing (rent/mortgage)
• Utilities
• Groceries
• Transport (gas, transit, car)
• Insurance
• Phone & subscriptions
• Dining out
• Fun money / entertainment
• Personal & health
• Gifts & holidays
• Savings
• Debt payments

The point of an annual layout is to see patterns, so resist the urge to over-split. You can always break a category in two later.

Step 2: Enter your income across the year

Add an income row (or a few — salary, side income) at the top and fill in each month. Use after-tax, monthly figures. If you're paid every two weeks, the months where a third paycheck lands will be higher; the annual grid is actually the best place to see those "extra paycheck" months, because they show up as visible bumps you can plan around.

If your income changes month to month, plan each column against the income you can reasonably count on for that month, and treat anything above it as a bonus to direct at savings or debt.

Step 3: Place your regular monthly spending

Fill in the categories that are roughly the same every month — rent, utilities, groceries — straight across all 12 columns. This is the boring, predictable backbone of the year, and getting it down first makes the irregular stuff easy to layer on top.

Step 4: Add irregular and seasonal costs in the right months

This is the step that makes an annual budget worth building. List your once-a-year and seasonal costs and put each one in the month it actually hits:

• Insurance renewals (auto, home, life)
• Property or estimated taxes
• Holiday and gift spending
• Annual subscriptions and memberships
• Back-to-school, travel, or seasonal expenses

Then take each total, divide it by 12, and you know how much to quietly set aside every month so the cash is ready when the bill arrives. A $1,200 insurance renewal isn't a $1,200 shock in March — it's $100 a month you plan for from January.

Step 5: Track actuals against the plan

You have three options, in increasing order of "set it and forget it":

1. Manual entry — fill each month's actuals as they happen. Most accurate, most effort, and over a year it's a lot of effort.
2. Monthly catch-up — sit down once a month with your statements and fill that column. Workable, but easy to skip.
3. Automatic sync — connect Avery and your transactions import and categorize themselves into every month's column.

Across a full year, option 3 is the only one that reliably survives, because the failure mode of an annual budget isn't a bad plan — it's the months you never got around to filling in.

Step 6: Review monthly, plan quarterly

An annual budget rewards two rhythms. Once a month, check the month that just closed against its plan — five minutes. Once a quarter, step back to the full-year view and look ahead: is a big cost coming, are your savings goals on pace, did the year drift? Quarterly is where you catch a problem while you still have months of runway to fix it.

Yearly vs. monthly budgeting: when to use which

These two tools answer different questions, and the smartest setup uses both.

A monthly budget answers: am I on track this month? It's tight, immediate, and great for controlling day-to-day spending. Its weakness is its strength — it can only see 30 days, so anything that happens less often than monthly is invisible to it.

An annual budget answers: is my whole year going to work? It's the wide-angle lens. It catches the seasonal and once-a-year costs a monthly view misses, and it's the only place a yearly savings goal makes sense.

You don't have to choose. Plan the year in the annual template, then run each month in a monthly one — or just use the annual grid's monthly columns as your detail view. If you want the dedicated month-by-month layout to pair with this, see the Monthly Budget template and the free monthly budget guide.

Planning for irregular annual costs (the part people skip)

The single biggest reason people overspend isn't lattes — it's the predictable-but-forgotten costs that only show up once or twice a year. They feel like emergencies because they arrive all at once, but almost none of them are actually surprises. You knew the insurance renewed. You knew the holidays were in December.

An annual budget turns these from shocks into line items. The method is simple:

1. List every irregular cost you can think of — renewals, taxes, holidays, registrations, annual fees, big seasonal purchases.
2. Place each one in its real month so the year's grid shows the true shape of your spending, spikes and all.
3. Divide each by 12 (or by the months remaining until it's due) to get a monthly set-aside.
4. Park the set-aside somewhere — a separate savings line or sub-account — so the money is waiting when the bill comes.

Do this once and a $900 holiday season becomes $75 a month you barely notice, instead of a January credit-card hangover. The template has a dedicated section for exactly this, and it folds the totals into your yearly plan automatically.

Setting annual savings goals that actually land

A yearly goal — $6,000 in an emergency fund, $3,000 for a trip — is hard to feel in a monthly budget, where it's just a number you hope to hit. In an annual budget it becomes concrete: the target divided across 12 months, with a running balance you can watch climb.

The template lets you set the goal once and tracks your progress month by month, so at any point in the year you can see whether you're ahead, on pace, or behind. If month four shows you behind, you have eight months to adjust — not a December scramble. Pairing the goal with the irregular-cost planning above is what keeps the goal from getting raided every time a renewal lands.

Keeping the annual budget current (the part that matters)

Here's the uncomfortable truth about every annual budget: a yearly plan is twelve times more data entry than a monthly one. That's twelve months of transactions to type, categorize, and reconcile. The plan you build in January is genuinely useful — but only if the actuals keep flowing in, and that is exactly where most yearly budgets quietly die.

That's the problem Avery solves. Connect your bank with a read-only link and Avery:

• Imports every transaction automatically into the right month's column.
• Categorizes each one with AI, learning your corrections over time.
• Keeps every month live, so your year-to-date totals and goal tracking are always accurate.

You go from "fill in twelve columns by hand" to "spend a few minutes a month confirming categories." The annual budget stays current all year, which is the only way a yearly plan ever actually pays off.

Related templates and guides

• Annual Budget template — the free Google Sheet this guide is built around.
• Annual budget Q&A — quick answers to the most common setup and planning questions.
• Monthly Budget template — the month-by-month companion for executing the year you've planned.
• Budget Spreadsheet template — a flexible, do-it-yourself budget you can shape however you like.
• Free monthly budget template guide — the companion walkthrough for monthly budgeting.
• How to use a monthly budget template — a deeper how-to for the monthly side of your plan.
• Browse all free templates — the full Avery library.

An annual budget gives you the long view; automation keeps it alive. Start with the free template, lay out your year, and let Avery handle the data entry so the plan is still working for you in month nine — not gathering dust by March.