Track Email Receipts and Invoices in Google Sheets

Google Sheets is a natural fit for receipt tracking. Each forwarded receipt becomes a row, and once you have rows, you can run SUMIF to total expenses by category, sort by vendor to audit subscriptions, and hand the whole sheet to your accountant with read access. No special tool required — just a spreadsheet everyone already knows how to use.

The trick is getting receipts into the sheet without manual effort. Forward them to a Google Sheets spreadsheet via Quicktion, and each receipt lands as a new row automatically.

Why Track Receipts in Google Sheets?

A spreadsheet is the right tool here because the data is inherently tabular. Receipts have amounts, dates, vendors, categories — columns. Sheets handles that natively, and adds real analysis on top. Use SUMIF to total expenses by category automatically, sort by vendor to spot recurring charges you forgot about, and share the sheet directly with your accountant or bookkeeper. They can filter by date range and category without needing to ask you for files.

Honestly, for expense tracking specifically, the formula layer is what makes Sheets worth choosing over a more opinionated tool.

Setting Up Your Spreadsheet

Create a Google spreadsheet with these columns:

Column	Type	Purpose
Subject	Text	What you bought (from email subject)
Vendor	Dropdown	Store or service name
Date	Date	Purchase date
Amount	Number	Cost (add manually or extract from subject)
Category	Dropdown	"Software", "Hardware", "Office", "Travel", etc.
Status	Dropdown	"Unprocessed", "Logged", "Reimbursed"
From	Text	Sender address
Tax Deductible	Checkbox	For tax-relevant purchases
Attachments	Text	Links to PDF receipts saved in Google Drive

Use data validation to create dropdown menus for Vendor, Category, and Status. This keeps your data consistent and makes filtering reliable.

Connecting Your Email (via Quicktion)

Method 1: Email Forwarding

Set up a destination in Quicktion pointing to your receipts spreadsheet. Map the email subject to Subject, sender to From, and date to Date. Quicktion uploads PDF attachments to Google Drive and links them in the Attachments column automatically.

Then create Gmail filters to auto-forward receipt emails:

from:receipts@amazon.com -- Amazon purchases
from:*@paypal.com -- PayPal transactions
from:noreply@stripe.com -- Stripe charges (SaaS subscriptions)
from:*@apple.com subject:receipt -- Apple purchases
from:*@uber.com subject:trip -- Uber rides

Create a Gmail filter for each (or combine them) and forward to your Quicktion address. Every matching receipt lands in your spreadsheet without any manual effort.

Method 2: Gmail Add-on

For receipts that don't match a forwarding rule, use the Quicktion Gmail add-on. Open the receipt email, click the Quicktion icon in Gmail's sidebar, and save it to your receipts spreadsheet with one click. Useful for one-off purchases or vendors you haven't added to your filters yet.

Working with Your Expense Data

Filter Views

Create saved filter views so you can switch between different perspectives without affecting other users:

Unprocessed Receipts -- Filter Status = "Unprocessed", sort by Date (newest first)
Monthly Expenses -- Filter Date to the current month, sort by Category
Tax Deductible -- Filter Tax Deductible = checked, group by Category
By Vendor -- Sort by Vendor, then by Date (newest first)

Formulas

Add a summary section at the top of your sheet or on a separate tab:

Total expenses this month: =SUMIF(Status_range, "<>Unprocessed", Amount_range)
Expenses by category: =SUMIF(Category_range, "Software", Amount_range)
Average purchase amount: =AVERAGE(Amount_range)
Receipt count by status: =COUNTIF(Status_range, "Unprocessed")

These are simple formulas but they make the difference between a log and an actual expense tracker. The category breakdown is useful on its own — the unprocessed count is a good motivator to stay on top of things.

Conditional Formatting

Highlight rows where Status = "Unprocessed" in yellow so they stand out. Turn Amount cells red when they exceed a threshold (e.g., over $500). Highlight Tax Deductible = checked rows in green for quick scanning.

Tips

Process receipts weekly. Open the "Unprocessed" filter view, fill in Amount and Category for each, and mark as "Logged". Don't let it pile up — it gets harder to categorize expenses accurately the longer you wait.

Decide on your categories upfront and match them to your tax categories if possible. Data validation dropdowns enforce consistency automatically, which matters a lot when you're running SUMIF formulas later.

Keep PDF attachments in the loop. Quicktion saves PDF invoices to Google Drive and links them in your spreadsheet — so you always have the original document, not just the email text.

Get Started

Sign up for Quicktion, create a receipts destination linked to your spreadsheet, and set up filters for your most common receipt senders. Your inbox will be cleaner and your expenses will be tracked -- automatically.

For more on saving emails to Google Sheets, see our complete guide or the email tracking spreadsheet walkthrough. You can also track receipts in Notion or Airtable if you prefer those platforms.