Sales Tax Report for New Implementations - Taxable vs. Non-Taxable

To properly calculate your taxable and non-taxable sales from two different systems such as QuickBooks and e-manage|ONE, you will need to extract information from both systems and perform some manual calculations using both reports.

It is important to note that QuickBooks Non-Taxable Sales should include ALL e-manageONE Sales, as e-manage handles your sales tax for e-manage projects by adding a line item for applicable sales tax.

When e-manage is used, all sales are classified appropriately on the e-manage side. Therefore, to determine your taxable total, you need to add the taxable sales in e-manage to the taxable sales in QuickBooks. Similarly, to obtain your non-taxable total, you need to deduct e-manage taxable sales from non-taxable sales in QuickBooks.

For instance, let's consider the following example:

In e-manage: • $100,000 in taxable sales • $50,000 in non-taxable sales

In QuickBooks: • $500,000 in taxable sales • $200,000 in non-taxable sales (this includes QB non-tax AND ALL e-manage transactions regardless of tax so this should be showing higher than expected, i.e., the $50,000 NT above is included in this total)

To calculate your grand total taxable sales, you need to add $100,000 in e-manage taxable sales to $500,000 in QuickBooks taxable sales, resulting in a total of $600,000.

Similarly, to calculate your grand total non-taxable sales, you need to deduct $100,000 in e-manage taxable sales from $200,000 in QuickBooks non-taxable sales, resulting in a total of $100,000.

However, it is important to note that the figures obtained may not balance, as items entered directly in QuickBooks may not be present in e-manage.