Monthly Spending Tracker in Google Sheets: Step-by-Step

This guide shows you how to build a simple, effective monthly spending tracker in Google Sheets. You’ll set up a sheet where you log every expense, categorize it, and automatically see totals by category and for the month. No formulas to memorize—just copy, paste, and adapt the steps below. You’ll need a free Google account (Gmail works) and a web browser.

What You’ll Need

• A Google account (free)
• Access to Google Sheets (sheets.google.com)
• Your spending data: receipts, bank statements, or a list of recent purchases

Step-by-Step

1. Open Google Sheets. Go to sheets.google.com and sign in. Click the blank spreadsheet icon (labeled “Blank”) to create a new sheet. It will open with a default name like “Untitled spreadsheet.”
2. Name your file. Click the title “Untitled spreadsheet” in the top-left corner and type “Monthly Spending Tracker – [Current Month]” (e.g., “Monthly Spending Tracker – March 2025”). Press Enter.
3. Set up column headers. In row 1, type these headers in columns A through E:
   • A1: Date
   • B1: Category
   • C1: Description
   • D1: Amount
   • E1: Payment Method (optional)
4. Format the Date column. Click on cell A2, then drag to select A2:A100 (or further if you expect more entries). Go to the menu: Format → Number → Date. This ensures dates are recognized as dates, not text.
5. Format the Amount column. Select D2:D100, then Format → Number → Currency. Choose your local currency (e.g., USD, EUR, GBP). This will automatically add the currency symbol and two decimal places.
6. Add a drop-down for categories. Select B2:B100, then go to Data → Data validation. Under “Criteria,” choose “List of items” and enter your categories separated by commas, for example: Housing, Groceries, Transport, Utilities, Dining Out, Entertainment, Health, Shopping, Other. Click “Save.” This gives you a clickable drop-down in each cell.
7. Create a totals area. In a free area, say column G, set up a summary table. In G1 type “Category”, H1 type “Total”. In G2:G10 list your categories (the same ones you used in the drop-down).
8. Write the SUMIF formula. Click on H2 and enter the following formula: =SUMIF(B:B, G2, D:D). This sums all amounts in column D where the category in column B matches the category in G2. Press Enter. You should see 0 or a blank until you have data.
9. Copy the formula down. Click on H2 again, then drag the small blue square at the bottom-right corner of the cell down to H10. This copies the formula for each category.
10. Add a total row. In H11, type =SUM(D:D) to get the overall monthly total. Label G11 as “Total”.
11. Add a month filter (optional but useful). If you want to track multiple months in one sheet, add a helper column. For example, in F1 type “Month”, and in F2 enter =TEXT(A2, "MMM YYYY"). Drag this down for all rows. Then you can filter or use SUMIFS to sum by month. For a single-month tracker, you can skip this step.
12. Test it. Enter a few sample expenses: Date (e.g., 3/1/2025), Category (choose from drop-down), Description (e.g., “Grocery store”), Amount (e.g., 45.50). Watch the totals update automatically.
13. Make it your own. Adjust categories to match your spending. Add more columns if needed (e.g., “Notes”). You can also add conditional formatting to highlight large expenses: select D2:D100, then Format → Conditional formatting → Greater than → 100, and set a background color.
14. Save and reuse. Google Sheets saves automatically. To reuse for next month, go to File → Make a copy, rename it, and clear the data rows (select A2:E100, press Delete).

Common Mistakes

• Mixing date formats: If you type dates as text (e.g., “March 3” instead of 3/3/2025), the month filter and sorting won’t work. Always use the date format you set in Step 4.
• Entering amounts as text: If you type “$45” instead of 45, Sheets may treat it as text. Use the currency format and type plain numbers.
• Inconsistent category names: If you type “Groceries” in one row and “grocery” in another, SUMIF treats them as different. Use the drop-down to keep names consistent.
• Forgetting to copy formulas: If you add new rows below your data, the SUMIF range (B:B) already covers the whole column, so it’s fine. But if you add a new category, you need to add a row in the summary and copy the formula.
• Overwriting the formula: When you clear data, be careful not to delete the formulas in H2:H11. Select only the data cells (A2:E100) when clearing.

Tips

• Use the mobile app: Install the Google Sheets app on your phone and log expenses on the go. The drop-downs work on mobile too.
• Set a budget: Add a column for “Budget” in your summary, and a formula to show the difference: =Budget - Total.
• Color-code categories: Use conditional formatting on the Category column to give each category a color. This makes your sheet visually scannable.
• Freeze the header row: View → Freeze → 1 row. This keeps the headers visible when you scroll down.
• Add a chart: Select G1:H10 (categories and totals), then Insert → Chart. Choose a pie chart to see your spending breakdown visually.
• Use the Explore feature: At the bottom-right, the Explore button can give you quick insights like “Average expense per day” without writing formulas.

Troubleshooting

• SUMIF returns 0 even though there are matching expenses. Check that the category in column B exactly matches the category in column G (including spaces and capitalization). Also ensure the amounts in column D are numbers, not text. Select a cell in D and check the formula bar—if it shows a number, it’s fine; if it shows text, re-enter as a number.
• Date column shows a number like 45000. This means the cell is formatted as a number, not a date. Select the cells, go to Format → Number → Date, and re-enter the date if needed.
• Drop-down not showing. Make sure you selected the correct range (B2:B100) and that you clicked “Save” in the data validation dialog. If you added new rows beyond B100, extend the range.
• Formula not updating. Google Sheets recalculates automatically, but if you see a stale value, press Ctrl+R (Windows) or Cmd+R (Mac) to refresh the page. Also check that you didn’t accidentally type the formula as text (e.g., starting with an apostrophe).
• Accidentally deleted the summary table. Undo with Ctrl+Z (Cmd+Z on Mac) immediately. If you saved and closed, you can go to File → Version history → See version history to restore an earlier version.

Frequently Asked Questions

Can I track multiple months in one sheet? Yes. Add a “Month” column as described in Step 11, then use SUMIFS to sum by category and month. For example: =SUMIFS(D:D, B:B, G2, F:F, "Mar 2025"). Alternatively, duplicate the sheet for each month.

How do I add a new category later? Add it to the data validation list (Data → Data validation → edit the list) and add a row in the summary table with the matching name and formula.

Can I share the tracker with my partner? Yes. Click the “Share” button in the top-right, enter their email, and choose “Editor” so they can add expenses. Both of you can edit simultaneously.

What if I want to track cash and card separately? Add a “Payment Method” column and use SUMIFS to sum by both category and payment method. For example: =SUMIFS(D:D, B:B, G2, E:E, "Cash").

Is there a way to import bank transactions automatically? Google Sheets doesn’t have a built-in bank import, but you can export your bank transactions as CSV and then use File → Import to bring them in. You’ll need to map the columns to match your headers.

Why does my total not match my bank statement? Check for missing entries, duplicate entries, or amounts entered as negative numbers (e.g., refunds). Also ensure all expenses are in the same currency. If you have a refund, enter it as a negative amount or use a separate “Refund” category.

Related

• Why Does USB Only Fit One Way?
• Fix Default Gateway Not Available in Windows 10
• Fix Compressed Folder Is Invalid Error on Windows 11