How to Get Amazon Business Invoices Into a Spreadsheet
Published 18 November 2026. Where other products are mentioned we describe the kind of product and its pricing model, not figures, which change.
Amazon Business gives you two different things, and it helps to know which you need. One is a CSV report of your orders, which opens straight in Excel. The other is the invoices themselves, which you can download in bulk. This guide follows Amazon’s own UK help pages as they read on 18 November 2026; menu names change, so check them against your account.
Quick answer
For a spreadsheet of what you bought, use the Orders report in Business Analytics and choose Download CSV. For the VAT invoices themselves, use “Get order invoices and other documents” on the same page, which downloads up to 2,000 at a time. The report is the faster route to a spreadsheet; the invoices are what your records need.
Route 1: the order report (CSV)
- Go to Business Analytics.
- Under Reports, select Orders.
- Choose the time period, any filters and the columns you want. “Adjust columns” shows the columns in each category.
- Name the report and select Download CSV.
Amazon describes the Orders report as order history and status “at the line-item level”, and says Business Analytics covers order IDs, transaction dates and amounts, payment instruments, purchase order numbers, who made the purchase and order contents. Refunds are a separate report. Earlier reports can be fetched again from Download History.
One warning from Amazon’s own page: if product identifiers and tracking numbers do not display correctly, open the file in a text editor or import the CSV into Excel instead of double-clicking it. That stops Excel reformatting long numbers.
Route 2: the invoices themselves
- Go to Business Analytics, then Reports, then Orders.
- Select “Get order invoices and other documents”.
- Select your orders and choose “Download from selected orders”.
Amazon says you can download up to 2,000 invoices at a time this way. Accounts that pay by invoice also have a “Your invoices” page listing invoices and credit memos, where selected documents from the last five years download together, packaged 2,000 to a zip file. For a single order, go to Your Orders and select Invoice beside it.
What catches people out
- Invoices become available 24 hours after an order ships, so last night’s order may not have one yet.
- Not every seller provides a downloadable invoice. Amazon says that where none is available you must ask the seller, and only the person who placed the order can ask.
- Sellers who have declared themselves VAT-exempt show “Downloadable receipt”, not “Downloadable VAT invoice”, on the product page. A receipt is not a VAT invoice.
- What you can see depends on your role: requisitioners see their own orders, group administrators and finance users see their group’s, and account administrators see everything.
When the report is not enough
The CSV describes orders. Your accounts usually need what the invoices say: the VAT actually charged, the invoice number and the supplier, which on Amazon is often a marketplace seller and not Amazon. If you need those in a spreadsheet, download the invoices in bulk and convert the batch. Invoices to Spreadsheets reads a folder of invoice PDFs into one table with supplier, invoice number, date, net, VAT, total and line items, each checked against the page it came from.
Can I export Amazon Business orders to Excel?
Yes. In Business Analytics, under Reports, select Orders, choose the period and columns, and select Download CSV. The CSV opens in Excel. Amazon’s help pages describe the report as line-item level.
How do I download all my Amazon Business invoices at once?
In Business Analytics, under Reports, select Orders, then “Get order invoices and other documents”, select the orders and download. Amazon’s help says up to 2,000 invoices can be downloaded at a time.
Why is there no VAT invoice for one of my Amazon orders?
Amazon says some marketplace sellers do not provide a downloadable invoice, in which case you must request one from the seller, and that invoices only become available 24 hours after an order ships. Sellers who are not VAT registered provide a receipt, not a VAT invoice.
How far back can I download Amazon Business invoices?
Amazon’s help page for the “Your invoices” page says documents from the last five years can be downloaded.
7 days · 50 documents · No card needed
Try it on one invoice, no account needed · The full 14-tool comparison table · More guides · What Invoices to Spreadsheets is · Invoice to Excel