Skip to main content
    Step 1 of 7
    Money & Banking
    Beginner
    5 min read 7 stepsMay 8, 2026Verified May 2026

    How to Use Google Sheets for Tracking Finances

    Build a free spreadsheet that tracks income, spending, and account balances — auto-saves to the cloud and works on phone or computer.

    At a Glance

    Category
    Money & Banking
    Difficulty
    Beginner
    Read Time
    5 min read
    Steps
    7
    Topics covered
    Google Sheets
    budgeting
    spreadsheets
    personal finance
    free tools

    In this guide (7 steps):

    1. 1.Open Google Sheets and start a blank spreadsheet
    2. 2.Build the column headers
    3. 3.Enter your first few purchases
    4. 4.Format the Amount column as money
    5. 5.Add a total at the bottom
    6. 6.Install the Sheets app on your phone
    7. 7.Share with a trusted family member if you want
    1

    Open Google Sheets and start a blank spreadsheet

    ~29s
    On a computer, open a web browser and go to sheets.google.com. Sign in with your Google account if asked. Click the large plus sign labeled "Blank" — a new empty spreadsheet opens. At the top left, click where it says "Untitled spreadsheet" and type a name like "My Finances 2026." Press Enter to save the name.

    Quick Tip

    If you do not have a Google account, click "Create account" at accounts.google.com. The setup takes about 5 minutes and gives you Gmail, Drive, and Sheets all at once.

    2

    Build the column headers

    ~21s
    Click cell A1 (the top-left box). Type "Date" and press Tab to move right. Type "Description" and press Tab. Type "Category," Tab, "Amount," Tab, "Notes," then press Enter. The five headers run across row 1. To make them stand out, click the row number 1 to highlight the whole row, then click the Bold button (B) at the top of the screen.
    3

    Enter your first few purchases

    ~21s
    Click cell A2. Type a date like 5/1/2026 and press Tab. In B2 type the store name (Walmart, Kroger, gas station). In C2 type a category (Groceries, Gas, Medical). In D2 type the amount as a number, like 47.85. Skip the dollar sign — Sheets adds it later. In E2 add notes if you want. Press Enter to start the next row.
    4

    Format the Amount column as money

    ~18s
    Click the letter D at the top of the Amount column to highlight the whole column. From the menu at the top, click Format, then Number, then Currency. Every number in column D now shows with a dollar sign and two decimal places. Empty cells stay blank until you type in them.
    5

    Add a total at the bottom

    ~30s
    Scroll down to a row well below your data — try row 50. Click cell C50 and type "Monthly Total." Click cell D50 and type =SUM(D2:D49) — the equal sign is what tells Sheets it is a formula. Press Enter. Cell D50 now shows the total of every amount in column D. Each time you add a new purchase above, the total updates on its own.

    Warning

    The formula must start with the equal sign. If you type SUM(D2:D49) without the equal sign, the cell shows the text instead of the total.

    6

    Install the Sheets app on your phone

    ~23s
    On iPhone, open the App Store. On Android, open the Play Store. Search for "Google Sheets" and tap Install. Open the app and sign in with the same Google account. Your spreadsheet appears in the list. Tap it to open. You can add purchases on your phone right after a store visit, and the changes show up on the computer the next time you open it.
    7

    Share with a trusted family member if you want

    ~24s
    On the computer, open the spreadsheet and click the blue Share button at the top right. Type the email address of an adult child or financial helper. Choose "Viewer" if you want them to read only, or "Editor" if you want them to add entries too. Click Send. They get an email with a link. You can remove their access at any time by returning to the same Share screen.

    You Did It!

    You've finished reading: How to Use Google Sheets for Tracking Finances

    How well did this guide stick with you?

    Need more help? Book a TekSure tech

    Google Sheets is a free spreadsheet program from Google. It does the same things as Microsoft Excel but costs nothing, saves your work to the cloud automatically, and opens on any computer or phone with an internet connection. For tracking personal finances, it is one of the best free tools available — no subscription, no ads, no ads selling your data.

    A spreadsheet is a grid of boxes called cells, arranged in rows and columns. Each cell can hold a word, a number, or a formula. The power comes from formulas — type =SUM(B2:B10) into a cell and Sheets adds up the numbers in those nine cells automatically. Change one number and the total updates on its own.

    For finances, three sheets cover most needs: a monthly spending log, an account balance tracker, and an income log. The spending log lists every purchase with the date, description, category, and amount. The balance tracker holds the end-of-month balance for each account. The income log records Social Security deposits, pension payments, and any other money coming in.

    Google Sheets saves automatically. There is no Save button — every keystroke is stored on Google's servers within two seconds. If your computer dies, you turn on a different computer, sign into your Google account, and the spreadsheet is exactly where you left it. The same is true on your phone — install the Google Sheets app, sign in, and your spreadsheet appears.

    The trade-off is that you need a Google account (free) and an internet connection most of the time. If privacy worries you, remember that Google's terms of service for personal Drive files state that Google does not sell the contents of your files. Two-step verification on your Google account adds a code from your phone every time someone tries to sign in, which keeps the spreadsheet safe even if your password is stolen.

    This guide walks you through making a basic monthly spending tracker. Once you have built it, you can copy the same sheet for next month or expand it into a full budget.

    Rate this guide

    How helpful was this guide?

    Google Sheets
    budgeting
    spreadsheets
    personal finance
    free tools

    Official Resources

    Consumer Financial Protection BureauFTC — Identity TheftAnnualCreditReport.com

    Sources used to create and verify this guide. View all sources →

    ← Previous

    How to Do an End-of-Year Financial Snapshot

    Next →

    How to Update Beneficiaries on Retirement Accounts

    Still stuck? Let a pro handle it.

    A real person can walk you through this over the phone, anywhere in the US. If we can't fix it, you don't pay.

    Book a Verified Tech How It Works

    Learn more from official sources

    Related Guides

    How to Set Up Mobile Check Deposit on Your Phone

    Deposit checks from your phone using your bank's app — no trip to the branch or ATM required.

    2 min read

    How to Send Money with Zelle

    Send money to friends and family in minutes using Zelle — built into most major bank apps, with no fees.

    2 min read

    How to Use Venmo Safely

    Set up Venmo, send payments to friends, and adjust privacy settings to keep your transactions private.

    2 min read