How to convert receipts into an expense spreadsheet
Receipts pile up in camera rolls and email inboxes. Finance still wants a spreadsheet: date, merchant, category, amount, project, reimbursable or not. Converting photos into that sheet does not have to be chaotic if you use a fixed schema and a two-speed workflow — DIY for a handful of lines, outsource when volume spikes.
Define the columns once
Agree on a minimum set before you type a single row:
- Date (ISO
YYYY-MM-DDwhen possible) - Merchant
- Description / line item
- Category
- Subtotal, tax, amount
- Payment method
- Project or client
- Reimbursable? (Yes/No)
- Receipt ID or filename
Changing column names mid-month breaks every SUMIF you will write later.
A fast DIY path for text you can copy
If you already have line items as text (forwarded email receipts, PDF text layers, notes), paste them into the free receipt / invoice → CSV tool. It guesses dates and amounts, builds a table, and lets you download CSV to open in Excel. Then paste into a proper tracker workbook.
Use a workbook with formulas, not a blank grid
Blank sheets invite inconsistency. A good expense workbook gives you category dropdowns, Amount = Subtotal + Tax, dashboard totals, and a place for monthly summaries. That is what the Receipt-to-Expense Tracker Kit is for — import your CSV or type rows and let formulas hold the math.
When photos and PDFs dominate
Phone photos of thermal paper are hard to type accurately. OCR helps but still needs a human pass for totals, tips, and multi-line merchants. If you have a stack of receipts before a client invoice deadline, outsourcing to a fixed-price Catalog project (chat-only, 24h) is often cheaper than your evening.
Categories that survive audit questions
Keep the category list short (8–12). Map fringe spends to “Other” with a note rather than inventing a new bucket every week. Separate reimbursable client costs from internal overhead using a column, not a parallel spreadsheet.
Quality checks before you submit
- Spot-check five amounts against images.
- Confirm currency — do not mix VND and USD in one amount column without a currency field.
- Ensure every reimbursable row has a client/project tag.
- Store the original image filename in Receipt ID so finance can pull evidence.
Bottom line
Schema first, CSV second, workbook third. Use free formatters for small batches; keep a formula-ready template for ongoing tracking; outsource OCR-heavy stacks when time matters more than hourly DIY.
Naming files so humans can find them later
Use YYYY-MM-DD_merchant_amount.ext for images and PDFs. When the spreadsheet Receipt ID matches the filename, finance stops pinging you for “the Uber from Tuesday.” Keep originals in a monthly folder even after the row exists; tax questions arrive months later.
Multi-currency and multi-client realities
If you invoice clients in USD but buy coffee in VND, keep an Amount column in the spend currency and a separate Amount USD column with a dated FX rate — or convert once at month end with a documented rate source. Never silently mix currencies in one numeric column. Tag every reimbursable row with a client code before you submit; untangling “whose lunch?” after the fact wastes more time than tagging up front.
Building the habit for solo freelancers
Set a weekly 20-minute block. Empty the phone’s receipt album into the month folder, run new text receipts through the CSV formatter, paste into the tracker, and clear the album. Small batches beat quarterly archaeology.
When travel weeks produce fifty photos, stop DIY and send the batch to a 24h Catalog delivery. Your billable hour is usually worth more than manual OCR.
Hand-off packet for a bookkeeper
Zip the spreadsheet, the month’s receipt folder, and a one-line note about FX policy. If you use the Gumroad expense kit, the Dashboard sheet already answers “what did we spend by category?” without a live walkthrough.
Template maintenance over a year
Every January, archive last year’s workbook and start fresh from the same template so pivots stay snappy. Review categories: retire unused ones, add at most one or two new ones. If you constantly write essays in the Notes column, you probably need a better Category or Project taxonomy — not longer notes.
Keep the Gumroad kit as the pristine master; clone it per year or per client rather than mutating the only copy until formulas break.
From CSV into the tracker without breaking formulas
Download CSV from the formatter, open it, and copy values into the Expenses sheet beneath any sample rows you no longer need. Do not paste over the header. Leave the Amount formula column alone if your tracker computes Amount from Subtotal and Tax — paste into Subtotal/Tax instead. If your CSV only has a single Amount, put it in Subtotal and leave Tax blank or zero.
After paste, spot-check five merchants, confirm dropdown categories still validate, and glance at the Dashboard totals. If the pie chart looks empty, you likely pasted categories that do not match the Categories sheet spelling. Fix spelling rather than editing chart series by hand.
Edge cases: tips, refunds, and split tickets
Record tip as its own line or include it in Amount with a note — pick one policy. Refunds should be negative amounts, not deleted history. Split restaurant bills across clients only when contracts allow; otherwise keep one row and allocate in billing software separately to avoid a fractal of tiny receipt lines.