How to organize Gmail receipt details in a spreadsheet
A receipt spreadsheet helps collect the transaction references and amounts shown in selected purchase emails. It is useful for review when currencies and merchant identities remain clear.
Start with the right material.
- What you provide
- the readable body of a receipt email in Gmail.
- The intended result
- Readable receipt-email fields in CSV.
How the workflow works.
Map the readable merchant, transaction date, amount and reference into separate fields. Distinguish a receipt total from individual line amounts and keep order identifiers separate where both appear.
What to check in the result.
Compare every amount with the source and check for duplicate receipts. The resulting rows are administrative records, not proof of reimbursement eligibility or a determination of accounting treatment.
Import the CSV with a consistent delimiter and inspect text identifiers, dates and amounts before using spreadsheet totals. Keep the original file available while checking any automatic type conversion.
Learn from the worked example.
The downloadable CSV example uses these columns: Merchant, Receipt, Date, Subtotal, Tax, Paid, Currency, Payment method. Compare a complete record with the source before sorting, combining or importing your own output.
The supplied example is illustrative. It is not a recorded run on your data.
Download the example ↓Use it with your own material.
- Open the source you want to work with and activate WebAct on that tab.
- Copy the task from the hero, add any required fields or preferences, and review the proposed actions.
- Compare the first result with your source. Ask for a specific correction or refinement where needed.