How to Scan Receipts into Google Sheets for Expense Tracking

Receipts are the worst kind of paperwork: small, crumpled, faded, and easy to lose — yet you need them for expense reports, tax deductions, and reimbursements. Typing each one into a spreadsheet by hand is tedious, and most people put it off until the pile is overwhelming.

This guide covers how to scan receipts into Google Sheets and build an expense log that keeps itself organized, whether your receipts are paper, PDFs, or photos on your phone.

What to capture from each receipt

A useful expense log usually needs just a few columns:

• Merchant / vendor
• Date
• Total amount
• Tax (and tax rate, if you reclaim VAT/GST)
• Category (meals, travel, supplies…)
• Payment method, if you reconcile against a card statement

Decide these first — they become the schema you extract into.

Why receipts are harder than invoices

Receipts push OCR harder than clean PDFs do. Thermal-paper receipts fade, photos are taken at odd angles in bad lighting, and layouts vary wildly between a café and a hardware store. Plain text-copying fails completely on a photo, and generic OCR often returns a jumble that still needs untangling. What works is vision-based extraction that understands a receipt as a receipt — locating the total even when it's near the bottom in tiny print. (The same approach that powers invoice extraction handles receipts.)

Step by step: receipts to a Google Sheet

Using Scrape2Sheets, the flow runs inside Google Sheets:

1. Snap or collect your receipts. Photograph paper receipts with your phone (JPG/PNG) or gather PDF receipts — then drop them in a Google Drive folder.
2. Open the add-on in a Google Sheet and select those files from Drive.
3. Set your columns — Merchant, Date, Total, Tax, Category — or auto-detect them from a sample receipt.
4. Run the batch. Each receipt is read by a vision model and written to your sheet as a row. Up to 100 at a time.
5. Review and categorize. Add a category dropdown column and tidy any exceptions.

Because the schema saves, next month you just add new photos and re-run.

Tips for cleaner scans

• Fill the frame with the receipt and avoid shadows — brighter, flatter photos read more accurately.
• Capture the whole receipt, including the total and tax lines at the bottom.
• Keep one receipt per image so each maps cleanly to one row.
• For very long receipts, a straight-on photo usually beats a steep angle.

Turning the log into something useful

Once receipts are rows in Google Sheets, expense tracking gets easy:

• SUMIF by category to see where the money goes.
• Filter by date range for a monthly or quarterly expense report.
• Total the tax column for VAT/GST reclaim.
• Share the sheet with your accountant or reimbursement approver — no shoebox handoff.

Frequently asked questions

Does it work with photos, not just PDFs? Yes. JPG and PNG photos of receipts are supported directly — vision AI reads what's actually in the image, including faded thermal receipts and, in most cases, handwriting.

How is a receipt billed? Billing is per page. A single receipt photo counts as one page; a multi-page PDF receipt counts one page per page.

Can I categorize expenses automatically? You can extract a category if the receipt states one, but most people add a category column with a dropdown in Sheets and set it during a quick review — fast, and fully under your control.

What file size is supported? Up to 10MB per document, which comfortably covers phone photos and scanned PDFs.

---

Clear the shoebox for good. Try Scrape2Sheets free — start with 5 pages, no credit card required.