Quote:
Originally Posted by ERD50
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