How to Keep Receipts With an Excel Bookkeeping Spreadsheet

Quick Answer

To keep receipts with an Excel bookkeeping spreadsheet, give every expense row a pointer to a file: a receipt_ref column with a stable filename, a month folder that actually contains that file, and a short business-purpose note. Hyperlinks are optional. They help when the folder never moves. They fail when you rename drives or email the workbook without the files.

This is the row-to-file connection. How to organize receipts when you use Excel is the filing system around it (folders, paper, weekly capture, backup). Do not skip the folders and try to solve everything with blue underlined links.

The receipt column

Add receipt_ref next to amount and category.

Store the filename, not a novel:

2026-09-14_adobe_2190.pdf

Or a sequential code if you already number envelopes: 2026-09-014. Then put that same code in the filename.

Empty cells are a queue, not a style choice. A month should not close with a column of blanks you meant to fill.

File naming that matches the row

Same pattern as the organization article, because the pointer has to resolve:

YYYY-MM-DD_payee_amount.ext

If two purchases share date, payee, and amount, add -2. Ambiguity is how you attach the wrong lunch.

Put the file in /Business-records/2026/09-September/ (or your equivalent). The sheet should not be the only place the name exists.

Hyperlinks, used carefully

Excel can link a cell to a local file or a cloud URL. Microsoft documents how to create a hyperlink.

Use links if:

• the files live in a cloud folder that will not be reorganized on a whim
• you are the only one moving the workbook
• you are willing to fix links after a path change

Do not use links as the only identifier. Keep receipt_ref as plain text so an accountant can search the folder when the workbook arrives by email and the links point at your laptop.

Relative links inside a folder you zip together (books.xlsx + receipts/) travel better than C:\Users\you\Desktop\....

Email receipts

Forward or download the PDF the same week. Do not leave "the email is the receipt" as policy. Search fails when the vendor name in Gmail is not the payee in the sheet.

If the email is the only copy, save it as PDF into the month folder and put that filename in receipt_ref.

Business purpose on the row

A third column, purpose, for anything that is not obvious:

• client name for a meal
• project name for software
• "office supplies for studio" when the merchant is a supermarket

The receipt shows the cart. The purpose shows why the business paid. Together they are an audit trail a stranger can follow. That is what your accountant is looking for, not a prettier font.

What a usable audit trail looks like

For a random expense, you can:

1. Find the row.
2. Read payee, amount, account, purpose.
3. Open the file named in receipt_ref.
4. See that the file matches the row.

If that takes more than a couple of minutes, the link between sheet and proof is decorative.

When you later convert the spreadsheet to software, this column is what you migrate as attachments. Formulas will not come along. Filenames can.

When the row-link workflow becomes too much

It becomes too much when you have more receipts than patience: marketplace payouts, staff expenses, two cards, and a close you keep postponing because attaching files is the slow step.

The method is still correct. The container is the constraint. That is the same maintenance threshold as the Excel pillar. Bookkeeping software does not excuse you from proof. It shortens the distance between the transaction and the file.

Frequently Asked Questions

A Clear Next Step

Add receipt_ref and purpose to this month's sheet. Attach the last ten expenses using filenames, not "see email." If those ten are easy, you have a workflow. If those ten are a hunt, fix the month folder first, then decide whether the grid is still the right place to keep doing this.