How to Organize Receipts in Excel or Google Sheets

To organize receipts in Excel or Google Sheets, make one row per receipt and one column per detail (date, vendor, category, amounts and a link to the file). Format it as a table, keep categories in a dropdown, and total them with SUMIFS or a pivot table. That's the whole system. The rest of this guide shows how to set it up so it stays tidy all year.

Everything here works in Microsoft Excel and in Google Sheets. Where the two differ, the difference is noted.

Step 1: Choose your columns

Start with these columns. They cover what a tax preparer or expense report usually asks for, and nothing you'll have to fill in for no reason.

Optional extras: Client or project (if you re-bill expenses), Reimbursed? (for employee expenses), and Notes.

Tips that save trouble later:

• Enter dates as real dates, not text. Use year-month-day (2026-03-14) if you can. It's unambiguous and sorts correctly.
• Keep amounts as plain numbers, without currency symbols typed into the cell. Use number formatting instead.
• Use one row per receipt, even if a receipt contains items from two categories. If you must split one, use two rows with the same date, vendor and file, and note the split.

Step 2: Turn the range into a table

In Excel, click any cell in your data and choose Insert > Table (or press Ctrl+T). Tables extend automatically when you add rows, keep formulas consistent, and give you filter buttons on every header.

In Google Sheets, select the data and use Format > Convert to table, where your version offers it. Otherwise freeze the header row (View > Freeze > 1 row) and add a filter (Data > Create a filter).

Menu names change between versions. If you can't find an option, search the app's help for "create table" or "filter".

Step 3: Make categories a dropdown

Typos split your totals. "Office supplies", "office supply" and "Office Supplies " (with a trailing space) are three different categories as far as a formula is concerned.

1. Put your list of categories on a separate sheet called Lists.
2. Select the Category column in your main sheet.
3. In Excel use Data > Data Validation > List. In Google Sheets use Data > Data validation > Dropdown (from a range).
4. Point it at the list on the Lists sheet.

Keep the list short and stable. If you're self-employed, base it on the expense lines of your tax form, or ask your accountant which groupings they want. Our guide to organizing receipts for taxes has a typical starter list.

Step 4: Total each category with SUMIFS

Make a small summary block, on a second sheet or to the right of the table. List each category in column A, then use:

=SUMIFS(Receipts!G:G, Receipts!D:D, A2)

That adds up the Total column (G) wherever the Category column (D) matches the category in A2. Adjust the column letters to match your sheet. It works the same in Excel and Google Sheets.

To total one tax year only, add date conditions:

=SUMIFS(Receipts!G:G, Receipts!D:D, A2, Receipts!A:A, ">="&DATE(2026,1,1), Receipts!A:A, "<="&DATE(2026,12,31))

To count how many receipts are in each category, use COUNTIFS with the same conditions.

Step 5: Or let a pivot table do it

A pivot table gives you category totals, monthly breakdowns and counts without writing formulas.

• Excel: click inside the table, then Insert > PivotTable. Drag Category to Rows and Total to Values. Drag Date to Columns and group it by months if you want a monthly view.
• Google Sheets: Insert > Pivot table, then add Category under Rows and Total under Values (summarized by SUM).

Refresh the pivot table after adding rows. In Excel that's Refresh on the PivotTable tab. Google Sheets usually updates on its own.

Step 6: Link each row to the receipt file

A spreadsheet total is only as good as the evidence behind it. For each row, record where the receipt lives:

• File name: if you name files consistently (for example 2026-03-14_staples_54.20.pdf), the name alone is enough to find it.
• Hyperlink: in either app, paste a cloud-drive share link into the File column, or use =HYPERLINK("url", "view").

Keep the receipt files themselves in a year-by-year folder, so the spreadsheet and the evidence move together. How long you need to keep them depends on your country. See how long to keep receipts.

Step 7: Check it monthly

Once a month:

1. Filter the table to the month and compare the total with your bank or card statement.
2. Look for statement lines with no matching row. Those are missing receipts.
3. Filter Category for blanks and fill them in.
4. Sort by Total, largest first, to sanity-check anything unusual.

This takes a few minutes and means the year-end total has already been checked twelve times.

The slow part: getting receipts into the sheet

Designing the spreadsheet takes an hour. Typing in 300 receipts takes far longer, and that's where most receipt spreadsheets get abandoned in March.

Some ways to cut the typing:

• Enter weekly, not yearly. Ten receipts a week is manageable.
• Download what you can. Many card issuers and banks let you export transactions as CSV. That gives you dates, vendors and amounts for card purchases. You still need the receipts as evidence and to fill in tax and category.
• Batch-extract from images and PDFs. A tool like ReceiptBatch reads a folder of receipt photos and PDFs and returns one Excel or CSV file with the date, vendor, subtotal, tax, tip, total, currency and a suggested category for each receipt. You review the table, fix anything it got wrong, download, and paste the rows into your master sheet. If you work in Google Sheets, you can import the CSV straight into Sheets.

Whatever the method, keep the same column order every time so pasted rows line up.

A ready-made layout to copy

If you want to start right now, create these sheets:

1. Receipts: the table from Step 1.
2. Lists: your category list for the dropdown.
3. Summary: categories in column A, the SUMIFS total in column B, a COUNTIFS count in column C, and a grand total at the bottom.
4. Pivot (optional): a monthly breakdown by category.

Make a new copy of the file for each tax year. Keep last year's as it is, so the numbers behind a filed return never change.

FAQ

Is Excel or Google Sheets better for tracking receipts?

Either works for this. Excel has stronger pivot tables and works offline. Google Sheets is free, easy to share with an accountant and handy on a phone. Pick the one you'll actually open every week.

Can I attach the receipt image inside the spreadsheet?

You can insert images into cells in both apps, but it makes files large and slow. Linking to the file in a folder works better over a full year.

How should I handle a receipt in a foreign currency?

Record the original amount and currency, and add a column for the converted amount in your home currency. The exchange rate rules for tax depend on your country, so ask your accountant which rate to use.

What if a receipt covers business and personal items?

Split it into two rows (business and personal) with the same file link, and note the split in the Description column.