How to Track Spending in Google Sheets Step by Step

To track spending in Google Sheets, create a transaction list with a date, description, category, and amount, then use simple formulas to total spending by category and month. You will need a Google account and a browser. Start with a blank spreadsheet, enter purchases consistently, and update it regularly; the formulas will summarize the records you add.

What You’ll Need

A Google account with access to Google Sheets in a web browser.
Recent transaction details, such as dates, amounts, and what each purchase was for. Bank or card statements can help you fill in missing records.
A short list of spending categories that makes sense for you, such as Groceries, Housing, Transport, Bills, and Eating out.

You can build the tracker in one sheet and add more sheets later if needed. The instructions below use Google Sheets in a browser. Basic formulas such as SUM and SUMIF also exist in Excel, but Excel uses a different ribbon and menu layout; follow the Google Sheets menu paths here. Depending on your spreadsheet locale, Sheets may require semicolons instead of commas in formulas.

Step-by-Step

Create the spreadsheet and transaction columns. Open Google Sheets, choose Blank, and rename the file to something recognizable, such as Spending Tracker. In row 1, enter these headings: Date in A1, Description in B1, Category in C1, Amount in D1, Payment method in E1, and Month in F1. Keep one purchase per row and do not leave blank rows inside the transaction list. This consistent layout makes filtering and summaries easier.

Format column A as a date and column D as currency. Select the relevant cells or whole columns, then choose Format > Number > Date or Format > Number > Currency. Use positive amounts for purchases. If you later record refunds, keep them separate or enter them as negative amounts consistently, so totals are not misleading.
Enter a few transactions as a test. Add the date, a short description, category, amount, and payment method for each purchase. For example, you might record 4.50 for coffee under Eating out, 62.30 for a grocery shop under Groceries, and 18.00 for a bus pass under Transport. These are illustrative amounts, not recommendations. Use actual transaction dates rather than the date you happen to enter them.

Enter amounts as numbers, not text such as 62 dollars. Currency formatting adds the symbol while keeping the value usable in calculations. Check that decimal separators and dates display as expected in your locale.
Make categories consistent. If one purchase is labeled Groceries, use the same spelling for every grocery transaction. Inconsistent labels such as Grocery, groceries, and Food will be treated as separate categories in summaries. To make selection easier, create a dropdown: select C2:C100, choose Data > Data validation, add a rule with a dropdown, and enter your categories. Save the rule. You can adjust the range and category list as your tracker grows.

A dropdown helps prevent typing variations, but it does not decide the best category for you. Pick clear categories you can apply the same way over time. If you are unsure where a purchase belongs, use a miscellaneous category sparingly and review it later.
Add a month helper column. The Month column lets you summarize transactions by month without manually selecting date ranges. With transaction dates in A2:A100, enter this in F2:

With a transaction date in A2, this formula returns the first day of that transaction’s month. For example, if A2 is January 5, 2026, the result is January 1, 2026.

=DATE(YEAR(A2),MONTH(A2),1)

Format column F as a date, then copy the formula down the column using the fill handle. The underlying value remains a date, even if you choose a display such as Jan 2026 through Format > Number > Custom date and time. Leave F blank on unused rows if you prefer; the formula can be copied down when new transactions are added.
Build a category summary. Make a small summary table in H1:K. Add Category in H1, Actual in I1, Budget in J1, and Remaining in K1. Enter your category names in H2:H, and optional monthly budget amounts in J2:J. Keep the budget period clear: the following example assumes each budget is for one month.

With transaction categories in C2:C100, amounts in D2:D100, and a summary category in H2, enter this in I2:

=SUMIF($C$2:$C$100,H2,$D$2:$D$100)

For the illustrative transactions above, if Groceries totals 62.30 plus another 47.20 and 76.95 purchase, the Groceries result is 186.45. Copy the formula down alongside your other category names. The dollar signs keep the transaction ranges fixed while the summary reference changes from H2 to H3 and so on. Extend the ranges when records pass row 100.
Calculate the amount remaining in each budget. In K2, subtract the actual category total from its budget. With the category actual in I2 and its monthly budget in J2, this formula returns the amount left:

=J2-I2

For example, if J2 contains 250 and I2 contains 186.45, K2 returns 63.55. A negative result means recorded spending is higher than the entered budget; it is a signal to review the numbers, not a prediction of future costs. Copy the formula down the summary table and format columns I:K as currency.
Summarize monthly spending. Create a second table with Month in M1 and Total in N1. Enter the first day of each month you want to review in M2, M3, and later rows, formatted as dates. With month helper dates in F2:F100, amounts in D2:D100, and a month-start date in M2, put this in N2:

=SUMIF($F$2:$F$100,M2,$D$2:$D$100)

For the example records dated in January, the result is 243.95: 4.50 + 62.30 + 18.00 + 47.20 + 35.00 + 76.95. Copy the formula down for each month. Make sure the month in column M is a real date matching the first day of the month, not text that only looks like a date.
Make the sheet easier to use and review. Freeze the header row with View > Freeze > 1 row, so headings stay visible as the list grows. Turn on filters with Data > Create a filter to view one category, date range, or payment method at a time. Use Format > Conditional formatting on the Remaining column if you want negative balances highlighted; set the rule to format cells that are less than 0.

For a visual overview, select the month summary table and choose Insert > Chart. Check that the chart uses the month and total columns, and choose a chart type that is easy to read. Treat it as a view of recorded spending, not a substitute for checking the underlying transaction rows.
Keep the tracker current. Add transactions weekly or on another repeatable schedule. Compare the entries with your bank or card statements and correct missing, duplicated, or mistyped amounts. At the end of each month, confirm that the month total and category totals reflect the dates you intended to include. A tracker is only as useful as the records it contains.

Common Mistakes

Mixing amounts and text: Typing entries like 20 dollars may store text that SUMIF cannot add. Enter 20 as a number and apply currency formatting.
Using inconsistent categories: Different spellings split one type of spending into separate totals. Use a dropdown or check category names when reviewing.
Leaving out dates or entering text dates: Month summaries depend on real date values. Check that dates sort chronologically and that column A is formatted as Date.
Counting a payment twice: If you record a card purchase and later record the card bill payment as spending, the same expense may be counted twice. Decide whether your tracker records purchases, account transfers, or both, and apply that approach consistently.
Forgetting to expand formula ranges: A formula using rows 2 through 100 will not include row 101. Expand the ranges, or set them to cover a larger planned area.
Assuming a budget balance is an account balance: Remaining in the summary is budget minus recorded spending. It does not show how much money is in a bank account.

Tips

Use descriptions that will make sense later, such as Pharmacy prescription rather than Purchase.
Choose categories that answer useful questions without becoming too detailed. You can split a category later if the records show that it would help.
Keep a separate column for payment method if you want to compare cash, debit, and credit purchases. Do not treat that field as another category in the spending total.
Use filters to check one month or category at a time, but remove or adjust the filter before deciding a total is missing transactions.
Make a copy before experimenting with formulas or reorganizing the sheet. Choose File > Make a copy to preserve the original.
Protect privacy: avoid storing full card numbers, account passwords, or other sensitive details in the spreadsheet.

Troubleshooting

A formula displays an error: Check that the formula begins with an equals sign, the cell references match your layout, and the parentheses are balanced. If Sheets says the formula cannot be parsed, your locale may use semicolons rather than commas; change the separators to match the spreadsheet’s locale.
A total is zero or too small: Confirm that the category text matches exactly and that amounts are numbers. Check that the formula range includes the transaction rows and that any filters are not hiding records you expect to see.
The month total is zero: Check that column F contains the helper formula and that M2 is the first day of the same month. A text label such as Jan 2026 may look right but not match a date value. Format both cells as dates to inspect them.
A date appears as a number: The value may still be a date, but its number format is not set to display it as one. Select the cell and choose Format > Number > Date.
A chart looks wrong: Select only the month and total columns, including their headings, and verify the chart’s data range. Remove blank rows or unrelated summary columns from the selected range.
The dropdown does not appear: Select a cell inside the validation range and open Data > Data validation to check the rule. If you added transactions below row 100, update the validation range as well as the formula ranges.

Frequently Asked Questions

Can Google Sheets track spending automatically from my bank?
These steps use manual entry. Bank connections or third-party services may be available, but availability and permissions vary. Review a service’s access and privacy terms before connecting an account.

How often should I update the sheet?
Weekly updates are a practical starting point for many people. A schedule you can maintain matters more than choosing a particular day; reconcile entries with statements regularly so omissions are easier to spot.

Can I use this tracker for shared household expenses?
Yes. Agree on category names and decide how to record shared purchases and reimbursements. You can add a Person column if you need to distinguish who paid, while keeping each purchase on its own row.

How do I track refunds?
Use one consistent method. For example, enter a refund as a negative amount in the same category as the original purchase, so it reduces that category’s total. Check that your budget and monthly summary formulas include the refund row.

Can I use the same sheet on my phone?
Yes. You can open a spreadsheet with the Google Sheets mobile app, but the menus differ from the browser and longer data entry may be easier on a computer. Keep the same columns and data conventions so the formulas continue to work.

Is this a substitute for financial or tax advice?
No. It is a record-keeping tool for organizing spending. For financial, tax, or other professional questions, check the relevant terms or consult a qualified professional.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.