Bookkeeping, payroll, and controller services for small businesses in Scottsdale and Greater Phoenix.

Call or Text: (623) 439-9961

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 answer

Why 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 answer

Why 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 answer

How 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 answer

What'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 answer

Can 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

Scottsdale bookkeeping firm serving small businesses across Greater Phoenix. Full-service bookkeeping, payroll, and outsourced controller services backed by over a decade of hands-on accounting experience.

Client Reviews

5-Star Rated Firm

Social

© 2026 LedgeTrakr Bookkeeping