Extract Receipt Details Without Treating the Extraction as Truth

You photograph a receipt, extract the total, and file the result. It feels finished—until the image turns out to show $84.00 and the extracted text says $34.00. Text extraction reduces typing. It does not establish that the expense record is correct.

Keep the image beside the fields Create a record with merchant, date, currency, subtotal, tax, total, source reference, and review status. Use the tracker design principles to make the next action obvious. Keep the original in an organized, restricted location using the file-handling guide. Google’s image-to-text instructions explain its conversion process and limitations. Start with clear fictional samples before real receipts.

Use uncertainty as a useful result If the currency is not shown, write Not shown. If the date is cropped, write Unreadable. Do not let a tool guess because your spreadsheet expects every cell to contain something. Practice instruction: “Extract only fields visibly supported by this receipt. Preserve the displayed currency. Mark unreadable or absent fields. Do not infer missing values or assign tax treatment.” For sensitive records, decide what you are authorized to process and retain; consult the FTC’s business data-protection guide.

Check arithmetic without repairing the evidence Fictional receipt: subtotal 25.00, tax 2.00, total 27.00. Those numbers reconcile. If the extracted total is 72.00, flag the mismatch and inspect the image. Do not silently replace 72.00 with 27.00 and call it verified. The image might include a charge that was missed. A matching sum is a useful check, not proof that every field was read correctly. Record the reviewer and any correction through your approval process. Google’s version-history tools can help inspect spreadsheet changes; they are not a dedicated accounting audit trail.

Watch for the same receipt arriving twice A photo and a PDF may represent one purchase. Two purchases can also have the same merchant and total. Flag possible duplicates for review; apply the caution from contact matching rather than treating a similarity as proof.

Run a small test batch Use clear, blurry, cropped, and duplicate examples with the testing checklist. Give unresolved records an owner and next action. Measure extraction plus correction time using the measurement guide. The output is prepared data ready for the business’s expense-review process—not a decision about deductibility or final accounting treatment.