Slipsheet · Content Back to ledger
Home / How to Track Receipts in Excel: A Log That Adds Up
How to Track Receipts in Excel: A Log That Adds Up

How to Track Receipts in Excel: A Log That Adds Up

To track receipts in Excel, keep one Excel Table with a row per receipt and a small summary sheet that totals it by category and month with SUMIFS. Add two checks, one for rows missing a client tag and one for duplicates, and the log stays honest as it grows.

Turning a single photo or PDF into a row is a separate job, covered in receipt to Excel. This page is about the log you keep month after month.

The test behind this page

We built a small workbook to check every formula here. It uses example data: 10 made-up receipts from September and October 2026, shaped exactly like a Slipsheet export. It was recalculated in LibreOffice Calc, not Microsoft Excel, and every total was checked by hand against the raw rows.

Step 1: one table, the right columns

Put receipts on a sheet called Receipts and format the range as a Table (Home, Format as Table). Use the nine columns a Slipsheet CSV has, in the same order: date, merchant, total_amount, currency, tax_amount, category, client_tag, notes, file_name. Add one helper column, month, in front.

Example data: the first three of the 10 made-up receipts in the Receipts table
datemerchanttotal_amountcurrencytax_amountcategoryclient_tagnotesfile_name
2026-09-02Staples48.17USD3.92Office suppliesAcmeprinter paperIMG_2041.jpg
2026-09-03Blue Bottle Coffee11.5USD0.98MealsAcmeclient coffeeIMG_2044.jpg
2026-09-08Adobe59.99USD0.0SoftwareCreative Cloudadobe-invoice-sep.pdf

The month column holds this formula in row 2, filled down:

=TEXT(DATEVALUE(B2),"yyyy-mm")

It turns 2026-09-02 into the text 2026-09. If Excel has already converted your date column into real dates, you can format the date directly and skip DATEVALUE.

Step 2: totals by category and month

On a Summary sheet, put categories down column A and months across row 1 (2026-09, 2026-10). Each cell is one SUMIFS:

=SUMIFS(Receipts!$D$2:$D$11,Receipts!$G$2:$G$11,$A2,Receipts!$A$2:$A$11,B$1)

Because the month is a single text value, "spend in September" is one criterion instead of a start date and an end date. Tax works the same way on the tax_amount column:

=SUMIFS(Receipts!$F$2:$F$11,Receipts!$A$2:$A$11,B$1)

Example data: spend by category and month, from the Summary sheet (10 made-up receipts, recalculated in LibreOffice Calc)
category2026-092026-10total
Equipment134.880.00134.88
Meals35.259.2544.50
Office supplies48.1722.6170.78
Software59.9959.99119.98
Travel62.40318.20380.60
Total340.69410.05750.74
Tax total18.052.6320.68
Untagged rows224

In the example data, September comes to 340.69, October to 410.05, and the two months to 750.74. Tax is 18.05 and 2.63.

Step 3: catch rows with no client tag

An untagged receipt is one you can't bill or file. Our first version counted blank client_tag cells with COUNTIFS and a blank criterion (""). It returned 1 for October. The right answer was 2: the October Adobe charge and the October Blue Bottle Coffee receipt both have no tag. That is what happened in our LibreOffice test; we didn't test Excel. This version returned the correct 2 for each month:

=SUMPRODUCT((LEN(Receipts!$H$2:$H$11)=0)*(Receipts!$A$2:$A$11=B$1))

It checks the length of each cell instead of matching an empty string.

Step 4: find duplicates without flagging subscriptions

A duplicate check on merchant plus total alone flagged 2 rows: the Adobe $59.99 charges on Sep 8 and Oct 1. Those are a monthly subscription, not the same receipt twice. Adding the date to the key dropped the false flags to 0:

=SUMPRODUCT((COUNTIFS(Receipts!$B$2:$B$11,Receipts!$B$2:$B$11,Receipts!$C$2:$C$11,Receipts!$C$2:$C$11,Receipts!$D$2:$D$11,Receipts!$D$2:$D$11)>1)*1)

The merchant plus total version, for comparison, is the one that flags recurring bills:

=SUMPRODUCT((COUNTIFS(Receipts!$C$2:$C$11,Receipts!$C$2:$C$11,Receipts!$D$2:$D$11,Receipts!$D$2:$D$11)>1)*1)

A dedupe key needs the date. For more ways to spot the same receipt filed twice, see how to find duplicate receipts.

The hard part is getting rows in

The formulas are the easy part. Keeping the Receipts table full is the real work: slips in a shoebox, PDFs in an inbox, all typed in by hand.

Typing receipts into Excel vs opening a Slipsheet CSV in Excel
Typing it yourselfSlipsheet CSV opened in Excel
Where rows come fromYou read each slip and type date, merchant, total and taxUpload photos, PDFs or forwarded emails, check each row, export
ColumnsWhatever you set up, and whatever you remember to fillThe same nine columns every export
Link back to the receiptOnly if you rename and record files yourselffile_name on every row
Your formulas and summaryYoursStill yours; paste new rows into the table

Slipsheet fills the rows; you keep the workbook. It exports one CSV named slipsheet-YYYYMMDD.csv with the nine columns above. Slipsheet does not sync to Excel; Excel and OneDrive sync are coming soon. The CSV opens in Excel, and if merchant names have accents, import it with Data, From Text/CSV and pick UTF-8, as explained in this CSV guide. The column walkthrough explains each field.

One receipt is always one row; Slipsheet has no merge feature. Google Sheets sync is on Pro. QuickBooks and Xero take the same CSV through their import. Starter is $5/mo for 250 receipts, Pro is $12/mo for 1,500 receipts plus Google Sheets sync, and yearly plans are $50 and $120. The 14-day free trial needs no card. Try Slipsheet.

FAQ

What columns should a receipt log in Excel have?

Date, merchant, total_amount, currency, tax_amount, category, client_tag, notes and file_name, plus a month helper column. That matches a Slipsheet export, so new rows paste straight into the table.

How do I total receipts by month in Excel?

Add a month column that turns each date into text like 2026-09, then use SUMIFS with category and month as the two criteria. One month value replaces a pair of start and end dates.

How do I stop counting a receipt twice?

Check for repeats on date, merchant and total together. Merchant and total alone will flag recurring bills, like the same software charge each month, as duplicates.

Can I keep the receipt image with the row?

Keep the image as a file and record its name in a file_name column. Slipsheet fills file_name on every row it exports, so each total points back to its receipt.

Ready to stop typing receipts?

Open your ledger.

14-day trial. No card. Cancel anytime. Your receipts write themselves while you do literally anything else.