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
Do I need a bookkeeper who understands the restaurant industry?
Technically no, but you'll get more value from one who does. Restaurant bookkeeping involves tip compliance, food cost tracking, and labor analysis that generic bookkeeping often misses.
Read answerWhy is my e-commerce profit and loss statement inaccurate?
E-commerce P&Ls are often wrong because of inventory costing problems, miscategorized marketplace fees, or timing issues with returns. The most common culprit is Cost of Goods Sold that doesn't reflect actual product costs including landed costs like shipping and duties.
Read answerWhy don't my Amazon deposits match my sales reports?
Amazon deposits are net amounts after fees, refunds, advertising costs, and reserves are deducted. The number hitting your bank is what remains after Amazon takes its cut, not your gross sales.
Read answerWhat bookkeeping tasks should be done weekly vs monthly?
Weekly tasks focus on keeping transactions current and catching issues early. Monthly tasks involve full reconciliations, financial statement review, and closing out the period properly.
Read answerHow do I track sales by department or product category?
Set up classes or product categories in your accounting software and assign them consistently to every sale. This gives you profit and loss reports broken down by department so you can see what's actually making money.
Read answerWhat's the retail inventory method and should I use it?
The retail inventory method estimates ending inventory using the ratio between cost and retail prices. It works for stores with consistent markups but has largely been replaced by modern POS systems that track inventory in real time.
Read answer