Sales Tax Liability Tracker
A clear, period-by-period view of sales tax owed, collected, and remitted.
Tracking sales tax isn't just about compliance; it's about protecting your cash flow. This tracker captures taxable sales, collections, and remittances so your liability accounts stay accurate and your filings are stress-free.
Why This Matters: The "Pass-Through" Reality
Think of sales tax like a tip jar that doesn't belong to you. When a customer pays sales tax, that money is never yours—you are simply holding it in trust for the state government.
A common mistake is treating all incoming cash as "revenue." If you don't separate the sales tax immediately (either in a separate bank account or at least in your bookkeeping), you might accidentally spend money that isn't yours. When the tax bill comes due, you're left scrambling to pay it out of your actual profits. This tracker helps you visualize exactly how much "other people's money" you are holding at any given time.
Understanding Nexus: Where Do You Owe?
Before you can track what you owe, you need to know where you owe it. This concept is called Nexus. In plain English, Nexus just means a "significant connection" between your business and a state. If you have Nexus, the state says, "You're doing business here, so you must collect sales tax from our residents."
There are two main ways to establish this connection:
- Physical Nexus: This is the traditional standard. If you have an office, a warehouse, an employee working from home, or even inventory stored in an Amazon fulfillment center in a state, you likely have Physical Nexus there.
- Economic Nexus: This is the newer standard (thanks to the 2018 Wayfair ruling). Even if you have zero physical presence, if you sell enough to customers in a state (e.g., $100,000 in sales or 200 separate transactions), you trigger Economic Nexus.
Once Nexus is triggered, the clock starts ticking on your collection and filing responsibilities.
Template Details
What's Included
This isn't just a blank spreadsheet; it's a log designed to match the flow of a tax return.
- Monthly Sales Tax Summary Table: A high-level dashboard that shows your Gross Sales, Taxable Sales, and Tax Collected for each month. This allows you to spot trends or missing data at a glance.
- Taxable vs. Non-Taxable Sales Fields: Not everything you sell is taxable. Services, digital goods, or wholesale items might be exempt. This section helps you prove why you didn't collect tax on certain transactions, which is your first line of defense in an audit.
- Marketplace Facilitator Adjustments: If you sell on platforms like Amazon or Etsy, they often collect and remit tax for you. However, you still need to report the gross sales. This tracker includes a specific line to "back out" the tax Amazon already paid so you don't double-pay.
- Payment and Filing Log: A simple checklist to record when you filed the return, how much you paid, and the confirmation number. "I think I paid that" is not a valid defense; this log provides the proof.
- Jurisdiction Notes and Deadlines: States have different filing frequencies (monthly, quarterly, annually). This section lets you keep a "cheat sheet" of due dates and login credentials for each state portal.
Who It's For
- Ecommerce Businesses: Especially those selling across state lines who need to monitor Economic Nexus thresholds.
- Bookkeepers: Professionals managing multi-state filings for clients who need a standardized workpaper to reconcile the liability account.
- Small Business Owners: Anyone who wants to ensure they aren't accidentally spending their tax collections.
Outcomes
- Fewer Missed Filings: By tracking deadlines and payment confirmations, you avoid costly late fees and penalties.
- Cleaner Liability Balances: Your Balance Sheet will accurately reflect what you owe, matching your bank account reality.
- Faster Month-End Tie-Outs: When your liability account reconciles to the penny every month, year-end tax prep becomes a breeze.
Suggested Pricing
- $19-$39 as a standalone tool.
- Value Add: Ideal to bundle with an Ecommerce Starter Pack or a Monthly Bookkeeping engagement letter.
