How to import Sales Tax on transactions into QuickBooks Online

Using the Zed Axis import utility you can import transactions into QuickBooks Online with Sales Tax on them. This article specifically relates to US editions of QuickBooks Online for guidelines for importing Value Added Tax VAT (UK) or Goods and Services Tax GST (Canada, Australia) please refer to this article.
 
 

Method 1: Provide relevant Tax Codes and let QuickBooks calculate the Tax Amounts (Recommended)
  • At the line level - LineTaxCodeRef - this is either TAX or NON and determines if the line item is taxable or not
  • At the footer level - TxnTaxCodeName - Name of the State, County or City Tax and rate to be applied to the transaction. (eg Sales Tax, Tucson, etc...)
You have also the option to set the Total Tax and the Tax Line Amount and Tax Percent
 
Method 2: Set the Tax Codes used, % rate and calculated Tax Amount
 
  • At the line level - LineTaxCodeRef - this is either TAX or NON and determines if the line item is taxable or not

Common errors and Troubleshooting steps


Error: Business Validation Error: Tax Exemption Reason should be specified incase customer is marked as not taxable 

When importing a sales transaction into QuickBooks Online using Zed Axis and the company file has the Automatic Sales Tax is enabled, and the Customer for the transaction has the option checked for "This customer is tax exempt" you must set a reason for the exemption and retry the import.

Add Feedback