sales tax liability report incorrect

Thanks for reaching out to the Community for support, dLearned.

I want to make sure the data on the Sales Tax Liability report is correct in QuickBooks Online. 

There are few things review and verify are correct in order to generate the data you need:

1. Verify Report Settings 

Ensure the report is running on the correct parameters to match your filing period and accounting method. 

• Check Date Range: The "To date" on your Sales Tax Liability report should match the "Show sales tax due through" date in the Pay Sales Tax (or Taxes) window.
• Confirm Accounting Method: Discrepancies often arise from mismatched cash versus accrual basis settings. Go to the report's customize options and switch the accounting method to see if the figures align with your state's required method. 

2. Audit Transactions for Errors

Incorrect item setup or transaction entry is a common cause of report discrepancies. 

• Review Taxable/Non-Taxable Sales:
  • From the Sales Tax Liability report, click on the amounts (QuickZoom) to see detailed transactions.
  • Manually review individual invoices or sales receipts. For any with zero or incorrect tax, select the See the math link to verify the product/service's tax category and ensure it is marked as taxable or non-taxable as appropriate.
  • If changes are made, save the transaction to update the report.
• Check for Incorrect Journal Entries/Payments:
  • Audit the Sales Tax Payable account register. Look for any manual journal entries, adjustments, or regular checks that were used to pay sales tax instead of the dedicated "Record Tax Payment" feature. These incorrect entries can skew the report. 

3. Record Necessary Adjustments 

If a small, unresolvable discrepancy (like a minor rounding difference or a state-approved discount/penalty) persists, you can make a sales tax adjustment. 

• Navigate to Taxes on the left menu, then the Sales Tax tab.
• Locate the tax period that needs adjustment and select View return.
• Select Add an adjustment.
• Enter the adjustment amount and select an appropriate income or expense account to track the adjustment's reason (e.g., penalties are an expense, credits/discounts an income account).
• Select Add to apply the change.

You may also want to reach out to an accountant to go over this info with you. If you don't currently have one you can find one in your area specifically trained in QuickBooks by searching her: Find a ProAdvisor.

If you need a hand or have questions about anything else please don't hesitate to reach. I'll do my best to help in any way that I can.

You haven't answered the questions, but I will attach a copy of the liability report and you can explain it to me.

Our total sales for December were $86776.75.  Non-taxable sales were $59800.00.  Taxable $26978.75.

These are the numbers that the state requires, in addition to the taxable amounts subject to surtax.

The total sales will be the Gross Total of "Florida State" (no idea where this tax name came from or why there is data here) and "State Tax".  These two do total $86776.75.

The total non-taxable is the same (Florida State plus State Tax).  None of the other values under non-taxable are relevant.

The taxable amounts are correct, as is the tax amount.

Since the state requires Total Sales, Exempt Sales and Taxable Sales values, what is Quickbooks going to use?  Why are the amounts appearing in multiple rows, and why are there extra values?

Hello there, @dLearned. I appreciate the details you provided from your Sales Tax Liability report.

The Gross Total and Non-Taxable amounts in your report are being calculated based on the transactions linked to the tax names listed on the report.

To identify the source of these figures, I recommend clicking the amounts to see what entries contribute to the totals. You can also review the item tax settings and individual transaction details to ensure sales are properly categorized as taxable or non-taxable.

Some tax names might seem unfamiliar, but they are typically tied to specific jurisdictions that require tax calculations. QuickBooks Online may automatically add these based on your location or transaction details.

To review this further, it would be best to contact our Live Support team. They can help check transactions to trace these amounts, confirm tax names, and ensure your account meets Florida’s tax rules.

Here's how:

1. Click the Help icon and select Search.
2. Provide a brief description of your concern.
3. Choose Contact Us.
4. Decide whether to request a Callback or initiate a Live Chat.

Let us know if you have additional questions. We're always here to help.