Analyzing Amazon & Grocery Expenditures By Category

Some (not all) grocery chains can provide a spreadsheet with great info – if you’re a member and log in whenever checking out. I’ve found it interesting to track what we’ve spent on produce, dairy, frozen, meat, etc. in 2024, or whenever.

Amazon can also provide a spreadsheet of purchases. However, they claim they cannot provide categories – even their own listed category for each item (e.g., toys, clothes, garden, electronics, office, etc.). This seems ludicrous to me. (And, embarrassingly, we have so many purchases, I cannot imagine adding them myself item-by-item.)

Has anyone figured out how to analyze Amazon purchases by category?

It seems very interesting expectation. I am working on my personal finance app and will try to find an option and let you know if I get it.

If they provide a spreadsheet, any half-decent spreadsheet processor will be able to automate this if you’re a little handy with it. You could set up rules based either on product description or merchant.

Where do you find the Amazon info? I tried a while back to find one and couldn’t. Also, I’m not so sure I want my grocery store to tell me how much cheese I bought last year :joy:

Ha! We were fairly shocked by how much we spent on coffee!

To find your purchase history, click on your Account/Lists at the top of the page when you’re logged in. Then scroll down to ‘Manage Your Data’. Click ‘Request Your Data’ and select your Data Category.