How to Organize Receipts When You Use Excel

Quick Answer

To organize receipts when you use Excel, treat every expense as three pieces: the transaction in the sheet, the receipt file or paper, and a short note of business purpose. Put digital files in a year/month folder with boring names. Keep paper in the same monthly buckets. Put a receipt reference on the row. Capture weekly, back up the folder, and close the month only after random receipts still match.

This page is the broader filing system: folders, names, paper vs digital, monthly rhythm. How to keep receipts with an Excel bookkeeping spreadsheet is the narrower job: linking those files to specific rows. The same proof idea without the spreadsheet constraint is how to organize business receipts.

Transaction, receipt, purpose

A row without proof is a claim you might have to reconstruct. A receipt without a row is a photo in a camera roll.

Transaction: date, payee, amount, category, account.

Receipt: the image, PDF, or paper that shows what was purchased.

Purpose: why it is a business cost, in a few words. Especially when the merchant name is vague.

U.S. readers: supporting documents are part of recordkeeping, not a nice extra. Retention depends on the type of record. The IRS explains how long to keep records. This is not tax advice, and other countries differ.

Folder structure that survives a busy month

Keep it boring so you will actually use it.

/Business-records
  /2026
    /01-January
    /02-February
    ...
  /paper-inbox   (scans waiting to be filed)

One business, one tree. Do not make a folder per vendor unless you enjoy filing as a hobby. Month is the unit that matches the close.

If you have more than one entity, the entity is the top folder, then year, then month.

Naming convention

YYYY-MM-DD_payee_amount.pdf

Example: 2026-09-14_adobe_2190.pdf

You should be able to find a row's proof from the name even if Excel is closed. Avoid IMG_4021 and scan_final_really.

Email PDFs belong in the same month folder, not left in the inbox as "storage."

The receipt reference column

In Excel, add receipt_ref. Store the filename, or a short code like 2026-09-014. You do not need a novel in the cell. You need a pointer.

Hyperlinks are optional. They break when folders move. A stable filename in a known month folder is more durable. The row-link workflow, including hyperlinks when you want them, is the companion article.

Paper receipts

Photograph or scan in the weekly session. Put the paper in a monthly envelope if you still need the physical copy. Do not run two systems where paper is "the real one" and the drive is a graveyard of blurry photos.

Thermal paper fades. Digital copies are how those receipts survive.

Monthly workflow

1. Capture during the week (photo, forward email, drop in inbox folder).
2. Once a week, rename and file into the month.
3. Enter or review the Excel rows the same day you file.
4. At month-end, pick five expenses and find their files on purpose.
5. Back up the year folder (drive plus a second location).

If step 4 fails, the organization is theatrical. Fix names and timing before you buy another app "for receipts" that you will also not open.

When this Excel-plus-folders system gets heavy

The filing idea is sound. The failure mode is volume plus delay: 80 photos on Sunday, mystery merchants, and a sheet that was last updated in July.

That is not a reason to keep a worse folder tree. It is a reason to ask when to stop using Excel for bookkeeping. Receipts were the first part of the process to crack.

Frequently Asked Questions

A Clear Next Step

Create this month's folder today. Rename ten existing photos into the convention above. Add receipt_ref to the sheet. Next Sunday, file what you captured this week before you open anything else. Organization is a weekly motion, not a year-end project.