A shoebox of receipts is useless at tax time. A spreadsheet of the same receipts is a deduction. Here are three ways to make that conversion — and the one that suits you depends entirely on how many receipts you have.
Why bother putting receipts in a spreadsheet at all
Two reasons, and only one of them is tax. The obvious one: if you are self-employed, run a small business, or claim work expenses, you need a total you can defend — and adding up crumpled paper in April is how deductions get missed. The less obvious one: a spreadsheet lets you see spending. Sorted by vendor, a year of receipts will tell you things about your business that no bank statement does, because a statement shows "$412 — Costco" while a receipt shows what was actually in the trolley.
Either way, the goal is the same: every receipt becomes one row, with consistent columns you can sort, filter and total.
Method 1 — Typing them in by hand
Unglamorous, free, and genuinely the right answer if you have fewer than about twenty receipts a month. Open a blank sheet, make columns, and type. Fifteen receipts takes maybe ten minutes.
The trick is to decide your columns once and never change them mid-year, because a spreadsheet with inconsistent columns is worse than no spreadsheet. A workable minimum:
- Date — always in one format.
YYYY-MM-DDsorts correctly;03/04/25is ambiguous across countries and will betray you. - Vendor — the business name as written on the receipt.
- Subtotal — the amount before tax.
- Tax — kept separate; you will need it if you claim input tax credits, and it makes errors obvious.
- Total — what you actually paid.
- Category — meals, fuel, software, supplies. Pick a short list and stick to it.
- Payment method — makes reconciling against a card statement far quicker.
The weakness of manual entry is not accuracy, it is consistency over time. Nobody abandons this method because it is hard; they abandon it because they skip a week, then a month, and then face a backlog.
Method 2 — Photograph and extract the text automatically
Once you are past roughly twenty receipts a month, typing stops being sensible. The alternative is to photograph each receipt and let software read the text off it — a technology called OCR, optical character recognition. Modern versions handle creased thermal paper and odd fonts far better than the scanners of a decade ago.
This is what our Receipt → Excel tool does: you upload a photo of a receipt, it reads the vendor, date, line items, tax and total, and gives you a table you can edit and export to Excel or Google Sheets. It is free, needs no account, and is useful precisely when the manual method has become a chore.
Whatever tool you use, a few habits make extraction dramatically more reliable:
- Photograph the receipt flat, on a contrasting surface — a dark table under a pale receipt.
- Get the whole receipt in frame, including the total at the bottom. A cropped total is the single most common cause of a wrong row.
- Avoid shadows, especially your own hand or phone shading the paper.
- Do it the same day. Thermal receipts fade — a receipt left in a hot car for a fortnight can be genuinely unreadable, by software or by you.
Always cast an eye over the extracted row before you accept it. OCR is very good, not infallible, and the errors it makes are usually quiet ones: a 3 read as an 8, a date in the wrong order, a tip omitted from the total.
Method 3 — Email receipts and digital invoices
A growing share of receipts never exist on paper: they arrive as an email or a PDF invoice. These are the easiest of all to handle, because the text is already text — no photography and no OCR required.
The practical approach is to create one email folder or label, file every receipt into it as it arrives, and process the folder in one sitting each month. For a PDF invoice you can usually select the text directly and paste it. Some accounting software can watch a dedicated mailbox and file receipts automatically, which is worth setting up if your volume justifies it.
The failure mode here is not technical, it is organisational: receipts scattered across an inbox of thousands of messages are effectively lost. The folder is the whole trick.
Which method should you use?
| Your situation | Best approach |
|---|---|
| A handful of receipts a month | Type them in |
| 20+ paper receipts a month | Photograph and extract |
| Mostly email and PDF invoices | Dedicated email folder |
| A year's backlog in a box | Extract, in batches by month |
Most people end up using two of the three, and that is fine — provided everything lands in the same spreadsheet with the same columns.
How long you need to keep the original receipts
Converting a receipt to a spreadsheet row does not automatically mean you can bin the original. Both the Canada Revenue Agency and the IRS expect you to be able to produce supporting documents if they ask, and there are minimum retention periods for business records. Digital images are generally acceptable to both, provided they are complete and legible — but the specific rules depend on your situation and on the type of record.
The safe habit is to keep the image file, not just the row. Store scans in dated folders that mirror your spreadsheet, back them up somewhere that is not only your phone, and check the current retention guidance from the CRA or the IRS for your circumstances — or ask your accountant, who will have a firm view.
Once the mechanics are sorted, the next question is organisation — what to keep, how to categorise it and how long to hold it. Our guide to organising business receipts for tax time covers that side.
Mistakes that cost people deductions
- Recording only the total. Without the tax split you cannot claim input tax credits, and you cannot spot a mistyped figure.
- Inconsistent vendor names. "Staples", "Staples Canada" and "STAPLES #142" are three different vendors to a spreadsheet, and your category totals will be wrong.
- Letting it pile up. A backlog is the reason most receipt systems die. Ten minutes a week beats four hours in March.
- Trusting the extraction blindly. Scan the row, check the total against the image, then move on.
- Mixing personal and business. Keep them in separate sheets from day one; separating them later is miserable.
Frequently asked questions
How do I convert a receipt to Excel for free?
For a small number of receipts, type them into a blank sheet using consistent columns for date, vendor, subtotal, tax and total. For larger volumes, upload a photo to our free Receipt → Excel tool, check the extracted row, and export the table to Excel or Google Sheets.
Can I scan receipts directly into Excel?
Excel itself does not read photographs of receipts. The usual route is to extract the text with a scanning tool first, then export or paste the resulting table into Excel — which is exactly the workflow described above.
What columns should a receipt spreadsheet have?
At minimum: date, vendor, subtotal, tax, total, category and payment method. Keeping tax in its own column matters if you claim input tax credits, and a consistent category list is what makes the totals useful at year end.
Is a photo of a receipt acceptable for tax purposes?
Digital copies are generally acceptable to both the CRA and the IRS provided they are complete and readable, but retention rules vary by record type and situation. Keep the image files as well as your spreadsheet, and confirm the current requirements with the relevant agency or your accountant.
How do I handle receipts in a foreign currency?
Record the original amount and currency, then add a converted figure using the exchange rate on the transaction date. Keep both — the original supports the receipt, the converted figure supports your return.
This article is general information, not financial, tax, or medical advice. See our disclaimer.