How to Track Finances in Google Sheets Step by Step

To track finances in Google Sheets, create a transaction log, record each income or expense on its own row, and use a monthly summary to total income, spending, and the difference. You’ll need a Google account, a browser, and recent transaction details. The setup below uses Google Sheets in a web browser; Excel has different menus and is not covered here.

What You’ll Need

A Google account and access to Google Sheets at sheets.google.com.
Recent bank, card, cash, or payment-app transactions. A few weeks of data is enough to start.
A short list of spending categories that make sense for you, such as Housing, Groceries, Transport, and Bills.
About 20 minutes to set up the workbook. You can enter transactions manually; linking a bank account is not required.

Step-by-Step

Create a workbook and name it. Open Google Sheets, choose Blank spreadsheet, then click the title at the top left and give the file a clear name, such as “Monthly Finance Tracker.” Create two tabs at the bottom and name them Transactions and Summary. Keeping raw entries apart from totals makes the file easier to review and reduces accidental edits to calculations.
Set up the transaction columns. On the Transactions tab, enter these headers in row 1: Date, Description, Category, Account, Type, Amount. Use one row per transaction. Enter amounts as positive numbers, and use Type to distinguish Income from Expense. This consistent approach avoids mixing positive and negative conventions. For example, a paycheck is Type Income and Amount 3200; a grocery purchase is Type Expense and Amount 85.
Format the date and amount columns. Select column A, then choose Format > Number > Date. Select column F and choose Format > Number > Currency. If your region uses a different currency or date order, Sheets may display the format differently; select an appropriate currency or date format through the same Number menu. Enter actual dates, not labels such as “Jan 2,” so monthly summaries can identify transactions reliably.
Enter a small sample and check the convention. Try six illustrative entries dated in January 2026: paycheck, Income, 3200; rent, Expense, 1200; groceries, Expense, 85; utilities, Expense, 140; freelance payment, Income, 400; and transport, Expense, 60. Add the account for each entry, such as Checking or Credit card. In this sample, income totals 3600, expenses total 1485, and the difference is 2115. Actual spending records should reflect how you want to track purchases: if you log a card purchase as an expense, paying that card bill should not be logged as another expense, or you would count it twice.
Add dropdowns to prevent inconsistent labels. Select the cells in column E where you will enter transaction types, then choose Data > Data validation. Add a dropdown with the options Income and Expense, and save the rule. Repeat for Category using your chosen category list, and for Account if you use a fixed set of accounts. Consistent labels matter because a summary will not group “Groceries” and “Grocery” together. If your Sheets interface offers a dropdown rule or a dropdown from a range, use the option that matches how you maintain the list.
Build the monthly summary layout. On Summary, put “Month starting” in A1 and enter a real first-of-month date in B1, such as 1/1/2026. Put Income in A3, Expenses in A4, and Net cash flow in A5. The examples below assume the Transactions columns are exactly as listed, B1 holds the first day of the month, and summary totals go in B3:B5. As you change B1 to another month, the date-based totals will update.
Calculate monthly income. With transaction dates in Transactions!A:A, types in Transactions!E:E, amounts in Transactions!F:F, and the month start date in Summary!B1, enter this in Summary!B3:
=SUMIFS(Transactions!F:F,Transactions!E:E,"Income",Transactions!A:A,">="&B1,Transactions!A:A,"<"&EDATE(B1,1))
For the six sample rows in January 2026, the result is 3600: 3200 plus 400. The start-date condition includes January 1, and the next-month condition excludes February 1 and later dates.
Calculate monthly expenses and net cash flow. With the same columns and date in Summary!B1, enter this in Summary!B4:
=SUMIFS(Transactions!F:F,Transactions!E:E,"Expense",Transactions!A:A,">="&B1,Transactions!A:A,"<"&EDATE(B1,1))
The sample result is 1485, checked by adding 1200 + 85 + 140 + 60. With income in B3 and expenses in B4, enter this in B5:
=B3-B4
The result is 2115 because 3600 − 1485 = 2115. A positive number means income exceeded recorded expenses for that period; a negative number means recorded expenses were higher.
Break expenses down by category. On Summary, put “Category” in A7 and “Spent” in B7. Enter a category name such as Groceries in A8. With transaction categories in Transactions!C:C, types in Transactions!E:E, amounts in Transactions!F:F, the month start in B1, and the category label in A8, enter this in B8:
=SUMIFS(Transactions!F:F,Transactions!C:C,A8,Transactions!E:E,"Expense",Transactions!A:A,">="&B1,Transactions!A:A,"<"&EDATE(B1,1))
For the sample entries, B8 returns 85. Add other categories in A9, A10, and below, then copy the formula down so each row refers to its category in column A. Check that the category totals together match the monthly expense total.
Make the sheet easy to use and protect calculations. Freeze the header row on Transactions with View > Freeze > 1 row. Use Format > Conditional formatting to highlight expenses or unusually large amounts if helpful, and use bold formatting for summary totals. Consider protecting formula cells: choose Data > Protect sheets and ranges, select the relevant cells, and set who can edit them. Protection helps prevent accidental changes, but it is not a substitute for keeping a backup.

Common Mistakes

Using mixed signs or types. If expenses are sometimes negative and sometimes positive, totals can become confusing. The example uses positive amounts and an Income/Expense type for every row; stick with that convention throughout.

Entering text instead of dates or numbers. A date typed as unrecognized text may not fall inside the month criteria, and an amount with extra words may not add correctly. Use date and currency formatting, and check that entries are values rather than descriptive text.

Changing category names midstream. “Transport,” “Transportation,” and “Transit” will appear as separate labels. Choose a practical list and use dropdowns. If you rename a category, update old entries too when you want one combined total.

Counting a payment twice. If you record each card purchase as an expense, recording the later payment to the card as an expense again duplicates the cost. Decide whether you are tracking purchases or account cash movements, and apply the method consistently.

Leaving out cash or irregular income. A tracker only describes the activity you enter. Add cash purchases, refunds, and occasional income if they belong in your chosen view. Use a clear category or description for refunds so they do not quietly distort spending totals.

Tips

Enter transactions once or twice a week rather than trying to reconstruct several months at once. A routine makes missing receipts and unclear descriptions easier to resolve.
Use a consistent description that will make sense later, such as “Market groceries,” rather than “Purchase.” Avoid storing full card numbers, passwords, or other sensitive credentials in the sheet.
Keep a copy of the original statement or receipt for reconciliation. The sheet is a tracking aid, not a replacement for official account records.
Start with a manageable number of categories. Split a category only when the extra detail helps answer a real question, such as how much you spend on transport versus vehicle costs.
Make a monthly review part of the process: compare the entries with account statements, check the category totals, and note any missing or duplicated transactions.
If you share the file, use the Share button and choose viewer or editor access deliberately. Give editing permission only to people who need to change entries or formulas.

Troubleshooting

A monthly total is zero or too small: Check that dates in column A are real dates within the selected month, that Type is exactly Income or Expense, and that Amount contains numeric values. Confirm B1 is the first day of the month you intend to summarize. A space or a different spelling in a dropdown label can prevent a match.

The formula shows an error: Check that sheet names and column letters match your workbook, and that the formula was pasted into the intended summary cell. Google Sheets normally uses commas between function arguments in the examples here, but spreadsheet locale settings can require semicolons. If Sheets flags a parse error, check File > Settings for locale and use the separator expected by that locale.

A date appears as a number: The value may still be a valid date displayed with a number format. Select the cell and choose Format > Number > Date. If the value was pasted as text, re-enter it in a recognizable date format and verify that the monthly total changes.

Totals do not match the bank: Compare a single statement period transaction by transaction. Look for pending transactions, omitted cash spending, refunds, duplicate card-payment entries, and date boundaries. Decide whether the tracker uses transaction date or posting date and use that choice consistently.

A copied category formula repeats the wrong result: Make sure each category name is in the same row as its formula, and check that the formula references that row’s category cell. If a formula cell was overwritten, copy it again from a correct row and verify the category total against the transaction log.

Frequently Asked Questions

Can Google Sheets connect directly to my bank?
Google Sheets does not provide a universal built-in bank connection for this tracker. You can enter transactions manually or import data from a bank-provided CSV, then review dates, categories, and duplicate rows before relying on the totals. Be cautious with third-party services and account permissions.

How often should I update a finance tracker?
Weekly is a manageable starting point for many people. If you make many cash purchases or need a current balance view, update more frequently. The most useful schedule is one you can maintain and reconcile against statements.

Can I track multiple accounts in one sheet?
Yes. Record the account name in the Account column for each row and keep the same category and type conventions across accounts. Remember that transfers between your own accounts are not income or spending if your goal is to measure overall inflows and outflows.

Can I use this sheet for a household or shared budget?
Yes, if everyone agrees on the categories, entry rules, and who can edit the workbook. Avoid placing sensitive account details in the file, and review sharing access when circumstances change.

Is this tracker suitable for taxes or investment decisions?
It can help organize records, but it is not tax, investment, legal, or financial advice and may not meet recordkeeping requirements. Check actual terms and requirements with the relevant institution, lender, or 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.