Create your rules in A2X
Using automapping rules, you can specify how transactions should be categorized based on a set of criteria. When you are just starting to set up your A2X account, your accounts and taxes mapping is where you will set the majority of your rules. As a default the automapping feature will be enabled in your account and your mapping page will show a list of the rules to save.
For advanced Amazon rules, reference this article HERE
The transaction types from the ecommerce channels are listed on the left side of this page. The first step in setting your rules is to select the chart of account (and the tax rate) you would like to apply for each transaction type.
Getting started with this page
To get started with your mapping, if you'd like to use A2X's suggested chart of accounts list, click on the blue "Use Auto Setup" button, and save your mapping
Then, make adjustments to your rules as needed until you've completed setting your rules.
Rules by income, expense, liability, asset, tax and other categories
For example, IF the transaction type is a sale, THEN categorize the transaction as Shopify Sales in my accounting system
Or, IF the transaction type is a refunf, THEN categorize the transaction as Shopify Refunds in my accounting system
Below is an example of the automapping rules for the income category available.
Below is an example of the automapping rules available in the expense category
Examples of the automapping rules for future transactions
Below is an example of an Etsy mapping page with auto-mapping rules enabled. To use this automation feature, apply the account and tax rate you would like to use for all transactions within the main transaction category.
For example, the "advertising" transaction type is mapped to an Etsy Advertising expense account. The auto-mapping rule will be applied to the detailed transactions regardless of the shipped-to country, marketplace, or product group information.
Example when auto-mapping rules are applied:
Below is an example of the advertising transactions including a shipped to country and product types and how the auto-mapping rules apply.
Example when auto-mapping rules are customized to apply only the account, tax rate, or tracking:
Un-map the account or tax field in the auto-mapping rules transaction if you do not need to apply the account or tax rate to all transactions regardless of the shipped to country, marketplace, or product group. In this scenario below, you will be required to log into A2X and update new transactions that have been fetched into the system that do not already have an account or tax rate mapped.
The example below will automap the Etsy Sales account for all future Sales transactions, but will not map the tax rate column when a new transaction appears.
Another example below will automap the Shopify Sales and Tax rate for all Shopify sales regardless of the country, marketplace, or product group. The tracking category is left blank in the auto-mapping rules and will be blank for all new transactions.
Note: Changes to your invoice settings will disable the auto-mapping feature. Please re-enable the auto-mapping feature when you're ready.
View and map all transaction details
You can also view the transaction details for each category by excluding the automapping transactions from the list. Click on the "exclude" icon here to view all of the transactions available to map at the detailed level
In this view you can override the initial rules and apply your preferred income account for specific transactions as needed.
Related articles
Advanced Amazon UK VAT, OSS/IOSS and AU GST registred sellers
Mapping in A2X to include or exclude transactions from your VAT or GST reports
A2X for Amazon transaction types and 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.