Setting up rules in A2X is essential for effectively categorizing your transactions. This article provides self-onboarding users with easy-to-understand instructions on how to create and verify rules in A2X for accurate transaction categorization.
Create your rules in A2X
Automapping Rules
Automapping rules allow you to specify how transactions should be categorized based on specific criteria. When you start setting up your A2X account, the accounts and taxes mapping section is where you will define most of your rules. By default, the automapping feature is enabled, and you can see a list of rules on the mapping page.
Defining Transaction Categories
Begin by selecting the chart of accounts and the tax rate you want to apply for each transaction type. For example, if the transaction type is a sale, you can set a rule to categorize it as "Shopify Sales" in your accounting system. Similarly, if the transaction type is a refund, create a rule to categorize it as "Shopify Refunds". Customize rules based on income, expenses, liabilities, assets, taxes, and other relevant categories.
The transaction types from the ecommerce channels are listed on the left side of this page.
For advanced Amazon rules, reference this article HERE
Using Auto Setup (Optional)
A2X's Auto Setup Feature
A2X provides an auto-setup option that suggests a default chart of accounts and automatically maps the accounts.
To use this feature, click the "Use Auto Setup" button and save your mapping. However, if you prefer having full control over your account and tax preferences, you can manually select your preferred accounts and tax rates for each rule.
Verifying Rule Setup
Mapping Validation
Double-check the mapping of transaction types to the appropriate accounts and tax rates. Review your rules and ensure they align with your desired categorization.
Test Transactions
Test sample transactions to verify that the accounts and tax rates are correctly categorized according to your defined rules. This step helps validate the accuracy of your rule setup.
Rules by income, expense, liability, asset, tax, and other categories
In A2X, you can easily categorize your transactions using automapping rules based on various categories such as income, expense, liability, asset, tax, and more. Let's explore how these rules work:
For instance, if a transaction type is a sale, you can set a rule to categorize it as "Shopify Sales" in your accounting system.
Similarly, if a transaction type is a refund, you can create a rule to categorize it as "Shopify Refunds" in your accounting system.
Automapping Rules for Categories
Below are examples of automapping rules available for different categories.
Income Category
Expense Category
Automapping rules for future transactions
When you set up automapping rules in A2X, they are automatically applied to future transactions that match the defined criteria.
Automapping rules categorize transactions based on the criteria you've set. For example, let's consider advertising transactions, including shipped-to country and product types. Automapping rules will categorize these transactions accordingly without manual intervention.
Example when auto-mapping rules are applied
When automapping rules are applied, transactions are automatically categorized based on the defined criteria. Here's an example of how automapping rules apply to advertising transactions, including shipped-to country and product types.
Example when auto-mapping rules are customized to apply only the account, tax rate, or tracking
In certain cases, you may want to customize automapping rules to apply only to specific aspects of your transactions. Here are two examples:
Un-map the account or tax field in the auto-mapping rules transaction if you do not need to Automapping the Etsy Sales account for all future Sales transactions but excluding the tax rate mapping when new transactions appear. This allows you to categorize sales accurately while leaving the tax rate field open for customization.
Automapping the Shopify Sales and Tax rate for all Shopify sales, regardless of the country, marketplace, or product group. By leaving the tracking category blank in the automapping rules, it will remain empty for all new transactions, giving you the flexibility to add tracking information as needed.
Note
Modifying your invoice settings will remove the automapping feature from your page. To continue automapping your transactions, please re-enable the feature by going to Settings > Automation > Enable auto-mapping.
Pro Tip: Verify Transaction Details and Adjust Rules
To ensure the accuracy of transaction categorization, follow this valuable tip:
Viewing Transaction Details
To review the details of each transaction within a category, you can exclude auto-mapped transactions from the list. For example, select your "income" transaction, then enter "automapping" in the transaction details filter. By clicking on the "exclude" icon, you can access a comprehensive view of all transactions available for mapping at a detailed level.
In this detailed view, you can modify the initial rules and apply your preferred income account for specific transactions as necessary. This empowers you to fine-tune the categorization and ensure that transactions are correctly assigned to the desired accounts.
By following these easy steps, self-onboarding users can effectively create and verify rules in A2X for accurate transaction categorization. Regularly reviewing and adjusting your rules will ensure the integrity of your financial data and streamline your accounting processes within A2X.
Do you need help with your A2X set up?
Would you like to receive assistance with setting up your Accounts and Taxes page 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
We’re here and available via chat to help with any questions you have.
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