# How much have I spent on Amazon each year?

> Markdown version of https://stella.sh/how/money-household/how-much-have-i-spent-on-amazon for agents and LLMs.
> Request your Amazon order history, then total each year's spending minus refunds and cancelled orders. With a PivotTable, or Stella (stella.sh) on your own computer.

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.

- Checked: 14 November 2026
- Stella does it on: Windows, Mac, Linux

## Stella doing it

Recorded 14 November 2026 on Linux (Omarchy) with Claude Code with Opus, on a Claude plan.
Result: 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×.

Video (46 s): https://stella.sh/media/proofs/money-household/how-much-have-i-spent-on-amazon/proof.mp4

Transcript:

- 0:00 Stella on a Linux computer. The Your Orders zip from an Amazon data request is in Downloads.
- 0:02 The prompt: how much spent each year after refunds, saved as a spreadsheet.
- 0:13 Stella replies: it will add up each year minus refunds and save the spreadsheet next to the zip.
- 0:19 Going through the order rows and refunds, sped up 9×.
- 0:31 Done: $17,159.19 since 2022, a total per year, cancelled orders left out and what the export doesn't cover.

What Stella does:

1. Opens `Your Orders.zip` in Downloads: the order history, one row per item, and a separate refunds file
2. Adds up what was charged each year, combining orders with several item rows
3. Leaves out $151.42 of orders that were cancelled and never charged
4. Takes each year's refunds off, $587.21 in total
5. Saves `Amazon spend by year.xlsx` next to the zip, with purchases, refunds and net spend per year, and tabs of every order line and refund
6. Says what isn't in this export: digital purchases and membership fees come in a separate part of Amazon's data

## The prompt to paste

```text
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.
```

## Add it up yourself

1. **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.
2. **Open the order history.** Unzip it and open `Retail.OrderHistory.1.csv` in Excel or Numbers. Each row is one item, so an order with three things has three rows. Filter Order Status and remove Cancelled.
3. **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.
4. **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 Stella 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](https://stella.sh/how/money-household/make-a-budget-from-bank-statement).

**Can it do the same with receipts?**
Yes: see [receipts to spreadsheet](https://stella.sh/how/pdf-excel/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.

Sources: [Amazon Help: How do I request my data?](https://www.amazon.com/gp/help/customer/display.html?nodeId=TBiXKXG7RDE6mBHk0b), [Tiller: How to download your Amazon order history](https://tiller.com/?p=137473).

## Related problems

- [Make a budget from your bank statements](https://stella.sh/how/money-household/make-a-budget-from-bank-statement.md)
- [Turn receipts into a spreadsheet for your expense report](https://stella.sh/how/pdf-excel/receipts-to-spreadsheet.md)
- [Find every subscription and regular payment in your bank statements](https://stella.sh/how/pdf-excel/find-subscriptions-in-bank-statement.md)
- [Find duplicate charges on your credit card](https://stella.sh/how/money-household/find-duplicate-charges-on-credit-card.md)
- [Convert OFX, QFX and QIF files to Excel](https://stella.sh/how/money-household/convert-ofx-to-excel.md)
- [Total your mileage log for taxes](https://stella.sh/how/money-household/mileage-log-for-taxes.md)

Get Stella: https://stella.sh/download. Free with the ChatGPT or Claude plan you already have.
