NOTE: Due to recent changes in how TpT generates Seller Detail Reports, this tool only works with years prior to 2019.
TpT sales tax help is here!
We're all stressing a bit about having to wade through mountains of seller data to total up sales tax for each U.S. state, especially since we'd rather be just writing educational resources and working on our store.
Well, I have great news! The TpT Sales Tax Tool will instantly sort, summarize and categorize your TpT seller data for you. No need to learn super-secret-Ninja Excel tricks and keystrokes, no need to spend a lot of your precious time dealing with endless data and spreadsheets. Just download your seller data from TpT, open it in the TpT Sales Tax Tool, click a button and Shazzam! Within a few seconds all of your data will be instantly organized so you can quickly see if you even need to worry about sales tax, nexus, remittances, and all that other ugly stuff we didn't sign up for when we just wanted to share our educational resources and make a few bucks.
And if, perchance, you do think you'll end up needing to address sales tax issues, the resulting spreadsheets will make life a lot easier for you when consulting with your tax professional.
Breathe easier and don't let Wayfair and South Dakota ruin your life. Get a copy of the TpT Sales Tax Tool and make quick and easy work of TpT sales tax concerns.
★ Included tables and charts:
• table: SubTotals sorted by Transactions
• table: SubTotals sorted by Total Sales
• table: SubTotals sorted by Your Earnings
• table: SubTotals sorted by State
• chart: U.S. Transactions by State
• chart: U.S. Sales by State
• chart: U.S. Earnings by State
• chart: States with More Than 200 Transactions
• table: Original seller data, width adjusted
• table: List of state abbreviations
★ This is version 1.2 of the spreadsheet. As I update this spreadsheet with additional features, charts or tables, I alert buyers to download new versions at no additional cost.
★ System Requirements: Microsoft Excel 2010 or newer. Mac Users: Must have Visual Basic for Applications (VBA) installed.
NOTE: This worksheet is intended to present a general overview of seller's state sales tax totals. As tax laws, TpT collections and reporting rules change, the information generated by this workbook may differ slightly from data reports generated by TpT. Use only official data obtained from TpT for your tax reporting, as it will be the most current and accurate.
I am not a tax professional, and this is in no way to be construed as tax advice. I do not work for TpT and this is not a TpT-sponsored or endorsed product. This spreadsheet is simply a tool to help TpT sellers (and myself!) quickly organize their sales data to address potential sales tax issues as a result of the recent Supreme Court Wayfair decision.