Thanks for elaborating on your concern, @dLearned I understand what you're going through under the sales tax liability report. 

I can get you the right support that has the resources to check your account and sales tax setup in a secure environment. You'll want to reach out to our Customer Support Team. They'll surely sort things out with you and give you direct and detailed steps on how to fix the issue you're currently experiencing. 

Here's how to contact us:

1. Go to the Help menu ( ? ) and click Contact us.
2. Enter a brief description of your concern something about your sales tax setup and returns.
3. Click Let's talk and choose the best way you can get in touch with us based on our availability.

You can also check out this article that lists all our support hours and types. 

I'll be attaching an article that will help you manage your sales tax setup while waiting to get connected with our Phone Support.  

I appreciate your patience while we are looking for remedies for your sales taxes. Please know that we are here to support your growing industry.

I am also having issues with sales tax liability reports. Over the last year my total sales on the sales tax liability report is no longer correct.I did not realize this until recently. It only shows sales that are marked taxable somewhere in the invoice. It does not report the true total sales numbers. Why? What setting could have changed?

I completely understand how crucial it is to have accurate sales tax data, especially when it comes to reporting, Steelrose22.

Let me make it up to you by making sure you get a detailed explanation of why this issue occurs.

I recommend contacting our QuickBooks Support Team. They have full access to your account and can review the sales taxes added to your invoices. They can also determine its cause to ensure it won't happen again.

Here's how to contact our support:

1. Go to the Help (?) icon at the top.
2. On the Assistant tab, click Talk to a human.
3. Enter the issue in the Type something field, then click the Send icon.
4. Click on I still need a human.
5. Select Get help from a human.
6. You can either select Chat with us or Have us call you.
   

I appreciate your patience as we work through this. If you have any other concerns or questions about managing your sales taxes and  transactions, please don't hesitate to add a comment below. I'll be glad to help you out.

Can someone explain to me about the Multiple tax line?  On the sales tax liab report, and it has a negative number.  I think I understand it but I want an official meaning if I could.  Thank you!

KT

Hello, Ktbarthedoor. 

Let me explain what the Multiple tax line means and what causes the negative number on your sales tax liability report. 

In QuickBooks Online, the term "Multiple tax line" refers to a feature that allows you to apply different tax rates to individual line items on a sales transaction. This feature is useful when you have products or services subject to different tax rates within the transaction.
 

For example, let's say you have an invoice with two line items: Item A and Item B. Item A is subject to a 5% tax rate, while Item B is subject to a 10% tax rate. By using the multiple tax line feature, you can assign the appropriate tax rate to each line item, and QuickBooks Online will calculate the tax amount accordingly and ensure that your sales transactions comply with the applicable tax laws and regulations.

Now, regarding the negative number on your sales tax liability report, there are a few possible causes: 

1. Returns or credits: If you issue refunds or credit memos to your customers for returned items or overpayments, these negative amounts can offset the positive sales amounts, resulting in a negative sales tax liability.
2. Discounts: If you offer discounts to your customers that are applied to the total invoice amount, this can reduce the taxable sales and result in a negative sales tax liability.
3. Tax agency adjustments: In some cases, adjustments made by the tax agency or corrections to previous tax filings can result in negative amounts on your sales tax liability report.

It's important to review the details of your sales tax liability report to understand the specific transactions or adjustments that are causing the negative amount. If you're unsure about the particular entries, consult an accountant or bookkeeper who can review your QuickBooks Online data and provide guidance on addressing any discrepancies.
 

For additional tips while handling your sales taxes and liability reports, you can check out these articles:

• Check how much sales tax you owe in QuickBooks Online
• Set up your sales tax in QuickBooks Online

On the other hand, you may review the topics from this link for more resources while working with your sales and other customer transactions in the future: Topics about your company's income and customers. 

Just leave a comment below if you have other questions or concerns with QuickBooks and sales tax liabilities. I got your back! Stay safe always, and have a great day!

Thank you for the quick response but this is quickbooks desktop enterprise not sure if that matters.  I have reviewed all of the invoices that are showing up in the negative line.  The only thing I can determine is we are using QB Grouping which part of what QB offers for Sales Tax.  Some of the items are taxed at one rate for city tax and then another rate for county tax.  Do you think QB is deducting back out invoice amount of one of those lines since it does include both lines in the report?  

Example:

Mayes County 4988 Taxable Sales 1000.00 Tax Rate $137.50

Pryor City 4909 Taxable Sales 1000.00 Tax Rate $400.00

Ok State Taxable Sales 1000.00 Tax Rate $450.00

Total Sales for the month is $1000.00

So is it putting in a negative in the multiple tax line so that your total is $1000.00 not $3000?

Thank you!

Katie

Hey there, @Ktbarthedoor. 

Thanks for joining in on this thread. 

The negative will show on the sales tax liability once you make an overpayment in QuickBooks. You can view all the transactions to check if you made an overpayment. If there is, you'll need to clear the negative amount in the sales tax payable by adjusting the sales tax liability.

If the set up is causing you to have negative items, you may need to double check that it's set up correctly and that you aren't somehow doing a double charge.

I hope this helps. If you have any further questions, just let me know. I'm only a post away! 

So are you referring to the setup of the sales tax group below?  There is not an overpayment so I don't think that is the issue.  I just can't find anywhere in QB Desktop that explains the report itself.  When you are invoicing you would pick the Group Name: Pryor, Mayes, OK-GRP.  Then on the report it will have them listed separate. That is what is nice about the report in QBD it gives you the totals as compared to QBO.  But if your total is $1000 in net sales and as per my example above and you have $1000 in each line does QBD just know that the total is $1000 in total sales or does it have $1000 on each line then a Negative $2000 on the multiple tax line (subtracting the duplicate taxable amounts) which gives you your actual total of $1000.00 for the month....  

Hi there, Ktbarthedoor.

I'd be happy to provide clarification about the negative multiple tax line on the Sales Tax Liability report.

Yes, you're right. QuickBooks deducts the amount in the multiple tax line to offset and correct the total sales amount. It puts a negative in the multiple tax line, so the total amounts to $1000 and not $3000.

If you need additional information on reviewing sales tax reports, please refer to this article: Review sales tax reports.

You might find this article handy when paying sales tax: Pay sales tax.

Please let me know in the comments below if you have additional questions about sales tax or anything related to QuickBooks. I'm just around to help you.

Our QB online report seems to be grouping nontaxable sales with tax exempt sales. Is there a way to separate them? Colorado requires them to be reported on separate lines in the sales tax report. Putting them all under nontaxable sales when that normally only accounts for approx 1% of these sales. How can I get QB to report these items separately? QB desktop had that capability.

Thank you for joining this thread, dbmom.

The option to separate the nontaxable and tax-exempt is not available in QuickBooks Online. What we can do is export the nontaxable report to an Excel file to add columns for your item. Let me help you on how to do it.

First, let's run a report for Nontaxable, here's how:

1. Go to Report.
2. In the search field, enter the Taxable Sales Detail.
3. Click Customize.
4. Choose the date range in the General drop-down.
5. On the Filter ▼ dropdown, select the checkbox:

• Customer Taxable, to list all customers with non-taxable sales.

6. Select Run report.

Next, we can now export the report.

1. In the Taxable Sales Detail Report, click the Export logo beside the small Print logo.
2. Select Export to Excel.

If you have additional concerns regarding your nontaxable sales in QuickBooks Online, please don't hesitate to post them here in the Community space.

This is a major problem. It is beyond naive to assume that tax exempt sales, which are very closely monitored by the taxing authorities, are the same as no tax sales. Expecting you users to dive down into the bowels of a report because Intuit made a very bad decision is beyond insulting. You need to fix this before you lose more customers than I suspect you already have.

I would NOT place sales tax in the hands of Intuit. What is wrong with using Avatax? 

Hi Coast2 - Did you find a resolution to this? I just switched to online last month and sales tax is due TODAY! 

Agree 100%. Never an issue with QB desktop, QBO - no way to get an accurate sales tax report. Does seem to have gotten worse after an update. Tried 3 times to talk with support, absolutely no clue. Have any of the developers ever done a sales tax report? And you want to raise prices?

Hello @Coast2 , I am an accounting professional who is a Certified QBO ProAdvisor and is based in CA with clients in CA and other states. I came across your problem in the QBO community when I was searching to see if anyone else was having issues with the built-in sales tax system miscalculating the total tax for items for the 6% state rate for Florida where my client is located (similar to CA, Florida has county surtax rates that QBO also tracks and calculates which show as sub-lines on the Sales Tax Liability report proper filing of the return and payment on Florida's DOR website). Your issue came up because a commenter mentioned Florida.

What I am writing to you about has nothing to do with your missing column problem ... I happened to notice on your screenshot of your sales tax liability report you provided to the QBO employee, that it is a Cash Basis report. CDTFA regulation is that sales tax liability in CA is required to be remitted on a accrual basis, regardless if your business is cash-based for income tax purposes. (https://www.cdtfa.ca.gov/lawguides/vol2/suta/130-0005.html)

Based on direct experience with my clients in CA, I strongly recommend you start filing your tax returns using an accrual basis sales tax liability report from QBO, because CA routinely audits businesses who have Sales & Use Tax accounts, and the aftermath of an audit on your account is a time-sucking headache for the business owners (I have a CA client who made online purchases for her business but some retailers were not charging tax on the sales--CDTFA caught this and assessed a ridiculous amount owed with penalties and fees based a blind estimate of total purchases she made in a calendar year (multi years) - she had to produce all the receipts for her online purchases to prove she was charged sales taxes on most of her online purchases).

Hope this helps! Just wanted to offer some sage advice from one business own to another! Have a nice day!