Sales Tax Liability Report in QuickBooks Online | Review Sales Tax Report

The Sales Tax Liability Report in QuickBooks Online is a built-in report that provides insights into the tax collected by a business over a specific period and the amount owed to tax authorities. It also includes important details such as tax agencies, tax rate breakdowns, tax calculations, and both taxable and non-taxable sales.

In this detailed guide, we will explore the report, its key components, and why businesses should use it for better financial management and compliance. This report also helps businesses ensure accurate tax tracking, avoid penalties, and simplify the tax filing process.

What is the Sales Tax Liability Report in QuickBooks Online? 

The sales tax liability report in QuickBooks Online is a crucial financial document that demonstrates the total tax collected by a business and, consequently, how much you owe to tax agencies over a specific period of time.

Using the report, you can easily monitor taxable/non-taxable sales, ensure compliance, and aid in accurate tax filing to avoid penalties.

This report typically breaks down:

• Taxable sales – sales on which tax was applied
• Non-taxable sales – sales that weren’t taxed
• Sales tax collected – total tax you charged customers
• Tax owed (liability) – the amount you need to pay to the government

Learn How Sales Tax is Calculated in QuickBooks. 

Sales tax in QuickBooks Online is calculated automatically using built-in tax rules based on your business location, customer address, and the taxability of items. When you create an invoice or sales receipt, the system applies the correct tax rate only to taxable products or services and adds it to the total amount. It can also handle multiple tax components, such as GST splits, and updates your reports in real time, helping you accurately track how much tax you’ve collected and owe to authorities.

Here’s What the Sales Tax Liability Report Shows You

To learn how sales tax is computed, choose See the math on an invoice or sales receipt.

You’ll find:

• Whether you’re applying automatic sales tax calculation or custom rates.
• The rate and breakdown for the taxable location at the state, county, and city levels.
• If an item isn’t categorised, the default rate is used. By organising your products and services, you’ll make sure you’re charging and collecting the correct sales tax amount.

Note: All images display sales tax calculations for Texas only.

The sales tax liability provides a summary of the sales tax breakdown for all transactions in Texas within the reporting period.

1. Tax name (column 1): Tax details are divided into state, city, and county. Each level has its own tax name. At the state level, there may be extra layers visible by selecting See the math from your transaction.
2. Gross total (column 2): The total net amount (excluding sales tax) of all sales, both taxable and non-taxable. Invoices and sales receipts increase the gross total, while credit memos and refund receipts decrease it. Your state may label this as total sales or total gross receipts.
3. Non-taxable amount (column 3): Transactions may be classified as non-taxable in the following ways:
   • Sale made to an exempt customer.
   • Tax is not chosen on the sales form.
   • The product or service on the sales form is set as non-taxable.
   • The product/service on the sales form is assigned to a category that is fully or partially non-taxable. 

Note: A sales form may include both taxable and non-taxable lines. Transactions that aren’t sales forms, such as bank deposits and journal entries, are not included in the sales tax liability report.

4. Taxable amount (column 4): The net value for taxable transactions is shown in this column.
5. Tax amount (column 5): The sales tax applied to taxable sales, which also represents the total amount owed.
6. State tax (first row): Totals include all sales within the state, including county and city amounts.
   • The total gross sales amount for all transactions within the state. 
   • The total amount of non-taxable sales for all transactions in the state.
   • The total amount of taxable sales for all transactions that occurred in the state.
   • The sales tax is charged at the state level on the total taxable sales.

• In this example, the amount is 6.25% of the taxable amount. County or city taxes are not included in this figure. In some cases, multiple rates may apply to the state, such as when a special food rate applies to certain sales.

7. County tax: totals are included in the state amounts since sales occur within the state.
   • The total gross sales for all transactions in this county. Sales across multiple counties will list each county separately.
   • The total amount of non-taxable sales for all transactions in this county.
   • The total net value of taxable sales for all transactions in this county.
   • The sales tax is charged at the county level for the total taxable sales. State or city taxes are not included in this amount. For example, in McLennan County, this is 0.5% of the taxable amount (column 7c). Similar to the state level, more than one tax rate may apply at the county level.

8. City tax: totals are also included within the state and county amounts.
   • The total gross sales for all transactions in this city. Sales across multiple cities will display each city separately in this report.
   • The total amount of non-taxable sales for all transactions in this city.
   • The total net value of taxable sales for all transactions in this city.
   • The sales tax is charged at the city level for the total taxable sales. In this example, the amount is 1.5% of the taxable value. This represents the city tax for Waco City, as shown in the “See the math” panel. State or county taxes are not included in this figure. Similar to the county and state levels, more than one rate may apply at this level.

The Gross total, Non-taxable, and Taxable amount columns can’t be summed to get a final total because, in this example, there are three levels (state, city, and county). The transaction is fully taxable at each level, so for a single transaction, the net sale value is counted three times.

For the Tax Amount column, you can add all the values to calculate the total tax owed to the State Comptroller. This is because each value in the tax amount column appears only once. In this example, it includes the state tax (6.25%), the county tax (0.5% in McLennan County, though it may differ by county), and the city rate (1.5% in Waco City, though it may vary by city).

Conclusion

Get a detailed overview of how much of the total sales tax was collected from customers on behalf of tax authorities over a specific period. Following the above steps, you will understand what the sales tax liability report in QuickBooks Online is, what it demonstrates, and the total amount of tax you owe to customers.

If you face any challenges understanding the detailed report or need further assistance, you must contact the QuickBooks ProAdvisor available at 866-500-0076. Connect with a certified ProAdvisor and enjoy assistance now!

Frequently Asked Questions

1. Where can I find the sales tax liability report in QuickBooks?

The Sales Tax Liability Report in QuickBooks Online displays the total sales, taxable sales, and tax amounts owed to specific tax agencies, helping you monitor tax obligations. Access it by navigating to the Reports center and searching for “Sales Tax Liability Report.”

2. What is a sales tax liability report?

A sales tax liability report is a financial document summarizing the total sales tax a business has collected from customers on behalf of tax authorities over a specific period, detailing taxable/non-taxable sales and the amount owed. It is used to calculate accurately how much money must be remitted to government entities. 

3. How to pull tax reports from QuickBooks?

To pull tax reports in QuickBooks Online, navigate to the Taxes or Sales Tax menu, select your agency, and choose “View report” to see the Sales Tax Liability report.

In QuickBooks Desktop, go to Reports, select Vendors & Payables, and choose Sales Tax Liability or Sales Tax Revenue Summary.

4. What is the difference between a QBB and QBW file?

A QBW file is the primary, active QuickBooks working file used for daily accounting tasks, while a QBB file is a compressed backup file used for data restoration and protection. QBW holds live transactional data, whereas QBB includes this data plus templates, letters, and logos for security.

5. How to get a sales report from QuickBooks Online?

To get a sales report in QuickBooks Online, go to the Reports menu, search for “Sales,” and select reports like “Sales by Customer Summary” or “Sales by Product/Service.” Customize the date range and filters, then click “Run report” to generate the data.