Annual Budget Spreadsheet for Excel and Google Sheets

Picture someone who budgets “in their head”. They know rent and the phone bill, roughly. But every few months a yearly subscription renews unexpectedly, a credit card balance creeps up, and the savings goal for a holiday never quite gets started. Monthly budgeting apps show this month, but not the shape of the whole year. An annual budget spreadsheet does: twelve months planned up front, actual spending compared against it, and bills, subscriptions, debt and savings in the same file.

This guide explains how to build a yearly budget that you will keep using, then walks through our Annual Budget Spreadsheet for Excel and Google Sheets.

Get the Annual Budget Spreadsheet →

Why monthly budgets miss the bigger picture

A monthly budget is a good start, but money problems often come from things that do not happen every month.

• Irregular costs. Annual insurance, car servicing, holidays and gifts fall in particular months and wreck a budget that assumed every month is the same.
• Forgotten subscriptions. Small weekly or yearly charges renew quietly, and it is hard to see their total.
• Debt without a plan. Paying a bit off each card without a strategy can mean paying more interest than you need to.
• Savings goals with no monthly number. “Save for a deposit” is hard to act on until it becomes “put aside this much each month”.
• No sense of progress. Without net worth or a year-to-date view, it is hard to tell whether things are improving.

Free budget templates often cover one of these well. Combining them into a single workbook, with each sheet feeding the dashboard, is what turns a budget into a year plan.

How to build a yearly budget (step by step)

You can follow these steps in any spreadsheet.

1. Set up your categories. Group them (for example housing, transport, food, lifestyle and savings) and keep the list short enough to maintain.
2. Plan all 12 months. Start with your usual monthly amounts, then adjust the months where you know costs will differ: insurance renewals, holidays, gifts.
3. Log transactions regularly. Weekly is a good rhythm. Each entry needs a date, a category and an amount.
4. Compare budget vs actual each month. Look for categories that are consistently over and decide whether to change the plan or the spending.
5. List bills and subscriptions with due dates. Note how often each one is charged, when it renews and whether it is on autopay.
6. Choose a debt strategy. Snowball pays the smallest balance first for quick wins; avalanche pays the highest interest rate first to reduce total interest. Comparing both helps you choose.
7. Give each savings goal a monthly target. Divide the amount you need by the months remaining.
8. Track net worth monthly. Assets minus debts, once a month, is a simple measure of progress.

Tip: build a small buffer category for unexpected costs. A budget with no room for surprises tends to get abandoned after the first one.

A monthly money routine (about 20 minutes)

• Log or check any transactions you missed.
• Look at budget vs actual for the month and note the two categories furthest off plan.
• Check the bills due next month and any subscriptions about to renew. Cancel anything you no longer use.
• Update debt balances and savings goal progress.
• Record net worth for the month, and note one thing that went well.
• Adjust next month’s plan if something has changed.

Doing this on the same day each month, for example the first weekend, makes it a habit rather than a chore. If you share costs with a partner or housemate, do the review together so you both see the same numbers and agree on any changes.

Inside the annual budget spreadsheet

The Annual Budget Spreadsheet works in Excel and Google Sheets. Plan the whole year, log what you spend and see where your money goes, with bills, subscriptions, debt and goals in the same file. It includes a sample year to learn from.

Start Here, Setup and Budget Plan

The START HERE tab explains the steps and colour key. On SETUP you choose the year, currency, up to 40 categories in 5 groups, and your accounts. BUDGET PLAN holds monthly amounts for 12 months, and you can type over any month.

Dashboard

Year-to-date income, spending, debt paid, saved, savings rate, left over, net worth and emergency-fund months, with charts, top categories and this month at a glance.

Monthly view and transactions

MONTHLY lets you pick any month and see budget vs actual for every category and group, with a chart. TRANSACTIONS has 3,000 rows, and group and month fill in for you.

Annual overview

Every category by month, compared with your plan, by group, with savings rate and a chart.

Bills calendar and subscriptions

The BILLS CALENDAR shows each bill as paid, due soon, overdue or autopay, with paid status taken from your own transactions and a month calendar. SUBSCRIPTIONS handles weekly to yearly costs, the next renewal date, 7-day alerts and the money saved if you cancel.

Debt payoff, savings goals and net worth

DEBT PAYOFF handles up to 10 debts and compares snowball vs avalanche side by side: payoff dates, debt-free date, total interest and interest saved. SAVINGS GOALS shows progress, how much you need per month and emergency fund months covered. NET WORTH tracks assets and debts by month with a chart.

Watch the setup guide and full tour

This video walks through setup and every tab:

Who it’s for (and who it isn’t)

A good fit if you:

• Want to plan a whole year of spending, not just this month
• Have bills, subscriptions or debts you want to see together
• Are deciding between snowball and avalanche debt payoff
• Prefer a spreadsheet you own to a budgeting app subscription

Probably not for you if you:

• Want automatic bank imports (you enter transactions yourself)
• Need business bookkeeping with invoicing and tax set-aside (see the Small Business Finance Spreadsheet Bundle)
• Only use a phone (a computer is recommended for setup)

This is an organising tool for your own money, not financial advice.

FAQ

Excel or Google Sheets: which do I need?

Either. Open the .xlsx file in Excel, or in Google Sheets create a blank sheet, then File > Import > Upload > Replace spreadsheet. It uses formulas only.

Is it an instant download?

Yes. You download the .xlsx file and the Setup Guide PDF. Nothing physical is shipped.

Can I use my own currency and categories?

Yes. On the SETUP tab you set the year, currency, up to 40 categories in 5 groups, and your accounts.

Can I use it for more than one year?

You choose the year on the SETUP tab. You can start a fresh copy of the file for each new year.

Does it work on my phone?

A computer is recommended for setup. The Google Sheets app works for quick updates.

Running a small business as well? The Small Business Finance Spreadsheet Bundle covers cash flow, P&L, invoicing and tax set-aside. See more in our Excel and Google Sheets spreadsheets.

Get the Annual Budget Spreadsheet →

Excel is a trademark of Microsoft and Google Sheets is a trademark of Google. This spreadsheet is independent and not affiliated with or endorsed by either.