P&L Sales Deposit Variance

Hello there, Mariann.

It's possible that there were edited transactions and the total amount didn't recalculate the changes. Just ensure that the total amount is correct before saving them. To have an up-to-date release of updates and system fixes, you can download the latest version of QuickBooks Desktop.

Then, we can run the Verify and Rebuild Utility tool to make sure that there are no data issues that can possibly cause the discrepancy of your transactions and reports. After doing these processes, I'd just closing and reopening QuickBooks to refresh.

If the same thing happens, I'd suggest looking into each transaction and review the amounts. If the total amount doesn't match, just click the Recalculate option from the menu.

Keep me posted on how this works. I'm just around the corner to help. Stay safe!

The amounts aren't edited I've doubled checked all of them there correct.  It seems like the tax is calculating slightly differently in QB even though the same amounts and tax is used in QB and our sales report.

I ran the utility tool and no data errors.

Thanks

Thank you for getting back to us and sharing the result after running the utility tool, @MP11.

Another possible reason you're seeing a slightly different amount on sales reports is due to the automatic rounding off decimals in QuickBooks. Please know that when the cents of a transaction exceed three or more decimal points, QuickBooks will automatically round it off into two decimal places as designed.

In this case, if there are a few more pennies collected, you can process a sales tax adjustment to make sure you keep an accurate record of these taxes. For more guidance, feel free to read this article: Process sales tax adjustment.

Please let me know if you need clarification about this, or there's anything else I can do for you. I'll be standing by for your response. Have a great day.

The sales tax adjustment I need is for customer invoices not a vendor invoice. I took snip it of how I think it would be set up to adjust the customer sales tax using the process you provided. Can you let me know if I'm on the right track?

Thank you

Mariann

Appreciate the screenshot, @MP11.

You're on the right track in recording a sales tax adjustment. The Sales Tax Vendor drop-down is where you choose the agency to which the adjustment applies.

The details are discussed in this article, under the "Adjust the sales tax amount you owe" section: Process sales tax adjustment.

As always, feel free to browse this link here if you need help with other tasks in QBDT. It contains topics with articles that'll help you along the way.

Keep me posted if you still follow up questions about sales tax. I'll be around for you. Take care and have a great day ahead.