Scanning receipts for expense tracking: from wallet to spreadsheet

A receipt printed on thermal paper starts to fade within weeks. It is small, it crumples in your wallet, and it disappears exactly when you prepare an expense report. The fix is not a better binder. It is a short routine that turns each receipt into a row in a sheet on the day you get it.

Why receipts get lost

• Thermal paper fades with heat, light and friction. A receipt left in a car can turn into a blank slip.
• They are small and long, so they are hard to photograph well in a hurry.
• They pile up. A month of receipts in one bag turns an hour of work into an evening.

A two-minute routine

1. Photograph the receipt on the day you get it, before it fades or crumples.
2. Lay it flat on a dark, even surface. The contrast helps find the edges of the paper.
3. Shoot from above, with the whole receipt in the frame, including the top line and the total at the bottom.
4. One receipt per photo. Several receipts in one picture get mixed up.
5. Drop the photo onto the receipt scanner page, or shoot directly from your phone with the camera button.

What comes out of a receipt

A typical receipt usually yields the business name, its VAT number, the date and time, the total, the VAT if shown, and the payment method. When items are listed, they come out as a table with description, quantity and price.

Many receipts show the card number partially, the last four digits only. That is how it should be. If a receipt shows a full card number, do not keep it in your sheet.

From a sheet to an expense report

One sheet a month, one row per receipt, is enough for most small businesses and for most employees claiming expenses:

The last two columns are your decision, and no automatic reading replaces it. A PivotTable by category gives you the monthly report.

Each receipt exports to its own file. To move it into the monthly sheet, copy the value column from the fields sheet and paste it as a row with Paste Special and Transpose.

Receipts that are hard to read

• Faded receipts: photograph in daylight, without flash. If the digits are barely visible to you, the reading will struggle too, and the values will be marked for review.
• Long receipts: get all of it in one photo, even if you have to step back a little. One sharp photo of the whole receipt beats two halves.
• Crumpled receipts: smooth them by hand before shooting. A crease through an amount is a classic source of mistakes.

What to keep

The sheet gives you data, not an official archive. Bookkeeping rules decide when a scanned copy is enough and under what conditions, so keep the original receipts as the rules require, or check with whoever keeps your books.