Annual budget template: plan 12 months, catch irregular costs and see the year at a glance

The short answer: An annual budget template puts your whole year on one page: what comes in, what goes out each month and the irregular costs that tend to ambush a monthly budget. With the year mapped out, December gifts and July car registration stop being surprises.

• Layout below: one row per category, 12 month columns and a year total
• For scale: U.S. households averaged $78,535 in spending in 2024, per the BLS
• Free tool: set monthly targets with the free budget calculator
• Next step: the Annual Budget Spreadsheet ($6.99) does the math across 12 monthly tabs.

Here's a layout you can copy, how to fill it in from last year's statements, and how to keep it current month by month.

Want the math done for you? Our Annual Budget Spreadsheet starts with a setup tab for your own categories, then gives you 12 monthly tabs with planned vs. actual and a year dashboard, in Excel or Google Sheets.

For context, the Bureau of Labor Statistics' Consumer Expenditures report for 2024 put average annual spending at $78,535 per household (BLS calls them consumer units), up from $77,158 the year before, with average pre-tax income of $104,207. Your numbers will be different, and they're the ones that matter, but it's a reminder of how much money moves through a household in twelve months.

Why plan the year, not just the month

Monthly budgets work well for regular bills. They break when something shows up once a year: the insurance premium, the holiday season, back-to-school, the annual subscription that renews in March. The Federal Reserve's 2025 household well-being report found 63% of adults would cover a $400 surprise expense with cash or its equivalent, which means many households don't have a cushion when an irregular bill lands.

An annual budget turns those big, rare bills into small monthly amounts.

The annual budget template layout

On paper, this fits on one landscape sheet. In a spreadsheet (see how to create a budget spreadsheet), the totals and the left-over row calculate themselves. Want it ready-made? Our budget Excel template does the totals for you and also works in Google Sheets.

The Annual Budget Spreadsheet ($6.99) is built this way: a setup tab for your categories and plan, 12 monthly tabs (January to December), a transaction log with category dropdowns, planned vs actual by category, over-budget alerts in red and a year dashboard with a chart. It works in Excel and Google Sheets.

Step 1: Gather last year's numbers

Pull 12 months of bank and credit card statements. For each category, add up the year and divide by 12. That's your honest starting point. If you don't have a full year, three months multiplied by four gets you close.

Step 2: List every irregular expense

This is the step that makes an annual budget worth doing. Go month by month and write down anything that doesn't happen every month:

Divide each yearly cost by 12 and add those set-asides to your monthly plan. The Sinking Funds Tracker ($4.99) tracks up to 20 of these goals with the monthly amount needed to hit each due date. Our sinking funds guide explains the method.

Step 3: Set monthly targets

For each category, write the planned amount in every month. Most categories repeat; irregular ones spike in their month. Then check the left-over row. If any month goes negative, move money from a lighter month or trim a category before the year starts, not after.

If you're paid on an uneven schedule, plan each month's income separately. Months with a third paycheck (for biweekly pay) are a great place to catch up on savings.

Step 4: Track actual spending each month

At the end of each month, log what you actually spent and compare it to the plan. You're looking for patterns, not perfection:

• One category always over? The plan is too low. Raise it and lower something else.
• One category always under? Move the difference to savings or debt.
• A surprise expense? Add it to next year's irregular list.

The budget categories list is useful here if you find spending that doesn't fit your current categories.

Step 5: Do a year-end review

In December, compare the year total for each category to the plan. Three questions set up next year:

1. Where did we spend more than planned, and was it worth it?
2. Where did we save, and where should that money go next year?
3. What irregular expense caught us off guard?

Our end-of-year financial checklist walks through the rest of the year-end tasks, and how to make a budget for the new year picks up in January.

A year-end review is also a good time to update a personal financial statement, which lists what you own and what you owe on one date.

Prefer paper?

Affiliate links: we may earn a small commission. As an Amazon Associate we earn from qualifying purchases. Details.

Some people plan better with a pen; Paper Mate InkJoy gel pens are one option. The Budget Planner Printable ($5.99) has 12 undated pages, including a monthly budget, income, expense log, bill payments, debt payoff, savings, sinking funds and an Annual Summary page for your year at a glance. Print it, keep it in an Avery Durable View 1-inch binder and fill in one month at a time.

Not sure which format suits you? See budget planner printable vs spreadsheet, or start with the monthly budget worksheet if the year feels like too much for now.

Want the whole year on your phone and laptop? See our digital budget planner guide.