All Collections
FAQs
Account Mapping and Configuration
Enable advanced mapping rules in A2X for Amazon for UK VAT, OSS/IOSS and AU GST registered sellers
Enable advanced mapping rules in A2X for Amazon for UK VAT, OSS/IOSS and AU GST registered sellers

V2. Sellers registered in multiple countries can enabled advanced mapping rules in A2X for Amazon accounts

Natalie Flex avatar
Written by Natalie Flex
Updated over a week ago

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, Shopify, Ebay and Etsy transactions.

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

Advanced automapping rules example 1

Advanced rules are available for UK and AU based Amazon, Shopify, Ebay and Etsy sellers who need to set automapping rules at the detailed country and tax level transactions.

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.

By setting up additional rules, you can complete your set up once and apply them to all future transactions. This means you can set it and forget it.

As a default, there is one automapping rule available for Amazon Sales

After enabling the advanced automapping rules, UK VAT and AU GST registered users will have six automapping rules available.

The rules are separated by registered country, and non-registered country transactions.

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, QuickBooks Online 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 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

  2. 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.

  3. 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.

  4. Amazon sales shipped to any unknown 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.

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:

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

Did this answer your question?