How to convert Gross amounts to Net when importing into QuickBooks

If you are importing transactions into the Australian, UK or Candian editions of QuickBooks you may have your import data as amounts including tax (Gross).  In order to display those amounts or rates as including tax (Gross) in QuickBooks you will need to convert the amounts from Gross to Net during the import process.  Zed Axis provides a feature that will convert those amounts or rates for you.  Axis checks to see whether you have mapped the IsTaxIncluded, a Sales Tax Code (SalesTaxCodeRefFullName) and Rate and will lookup the tax rate in QuickBooks and convert the amount from Gross to Net. (if you do not map these fields the conversion will not be able to process)

To turn this option on in Axis, click on the Import tab and then click the Options button and check the Convert gross to net option.  This will apply to all QuickBooks transaction types that have an amount and a tax code.

Article ID: 86, Created On: 10/21/2011, Modified: 10/21/2011