Amazon receipt: fields & CSV layout
Amazon order receipts bundle items, shipping and tax into one document. For expense tracking you want the totals as structured fields. Here's what an Amazon receipt contains and the CSV layout to export.
Convert a receipt free →Fields extracted
| Field | Type | Description |
|---|---|---|
| order_number | string | Amazon order ID (e.g. 123-4567890-1234567). |
| date | date (ISO) | Order date, normalized to YYYY-MM-DD. |
| merchant | string | 'Amazon' or the third-party seller name. |
| subtotal | number | Items subtotal before shipping and tax. |
| shipping | number | Shipping & handling charge. |
| tax | number | Sales tax / VAT applied. |
| total | number | Grand total charged. |
Clean CSV layout
| order_number | date | merchant | subtotal | shipping | tax | total |
|---|---|---|---|---|---|---|
| 112-3456789-0123456 | 2026-03-14 | Amazon.com | 39.98 | 0.00 | 3.40 | 43.38 |
| 114-9876543-2109876 | 2026-03-20 | Marketplace seller | 120.00 | 5.99 | 10.71 | 136.70 |
Sample rows are illustrative. ParseDoc outputs this exact column layout from your own document.
Conversion notes
›Amazon's own 'Order History Reports' export covers your account, but only your account — for clients, mixed inboxes, or forwarded receipts you parse the PDF/HTML receipt instead.
›Third-party (marketplace) orders show the seller as merchant, which matters for VAT and 1099 categorization.
›Keep subtotal, shipping and tax separate from total so deductible vs non-deductible portions stay visible.
FAQ
Does Amazon export receipts to CSV?
The Order History Report exports your own orders. For receipts forwarded by others or for clients, converting the receipt document is the way to structure them.
Itemized lines?
Item-level detail is available; many bookkeepers keep header-level (subtotal/tax/total) for speed and only itemize when needed.
Convert your own Amazon receipt
Drop the PDF or a photo into the free converter — 10 pages/day, no signup, nothing stored. See also: the full guide.