Skip to main content
All CollectionsFAQsAccount 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: Scenario 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. The list offers 56 detailed mapping rules available across all categories including income, expense, current liability, current asset, tax, and other.

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

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.

Example (Sales) customized mapping:

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: Scenario 2

For users who need advanced automapping rules, the option to add multiple country-level transactions is 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.

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 has been grouped into 4 main categories:

  1. Amazon sales shipped to GB

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

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

    3. Amazon sales shipped to GB that include "No Tax" in the detailed descriptions. These are sales to GB, where Amazon did not collect any VAT on them.

  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 the UK, IT, and FR in this example. The options offered are EU-Country and non-EU Country 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 the rules above. 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 in.

  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 the 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 the UK, IT, and FR. The taxes are separated into the EU and countries outside of the 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 setup?

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?