How to Set Up and Record Sales Tax in QuickBooks Online
Jul 19, 2026
Convert your bank statement to Excel now
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
Short answer: To handle sales tax in QuickBooks Online you use automated sales tax. Go to Taxes, then Sales tax, and complete the setup: confirm your business address, add every state where you hold a sales tax permit as a tax agency, and set a filing frequency. After that, QuickBooks calculates the right rate on each invoice and sales receipt based on the customer's location and what you sold, tracks what you owe by agency, and tells you when a return is due. When it is time to file, you record the payment under Taxes so the liability clears from your books.
Sales tax is money you collect on behalf of a state, not revenue. It sits as a liability until you remit it, so the goal in QuickBooks is simple: charge the correct amount, keep the collected tax in a liability bucket, and pay it to each state on schedule without touching your income numbers.
Set up automated sales tax
Open Taxes, then Sales tax, and select Use Automated Sales Tax if you have not already. Work through the setup:
- Confirm your business address. QuickBooks uses it to determine your home state rate and nexus starting point.
- Add your tax agencies. Add each state where you are registered to collect, because you only owe where you have a permit. Do not add states you are not registered in.
- Set the filing frequency. Monthly, quarterly, or annual, matching what the state assigned you when you registered.
- Assign tax categories to products and services. This lets QuickBooks apply the correct treatment, since some items are taxable, some are exempt, and some are taxed differently by state.
How QuickBooks calculates the rate
Once automated sales tax is on, you no longer pick a rate by hand. On each taxable sale QuickBooks combines the customer's shipping or service location, the product's tax category, and the current state and local rates to produce the exact combined rate, then applies any customer exemption you have flagged. This matters in states with thousands of local jurisdictions, where a single statewide rate would be wrong. To exempt a specific customer, such as a reseller or a nonprofit, mark them exempt on the customer record and keep their exemption certificate on file.
Where collected tax lands
Every dollar of sales tax you charge posts to a Sales Tax Payable liability, not to income. That keeps your profit and loss showing only your actual sales, while the balance sheet shows what you still owe the states. The table shows how a $100 sale with 8 percent tax records.
| Account | Debit | Credit |
|---|---|---|
| Bank or Accounts Receivable | $108 | |
| Sales Income | $100 | |
| Sales Tax Payable | $8 |
The $8 is never yours; it is the state's money passing through your account.
Check what you owe before filing
When a filing period ends, go to Taxes, then Sales tax, and review the Sales Tax Liability report. It breaks down, by agency, your taxable sales, nontaxable sales, and the tax collected for the period. Reconcile that figure against what you will report on the state return. If your state charges the tax on an accrual basis but you file on cash, confirm the report basis matches how you file, because a mismatch is the most common reason the QuickBooks number differs from the return.
Record the sales tax payment
Do not pay sales tax with a plain Expense or Check, because that leaves the liability on your books. Instead, in Taxes, select the agency and the period, and choose Record payment. Enter the payment date, the bank account, and the amount, and adjust for any discount or penalty the state applied. QuickBooks then reduces Sales Tax Payable by what you paid and records the cash leaving your bank, so the liability and the bank both move correctly. When the payment shows up in your bank feed, match it to that recorded payment rather than adding a new transaction.
Common sales tax mistakes to avoid
- Treating collected tax as income. It is a liability; if it lands in a revenue account your profit is overstated and you may pay income tax on money that belongs to the state.
- Adding agencies you are not registered in. You only collect and remit where you have nexus and a permit.
- Paying with an expense instead of Record payment. That understates the liability and leaves a permanent balance in Sales Tax Payable.
- Ignoring economic nexus. After the 2018 Wayfair decision, sales into a state can create a filing obligation once you cross that state's sales or transaction threshold, even with no physical presence.
Kept clean, sales tax in QuickBooks runs almost on its own: automated rates on every sale, a liability that grows as you collect and shrinks as you pay, and a liability report that ties to each return. When you close the books each month, turning the reconciled figures into clean financial statements gives you and your accountant a clear read on the business with the tax liability shown where it belongs. If your bank data arrives as PDFs, converting the statement to Excel first, then importing through a QuickBooks bank statement converter, keeps every taxed sale and every remittance matched to the bank.
Ready to convert your bank statement?
Upload a PDF and get clean Excel or CSV in seconds. Works with statements from any bank.
Convert to Excel nowFree to try, no credit card required