This method will let you find all sales tax you have collected for any period you need. It could be for the past month or the past year.
So first go to your PayPal account.
Go to the Reports tab in the top menu.
On the left side menu select Activity download.
Here you have three boxes, transaction type, date range, and format. Underneath those you have a link that says Customize report fields.
For transaction type select All transactions. For date range select the date range you need the sales tax info for. For Format select CSV.
Click the link that says Customize report fields.
Expand Transaction Details and make sure Sales tax is selected. Expand Shipping Details and make sure Town/city and State is selected Press Save.
Press Creat Report. Refresh the page to see if the report is ready.
(Make sure that the date range is what you selected. Mine would sometimes set to a single day and I had to go set it a second time.)
Once the report is ready, download the file and open it.
This report has a column with sales tax, city, and state. You can go through this report and find all the sales that you collected sales tax on and what city you shipped the item too.
You can sort the sales tax column in descending order and that will bring all the transactions with sales tax to the top. Or you can use conditional formatting to highlight all the cells in the sales tax column that are not zero. You can also move the sales tax, city and state columns next to each other to have every thing in one place. And you can grab all the rows that have sales tax and move them all to the top so that you have them all together and then you can delete the rest of them that didn’t.
You can find sales tax info in eBay but it only let you see sales for the past 90 days and this method presented here is easier.
So that’s it. Hope this article will help somebody. I’ve searched for this information before and couldnt ever find how to do this. I ended up finding this out myself and wanted to share it.