How to find your total sales tax in paypal for 2011
Note: The sales tax (and a bunch of other information) will only show up in that report if you’re selected to be included in your default reports. if you haven’t selected sales tax as one of the columns you want, it won’t be included.
Ff you’re not seeing what you need, you can customize your reports (after signing in) here: https://history.paypal.com/us/cgi-bin/webscr?cmd=_history-download-customize
I always use google to try and find answers to my questions but somehow I couldn’t find any good information on how to find the total sales tax for 2011. I figured it out myself and decided to write a step by step process on how to find the sales tax for the 2011 in paypal.
- Log into paypal
- Click on “History”
- Chose a custom date so you can get all the information from the entire year.
- Set the start date to 1/1/11 and the end date to 12/31/11
- Click the “show” button
- It takes a couple minutes so just wait for it and do something else for a little while
- Once everything has come up click on the”more” button on the right side
- Click on “Tab deliminated – all activity”
- This screen below pops up.
- Click “download”
- Usually the file is to large and they will email you a day later when you can download it.
- Once you have downloaded the file open it in excel
- Highlight the entire column for sales tax
- Click on the “AutoSum” button
- The total sales tax for the year will be added up and appear at the bottom of the list
7 Comments
William
January 27, 2012Good, helpful walk-through.
erfon
January 31, 2012good walkthrough, but not totally accurate. the sales tax (and a bunch of other information) will only show up in that report if you’re selected to be included in your default reports. if you haven’t selected sales tax as one of the columns you want, it won’t be included.
if you’re not seeing what you need, you can customize your reports (after signing in) here: https://history.paypal.com/us/cgi-bin/webscr?cmd=_history-download-customize
Bryan
February 5, 2012Thanks. Great tutorial. Just a note, I noticed that this report doesn’t show all the sales tax that I collected when compared to the invoices that I printed off. For some reason, PayPal isn’t compiling everything correctly.
Isaac
March 25, 2012Thanks Jon…very helpful info!
daniel
April 16, 2012There are some instances where a taxable transaction was refunded in full or partially. It would be nicer if this information is factored in.
Mike Mitchell
July 26, 2012Thank you very much for this tutorial. You saved me a lot of time by not having to download a report for each and every month.
Allie
January 18, 2013Thank you! That was super helpful.