This article explains the reasons why the 'Auto Look Up' function (offered by Xero) doesn’t work with A2X, and (in that context) is not a viable tax rate.  

Introduction

Sales Tax is complicated and it is great to have a way to ease this pain and automatically calculate it. As a Xero user, you have the option to do that with the 'Auto Look Up' tax rate option that Xero offers, but is that the best way to automate using A2X?

When you are in the Accounts and Taxes section of A2X, it is tempting to choose Xero's 'Auto Look Up' option from the Tax Rate drop-down, which should automatically calculate sales tax (see below). 

Please read further to learn why it cannot be used as a tax rate in A2X.

“Auto Look Up” tax rate function further explained

The 'Auto Look Up' function needs some basic information for it to work, and that information is not supplied in the Amazon settlements fetched by A2X.  

The screenshot below shows an explanation from Xero:

As stated in the bullet points above, the 'Auto Look Up' function needs two addresses in order to work: 

  • The business owner’s address
  • The customer's address 

However, you will notice that your Amazon settlements in A2X do not contain address details in any of the transaction lines. Therefore, there is no basis for the 'Auto Look Up' function to calculate the sales tax, and thus it is not a viable tax rate to use in A2X.


What will Xero do if 'Auto Look Up' is set as a Tax Rate?

When the sales tax basis cannot be determined, Xero will change the 'Auto Look Up' rate to a 'Tax Exempt' rate by default for any transactions. 

If you actually need to calculate tax using Xero tax rates (for example, a business in the UK at a certain threshold of sales), the 'Auto Look Up' is not the way to automate tax calculation.  


To understand how you can apply correct tax rates in A2X, please check our other articles by going to Help > Support Centre in your A2X account or contact us through chat or e-mail.

Hint: If you are in chat and wish to view the article outside of the chat window, please click HERE

Did this answer your question?