A2X's goal is to automate your ecommerce accounting by allowing our users to create rules in our app to automatically map the default or preferred chart of account and tax rate for all Amazon transactions.

As a default, A2X has 23 automapping rules you can set in our app:

Advanced automapping rules example 1

Advanced rules are currently available for UK and AU based Amazon sellers who need to set automapping rules at the detailed country and tax level transactions. To enable this feature reach out to our support team!

Below is an example of advanced rules for a UK VAT registered user.
This list offers 56 detailed mapping rules available across all categories including income, expense, current liability, current asset, tax and other.

Pro tip: A2X can set all of the default accounts and tax rates for you, or you can customize the transactions to suit your needs.

The additional rules allows you to complete your set up once and apply rules for future transactions. This means you can set your rules once and set it and forget it!

Below are the 5 Amazon Income automapping rules available as a default

After enabling the advanced automapping rules, UK VAT and AU GST registered users will have 25 income automapping rules available with detailed country and tax level information.

Below is an example of an invoice in Xero using the assisted setup default mapping options that A2X offers. A2X's default mapping will include the Amazon sales and taxes transactions in your Xero, QBO or Sage tax module.

Advanced automapping rules example 2

For users who need advanced automapping rules, the option to add multiple country-level transactions are also available.

Below is an example of advanced rules for a UK VAT registered user who is also registered in Italy and France. This list offers 72 detailed mapping rules available, the screenshot covers the is an example of only the income transaction automapping rules.

Pro tip: A2X can set all of the default accounts and tax rates for you, or you can customize the transactions to suit your needs.

Why do I need this level of detailed transactions?

For sellers registered in multiple countries, the option to create additional chart of accounts in the accounting system for a customized financial reports can be automated by customizing the mapping in the accounts and taxes page.

Example (Sales) customized mapping:

This is an example of advanced rules for a UK VAT registered user who is also registered in Italy and France. Users can map a different income account based on the shipped to country. In the example below the list of sales transactions have been grouped into 4 main categories:

  1. Amazon sales shipped to any country. The tax rate has been left blank to prevent setting a rule that may override rules below. Please remove the accounts field accordingly as needed.

  2. Amazon sales shipped to GB

    1. Amazon sales shipped to GB that does not include "No Tax" or "MFT" in the detailed descriptions

    2. Amazon sales shipped to GB that include "No Tax" in the detailed descriptions. There are sales to GB, and Amazon did not collect any VAT on the sales

    3. Amazon sales shipped to GB that include "MFV" in the detailed descriptions. These are sales to GB, and Amazon collected and remitted marketplace facilitator vat on the seller's behalf

  3. Amazon sales shipped to IT and FR. These are the two additional VAT registered countries specified in the Registered Country settings. This includes sales that were taxable, nontaxable, or had marketplace facilitator taxes collected and remitted.

  4. Amazon sales shipped outside of the registered countries. These are all sales outside of UK, IT and FR in this example. The options are countries in EU, and countries outside of EU to give you more control over your preferred mapping.

Example (Sales Tax) customized mapping

Users can use the advanced mapping options to map a different tax liability account based on the registered VAT country as needed. Below is an example of an account with multiple liability accounts based on the country the VAT was collected for.

  1. Sales tax collected from orders shipped to any country. The tax rate has been left blank to prevent setting a rule that may override rules below. Please remove the accounts field accordingly as needed.

  2. Sales tax collected from orders shipped to GB

  3. Sales tax collected from orders shipped to FR

  4. Sales tax collected from orders shipped to IT

  5. Sales tax collected from orders shipped outside of the registered countries. These are all sales taxes collected from transactions shipped outside of UK, IT and FR. The taxes are separated into EU and countries outside of EU to give you more control over your preferred mapping.

Note: the example is to explain the flexible options available and is not a recommendation on tax mapping.

Related articles:

How to create and set rules in A2X

Tax mapping in A2X to include or exclude transactions from your tax module (for UK, EU, AU and NZ sellers)
Amazon Transaction Type Categories
Shopify Transaction Type Categories

Do you need help with your A2X set up?

Are you struggling with setting up your Accounts and Taxes page and you would like some help from an accountant or bookkeeper? We have a directory full of expert accounting/bookkeeping partners around the world who are ready to assist with your e-commerce accounting and A2X.

Please click HERE to find an expert

If you have further questions or need assistance, feel free to reach out to us at contact@a2xaccounting.com. We would be glad to help you.

Did this answer your question?