Portal
Language
 
Home>Knowledge Base>Root>Zed Axis>How to convert Gross amounts to Net when importing into QuickBooks
User Login
Username
Password
 
 Login
Information
Article ID86
Created On11/24/2009
Modified7/25/2010

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.