Your bank statement says "AMZN MKTP US" for every Amazon purchase — office supplies, software, electronics, subscriptions — all identical. But Amazon emails you a receipt for every order, and those emails have full itemized details.
ExpenseBot scans your Gmail and finds Amazon receipts automatically. Current-year and ongoing scans are included with subscription; completed prior years use the one-time historical unlocks.
📦 What ExpenseBot Finds:
- Amazon.com orders — product name, price, quantity
- Amazon Business purchases — read the same way as personal Prime orders (same
auto-confirm@amazonsender family); a purchase-order number visible in the document is extracted to its own PO Number column - Subscribe & Save — recurring items, amount, frequency
- Prime membership — annual/monthly fee, renewal date
- Kindle purchases — book/content title, price
- AWS charges — service breakdown, monthly totals
- Returns & refunds — matched to original purchase
📊 Tax-Ready Output: Each purchase is categorized by Schedule C line item (US) or T2125 category (Canada). Office supplies on Line 18, Equipment on Line 13, Software on Line 18.
Instead of a bare "AMZN MKTP US - $847.23" you get a row that names what was in the order — the product names are written into the Notes column (short orders list every item; longer ones list the most distinctive items and a "+N more" count), and the category is chosen from those product names rather than from the merchant name.
One order stays one row. ExpenseBot does not write a separate row per product. The order was one card charge with one receipt, so it stays one expense row — that is what keeps your sheet reconcilable against your statement. When a single order mixes business and personal items, or spans two categories, open Review expenses → Split and divide that one payment into allocation lines that add up to the order total exactly. You do not need to add extra rows or delete the original.
Which Amazon emails ExpenseBot picks up (and which it skips on purpose):
Amazon sends several types of emails per order. ExpenseBot is deliberate about which ones become spreadsheet rows:
✅ Processed — the receipt:
auto-confirm@amazon.*(any country marketplace — .com, .ca, .co.uk, .de, .fr, .co.jp, etc.) — the order confirmation ("Ordered: …" or "Amazon.com order of …"). This IS Amazon's receipt — Amazon doesn't send a separate one. ExpenseBot parses the plain-text body directly to extract items, total, tax, and order number, then drops the row into your spreadsheet. Works across 20+ Amazon country marketplaces.
⏭️ Skipped on purpose — not receipts:
shipment-tracking@amazon.*("Shipped: …") — status update, not a charge.order-update@amazon.*("Delivered: …") — status update, not a charge.return@amazon.*(refund issued, dropoff confirmed, return initiated) — skipped today because we don't yet match refunds back to the original purchase row.
Scanning the Shipped / Delivered / Refund emails would create duplicate rows for every order, which is why they're filtered out.
"I see Amazon emails in Gmail but no Amazon rows in my spreadsheet — is the scanner broken?" Usually not. The most common cause is simply that you haven't placed a new Amazon order since signing up — the status emails you're seeing are follow-ups to older orders. Your next actual order confirmation will be captured automatically. Subscribers can also use the "Scan older" option on the Gmail scan button to sweep historical orders from prior years.
Getting a receipt from Amazon yourself
Amazon gives you two documents. The order confirmation email from auto-confirm@amazon.com arrives at checkout and already lists every item, quantity and price. The formal invoice you download yourself: open Returns & Orders, find the order, choose View order details, open the Invoice menu, pick Printable Order Summary (or the numbered invoice if the seller issued one), then print it or save it as a PDF. Amazon makes the invoice available once the order has shipped.
On an Amazon Business account the order detail page shows Print invoice when the seller uses Amazon's tax-calculation service, and Request invoice when it does not — that request goes to the seller, who issues the document. Amazon Business also supports bulk invoice download under Business Analytics → Reports → Orders. Personal accounts have no bulk download.
To find an older order, use the time filter at the top of Your Orders and pick a year — Amazon keeps order history for the life of the account. The separate Archived Orders view was retired in August 2025; those orders now appear in the main Your Orders list.
ExpenseBot does not log into Amazon or scrape the website — it reads the confirmation emails already in your Gmail. If you need the formal invoice PDF for a specific order, download it from Your Orders and forward it to your ExpenseBot address; forwarded PDF attachments are processed like any other emailed receipt.
(Amazon interface steps verified against Amazon's published help pages on 2026-09-09.)
🔗 Learn more: Amazon Receipt Scanner