If you need to include VAT on Sales or Purchase transactions that you import into QuickBooks (QuickBooks UK editions) then Axis provides a way for you to do that. Unfortunately it is not possible to import Sale Tax Amounts directly into QuickBooks as Intuit does not permit that however it is possible to specify an Item Sales Tax Code, QuickBooks will then automatically calculate the tax amount. When setting up mappings in Axis you need to pay particular attention to the following QuickBooks fields:
Sale Tax Code field - Each item or account on a sales or purchase transaction is assigned an sales tax code that indicates whether the item or account is taxable or non-taxable. The default options in QuickBooks UK are shown in the table below however these may be modified so please check you Item Tax Code list in QuickBooks before setting these, if the Tax Code imported into QuickBooks is not found then Axis will report an error. If you do not specify a Tax Code then Axis will use the default tax code assigned to the item or account.
Is Tax Included
||Item is bought and sold domestically and attracts the standard rate of 20%
||Item is bought and sold domestically and is exempt from tax
||Item is bought and sold domestically and attracts the zero rate of tax
||Businesses entity not registered for tax
||Item is bought and sold within the EU and attracts the standard rate of 20%
||Item is bought and sold within the EU and attracts the zero rate of tax
- indicates whether the rate or amount being imported is including tax or is excluding tax, the possible values are true
Rate or Amount
- the price or calculated amount of the item being bought or sold, if not mapped then QuickBooks will use the QuickBooks default price or rate associated to that item
Finally Axis has an option to Convert Amounts from Gross to Net if you want to display amounts or rates in QuickBooks as not including tax. For more information about VAT in QuickBooks refer to Intuit Support.