Sales Tax Revenue Summary Report

You'll have to check your invoice to see if there are discounts or non-taxable items, @benz. Below, I'll provide more details to resolve the different amounts in the report.

To start, I suggest reviewing your invoice for non-taxable items or discounts applied that might explain the discrepancy in the reported amount. Also, verifying any adjustments made will help ensure the accuracy of the amount in your wholesale column.

If it's the same thing, we can use the verify and rebuild tools in QuickBooks Desktop (QBDT). These tools help address data issues in your company file that might be causing unexpected behavior, such as amount discrepancy in the report. The verify tool identifies common problems in your company file, while the rebuild tool works to fix them. Here's how:

1. Go to Window, then select Close All.
2. Go to File, then choose Utilities.
3. Select Verify Data.
4. Tap OK to continue.

To rebuild the data in your company file, please follow the steps provided below:

1. Go to File, then select Utilities.
2. Click on Rebuild Data.
3. Follow the on-screen instructions, then press OK.
4. Select the place where you want your backup file to be saved, then tap OK.
5. Enter a new name in the File name. Click Save.
6. Select OK when you get the message Rebuild has completed.

Please refer to the article below, which provides detailed instructions on the steps I outlined earlier: Verify and Rebuild Data in QuickBooks Desktop.

Additionally, you might want to check this resource to help you export your reports and analyze them in Excel, CSV spreadsheets, or PDFs: Export reports as Excel workbooks in QBDT.

You can tag me in the comment section if you have further concerns about the amount difference in your report. I'll assist you in any way possible.

If I rebuild QB will there be any issues since I am streaming it with rightworks

Yes, you're correct, @benz. The Verify and Rebuild feature is specific to fixing company files and doesn't affect the integration between Rightworks and QuickBooks Desktop (QBDT). I'll provide further details below to help address your inquiry.

As the option scans your company file for possible issues and then rebuilds the data that needs treatment, it doesn't harm the connectivity with Rightworks. This process promotes data integrity by doing a deep check-up within your files to ensure everything works well with your integrated application. 

I also recommend checking this article to learn more about how QuickBooks works with Rightworks: QuickBooks Desktop cloud hosting powered by Rightworks.

On top of that, you can explore this article so that in the future, when you need to run the Sales Tax Revenue Summary Report, you can still utilize the same settings for a seamless review of data. Feel free to check this page for more details: Create, access and modify memorized reports.

Count me in if you need further assistance handling report-related tasks or accomplishing goals within QuickBooks, @benz. As always, it'll be my top priority to provide a prompt response to answer your concerns. Stay safe.