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

Short answer: Build a Sheet with 7 columns (Date, Merchant, Category, Subtotal, Tax, Total, Notes), then either enter rows manually after each receipt or automate it with a scanner that writes to the Sheet directly. Use SUMIFS or a Pivot Table for category rollups. The template + setup walkthrough are below; the automation step is the one that breaks for most people.

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.

Receipts To Sheets captures receipt photos, PDFs and forwarded emails, extracts their data with AI and organizes it in Google Sheets. Use the website or the Android and iOS apps. Local Excel files are also supported through Excel Manager.

Set up a receipt mailbox with your Google account and Google Drive, then use that mailbox for uploads or email forwarding. Processing can write receipt data automatically, so review the extracted fields and your spreadsheet afterward. Keep the original receipt file and correct any amounts, dates or categories that need attention.

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 build a manual tracker using the column layout and formulas above. Keep the source receipt link beside each entry so a total can be checked against its documentation.

For the automatic mailbox workflow, follow the spreadsheet setup guide and use the app’s mailbox spreadsheet. Treat extra business-purpose, project and reporting columns as your own bookkeeping additions; arbitrary header mapping is not a prerequisite for setup.

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: Receipt Capture (Receipts To Sheets)

1. Sign in with the Google account you use for your records.
2. Create a receipt mailbox and choose the spreadsheet setup described in the getting started guide.
3. Upload a receipt photo or PDF, scan with a mobile app, or forward a digital receipt to the mailbox address.
4. Review the processed receipt and spreadsheet row. Add business purpose, job, platform or deduction-line notes in your Sheet when relevant.

The Personal plan includes 15 receipts per month and one mailbox. Unlimited + HSA/FSA adds unlimited receipts, two mailboxes, medical-item detection and reimbursement tracking. Business adds unlimited mailboxes, shared mailboxes, custom categories and integrations. Compare current plans, prices and included features.

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?

Capture a photo or PDF, or forward an email to your dedicated receipt mailbox. AI processing updates your mailbox records and Google Sheet. Review the extracted fields afterward and correct your records where necessary.

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?

Receipts To Sheets supports receipt photos, PDF uploads, multiple-file uploads and email forwarding to a dedicated mailbox. AI can extract itemized receipt data, and HSA/FSA mailboxes identify eligible medical items. Check the current plan features for your workflow.

---

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 Receipts To Sheets free — 15 receipts per month, no credit card required →