QBO Sales Tax Liability Report total does NOT match other reports

Hi there, @CBPP.

Let me help and provide information about the Sales Tax Liability report that does not match your other reports in QuickBooks Online (QBO).

If your Sales Tax Liability report shows total sales that are different from the total income, you'll want to be aware that total sales and income won't always match because there are transactions that can appear in a data file which makes it unlikely for your Sales Tax Liability and Sales by Product/Service Summary reports to match.

To match your Sales Tax Liability report and Sales by Product/Service Summary, you have to click the total amount of sales by product/service summary and filter or tick the box of Taxable Amount and Tax Amount.

Here's how:

1. Go to Sales by Product/Service Summary report.
2. Click the TOTAL AMOUNT.
3. Filter the Report Period, and click the small Gear Icon beside the Export.
4. Click Show More.
5. Tick the box of Taxable, Taxable Amount, and Tax Amount.
6. Select Customize.
7. Click Run report.

I'll also add this article to guide you in customizing your reports to show specific accounts or customers, or format the layout so the right data shows up in the right place: Customize reports in QuickBooks Online.

Please feel free to drop a comment below, if you have further concerns about matching your reports or other QBO-related concerns. I will answer them in any possible way.

Hello Clark,

Thank you very much for your answer to my question. Unfortunately, that did not seem to answer my question or change the report. It changed what information was shown on the report, yes, but ultimately, the TOTAL amount is still the same and NOT matching the Liability report.
I am not sure why total sales wouldn't match on various reports. Sales within a specific time period should all total to the same amount no matter which report is being ran, correct? Please find the attached screenshot that I have appropriate items ticked as you instructed, and attached PDF showing the full report.
Any additional guidance is truly appreciated. Thank you!!!

Jourdan

(Attached PDF was removed because it includes PII)

Hello, @CBPP. I appreciate the efforts you've made. I'm here to share additional information about your issue.

Sales Tax Liability report summarizes your taxable and non-taxable sales and the total sales tax you collected from customers. The Sales by Customer Summary Detail report lets you see the total sales made for the specific period.

The reason why Sales Tax Liability Report and Sales by Product and Services Report are different due to various reasons like the following:

• The report has a separate report basis. Businesses that use an accrual basis often pay sales tax on a cash basis. 
• Reports have different date ranges. 
• Finance and statements charges will not appear on the Sales Tax Liability report. 
• Reimbursed expenses may or may not appear on these reports, depending on how they've been set up.

When you pass on expenses to a customer during a sales transaction, you don't need to use a sales item. However, reimbursed expenses won't appear in standard sales reports that are filtered for all sales items. These transactions are usually taxable, so their amount should be included in the sales figures for the Sales Tax Liability report.

Also, you can check this article if you want to remember its current customization settings: Memorize reports in QuickBooks Online.

Don't hesitate to get back to us if you have further questions about reports in QBO. We're always available to assist you.