One of the biggest mistakes I see in QuickBooks is when business owners file their California sales tax returns but never reconcile the Sales Tax Payable account afterward.
A few months later, they open QuickBooks and ask:
"Why does QuickBooks show that I owe $8,000 in sales tax when I've already paid it?"
In most cases, the issue is that the sales tax payment was not recorded correctly, or the Sales Tax Payable account was never reviewed after filing.
Reconciling sales tax means verifying that:
The sales tax collected from customers is accurate.
The sales tax liability recorded in QuickBooks is accurate.
Payments made to the California Department of Tax and Fee Administration (CDTFA) were recorded properly.
The remaining balance matches what you actually owe.
Think of it like reconciling a bank account. The goal is to make sure your QuickBooks records match reality.
In QuickBooks, navigate to:
Taxes → Sales Tax → View Reports → Sales Tax Liability Report
Review the following:
Taxable sales
Nontaxable sales
Sales tax collected
Sales tax owed
This report should generally agree with the amounts reported on your CDTFA sales tax return.
Go to:
Chart of Accounts → Sales Tax Payable → Run Report
Review the account for:
Sales tax collected
Prior payments
Adjustments
Unusual transactions
Duplicate payments
Journal entries you don't recognize
Large outstanding balances from prior periods
Negative balances
These issues often indicate errors that need to be corrected.
Pull up the sales tax return that was filed with the CDTFA and compare the amounts.
QuickBooks
Tax Due: $1,450
CDTFA Return
Tax Due: $1,450
If the numbers match, you're off to a good start.
If they don't match:
Review individual transactions
Verify your sales tax settings
Confirm that taxable sales were categorized correctly
This is where many problems occur.
Let's say you made a CDTFA payment of:
$1,450
That payment should reduce the Sales Tax Payable liability account.
Many business owners accidentally record the payment to:
Taxes Expense
Miscellaneous Expense
Sales Tax Expense
instead of applying it against the Sales Tax Payable account.
When that happens, QuickBooks continues showing the tax as unpaid even though the money has already left the bank account.
Open your bank register and verify:
Payee: CDTFA
Amount: $1,450
Date: Correct
Then confirm that the transaction appears in your bank reconciliation.
If the bank account shows the payment but the Sales Tax Payable balance was not reduced, the transaction may have been coded incorrectly.
One of my favorite cleanup techniques is reviewing old sales tax balances.
Ask yourself:
Why is there still a balance from 2023?
Why is there a payment that never cleared?
Why is there a credit sitting in the account?
These older transactions often uncover:
Duplicate entries
Missed filings
Incorrect coding
Prior bookkeeping errors
Let's say you're an electrician in Pico Rivera.
Your quarterly sales tax return showed:
Sales Tax Due: $2,125
You paid the CDTFA:
$2,125
After the payment, your Sales Tax Payable account should look like this:
Sales Tax Payable
Beginning Balance: $2,125
Less Payment: $2,125
Ending Balance: $0
If QuickBooks still shows that you owe $2,125, something was likely recorded incorrectly and should be investigated.
Watch for these warning signs:
✅ Sales Tax Payable keeps growing even after payments are made
✅ Negative sales tax balances
✅ Sales tax payments recorded as expenses
✅ QuickBooks balances don't match CDTFA returns
✅ Old balances from prior years
✅ Unexplained adjustments
These are strong indicators that a sales tax reconciliation is needed.
For most businesses, I recommend the following schedule:
Review:
Sales Tax Liability Report
Sales Tax Payable Account
Taxable sales activity
Reconcile all sales tax balances
Verify the amount due on the return
Confirm all taxable sales are included
Review any adjustments
Performing these reviews regularly can significantly reduce year-end cleanup and help prevent costly mistakes.
This process is especially important for:
Plumbers
Electricians
HVAC contractors
Landscapers
General contractors
Auto detailers
Barbers who sell retail products
Salons that sell products
Photographers who sell prints or albums
E-commerce businesses
Retail stores
Any California business that sells taxable goods or taxable services
Sales tax reconciliation isn't complicated, but it's one of the most overlooked bookkeeping tasks in QuickBooks.
A properly reconciled sales tax account means:
Your CDTFA returns are easier to file.
Your liabilities are accurate.
Your books are cleaner.
You avoid unpleasant surprises.
The goal is simple:
The sales tax balance in QuickBooks should closely match what you actually owe CDTFA.
If it doesn't, it's time to investigate before the problem grows.
Disclaimer: This article is for informational purposes only and is not accounting, tax, financial, or legal advice.