What do I do if the amount of reported tax collected in Quickbooks and Zr Ware™ does not match?

 

From QBO

1. In QBO run the Taxable Sales Detail Grouped By Transaction Type (i.e. Invoice). You only need the Invoice Number and Tax Amount columns.
2. Order the data by invoice number.
3. If any of the Invoice numbers are duplicated, remove any header/total rows and create a pivot table in excel and group the tax amount by invoice number

From Zr Ware™

1. Run the sales tax detail report
2. Remove any header total rows
3. Order the data by invoice number
4. Create a pivot table and view the tax amount by invoice number

Now you can use excel to compare the two reports and figure out which invoice numbers have a different tax amount and you can figure out why.

Possible reasons(not an inclusive list):

• Duplicate Invoices with the same invoice number can exist for some client.
• Some Journal Entry occurred in QBO and the equivalent change was not made in Zr Ware™.