

Turn Receipts into a Reviewed Expense Spreadsheet
A folder of receipt scans contains the facts you need, but the format is inconsistent. Some totals are faint, currencies differ and two files may show the same purchase. A review sheet should expose those questions rather than silently resolve them.
Ask for named fields and one row per receipt, then verify each row against its source. Use the supported image or PDF path and review OCR text when a receipt is scanned.
Start with the result you need
Choose the columns
Use source filename, merchant, date, currency, subtotal, tax, total and review note where available.
Prepare the files
Start with a small fictional set. Convert supported images to PDF or use the verified image-handling route before extraction as needed.
Review and create the worksheet
Check the values before requesting the final supported spreadsheet output. Keep possible duplicates and missing values in the review notes.
Prepare a receipt review table with Source filename, Merchant, Date, Currency, Subtotal, Tax, Total and Review note. Use one row per receipt. Preserve the values shown and mark missing or unreadable fields. Flag possible duplicates for review without automatically deleting rows. Do not invent an expense category or approve reimbursement.What to look for in the result
| Source | Fictional value | Review note |
|---|---|---|
| receipt-01.pdf | Total 24.50 USD | Compare the currency and total with the image. |
| receipt-02.pdf | Tax not found | Do not assume that an unstated tax is zero. |
| receipt-03.pdf | Date unclear | Resolve the date before importing the row. |
Review before you move on
- Check the merchant, date and gross total against each source.
- Preserve currency rather than combining unlike amounts.
- Review possible duplicates before removing any row.
- Keep uncertain values separate from confirmed values.
Questions before you start
Can I combine receipt photos and PDFs?
Only use a verified supported input route. Test the actual file types and orientations before repeating the process.
Will this connect to my expense platform?
This article describes preparing an output file. It does not establish writeback or synchronization with an expense system.




