Tracking your expenses is one of the most powerful things you can do for your finances. When you know exactly where your money goes, you stop being surprised at the end of the month — and you start making intentional decisions about your spending. Google Sheets is one of the best free tools for doing this, and you don't need any technical background to set it up.
This guide walks you through the entire process, from creating your spreadsheet from scratch to building formulas that automatically total your spending by category. By the end, you'll have a working expense tracker you can use every month.
What You Need Before You Start
All you need is a free Google account and access to Google Sheets at sheets.google.com. No paid subscriptions, no downloads, and no prior spreadsheet experience required.
Step 1: Create a New Spreadsheet and Name It
Open Google Sheets and click the "+" button to create a blank spreadsheet. Name it something like "Monthly Expense Tracker 2026" so it's easy to find later. You'll use one tab per month, so clear naming matters from the start.
Step 2: Set Up Your Column Headers
In row 1, create the following column headers across columns A through E:
| Column | Header | Purpose |
|---|---|---|
| A | Date | When the purchase was made |
| B | Description | What you bought or where you spent |
| C | Category | Type of expense |
| D | Amount | How much you spent |
| E | Payment Method | Cash, debit, or which credit card |
Bold row 1 so it stands out from your data rows. These five columns capture everything you need to understand your spending patterns.
Step 3: Build Your Category List
Before entering any transactions, decide on your expense categories. The goal is to be specific enough to be useful, but not so granular that categorizing every purchase becomes a chore. A practical starting list for most people:
| Category | What It Covers |
|---|---|
| Housing | Rent, mortgage, property taxes, HOA fees |
| Groceries | Supermarket, farmers market, warehouse clubs |
| Dining Out | Restaurants, cafes, takeout, delivery apps |
| Transportation | Gas, car payment, public transit, rideshare |
| Utilities | Electricity, water, internet, phone bill |
| Subscriptions | Streaming, software, gym, memberships |
| Health | Doctor visits, prescriptions, dental |
| Personal Care | Haircuts, toiletries, clothing |
| Entertainment | Movies, concerts, hobbies, games |
| Savings | Transfers to savings accounts |
| Miscellaneous | Anything that doesn't fit elsewhere |
Add or remove categories based on your actual life. If you spend significantly on pet care or home improvement, those deserve their own lines.
Step 4: Create a Dropdown List for Consistent Categorization
The most common reason expense trackers produce useless data is inconsistent category names. If you type "Groceries" sometimes and "grocery" or "Food" other times, your totals won't add up correctly.
To prevent this, create a dropdown list in column C. Select the entire column C (excluding the header). Go to Data → Data Validation → Criteria → Dropdown from a list. Type your categories separated by commas. Click Save.
Now every time you click a cell in column C, a dropdown arrow appears and you select from your predefined list — no typing, no inconsistencies.
Step 5: Enter Your Transactions
Each time you spend money, add a new row to your spreadsheet. A completed week of entries might look like this:
| Date | Description | Category | Amount | Payment Method |
|---|---|---|---|---|
| 07/14/2026 | Whole Foods | Groceries | $87.43 | Debit Card |
| 07/14/2026 | Spotify | Subscriptions | $11.99 | Credit Card |
| 07/15/2026 | Shell Gas Station | Transportation | $54.00 | Credit Card |
| 07/15/2026 | Chipotle | Dining Out | $14.50 | Debit Card |
| 07/16/2026 | CVS | Health | $28.00 | Cash |
You can log transactions daily or batch them once a week — whichever you'll actually stick to. The important thing is that every purchase gets recorded.
Step 6: Create a Summary Section with SUMIF Formulas
This is where Google Sheets becomes genuinely powerful. In a separate section of your sheet (or on a new tab called "Summary"), create a table that automatically totals your spending by category.
Set up two columns: Category and Monthly Total. In the Monthly Total column, use a SUMIF formula:
=SUMIF(C:C,"Groceries",D:D)
This formula scans column C for every row where the category is "Groceries" and sums the corresponding amounts in column D. Copy this formula for each category, changing the category name in quotes each time.
Your summary section will update automatically every time you add a new transaction — no manual math required.
Step 7: Add a Budget vs. Actual Comparison
Once you have your category totals, add a third column to your summary table for your budget target. Then add a fourth column that calculates the difference:
| Category | Budget | Actual | Difference |
|---|---|---|---|
| Groceries | $400 | $387 | +$13 |
| Dining Out | $150 | $214 | -$64 |
| Transportation | $200 | $178 | +$22 |
| Subscriptions | $80 | $80 | $0 |
A positive difference means you came in under budget. A negative difference means you overspent. This comparison is the most useful output in your entire tracker — it tells you exactly where to focus your attention next month.
Step 8: Use Conditional Formatting to Spot Overspending Instantly
Select the Difference column. Go to Format → Conditional Formatting. Create two rules:
- Rule 1: If value is less than 0 → background color red, text dark red (you overspent)
- Rule 2: If value is greater than 0 → background color green, text dark green (you're under budget)
Now you can see your problem areas the moment you open the spreadsheet, without reading a single number.
Step 9: Duplicate the Tab for Each Month
Right-click on your sheet tab and select "Duplicate." Rename the new tab with the next month's name. Clear out the transaction rows but keep all your formulas, headers, and formatting. This way you build a full year of expense history in one file, with each month on its own tab.
The Biggest Challenge: Actually Entering Your Transactions
The system above works — but only if you actually log your expenses. The most common reason people abandon their expense trackers is that manually typing in every transaction is tedious, especially when you're paying with cards and collecting paper receipts throughout the day.
This is exactly what ReceiptSync solves. Instead of manually typing each purchase, you scan your receipts with your phone and ReceiptSync automatically extracts the date, merchant, and amount. You can then export that data directly to Google Sheets, so your tracker stays current without the manual data entry grind. It's the difference between a tracker you maintain for two weeks and one you actually use all year. Start tracking your spending free with ReceiptSync →
A Monthly Review Routine That Takes 15 Minutes
Once your tracker is set up, spend 15 minutes at the end of each month reviewing it. Ask yourself three questions: Which category surprised me the most? Where did I consistently overspend? What one change would make next month better? This review is where the real value of expense tracking shows up — not in the data itself, but in the decisions it helps you make.
Related posts: