A new year is the perfect time to get your money organized, and an annual budget spreadsheet is one of the easiest ways to do it. Instead of juggling twelve separate budgets, you plan and track January through December in one Google Sheets file, with automated charts that show exactly where your money went.
In this guide, you'll learn what an annual budget is, what to include in it (with lists of common expenses, bills, and savings goals), and exactly how to set up and use the Palm & Grace Annual Budget Spreadsheet for Google Sheets, step by step. Prefer to watch? The full video tutorial is right below.
Want to follow along? Grab the Annual Budget Spreadsheet Template and set it up as you read.
In this guide
- What is an annual budget?
- What's inside the annual budget spreadsheet
- How to set up your annual budget in Google Sheets (5 steps)
- Common variable expenses to include in your budget
- Common bills and subscriptions to track
- Don't forget irregular and once-a-year expenses
- Savings goals and sinking fund ideas
- Wants, needs, and savings: the 50/30/20 rule
- Tips for sticking to your annual budget
- Frequently asked questions
What is an annual budget?
An annual budget is a plan for your income, spending, debt payments, and savings for an entire year. It still breaks down month by month, but it also gives you the big picture: how much you earned and spent across the whole year, which categories took the most, and how close you are to your savings goals.
Annual vs. monthly budget: a monthly budget is great for managing what's happening right now. An annual budget adds the long view. It helps you plan for expenses that don't come every month (like holidays, insurance premiums, or vacations), spot spending trends over time, and see your progress month after month. If you only want to budget one month at a time, the Monthly Budget Spreadsheet is a beginner-friendly option. If you want the full picture, an annual budget is the way to go.
What's inside the annual budget spreadsheet
Before we jump in, here's a quick look at the tabs you'll be working with:
- Start – your settings and all of your budget categories
- Annual Overview – a fully automated summary of your entire year
- Savings – automated progress tracking for every savings goal
- Variable Expenses – one organized place to log every transaction
- 12 monthly tabs – a budget and spending tracker for each month, January to December
It works for any year and any currency, and you can add up to 40 variable expense categories, 40 bills or subscriptions, 30 debts, and 30 savings or investment goals.
How to set up your annual budget in Google Sheets
Step 1: Set up the Start tab
The Start tab is the first one you'll fill out, and it's where all the details for your spreadsheet live. You can come back at any time to add more categories.

At the top of the tab, you'll:
- Add your currency symbol. Type it in or copy and paste it.
- Type in the year you're budgeting for.
- Add a starting amount (optional). It's totally fine to leave this at zero.
- Choose whether to roll over leftover funds. If you finish January with $50 unspent, a check here carries that $50 into February's budget. Uncheck it to start each month fresh.
Tip: Choose your rollover setting before you start editing any of the monthly budget tabs.
Next, add your variable expense categories (spending that changes from month to month) and your bills and subscriptions. Not sure what to include? Jump to our lists of common variable expenses and common bills. The optional frequency column (monthly, yearly, twice a year) is just for your own organization.
For each category, choose from the dropdown whether it's a want, a need, or a saving. This powers the wants/needs/savings breakdown on every monthly tab.

In the debts section, add each debt you're paying off along with its minimum monthly payment. Debts are automatically counted as needs. In the savings and investments section, add each fund with a start amount and a goal. A holiday fund you're starting from scratch would have a start amount of zero. A trip you've been saving for over a few years would start with what you've already set aside, with your long-term goal as the target.

Step 2: Explore the Annual Overview tab
The Annual Overview tab is fully automated. It pulls every number you enter elsewhere into one detailed summary of your year, so you don't need to type anything here (and it's best not to, so the formulas stay intact).

- Hover over any chart to see the exact amounts behind it, including the trend lines and pie charts.
- Expand the sections at the bottom with the plus and minus signs in the left sidebar. Each one opens a month-by-month summary of what you spent in every category.

Step 3: Watch your goals grow in the Savings tab
The Savings tab is also fully automated and locked, so you can't accidentally edit it. (If you try, a pop-up appears and you can simply click cancel.)

Each savings goal gets its own box showing your goal amount, start amount, how much you've saved this year, your total saved, your average monthly contribution, and a progress chart. Scroll down to choose any fund and see how much you saved for it each month.

Plan your whole year in one spreadsheet
Dozens of automated charts, a savings tracker, and 12 monthly budget tabs, ready to use in Google Sheets.
Step 4: Log your spending in the Variable Expenses tab
This is where you'll record your everyday spending throughout the year. For each transaction:
- Add the date. Type it in, or double-click any cell in the date column and pick the date from the pop-up calendar.
- Add a description (optional), like "renting a canoe for the lake."
- Choose a category from the dropdown. These come from the categories you set up on the Start tab.
- Enter the amount and any notes.
The last column fills itself in automatically with whether that category is a want, need, or saving.

Highlight transactions by category or month. At the top of the tab, choose "Category," then pick one (like Groceries), and every matching transaction lights up. You can do the same by month.

Sort and filter your spending. Every column has a filter, so you can sort by amount or date, or show only certain categories or only your needs.

Step 5: Build your budget in the 12 monthly tabs
There's a monthly budget tab for each month of the year. They all look nearly identical, so double-check that you're in the right month before entering numbers! You decide how much to budget: just part of each paycheck or every dollar you earn.

Only type into the white cells. The darker columns are automated, and typing in them could break a formula. Here's the step-by-step:
- Fill out the Incomes box. Add up to 10 incomes (paychecks, gifted money, side income) with an estimated budget, then add the actual amounts as you're paid.
- Set your variable expense budgets. Add a budget for each category at the start of the month (a budget of zero is totally fine). Your actual spending fills in automatically from the Variable Expenses tab.
- Track your bills. Add a budget for each bill, enter the actual amount when it arrives, and check it off once it's paid.
- Track your debt payments. Toggle on "show minimums" to see each debt's minimum payment right next to your budget.
- Track your savings. Budget how much you want to set aside for each goal, add the actual amount, and check it off.
As you add numbers, the Cash Flow box updates automatically. It shows how much you have left to budget and your total cash remaining. If rollover is on, that remaining cash carries into next month's tab.

Further down, you'll find a breakdown of what percentage of your money goes to wants, needs, and savings. Switch the dropdown between budgeted and actual to compare your plan with what really happened.

In the bottom right corner, the Spend by Day chart shows your variable spending across the month. Days marked with an asterisk fall on a weekend, so you can see whether you tend to spend more on Saturdays and Sundays.

Time-saving tip: If some categories have the same budget every month, select the budget numbers, press Cmd + C (Mac) or Ctrl + C (Windows), go to the next month's tab, click the top cell, and press Cmd + V or Ctrl + V.
Common variable expenses to include in your budget
Variable expenses are the costs that change from month to month. They're usually the easiest place to find savings, which is why it helps to track them in their own categories. Here are common ones to consider:
- Groceries and household supplies (cleaning products, paper goods)
- Dining out, takeout, and coffee runs
- Gas and other transportation costs (parking, tolls, rideshares, transit)
- Personal care: haircuts, beauty products, toiletries
- Clothing and shoes
- Entertainment: movies, concerts, outings, hobbies
- Gifts for birthdays, weddings, and holidays
- Kids: activities, school supplies, childcare extras
- Pets: food, grooming, vet visits
- Medical: copays, prescriptions, over-the-counter items
- Home: maintenance, repairs, décor
- Miscellaneous purchases (a small buffer for everything else)
Tip: Start with fewer, broader categories. You can always split them later. The spreadsheet lets you add up to 40, but most people find 8–15 easier to keep up with.
Common bills and subscriptions to track
Bills and subscriptions are your recurring costs. Even when the amount is the same each month, tracking them helps you catch price increases and subscriptions you've forgotten about.
- Housing: rent or mortgage, HOA fees
- Utilities: electricity, water, gas, trash
- Internet and phone
- Insurance: car, health, renters or homeowners, life
- Streaming services and music subscriptions
- Memberships: gym, warehouse clubs, online shopping memberships
- Apps and software subscriptions
- Childcare or tuition
Use the optional frequency column on the Start tab to note whether each bill is monthly, quarterly, or yearly. That way you'll never be surprised by an annual renewal.
Don't forget irregular and once-a-year expenses
One of the biggest advantages of an annual budget is planning for expenses that don't show up every month. These are the ones that often catch people off guard:
- Holiday gifts, decorations, and travel
- Birthdays and anniversaries
- Car registration, inspections, and maintenance
- Insurance premiums paid once or twice a year
- Annual subscriptions and memberships
- Back-to-school costs
- Vacations
- Annual vet or dental checkups
A simple way to handle these: add up the yearly cost, divide by 12, and set that amount aside each month as a savings goal. Then when the expense arrives, the money is already there.
Savings goals and sinking fund ideas
A sinking fund is money you set aside little by little for a specific upcoming expense. In the spreadsheet, you can add each one as a savings goal with a target amount and watch its progress chart fill up in the Savings tab. Popular ideas include:
- Emergency fund
- Holiday fund for gifts and celebrations
- Travel fund for your next trip
- Car fund for repairs or your next vehicle
- Home fund for repairs, projects, or furniture
- Medical fund for deductibles and unexpected costs
- Big purchase funds, like a new laptop or a wedding
If saving is your main focus, our Savings Tracker Spreadsheet tracks up to 30 savings goals on its own.
Wants, needs, and savings: the 50/30/20 rule
Every category in the spreadsheet is labeled as a want, a need, or a saving, and each monthly tab shows how your money splits between the three. One popular guideline for that split is the 50/30/20 rule:
- 50% for needs: housing, utilities, groceries, insurance, minimum debt payments
- 30% for wants: dining out, entertainment, shopping, hobbies
- 20% for savings: savings goals, investments, and extra debt payments
It's a starting point rather than a strict rule, and the right split depends on your income, costs, and goals. The breakdown chart makes it easy to compare what you planned with what you actually spent, and adjust from there.
Tips for sticking to your annual budget
- Log expenses weekly. A few minutes each week is much easier than catching up at the end of the month.
- Review each month before starting the next. Check the monthly tab's charts, then adjust next month's budget based on what you learned.
- Budget for fun. A realistic budget includes some wants, which makes it easier to stick with.
- Use the Annual Overview for check-ins. Every few months, look at your yearly trends and savings progress to see how far you've come.
- Don't aim for perfection. Going over in a category is information, not failure. Adjust and keep going.
Starting a new year
Since this is an annual budget, you'll make a fresh copy of the spreadsheet each year, which keeps every year's spending neatly organized. To save time, copy and paste your categories from last year's Start tab. For long-term savings goals like a travel fund, update the start amount to what you'd saved by the end of the previous year so you can track your progress year over year.
Frequently asked questions
How do I make an annual budget in Google Sheets?
List your expected income, then your expenses in categories (variable expenses, bills, debts, and savings), and set a monthly budget for each. Track your actual spending throughout the year and compare it with your plan. A ready-made template like the Annual Budget Spreadsheet does the formulas and charts for you, so you only enter your numbers.
Does this budget spreadsheet work for any year?
Yes. Just type the year into the Start tab. It covers January through December of any year.
Can I use it in a currency other than dollars?
Yes. Type or paste your currency symbol into the Start tab, and the whole spreadsheet uses it.
Does it work in Excel?
No, it's made for Google Sheets only. It works on desktop, tablet, and mobile, but it works best on a desktop computer.
Do I have to budget every dollar?
Not at all. Budget as much or as little of your income as you like: all of your paychecks, or just part of them.
What happens to money I don't spend?
That's up to you. With the rollover setting on, leftover cash carries into the next month's budget. With it off, each month starts fresh.
Is there a simpler version?
If you only want to budget one month at a time, the Monthly Budget Spreadsheet is a beginner-friendly option. You can also browse all of our budget spreadsheets.
Ready to plan your year?
An annual budget gives you the big picture and the month-to-month details in one place, with dozens of automated charts doing the math for you. I hope it helps you feel more organized and confident with your money, and closer to your financial goals.

Annual Budget Spreadsheet Template for Google Sheets
Available in pink and blue, with instant access after purchase.
Have questions about setting it up? Reach out anytime. I'm always happy to help!

