Gmail
How to find every receipt in your Gmail
Copy-paste Gmail searches that surface receipts and invoices for any date range, how to label them so they stop getting lost, and how to get them out of Gmail and into a spreadsheet.
Most receipts don't come on paper anymore. They come from software subscriptions, online orders, ride shares, hotels and utilities, and they sit in Gmail with a dozen different subject lines. Searching for "receipt" finds about half of them. The searches below find most of the rest.
The search that does most of the work
Paste this into the Gmail search bar:
subject:(receipt OR invoice OR "order confirmation" OR "your order" OR "payment received" OR "payment confirmation" OR purchase OR "billing statement" OR "tax invoice") -category:promotions
It catches the common subject lines and skips the Promotions tab, where "Your order is waiting!" marketing emails pile up. It's close to the query What Receipt? itself starts from, tuned on real inboxes.
Add a date range for a tax year
Gmail dates use YYYY/MM/DD. after: includes the date you give it and before: excludes it, so one calendar year looks like this:
subject:(receipt OR invoice OR "order confirmation" OR "payment confirmation") after:2025/01/01 before:2026/01/01
For a rolling window, use newer_than:90d or newer_than:1y.
Catch PDF invoices with vague subjects
Some vendors send "Your statement is ready" or just the company name, with the real invoice attached as a PDF. Search the attachment instead:
has:attachment filename:pdf (receipt OR invoice OR order OR payment)
Search by vendor
When you know who you paid, searching by sender is faster and more complete:
from:(uber.com OR lyft.com OR amazon.com OR apple.com) after:2025/01/01 before:2026/01/01
from: matches part of the sender's address, so a domain catches every address that vendor sends from.
Cut the noise
Shipping updates and "your order has shipped" emails match the same words without being receipts. Exclude them:
-subject:(shipped OR delivered OR "out for delivery" OR "on its way")
Gmail search cheat sheet
| Operator | What it does | Example |
|---|---|---|
subject: |
Words in the subject line | subject:invoice |
from: |
Sender name, address or domain | from:stripe.com |
OR and ( ) |
Any of several terms | subject:(receipt OR invoice) |
- |
Exclude a term | -category:promotions |
" " |
Exact phrase | "order confirmation" |
has:attachment |
Messages with attachments | has:attachment |
filename: |
Attachment name or type | filename:pdf |
after: / before: |
Date range, YYYY/MM/DD |
after:2025/01/01 |
newer_than: / older_than: |
Relative dates: d, m, y |
newer_than:6m |
label: |
Messages with a label | label:receipts |
Label them so you only search once
Once a search returns the right results, make Gmail sort future receipts for you:
- Run the search, then click the Show search options icon at the right of the search bar.
- Click Create filter.
- Choose Apply the label and create a label such as
Receipts. Tick Never send it to Spam if you like. - Tick Also apply filter to matching conversations to label everything that already matches, then click Create filter.
From now on, label:receipts after:2025/01/01 before:2026/01/01 gives you a year of receipts in one search.
Getting receipts out of Gmail
This is where it gets tedious. Gmail can find receipts but has no "export these as a spreadsheet" button. The options:
- Print each one to PDF. Open the email, click Print, and choose Save as PDF. Fine for ten receipts, miserable for two hundred.
- Download attachments one by one. This works for PDF invoices, but many receipts are just the body of the email with no attachment.
- Google Takeout. You can export a single label as an
.mboxfile. It's a complete archive, but an mbox file isn't something you can hand to an accountant. - Type them into a spreadsheet. Vendor, date, amount, tax. This is the step everyone dreads, and where mistakes creep in.
Even after all that, a few problems remain:
- The same purchase arrives twice. An "order confirmation" and a "receipt" for the same charge get counted twice.
- Reminders that aren't receipts. "Your subscription renews in 7 days" has an amount but nothing was charged yet.
- Bank alerts. "Payment received" from your own bank isn't a receipt for an expense.
Or let it find itself
What Receipt? connects to Gmail read-only and does the above for you:
- On connect, it searches the last 90 days for receipt-like mail, and new receipts show up within minutes after that.
- Import a past year pulls an entire tax year in one go and hands you that year's CSV when it's done.
- Each candidate is read by an AI model. It keeps the attachment, or the email itself when the receipt is in the body, and pulls out vendor, date, total and tax. Shipping updates, renewal reminders and bank alerts are skipped and listed separately, so you can check what was left out.
- Receipts are filed by vendor, category and project alongside the ones you photograph. Then export CSV, Excel or a Zoho Books import file.
It never stores the rest of your mailbox. Disconnecting revokes access at Google and deletes the stored connection and message index. Receipts you already imported stay yours. The details are in the privacy policy.
Gmail import is part of Pro ($6.99/month or $59/year). Photo and PDF capture are free for up to 30 receipts a month.
Questions
How do I search Gmail for receipts from a specific year?
Add after: and before: to any search, using the YYYY/MM/DD format. after:2025/01/01 before:2026/01/01 covers calendar year 2025, since before: excludes the date you give it.
Can I export Gmail receipts to Excel?
Not directly. Gmail has no spreadsheet export. You can print or download each receipt and type the details in yourself, or use a tool that reads the receipts and builds the spreadsheet for you. What Receipt? exports CSV and multi-sheet Excel files.
Does Gmail have a receipts or purchases folder?
Gmail sorts some mail into tabs such as Promotions and Updates, but there's no dependable receipts folder. The reliable way is a search plus a filter that applies a label, as described above.
Is it safe to connect Gmail to a receipt app?
It depends on the app. Look for read-only access, a clear statement of what is stored, and one-click disconnect that deletes stored data. Apps that use Gmail data are bound by Google's API user data policy, which forbids using that data for ads or selling it.