Receipt to Excel Converter

These fictional purchases show the summary sheet before any corrections. The Shell row is red because 46.00 plus 4.00 is 50.00, while the extracted total is 51.00. Open that image and check those three figures first. The coffee receipt includes a tip, which belongs in the total rather than the goods subtotal.

1. 1

   Photograph or choose your receipts

   Use Take photo at the counter, select pictures from your phone, or drop in an electronic receipt PDF. Put one receipt in each picture. A PDF page also counts as one receipt; keep each PDF within 20 pages.

2. 2

   Compare the numbers with the paper

   Read the merchant and date, then inspect any red or gray row. Click a number to correct a recognition mistake. When you leave that cell, the calculation runs again. Expand Line items to inspect the purchases behind the subtotal.

3. 3

   Keep the workbook or either CSV

   Save one Excel workbook containing the receipt summary and product details. If you need plain tables, download the summary CSV and line-items CSV separately. Both include the receipt number so you can match purchases to their source row.

The Receipts worksheet contains one record per image or PDF page. Line items is a separate worksheet: it can contain several product rows for the same receipt. Numbers are numeric cells, dates are Excel date cells, and a missing printed value stays empty instead of becoming a guessed zero.

Subtotal + added tax + tip + service fees − discount = total

The comparison uses whole cents to avoid rounding artifacts such as 0.1 + 0.2. A discount reduces the expected total whether the receipt prints it with a minus sign or as a positive savings amount. Tax already included in the goods price is excluded from the addition. Tips and fees each have their own editable field.

If no subtotal is printed, complete item amounts can supply the base for the check. Without either a subtotal or a complete set of item amounts, the row is gray and says Subtotal not printed. A missing total also prevents a check. Extraction cut short by the processing limit stays marked incomplete even when the visible figures agree.

Product amounts are compared with the subtotal separately. An amber note says when the items add up to a different number; that alone does not turn the receipt red. Coupons applied to individual products, weighted groceries and grouped discounts can explain that difference. A red total may come from a misread digit, a fold through the tax line or a handwritten tip that was missed. Correct the printed value rather than changing a number simply to make the check pass.

Flatten the paper on a contrasting surface and keep all four corners in view. Use even light from the side so your phone does not cast a shadow over the prices. Tap the text to focus, hold the camera parallel to the receipt and check that the final total is legible before uploading.

For a long supermarket receipt, move farther away and take one complete photograph rather than overlapping fragments. The tool does not stitch separate pictures into a single receipt. If the print is too small at that distance, a clear PDF scan may work better. Faded thermal paper needs particular care: improve the lighting and retake the photo, but expect missing digits to need manual correction.

In Excel, filter the summary by Date or Merchant to gather a trip's expenses, then sum the Total column for that selection. Keep different currencies in separate totals. The receipt number connects those purchases to the second sheet when you need to explain which products made up an expense.

You can open the workbook in Google Sheets or import either CSV as a separate tab. For reimbursement, add your own purpose, project or expense-category column after downloading. Accounting software that accepts CSV may require you to map the date, payee and amount columns; this is a general expense table, not a dedicated import template. For bank-feed transactions in QuickBooks, use the PDF to QBO converter with a bank statement.

Start with 5 free receipts every day, including the combined workbook and both CSV downloads. Free receipt usage has its own allowance and does not consume your daily statement pages. Pro shares one credit balance across both tools: 1 credit = 1 statement page or 1 receipt. With credit available, you can process up to 20 receipts in one batch. Review the plans and credit packs for larger collections.