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'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 → Dropdown. Type your category list (one per line — see the list in the next section). Set "If 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.

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. 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. Right-click the file in Drive → Get link → change to "Anyone with the link can view" → Copy link.
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.

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 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.