- This topic has 8 replies, 4 voices, and was last updated 7 years, 11 months ago by
.
-
Posts
-
-
I am in missouri and got a statement last week notifying me I havent paid any sales tax since 2015 when I filed for my LLC. I am in shock. I guess I lived under a rock because I had no idea I needed to be charging or paying for sales tax. Income yes, sales tax, no. My account gave me no heads up either. I spoke with the mdor and they said if I cannot give them a printable document that has all my sales in missouri for the last 3 years they will charge me for the full amount paypal has declared! Ebay has been no help saying they dont keep that information and paypal wants me to go line by line through 250k in sales for the last 3 years (which are sorted by date and not location). Does anyone know of a less painful route I can take to obtain that information??
Thanks in advance,
Tina -
Check if you can get a PayPal download of your transactions and see if that has the location of the buyer (based on the buyer address on file with PayPal). If you can get that data, you can sort by only the sales into your state.
I would start there.
Maybe contact PayPal for this type of a download if you can.
-
Tina, I just did a check. I use the PayPal download for my accounting.
In PayPal, go to Reports \ Activity Download \ and select your time period. When you download the CSV file and open in Excel, there is a column for the State.
That is your starting point, so it gets you the data you need. Now you just need to get that info all the way back to 2015. Rather than try to do this manually (that is still an option, but I think you can only go back ), call PayPal and see if they can send this to you.
That is the report you need, you just need it for that long ago…
-
Tina,
This is actually very simple.
Go into your Paypal account. Click on the top tab that says Reports.
Then go down to Activity download. Click
Look under Create New Report. Use the drop downs to put in the correct date set. Click on Create Report.
Under Activity Reports, click on Download.
An excel sheet will open up.As T-Satt noted, if there is a stop point in time in which a report can be created, ask PayPal to send you an Excel sheet via emails of your past sales. This will save alot of time and energy.
Do you know how to use excel in order to filter? If you need some assistance with how to filter in Excel, please let me know and I will share how to do it.
-
-
PS – Looks like you can only go back to May 1 2015 as of now (so it looks like they allow 3 years of data).
I would download all that you can, and then ask PayPal if they can send you the early part of 2015. Even if you can’t get that data, you can talk with your accountant to show a % of sales that are within your state for the timeframe you can prove, and then ask that they use that same % for the early part of 2015.
Good luck!
-
Tina, I have done as t-Satt and AdvenE state above years ago. But now, I use quicken which has all the data saved for me. But to answer your question, I followed t-Satt and AdvenE instructions above and it worked just as they say. I only went back two years, but from the Activity section, use the All Transactions and download that report. Save to your desktop then open it in Excel. You may have to do some formatting to make it pretty, pretty but once the column widths are set, and unwanted columns deleted, then from that as they say and sort it by state.
Now create a formula [if you are familiar with Excel] at the top of the Sales column and get a total of the sales for all of your state sales.
Line by line for all those years will take a long, tedious time. so, see if you can get all that data into a spread sheet and do your filtering there.
Good Luck.
-
-
-
-
- You must be logged in to reply to this topic.