Support Portal Language
 
HomeKnowledge BaseZed AxisHow to convert Gross amounts to Net when importing into QuickBooks
Information
Article ID86
Created On11/24/2009
Modified11/25/2009
Share With Others
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 and a Sales Tax Code 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.