# Budget tracker spreadsheet in Google Sheets

Learn how to set up a budget tracker spreadsheet in Google Sheets with planned versus actual columns, tracking formulas and monthly expense categories you can share.

A budget tracker spreadsheet in Google Sheets is a single sheet where you list your income and expense categories, then compare what you planned to spend against what you actually spent. Google Sheets stores the file online and lets you share it with other people, so a household or a small team can update the same numbers. You build it once from a template or from blank cells, and then reuse the layout each month. 

- Set up one row per monthly expense category and keep planned and actual amounts in separate columns.
- Add simple formulas that total each column and show the difference between planned and actual.
- Fix the category list first, because the rows decide what the totals can tell you.
- Share the sheet with named people and set their edit or view access before the month starts.
- Save a blank copy as a reusable template so the layout stays identical every month.
 

## How a Google Sheets budget tracker is built 

A budget tracker spreadsheet in Google Sheets is a grid of rows and columns that holds your money plan for one period. Each row is a category, such as rent, groceries or transport, and each column holds one kind of number: the amount you planned and the amount you actually recorded. The grid stays readable because every row follows the same pattern from top to bottom. 

The file lives in Google Drive, so the sheet opens in a browser or the Sheets app and saves itself as you type. That online storage is what makes sharing practical, because two people can open the same file instead of emailing copies. A local spreadsheet file works the same way on one device but does not let others edit it at the same time. 

Start with a header row that names every column, then add one row per category below it. Leave a few empty rows at the bottom so a new category can be inserted without rewriting the totals. Name the sheet tab after the month or the purpose so a copy is easy to identify later. 

## Set up planned and actual columns 

Planned versus actual columns are the core of the tracker, because they turn a list of costs into a comparison. The planned column holds the figure you set before the period begins, and the actual column holds the figure you record as money leaves. One column tells you the intention and the other tells you the outcome. 

A third column for the difference, often called variance, shows the gap between the two numbers. A positive variance means you spent less than planned, and a negative variance means you spent more. Reading the difference is faster than comparing two figures by eye across a wide row. 

Keep income rows separate from expense rows so each total means one thing. If income and expenses sit in the same block, a column total mixes money coming in with money going out. A small header label above each block keeps the sheet clear to anyone who opens it. 
| Column | What it holds | Example entry | 
| Category | Name of the income or expense row | Groceries | 
| Planned | Amount set before the period | 400 | 
| Actual | Amount recorded during the period | 365 | 
| Variance | Formula result of planned minus actual | 35 |  

## Write formulas for totals and variance 

Budget tracking formulas do the arithmetic so the sheet updates itself when a number changes. A SUM formula adds a column of figures, and a subtraction formula gives the variance for one row. Formulas are typed once and then copied down the column. 

A typical row formula subtracts the actual cell from the planned cell and returns the difference. Copy that formula down so every category row calculates its own variance. A SUM formula at the foot of each column then totals the planned, the actual and the variance figures. 

Check a formula by typing test numbers into an empty copy and confirming the totals match a hand count. A formula that points at the wrong cell can stay hidden until the numbers grow. Absolute references, marked with dollar signs, keep a total range fixed when you copy a formula to another cell. 

## Choose your monthly expense categories 

Monthly expense categories decide what the tracker can tell you, so build the list before adding numbers. A category should group costs you would act on together, such as housing, food, transport or debt payments. Too many narrow categories make the sheet long, and too few broad ones hide where the money went. 

Use the same category names every month so comparisons stay valid across periods. Renaming a row halfway through a year breaks the link to earlier copies of the sheet. Keep a short reference list of category names on a second tab if several people add entries. 

- Housing: rent or mortgage payment
- Utilities: power, water and internet
- Food: groceries and meals outside the home
- Transport: fuel, fares and vehicle upkeep
- Debt: loan and card payments
- Savings: money set aside on purpose
- Other: costs that fit no fixed row
 

## Start from a Google Sheets budget template 

A Google Sheets budget template is a ready-made file with the rows, columns and formulas already in place. Google Sheets offers a template gallery, and a blank sheet works when you prefer to build the layout yourself. A template saves setup time, while a blank sheet gives you full control of the structure. 

Check what a template assumes before you trust its totals. A template built for yearly planning uses different periods and rows than one built for a single month. Open the formulas and confirm which cells each one reads, then delete rows you do not need. 

A hybrid approach works for many people: take the column structure from a template and replace its category rows with your own. The formulas survive the edit as long as the row range still covers the new list. Test one month of real numbers before relying on the file for a full period. 

## Share the sheet and control access 

Sharing a spreadsheet lets another person view or edit the same file, and Google Sheets sets the access level for each person you invite. View access suits someone who only needs to read the totals. Edit access suits a partner or colleague who records entries. 

Send an invitation to a named email address instead of opening the file to anyone with the link. Named access shows who changed the sheet and limits who can see your figures. Review the access list at the start of each period and remove anyone who no longer needs it. 

Version history in Google Sheets records earlier states of the file and lets an owner restore one. That record helps when an edit breaks a formula or a row disappears. Agree with the other editors on who owns the file and who makes structural changes. 

## Keep the tracker accurate over time 

Accuracy in a budget tracker comes from recording entries close to the moment the money moves. A receipt or a bank line checked against the sheet keeps the actual column honest. A large gap between planned and actual is a signal to look at the category, not to delete the row. 

Recopy the file at the start of each period and clear the actual column while keeping the planned column. That step gives you a fresh month with the same structure and a clear comparison to the previous one. Keep old copies in a folder so the record stays available. 

Protect the formula cells from accidental edits if several people share the file. Sheet protection restricts changes to chosen ranges while leaving the entry cells open. A protected sheet still allows the owner to change structure when a category is added or removed. 

## Questions about a Google Sheets budget tracker 

### Can I build a budget tracker spreadsheet in Google Sheets for free? 

Yes, a budget tracker spreadsheet can be built in Google Sheets without paying for the file itself. The sheet is created inside a Google account, and the cost depends on whether you need extra storage beyond the free allowance. Building the rows, columns and formulas costs nothing beyond the account. 

### What formulas does a budget tracker need? 

A budget tracker needs a SUM formula for column totals and a subtraction formula for the variance on each row. A SUM formula adds the planned figures and another adds the actual figures. The variance formula subtracts actual from planned so each row shows its own gap. 

### How do planned and actual columns work together? 

Planned and actual columns work as a pair, because the planned figure sets the target and the actual figure records the outcome. A variance column then shows the difference between them for each category. Comparing the two shows where the plan held and where it did not. 

### Can I share a budget tracker with someone else? 

Yes, Google Sheets lets you share a budget tracker with another person by email and set view or edit access. Named access keeps the file restricted to the people you invite. Version history then shows earlier states if an edit goes wrong. 

### Should I use a template or start from a blank sheet? 

Either option works, and the choice depends on how much control you want over the layout. A template supplies ready-made rows and formulas, which shortens setup. A blank sheet lets you design the categories and columns around your own spending. 

### Which expense categories should a monthly tracker include? 

A monthly tracker should include categories for housing, utilities, food, transport, debt payments and savings. Each category groups costs you would review together, so the totals point to an area you can adjust. Add or merge rows as your spending changes, and keep the names stable across periods.
