Turn a pile of itemized purchases into a reviewable worksheet
Turn the itemized section of a receipt photograph into spreadsheet rows for expense review. Thermal printing, discounts and wrapped product names can confuse recognition, so compare every important amount with the original receipt.
Itemized travel expense review
Separate purchased items from tax and payment lines before assigning your own expense categories in a workbook.
Comparing repeated purchases
Collect receipt line items over time, then normalize product names manually before comparing unit prices in Excel.
Check receipt items before adding expense categories
- Flatten the receipt and photograph it in even light so faded digits remain visible.
- Extract and review wrapped descriptions, negative discounts and quantity-price pairs.
- Keep subtotal and tax rows distinguishable from items, then export the checked workbook.
Faded receipts, discounts and totals that look like items
- Will receipt to Excel classify expenses automatically?
- It extracts visible table data. Assign accounting categories and decide which purchases belong in an expense claim after reviewing the workbook.
- Can a faded thermal receipt still be converted?
- Only legible marks can be recognized reliably. Try a better-lit close-up and correct uncertain amounts; missing print cannot be reconstructed with certainty.
- Why does my receipt total appear as another item?
- Receipts often separate totals through spacing rather than clear columns. Review the grid and distinguish subtotal, tax, tips and payment rows before analysis.
- Is the extracted workbook a replacement for the receipt?
- Keep the original receipt as supporting evidence. The workbook is a transcription for review and may contain recognition errors.
- What are Rows that look like totals in the History panel?
- They are lines whose label starts like a total, such as Total, Subtotal or Amount due. The chart adds up the whole amount column, so those lines are left out by default to avoid counting the same money twice. Tick one to include it, and check the line under How values will be read.
- Can I total a month of receipts in one workbook?
- Yes, once you are signed in. Save each checked receipt to a collection, choose a From and To period in History and open the combined workbook. Each row carries its Document date and Source file, so a single table can be summed or pivoted.
- Does Excel read the prices as numbers?
- Not at first. Every cell is saved as text, which keeps item codes intact, so convert the price column to numbers in Excel before you add it up. The History chart does its own reading of the amount column, using the decimal separator you choose for the collection.
- Why does the panel warn me that a receipt was already saved?
- It found the same source file or a table with the same contents in that collection, and it shows the date of the earlier save. Choose Save anyway only when it is a different receipt, such as two identical coffees bought on one day, so your daily total is not doubled.
- How do I separate store header lines from the items?
- Lines outside the item list come through as single-cell rows at the top of the grid. Delete them with the trash icon, or keep the store name as a note in your own column. History stores the Document date separately, so the date does not need to stay in the table.
- Can I process receipts in other languages or currencies?
- Yes. Set Language to the language printed on the receipt, convert, and enter the matching currency as the unit when you create a collection. Set the decimal separator to a comma for receipts that print 1.234,56, and keep one currency in each collection.
