Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
Downloading Amazon transactions
Old 01-19-2016, 05:42 PM   #1
Dryer sheet aficionado
 
Join Date: Feb 2013
Location: Small town in flyover country
Posts: 43
Downloading Amazon transactions

I just did a major face-palm this afternoon when I realized Amazon offers downloadable spreadsheets (CSV format) for all of your transactions.

I track all of our expenses throughout the year and categorize them (groceries, home repair, etc.) so that I can more easily track our budget and prepare for future budgets. I was able to get all of this data for our conventional financial institutions without any trouble. However, we use Amazon gift cards a lot because the 10% bonus for sending tax returns to Amazon is too hard to pass up. I've even been known to *ahem* overpay our estimated taxes so that we get the 10% bonus on our tax return. I don't know anywhere else you can get guaranteed 10% returns in a few months.

The problem is that I ended up needing to manually enter several hundred (don't ask) Amazon transactions at the end of the year and going through each item in my order history on Amazon's web site was a major pain. It just occurred to me today to check if Amazon offers a way to download a detailed order history.

Here is a link to Amazon's instructions on downloading order reports:
https://www.amazon.com/gp/help/custo...deId=200131240

Hopefully this link will save someone else the pain I went through.

Now I just need to order an icepack from Amazon to take down the swelling on my forehead from my face palm...

-Fean
__________________

__________________
Spirit of FIRE
Fean is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 01-19-2016, 06:27 PM   #2
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
harley's Avatar
 
Join Date: May 2008
Location: Following the nice weather
Posts: 6,435
Cool, and thanks! That could be quite useful. I have a small business that buys a lot of crap important stuff from Amazon. The majority of the time if there's a problem I can just look back at the order. But if you return an order it disappears as if it never existed, and sometimes I've needed to look back for some of the information. Now I can just download as I go, and keep it in a spreadsheet.


Edit: Even better! One of the options on the report is Returns, so (assuming it works) I won't even have to download as I go. I just started a report of all the items that I ordered last year, but it's taking a very long time. Once it's finished I'll try one for the returns and see how that goes. Once again, thanks!
__________________

__________________
"Good judgment comes from experience. Experience comes from bad judgement." - Will Rogers, or maybe Sam Clemens
DW and I - FIREd at 50 (7/06), living off assets
harley is online now   Reply With Quote
Old 01-19-2016, 06:43 PM   #3
Full time employment: Posting here.
 
Join Date: Jan 2007
Posts: 854
Quote:
Originally Posted by Fean View Post

Hopefully this link will save someone else the pain I went through.

Thank you! I love this forum.
__________________
spncity is offline   Reply With Quote
Old 01-19-2016, 10:56 PM   #4
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Sep 2005
Location: Northern IL
Posts: 18,288
Thanks - will try it later.

I recently was looking for something like this. Their normal listing is a few per page, and then you need to click 'details' to see... the details.

I wanted to check if they collected sales tax on all our 2015 orders. We are supposed to report sales tax due on items purchased outside of IL, and they have tightened up the entries on this (many people, myself included, ignored it in the past - it was just too much work to calculate, and I blew it off for the few bucks it would amount to).

But if I have documentation to back me, I'll proudly enter ZERO on that line, rather than their default % of income.

-ERD50
__________________
ERD50 is offline   Reply With Quote
Old 01-20-2016, 06:10 AM   #5
Thinks s/he gets paid by the post
grasshopper's Avatar
 
Join Date: Oct 2010
Posts: 1,671
Kool indeed, thanks
__________________
For me experiences are not good or bad, just different
grasshopper is online now   Reply With Quote
Old 01-21-2016, 10:32 AM   #6
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Sep 2005
Location: Northern IL
Posts: 18,288
Quote:
Originally Posted by ERD50 View Post
Thanks - will try it later. ...
It is 'later'. And it worked for me, thanks!

I chose the "Items" drop down (there are other choices, have not tried yet, as this gave me what I was looking for), took maybe a minute to run. LibreOffice imported it just fine, and it gave me everything I was looking for. I have not verified any of the data, I'm assuming it is correct for now. Some items listed with tax, some with $0.00 tax

The headings of interest to me, way out to the right (AB AC ) are:

Item Subtotal Item Subtotal Tax


I/we spent less at Amazon than I expected! A little sorting, summing, and I got:

78 << # of entries
50 << # entries with zero tax listed
28 << # entries with some tax listed

$50.09 << SUM of tax paid

$674.15 << SUM of purchases with ZERO TAX listed
$805.38 << SUM of purchases with TAX listed
$1,479.53

And while I'm at it (geek!): Average, median item $: $18.97, $9.99

Of course these are the individual items, my purchases are usually lumped (I don't buy 'Prime', so typically go for > $35 for 'free' shipping when it applies).


I'll look at my IL tax forms later, to see if this helps at all.

PS: A few more numbers:

6.22% << % of tax paid on the items that had tax collected.

5.63% << MIN % of tax paid on the items that had tax collected.
6.37% << MAX % of tax paid on the items that had tax collected.

We have a few sales tax entities, State, some regional transportation district (IIRC, this is on different borders than just county, or maybe includes several counties?), maybe something else? So who knows?

-ERD50
__________________
ERD50 is offline   Reply With Quote
Old 01-21-2016, 10:45 AM   #7
Dryer sheet aficionado
 
Join Date: Feb 2013
Location: Small town in flyover country
Posts: 43
Quote:
Originally Posted by ERD50 View Post
It is 'later'. And it worked for me, thanks!
-ERD50
Very cool It didn't even occur to me that this would be handy for calculating taxes.
__________________
Spirit of FIRE
Fean is offline   Reply With Quote
Old 01-21-2016, 10:59 AM   #8
Full time employment: Posting here.
Jack_Pine's Avatar
 
Join Date: Apr 2013
Posts: 834
I don't think I want to know.........................
__________________

__________________
The Constitution. It's not just a good idea...it's the law.
Jack_Pine is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sites for downloading music? David1961 Other topics 8 01-16-2014 07:24 AM
Downloading YouTube tunes - legal and/or ethical? Lsbcal Other topics 26 01-17-2013 09:35 PM
downloading free mp3 books - safe? simple girl Other topics 6 03-19-2009 02:16 PM
How do I optimize stock transactions ? Dry Socks FIRE and Money 4 10-22-2005 09:52 AM
Quicken 05-Downloading Lancelot Other topics 0 04-15-2005 03:19 AM

 

 
All times are GMT -6. The time now is 07:00 PM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.