How much have I spent on Amazon each year?
Five years of Amazon orders as one total per year, refunds taken off.
A real run on 14 November 2026, on a Linux computer, using Claude Code with Opus, on a Claude plan. The waiting is sped up; it took 2 min 34 s in real time.
The short answer.
Amazon retired its order history report, so the way to see everything now is Request Your Data on Amazon, choosing Your Orders. You get a zip with one row per item, cancelled orders still in it, and refunds in a separate file. Total the item rows per year without the cancelled ones, then subtract that year's refunds. Stella (stella.sh) does it from the zip on your computer, without logging in to Amazon, and saves a spreadsheet with every order line so you can check it.
Stella does this on Windows, Mac and Linux.
What happened.
About 2 minutes. Checked afterwards against an answer key written before the run: spending after refunds right for every year from 2022 to 2026 ($2,626.60, $3,086.26, $3,970.51, $4,581.67 and $2,894.15), with the refunds for each year shown.
The orders are fictitious. There's no published layout for Amazon's export, so the file was modelled on how others describe it; your download may have a few more columns. The work is sped up 9×.
How Stella does it.
- Opens
Your Orders.zipin Downloads: the order history, one row per item, and a separate refunds file - Adds up what was charged each year, combining orders with several item rows
- Leaves out $151.42 of orders that were cancelled and never charged
- Takes each year's refunds off, $587.21 in total
- Saves
Amazon spend by year.xlsxnext to the zip, with purchases, refunds and net spend per year, and tabs of every order line and refund - Says what isn't in this export: digital purchases and membership fees come in a separate part of Amazon's data
The prompt.
I requested my data from Amazon and got this zip in my Downloads. How much have I spent on Amazon each year, after refunds? Save it as a spreadsheet.
This is the exact prompt from the recording. If your files are somewhere else, say where.
Do it yourself.
Request your order data
On amazon.com, open Account, then the Request Your Data page (in the privacy section), choose Your Orders and submit. Confirm the email Amazon sends. The download link arrives by email, often within a few days.
Open the order history
Unzip it and open
Retail.OrderHistory.1.csvin Excel or Numbers. Each row is one item, so an order with three things has three rows. Filter Order Status and remove Cancelled.Total each year
Add a Year column from Order Date (
=YEAR(...), or the first four characters if the date is text). Insert a PivotTable with Year in Rows and Sum of Total Owed in Values.Subtract the refunds
Open the refunds file from the same zip (its folder name mentions Returns or Refunds), do the same pivot by year on the refund amount, and subtract it from each year's total.
Where it stops.
- Only what's in the export you requested. Kindle books, apps, video and membership fees sit in other parts of Amazon's data, and Stella said they weren't counted.
- Totals can differ a little from your card charges where gift cards, promotions or split shipments are involved.
- Your order list goes to the AI model you use in Stella while it adds up. Stella doesn't log in to your Amazon account; you request the data yourself.
- Recorded on Linux. On a Mac or Windows PC Stella may first install Python or a small spreadsheet library, which wasn't recorded.
Questions.
Where did Amazon's order history report go?
Amazon removed the old order report page. Your full history now comes through the Request Your Data page, as a zip of CSV files sent by email.
How long does Amazon take to send my data?
It varies, from hours to several days. Amazon emails you when the download is ready, and the link expires after a while.
Can it split the spending by category or by month?
Yes, in the same chat: ask for months or categories from the product names. For your whole household budget see make a budget from your bank statement.
Can it do the same with receipts?
Yes: see receipts to spreadsheet for PDFs and photos of receipts.
Is Stella free for this?
Yes. Free with the ChatGPT or Claude plan you already have. Sign in with your ChatGPT plan, or use your Claude plan through Claude Code, and this task costs nothing extra. New accounts also get a small free trial of Stella’s own models.
Can I control what Stella changes on my computer?
Yes. Stella works on Windows, Mac and Linux with your own files and shows each step in the chat, so you can watch it and stop it at any point. Tell it what it may not do, as the prompts on these pages do (“don't delete anything without asking”). In the Downloads recording it deleted nothing until it was told to go ahead. It also refuses commands that would wipe a whole disk, your home folder or system folders.
Checked against these sources on 14 November 2026.