How do you track receipts in Google Sheets? Turn email PDFs, Camera Roll snaps, and a Drive folder named Receipts 2026 into one sheet: one row per receipt, columns you can filter and sum. Soft product land: a sheet you own.
Tax week starts the same way every year. Inbox has twelve PDFs. Phone has coffee snaps with no filename that helps. Drive has Receipts 2026 full of files that open and close and still are not rows. Google Sheets only helps when each slip is a line with date, vendor, category, subtotal, tax, total, and a link back to the source file.
A worked Google Sheets receipt ledger
Copy this shape. Numbers below are measured slips from a local Q2 2026 research corpus (synthetic receipts), not invented vendors. Subtotal is total minus tax when the slip shows tax.
| date | vendor | category | subtotal | tax | total | source link |
|---|---|---|---|---|---|---|
| 2026-04-03 | Amazon Web Services | SaaS | 428.17 | 0.00 | 428.17 | 01-aws.png |
| 2026-04-18 | Blue Bottle Coffee | Meals | 16.95 | 1.52 | 18.47 | 04-bluebottle.png |
| 2026-04-27 | Staples | Office | 61.80 | 5.54 | 67.34 | 06-staples.png |
| 2026-05-01 | GitHub Inc | SaaS | 44.00 | 0.00 | 44.00 | 07-github.png |
| 2026-05-12 | Home Depot | Hardware | 143.97 | 12.91 | 156.88 | 10-homedepot.png |
| 2026-06-11 | Ace Hardware | Hardware | 82.07 | 7.36 | 89.43 | 16-ace.png |
Keep the sheet honest: one row equals one receipt. Source link opens the PDF or photo if someone asks. Do not collapse tax into total when the slip shows a tax line. Blank tax is fine when there is none.
Manual typing vs import into the same columns
You can type every cell yourself. That works until the pile grows. Import or OCR can fill the same columns from a photo or PDF. Either way, the product is the sheet: filter by month, sum a category, export CSV. OCR is how the row gets there. It is not the story.
A local Q2 2026 run on n=20 synthetic receipts (Tesseract 5.5.0, dumb OCR / Drive-like extract) shows why columns beat a text dump. Vendor hit 95% (19/20). Date and total hit 100%. Tax hit 60% (12/20). All four fields correct on only 55% (11/20). Ground-truth Q2 sum $2,034.43 matched the OCR-parsed sum. Treating OCR like a searchable folder, every receipt (20/20) still had 2+ currency-like amounts, avg 6.05 matches per receipt. That is why raw OCR text is not a Google Sheets ledger, and why tax stays its own column.
What “done” looks like in Sheets
Capture slips as they arrive. Land date, vendor, category, subtotal, tax, total, source link. Review odd tax blanks. Filter and sum when tax week shows up. Export CSV if you need a copy outside Google.
Slipsheet turns photos and PDFs into rows you review, then a sheet or CSV you own. Photo, PDF, or forward to receipts@slipsheet.app. Soft land only: open the ledger, keep the columns, export what you need.
A few straight answers
Is a Drive folder of receipts the same as tracking in Google Sheets?
No. A folder stores files. Sheets tracking means structured rows you can filter, sum, and hand to someone without opening every PDF.
Do I need a separate sheet for each month?
No. One ledger with a date column is enough. Filter the range when you need March or Q2.
Should tax and total be one cell?
Not when the slip shows tax. Keep subtotal, tax, and total separate so sums stay honest.