How to Organize Receipts in Google Drive (and Keep It Up)

A folder structure, a file-naming rule and a companion Google Sheet that make any receipt findable in seconds, plus the step that usually breaks.

The ExpenseCatcher team

How we write about money

· 4 min read

2 sources cited

Key takeaways

  • Keep folders shallow, with the year at the top, so a whole year can be archived in one move.
  • Name every file YYYY-MM-DD Vendor Total Currency, so Drive's search and sort order do the filing for you.
  • Keep a Google Sheet next to the folder: one row per receipt, with a link to the file.
  • The step that breaks is getting receipts in. Make it as close to automatic as you can.

Most receipt systems fail in the same place. The folders are fine, but nobody keeps them up. A Google Drive setup that lasts makes three decisions once, so you never make them again for each receipt: where a receipt goes, what it's called, and where its numbers are written down.

Here's a setup that works for households, freelancers and small businesses, and how to keep it running without effort.

A folder structure that holds up

Keep it shallow. Two or three levels is plenty:

Receipts/
  2026/
    2026-01/
    2026-02/
    …
  2025/
    …

Year at the top is the important part. Tax authorities think in years, your accountant thinks in years, and when a year's records no longer need keeping you can archive one folder in one move.

Months inside each year keep folders small enough to scan by eye. If you file fewer than about 20 receipts a month, a single folder per year is fine.

If you run a business or freelance, split by purpose above the years:

Receipts/
  Business/
    2026/
  Personal/
    2026/
  Reimbursable/
    2026/

Don't build category folders like Software, Travel or Meals. A receipt can belong to two of them, and every category folder is one more decision per receipt. Categories belong in a spreadsheet column, where a receipt can be filtered without being moved.

Name every file the same way

File names are what Drive search matches most reliably. A consistent pattern turns search into a filing system of its own:

YYYY-MM-DD Vendor Total Currency.pdf

For example:

  • 2026-10-04 Northwind Coffee 33.83 EUR.pdf
  • 2026-10-02 Figma 15.00 USD.pdf
  • 2026-09-28 Office Depot 86.40 USD.jpg

Why this pattern works:

  • The date comes first, written year-month-day, so files sort in date order even mixed together.
  • The vendor is the second word, because that's what you'll type into search ("Figma").
  • The total is in the name, so you can match a card statement line without opening anything.

Avoid names like scan_0042.pdf, receipt (3).pdf and IMG_2291.jpg. They're impossible to find, and they're what you get by default when you save attachments in a hurry.

Keep a sheet next to the folder

The folder holds the evidence. A Google Sheet holds the numbers, so you can add things up without opening files. One row per receipt:

Date Vendor Category Total Tax Currency File
2026-10-02 Figma Software 15.00 0.00 USD link
2026-10-04 Northwind Coffee Meals 33.83 5.64 EUR link

Put the Drive link to the file in the last column. In Drive, right-click the file, choose Share → Copy link, and paste it in.

Two formulas cover most questions. With dates in column A, categories in C and totals in D:

Total for October 2026:

=SUMIFS(D:D, A:A, ">="&DATE(2026,10,1), A:A, "<"&DATE(2026,11,1))

Total for one category:

=SUMIFS(D:D, C:C, "Software")

For a full breakdown, select the table and choose Insert → Pivot table, with categories as rows and months as columns. If you mix currencies, add currency as a filter so you don't add euros to dollars.

Getting receipts in: the step that breaks

Folders, names and a sheet are easy to set up on a Sunday afternoon. The hard part is the two minutes each receipt takes afterwards: download the attachment, upload it to the right folder, rename it, type a row. Skip that a few times and the system quietly stops.

Lower that cost as far as you can:

  • Paper receipts: use your phone's scanner rather than a plain photo. The Google Drive app can scan a document straight into a Drive folder as a PDF, and you can name it as you save.
  • Email receipts: these are most receipts now, and the most tedious to file by hand. Make one rule with your mail app's filters and stick to it.
  • Batch it: if you file by hand, do it once a week from a single To file folder rather than receipt by receipt.

Or take the filing step out of your hands entirely. With ExpenseCatcher you forward a receipt to a private address, and it's saved in your Drive under exactly this kind of name, in year or month subfolders, with a row added to your sheet. A Gmail filter can do the forwarding too, so monthly bills file themselves.

Share it with your accountant

Share the top folder and the sheet with your accountant as Viewer. They see everything, including new receipts as they arrive, and can't move or delete anything. If they need to leave notes, give them Commenter access on the sheet only.

Sharing the live folder beats emailing a zip in March: nothing goes missing between versions, and questions like "what was this $86.40?" are answered by the file link in the row.

A ten-minute monthly check

Once a month:

  1. Compare your card and bank statements with the sheet. Every business charge should have a row.
  2. Chase what's missing. Most vendors can resend a receipt from your account page.
  3. Fix categories while you still remember what things were.
  4. Look at the total by category. It's the quickest way to spot a subscription you forgot to cancel.

That's the whole system: shallow folders by year, one naming pattern, one sheet, and a filing step that's as close to automatic as you can make it.

Frequently asked questions

Should I organize receipts by category or by date?+

By date: year first, then month if you have a lot. A receipt can fit two categories, and every category folder is one more decision per receipt. Put the category in a spreadsheet column instead, where you can filter without moving files.

Can Google Drive scan paper receipts?+

Yes. The Google Drive app can scan a document with your phone's camera and save it to a folder as a PDF, and you can name the file as you save it.

How do I share receipts with my accountant?+

Share the top folder and the sheet with Viewer access, so they see new receipts as they arrive but can't move or delete anything. If they need to leave notes, give them Commenter access on the sheet.

Sources

  1. Google Docs Editors Help: SUMIFS function
  2. Google Drive Help: Scan documents with Google Drive

General information, not tax, legal or financial advice. Rules differ by country and change over time — check with an accountant or your tax authority for your situation. How we write.

More from the blog

More in How-to →

Newsletter · coming soon

One useful money-admin article a week

Receipts, expenses and write-offs, explained plainly. Sign-up opens soon.

Until then, follow new posts by RSS.