How do I track sales tax liability in my books?
Sales tax you collect from customers isn’t your money. You’re holding it temporarily for the state or city until filing time. Your books need to reflect this by tracking collected tax in a liability account, not as revenue.
Set up a liability account specifically for sales tax. In QuickBooks or Xero, this usually happens automatically when you configure sales tax settings. The account might be called “Sales Tax Payable” or “Arizona TPT Payable.” Every time you make a taxable sale, the tax portion posts to this liability account while the pre-tax amount goes to revenue.
When you sell a $100 item with 8% tax, you record $100 in revenue and $8 in the sales tax liability account. The customer paid you $108, but only $100 is actually yours. The $8 sits in the liability account until you pay it to the state.
Arizona’s Transaction Privilege Tax adds complexity because rates vary by city. Scottsdale, Phoenix, Tempe, and Mesa all have different combined rates. If you’re selling in multiple jurisdictions or have customers throughout the Valley, you need to track tax collected by location so you can file accurately. Your accounting software should allow multiple tax rates with separate tracking for each.
Reconcile your sales tax liability account monthly, not just when you file. Compare the balance in your liability account to what you actually owe based on your sales reports. If there’s a discrepancy, something is recorded wrong. Common problems include transactions coded as non-taxable that should have been taxable, refunds not properly reducing the liability, or manual journal entries that threw off the balance.
When you file and pay your TPT return, record a payment from your checking account to the sales tax liability account. This should zero out the liability for that period. If there’s a remaining balance after filing, investigate it. Small differences might be rounding, but larger discrepancies indicate a tracking problem that will compound over time.
For businesses with high transaction volume or sales across multiple Arizona cities, sales tax management can get complicated quickly. E-commerce businesses selling nationwide face even more complexity with varying state requirements and economic nexus thresholds.
The key habit is treating sales tax tracking as part of your regular bookkeeping routine rather than something you figure out at filing time. Monthly reconciliation catches errors early when they’re easy to fix. Waiting until year-end to sort out sales tax discrepancies means digging through hundreds of transactions trying to find where things went wrong.
If your current setup isn’t tracking sales tax properly or you inherited messy books where the liability account doesn’t match reality, getting professional help makes sense. Scottsdale bookkeeping services that understand Arizona’s TPT system can configure your software correctly and establish tracking processes that keep you compliant without the monthly headache.
Full-Service Bookkeeping for Greater Phoenix
The Next Step:
A Quick Conversation
Tell us about your situation. We'll listen, ask a few questions, and give you a clear price to handle the work.
More Questions
How do I prepare my Amazon seller books for tax season?
Start by reconciling your Amazon settlement reports to your bank deposits, then calculate your cost of goods sold using inventory records. Gather your 1099-K and make sure it matches your recorded revenue before handing everything to your accountant.
Read answerWhy doesn't my bank account match my QuickBooks balance?
The difference usually comes from timing issues like uncleared checks, duplicate entries from bank feeds, missing transactions, or an incorrect starting balance. Running a proper reconciliation will help you find where things went wrong.
Read answerWhy is my COGS wrong on my e-commerce profit and loss?
COGS errors in e-commerce usually come from how inventory is tracked. If purchases go straight to COGS instead of through an inventory account, or if your ending inventory balance is wrong, your cost of goods sold won't match reality.
Read answerHow do I track inventory for my online store?
Connect your sales platforms to accounting software, track cost of goods sold accurately, and reconcile physical counts regularly. The challenge isn't the tracking itself but getting all systems to sync reliably.
Read answerWhat's the best accounting software for small business?
QuickBooks Online is the standard for most small businesses. It integrates with banks, apps, and payment processors, and accountants know it well. But the software matters less than how it's configured for your specific needs.
Read answerCan a bookkeeper fix years of disorganized finances?
Yes, a skilled bookkeeper can clean up years of messy books. The process involves reconstructing transactions from bank records, reconciling accounts, and properly categorizing expenses to create accurate financial statements.
Read answer