How to Track Business Receipts in Google Sheets (Free Template + Automation)

By Daniel Shao · April 24, 2026

The Sheet my wife and I use for household expenses is structurally identical to the one a freelance designer would use for client receipts. Same columns. Same SUMIFS. The difference is consequences — we miscategorize a Wellcome run and we eat slightly wrong groceries; a freelancer miscategorizes a client meal and they overpay tax.

I built ReceiptToSheet for the household sheet first. Then small business owners started signing up, doing the same thing with higher stakes, and I realized the tool I'd made for me was the tool they'd been duct-taping out of Expensify exports for years.

This guide walks through what I've learned watching that audience: how to set up the tracker, a template you can copy, and how to stop typing the data in by hand.

Why Google Sheets for Receipt Tracking

Sheets is a reasonable choice here — not despite being a generic tool, but because of it.

You already use it. Zero switching cost. Your expense data lives next to your invoices, project budgets, and client tracker. Nothing to export.

It bends to you. Every business has different categories and different reporting needs. A spreadsheet conforms to your setup. Dedicated apps make you conform to theirs.

It's free. Sheets has no per-seat cost. For a sole proprietor with 30 receipts a month, paying $30/mo for QuickBooks is overkill. The lean stack is Sheets plus a way to get receipts into Sheets.

The downside is data entry. Every receipt still needs to land in the sheet somehow — and that's the problem actually worth solving.

Part 1: Setting Up Your Receipt Tracker

Recommended Column Layout

A simple layout that works for most freelancers and small businesses:

A	Date	Date on the receipt (not entry date)
B	Merchant	Store or vendor name
C	Amount	Total paid, including tax
D	Category	Expense type (see categories below)
E	Payment Method	Cash, personal card, business card, etc.
F	Notes	Optional — project, client, purpose
G	Reimbursable?	Yes/No — useful if expenses get submitted

Add this as row 1. Freeze the header row (View → Freeze → 1 row) so it stays visible as you scroll.

Standard Expense Categories

For most freelancers and small businesses, these cover the bulk of receipts:

Meals & Entertainment
Travel
Office Supplies
Software & Subscriptions
Marketing & Advertising
Professional Services
Utilities
Rent & Workspace
Equipment
Fuel & Transportation
Other

These roughly map to Schedule C line items. If you work with an accountant, ask for the category list they prefer — matching their taxonomy from day one saves hours at year-end.

Useful Formulas

Monthly spending by category:

=SUMIFS(C:C, D:D, "Meals & Entertainment", A:A, ">="&DATE(2026,1,1), A:A, "<"&DATE(2026,2,1))

This sums column C (Amount) where column D matches the category and column A falls within January 2026. Adjust the dates for each month.

Total spending this month:

=SUMIFS(C:C, A:A, ">="&EOMONTH(TODAY(),-1)+1, A:A, "<="&EOMONTH(TODAY(),0))

Category breakdown (pivot table alternative):

Add a second tab called "Summary." List each category in column A. In column B, use SUMIF:

=SUMIF(Receipts!D:D, A2, Receipts!C:C)

Where "Receipts" is the name of your main tab, D is Category, C is Amount.

A note from breaking this on myself: SUMIFS does not care about your header text, but data validation does. The first time I renamed "Meals & Entertainment" to "Meals" on the dropdown without renaming it in the formula, the Summary tab silently dropped a month of restaurant rows to zero. The formula didn't error — it just returned 0, which looked like a slow month. Conditional formatting on the Summary cell (red if a category drops more than 50% month-over-month) is what eventually caught it. Worth adding from day one.

Part 2: Free Receipt Tracker Template

You can copy this Google Sheets template to get started:

Copy the ReceiptToSheet Expense Tracker Template →

The template includes:

Pre-formatted receipt log with the column layout above
Summary tab with monthly totals by category
Pre-built SUMIFS formulas for the current month
Category dropdown in column D (data validation)
Conditional formatting to highlight large purchases

To use it: open the link, click "Make a copy," save it to your Drive, and start logging.

Part 3: Automating Receipt Entry

Manual entry works fine at low volume — maybe 10–20 receipts a month. Above that it starts to feel like a part-time job.

Option 1: Scan + Confirm (ReceiptToSheet)

ReceiptToSheet connects directly to your Sheet. You photograph a receipt, AI extracts merchant/date/total/category, you review, tap confirm, the row appends. The data lands in your Sheet — you own it, no platform lock-in, cancel anytime and the spreadsheet keeps working.

A few details from the build that matter for the audience reading this: I run a tiered OCR escalation pipeline so easy receipts go through the cheap path and only crumpled thermal receipts get the expensive treatment — total Gemini spend across the entire user base so far is about $18.88. Sheets writes are idempotent, so a flaky cell signal doesn't double-post a row. Uploads are compressed in the browser before they leave your phone (Vercel has a 4.5 MB request cap, which I learned by hitting it).

Setup takes about two minutes: sign in with Google, paste your Sheet URL, map your columns. After that, scanning is a 30-second loop.

Best for: freelancers and small businesses who want to eliminate manual entry with minimal setup.

Option 2: Zapier / Make Automation

If you already use a receipt scanning app (Expensify, SparkReceipt, etc.), you can use Zapier or Make to push new receipts into your Sheet.

Build a Zap with the receipt app as trigger and Sheets as action, then map the fields. This works — but it adds another subscription ($20–50/mo for Zapier), and the automations break silently when the receipt app changes its API schema.

Best for: users already on Zapier who want to route existing receipt data to Sheets.

Option 3: Google Forms + Receipt Photo

Simpler DIY: create a Google Form with fields for date, merchant, amount, category. Submit after each receipt. Responses populate a linked Sheet automatically.

This doesn't extract anything — you still type the numbers — but it removes the "open the spreadsheet, find the right tab, scroll to the bottom" friction.

Best for: businesses with multiple people submitting expenses who want consistent collection without buying software.

Making It Work Long-Term

The biggest failure mode with Sheets-based tracking is falling behind. Receipts pile up, you spend an hour catching up, you fall behind again.

Three things help:

Scan at point of sale. The best time to log a receipt is while you're still holding it. A 30-second phone scan beats the Sunday batch session that never quite happens.

Keep categories consistent. Use a dropdown (data validation) so every entry uses the same category name. "Meals" and "Meal" and "Dining" are three different things to a SUMIF.

Monthly close. Set a recurring calendar event for the first of each month: open the Summary tab, eyeball the totals, handle anything you missed. Catching a gap after one month is easy. After six, it's an afternoon.

Frequently Asked Questions

How do I add a dropdown for expense categories in Google Sheets?

Click the column D header to select the whole column. Data → Data validation. Under Criteria, choose "List of items" and enter your categories separated by commas. Save. Every cell in column D now shows the dropdown.

Can I track receipts in Google Sheets on my phone?

Yes — the Sheets mobile app handles manual entry fine. But typing on a phone keyboard is slow. A scanner that writes directly to Sheets (like ReceiptToSheet) is faster: photograph the receipt, the AI fills the fields, tap confirm.

How do I split a receipt between two categories?

Enter it as two separate rows with the same date and merchant, one per category, with the split amounts. Keeps your formulas and pivots clean — one row per category makes SUMIF straightforward.

Is this method good enough for taxes?

Depends on your situation. The IRS accepts digital records, including spreadsheets, as expense documentation — but you also need the receipts themselves (physical or photo) for expenses over a certain threshold (check the current limit with your accountant). The Sheet tells you what you spent. The receipt proves that you spent it. Keep receipt photos alongside the Sheet entries, either in Drive or a folder named by month.

What if I have hundreds of receipts per month?

At high volume, one-by-one scanning gets tedious. Batch scanning (multiple receipts in one shot) and email-receipt forwarding matter more at that scale. ReceiptToSheet's Business tier ($29/month, 500 scans) includes batch import on the roadmap; for very high volume, compare against dedicated expense management platforms.

The spreadsheet is the easy part. The data entry is what costs time. Automate that and the tracker becomes genuinely low-maintenance — open it at month-end and the data is already there.

Try ReceiptToSheet free — 20 scans/month, no credit card required →

Related reading:

How to Scan Receipts to Google Sheets Automatically — Step-by-step setup guide
Best Receipt Scanner for Google Sheets in 2026 — Full category roundup
ReceiptToSheet vs SparkReceipt (2026) — Does SparkReceipt's Zapier route actually work?

Written by Daniel Shao, creator of ReceiptToSheet. I built it for the shared Sheet my wife and I have been tracking household expenses in for years. Small business owners started using it for the same job at higher stakes — same columns, more rows, audit risk if it's wrong.