Receipts to Excel: Turn a Shoebox Into a Ledger
Receipts are the worst-quality documents in the pile: thermal paper that has faded, phone photos at an angle, totals printed in bold while everything else is faint. OCR has to survive all of it before a row is worth having.
Convert one file free — see the table land in Excel
Free daily conversions · photos and PDFs · files shredded after processing.
Why receipts are hard
Thermal paper fades
Six-month-old till receipts have lost contrast; standard OCR reads garbage where the amount should be.
Photos are not documents
Angled, shadowed, and cluttered shots with a table edge in frame confuse page detection.
The total is not the biggest number
Tax, change, and card auth codes can all look like the amount paid. Picking the wrong one is a silent error.
Mixed languages and currencies
A receipt from a trip abroad can carry two currencies and a foreign script.
Handwritten tips
Restaurant receipts often have a written tip and total — the one number you actually need.
Volume, not complexity
Individually trivial, fatal in aggregate: 200 receipts retyped is a lost day.
A receipt workflow that survives reality
Photograph flat and full-frame
Lay the receipt on a dark, plain surface, fill the frame, avoid your own shadow. One receipt per image is better than two on the desk.
Convert and check three fields
Merchant, date, and total. These are the only fields most expense reports need; verify them and move on.
Append to one sheet
Keep a column with the image filename so any row can be traced back to its receipt during an audit.
What to do with the output
The most common use is a monthly expense sheet: date, merchant, category, amount, currency, receipt file. Pivot it by category and the reimbursement claim writes itself.
For bookkeeping, feed the same rows into your accounting tool as expenses. If the receipts belong to a client, keep the source images alongside the sheet — auditors ask for both.
Set expectations before you batch
Receipts are the document class where automatic extraction is least reliable, for physical reasons: faded ink, folds, and handwriting. Treat the output as a fast first draft, not as final figures.
Check every total on receipts above a threshold you care about, and check all of them for the first batch. After a few dozen you will know which merchants and paper types convert cleanly and which need a human.
Frequently asked questions
Can I scan receipt photos into Excel?+
Yes. JPG/PNG photos are OCRed and structured. A flat, well-lit, full-frame shot converts far better than a casual snap.
Does it handle faded thermal receipts?+
Partly. High-contrast remnants convert; heavily faded receipts may lose digits. Check totals manually for anything that matters.
Can it read handwritten totals?+
Handwriting recognition is much less reliable than printed text. Budget for manual entry of handwritten tips and totals.
What fields should I keep?+
At minimum date, merchant, total, and currency. Keep the image filename too — it is the only audit trail you will have.
Is there a limit on how many receipts I can convert?+
Free daily conversions cover occasional use. For a backlog of hundreds, use a per-file pack rather than a subscription.
Keep reading
Done reading? Convert a document and check the output yourself.
Scan a receipt free