Troubleshooting Sales Tax in QuickBooks Online

Understanding Sales Tax in QuickBooks Online

Sales tax management is one of the most challenging aspects of running a business. Even small errors can lead to compliance issues, filing inaccuracies, and costly penalties. The complexity increases when your business operates in multiple states, where sales tax laws, and reporting requirements can vary significantly.

To stay compliant, it’s important to set up sales tax correctly in QuickBooks Online (QBO) from the beginning. Accurate setup helps ensure you:

Collect the correct amount of sales tax
Report taxable sales property
File and pay sales property
Reduce the risk of audits and penalties

Because tax rates and regulations change regularly, businesses should periodically review their sales tax settings in QBO. Better yet, schedule a sales tax wellness checkup with your CPA at Mahoney to confirm everything is worked as intended.

Is QuickBooks Online Calculating Sales Tax Correctly?

If you’re questioning whether QBO is applying sales tax correctly, start by reviewing these three key areas:

1. Verify Your Customer's Tax-Exempt Status

One of the most common reasons sales tax doesn’t calculate on an invoice is that the customer has been designated as tax-exempt.

Run a report to Identify Taxable and Non-Taxable Customers

Go to Reports
Select Customer Contact List from the Sales and Customers section
Click Customize
Select Change Columns
Check the Taxable box
Click Run Report

Note:

Taxable customers display “Yes” in the Taxable column.
Non-taxable customers will have a blank field.

How to Correct a Customer’s Tax Status

If a customer’s tax setting is incorrect:

Go to Sales > Customers
Select the customer
Click Edit
Navigate to Tax Info
Confirm that “This customer is tax-exempt” is not checked (unless appropriate)
Save the changes

2. Verify Your Customer's Tax-Exempt Status

Sales tax obligations often depend on where products or services are delivered. While QBO generally calculates tax based on your business location, many transactions require tax calculations based on the customer’s location.

Create a Sales Tax Agency for a New Tax Jurisdiction

Go to Taxes > Sales Tax
Select Sales Tax Settings
Click Add Agency
Choose the applicable state or local tax jurisdiction
Select the filing frequency
Enter the start date for tracking sales tax in that location
Click Save

Update the Customer Location on an Invoice

When creating an invoice:

Click +New
Select Invoice
Choose the customer
Enter invoice details
Click See the Math
select the Pencil icon next to the tax information
Enter the customer’s location
Click Close

Why This Matters

Sales tax rates can vary significantly by state, county, city, and even ZIP code. Ensuring the correct taxable location is entered helps QBO apply the appropriate tax rates.

3. Confirm Products and Services Are Marked Taxable

Sales tax may not calculate properly if the product or service assigned to the invoice is designated as non-taxable.

Run a Product and Service Taxability Report

Go to Reports
Select Product/Service List
Click Customize
Select Change Columns
Check the Taxable box
Click Run Report

Note:

Taxable items display “Yes” in the Taxable column.
Non-taxable items will show blank.

Update a Product or Service Tax Setting

If an item’s tax status is incorrect:

Go to Sales > Products & Services
Locate the product or service
Select Edit
Click Edit Sales Tax
Under Other Options, choose:
- Taxable – Based on Location Only, or
- Taxable

Best Practice

For most taxable products and services, choose “Taxable – Based on Location only.” This allows QuickBooks Online’s Automated Sales Tax (ATS) system to apply current tax rates based on the transaction location.

Sales Tax Best Practices in QuickBooks Online

Review the Tax Calculation Before Finalizing an Invoice

Before saving or sending an invoice, click the blue “See the Math” link in the lower-right corner of the transaction window.

Verify the following:

✅ The customer is not marked-tax exempt (unless appropriate)

✅ The taxable location is correct

✅ Tax rates are being applied properly

✅ All taxable products and services are calculated as expected

This simple review can prevent many common sales tax errors.

Review Sales Tax Reports Before Filing

Before submitting a sales tax return, run and review the following reports:

Sales Tax Liability Report
Taxable Sales Summary Report
Taxable Sales Detail Report

Location: Reports > Sales Tax

Important Tip: Always confirm that the report date range matches the filing period you’re preparing.

Verify Taxability and Rates with Your State

QuickBooks calculates sales tax based on information entered into the system, but it cannot determine whether your products are legally taxable in every jurisdiction.

Business owners should:

Verify taxable products and service with their state tax authority
Confirm appropriate sales tax rates
Review rate changes periodically
Check destination-based sales tax rules when selling across state lines

For Minnesota businesses, use the Minnesota Department of Revenue’s Sales Tax Rate Calculator to verify applicable tax rates before filing.

Important: It is ultimately the responsibility of the business owner to determine whether sales are taxable and to ensure sales tax is collected and remitted correctly.

Schedule a Sales Tax Checkup with Mahoney

If you’re unsure whether QuickBooks Online is calculating sales tax correctly, a sales tax checkup can identify issues before they become filing problems. A proactive review today can help prevent costly penalties and compliance issues tomorrow.

Contact Peggy Prall

📞 651-281-1865
📧 pprall@mahoneycpa.com

Next: QuickBooks Tips