Google Sheets Expense Tracker: Free Template Setup Guide

A working Google Sheets expense tracker needs exactly six columns, one dropdown, and two SUMIF formulas. You can be up and running in under 20 minutes. This guide walks through every step — from creating the sheet to linking receipts from Google Drive — so you end up with something you'll actually use at tax time. If you would rather not type the rows at all, an automated Google Sheets expense tracker can fill the sheet from your email receipts instead.

If you'd rather skip the setup entirely, the free ExpenseBot template has everything here pre-built — copy it to your Drive and start logging. Either way, you'll understand what the template does and why.

What a Business Expense Tracker Needs (The 6 Columns)

Most expense tracker templates have too many columns. Columns you won't fill in consistently become noise that makes the sheet harder to use. A working tracker only needs these six:

That's it. Don't add a "Receipt ID," "Vendor Code," or "Department" column until you've been using the tracker for at least 60 days and have a specific reason. Every unused column is friction that makes logging feel harder.

Setting Up the Sheet: Step-by-Step

1. Create a new Google Sheet. Go to sheets.new — this opens a blank sheet instantly. Rename it "Expenses 2026" (click the tab at the bottom).
2. Add headers in Row 1. Type: Date | Merchant | Category | Amount | Payment Method | Notes. Bold Row 1 (Ctrl+B / Cmd+B) and freeze it: View → Freeze → 1 row. Now your headers stay visible as you scroll.
3. Format the Date column. Select column A → Format → Number → Date. This ensures consistent date display and lets you sort/filter by date correctly.
4. Format the Amount column. Select column D → Format → Number → Currency. Now amounts display with a $ sign automatically without you typing it.
5. Add a Category dropdown (data validation). Select C2:C1000 → Data → Data validation → Add rule. Under Criteria, choose Dropdown and enter each category as its own option (see the list in the next section). Open Advanced options and set "If the data is invalid" to "Reject the input." This prevents the typos that break SUMIF.
6. Widen column B (Merchant) and F (Notes). Double-click the column border to auto-fit, or drag to make them wider. Merchant names and Drive links are long — give them room.

At this point you have a functional tracker. Rows 2 onward are your data. Everything below covers the summary dashboard, categories, and receipt linking.

Menu names in this guide were checked against Google's Sheets and Drive help pages on September 14, 2026. Google renames menus from time to time, so a label may differ slightly on your screen.

The Category List That Maps to Schedule C

Use categories that match IRS Schedule C line items. This isn't just organizational preference — it determines what's deductible and makes tax preparation faster when your accountant (or you) maps the tracker to the actual form. Schedule C has 20 expense lines; most freelancers only need 10–12.

Copy this list into your data validation dropdown exactly as written. Consistent naming is what makes SUMIF work — "Auto & Travel" and "Auto and Travel" are two different values and will produce two different rows in your summary. See the full expense categorization guide for edge cases (mixed-use phone, partial home office, meals with clients vs alone).

Adding a Summary Dashboard with SUMIF

Add a second tab named "Summary." This keeps your data entry clean and your summary always visible. In the Summary tab:

1. Column A — list every category (same names as your dropdown, one per row). Add a "TOTAL" row at the bottom.
2. Column B — Actual spend. In B2, enter:
   =SUMIF(Expenses!C:C,A2,Expenses!D:D)
   This totals all amounts in column D of the Expenses tab where column C matches the category in A2. Drag the formula down for every category row. The TOTAL row: =SUM(B2:B13)
3. Column C — Budget. Type your monthly budget for each category. Leave blank for categories with no planned budget.
4. Conditional formatting. Select B2:B13 → Format → Conditional formatting. Add a rule: "Custom formula is" → =AND(C2>0,B2>C2)→ fill color red. Now any over-budget category turns red automatically.

Receipt Linking: Google Drive Integration

Paper receipts and email receipts both belong in Google Drive. Here's the workflow that keeps them findable at tax time:

1. Scan paper receipts. Open the Google Drive mobile app → tap the + button → Scan (a camera icon on some devices). Drive scans the receipt to a PDF and saves it to your Drive automatically.
2. Use a consistent naming convention. YYYY-MM-DD_Merchant (e.g. 2026-03-14_Staples). Date-first naming means files sort chronologically automatically.
3. Get the shareable link. Select the file in Drive → Share → under General access choose "Anyone with the link" with the Viewer role → Copy link. Anyone who has that link can open the receipt, so share the tracker only with people you trust.
4. Paste into the Notes column of the corresponding row in your tracker. In Sheets, use Insert → Link (Ctrl+K / Cmd+K) to turn the URL into a clickable hyperlink labeled "Receipt" — cleaner than a raw URL in the cell.

Your accountant can access every receipt by clicking the link from the shared sheet. No downloading, no emailing files back and forth, no "can you resend that receipt from March?"

The Limitations You'll Hit

A DIY Sheets tracker works well up to a point. Here's where it breaks down and what the signal looks like when you've hit the ceiling:

The path forward from a DIY Sheets tracker is ExpenseBot's automated Google Sheets tracker — it keeps the exact same spreadsheet format you're used to, but auto-scans Gmail for receipts and writes rows automatically. You keep viewing and editing in Sheets; the data entry happens in the background.

Keeping the Sheet Current Without Touching It

Every limitation above comes back to one job: somebody has to type each row. A manual tracker rarely fails because the formulas break. It fails the month the typing falls behind, because the receipts keep arriving and the sheet stops.

The way to keep the spreadsheet is to stop being the data-entry step. Many business receipts already arrive by email: software renewals, online orders, travel bookings, contractor invoices. ExpenseBot is an AI expense tracker that connects to the Gmail inbox you choose, finds those receipt emails, reads the date, merchant, and amount, and writes each one as a row in a Google Sheet stored in your own Google Drive. You still review, recategorize, and share it like any other sheet. Paper receipts go in as a photo instead of a typed row.

It only reads the inbox you connect, so if receipts land in both a work and a personal address, connect the one that receives them. If you want to push Sheets' own tools first, such as Google Forms intake and Apps Script, read how to automate expense tracking in Google Sheets.

See the automated Google Sheets tracker →

ExpenseBot's Free Template vs Building Your Own

Both paths work. Here's how to choose:

Ready to automate the data entry? ExpenseBot's Google Sheets expense tracker scans Gmail for receipts and writes rows automatically — same spreadsheet, no manual logging. Or see the full expense categorization guide for edge cases on which costs go in which category.