A2X Mapping Page Tips and Tricks
V2. Advanced features including filters, sorting, and enabling automapping rules for your accounts and taxes page and settings
Natalie Flex avatar
Written by Natalie Flex
Updated over a week ago

The accounts and tax mapping page is where you select the correct GL account and tax rate, for each transaction type. A2X recently made changes to improve this page, making it easier, faster, and more accurate.

This video gives you an overview of the new page and explains how best to use it:

Do you need help with your A2X set up?

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

Does your page have a different view? Click HERE for more information

Mapping page tips and tricks

Your filter options in A2X will vary based on your ecommerce channel integration, registered country and invoice settings enabled in your account.

Default Categories

These filters allows users to view a filtered list based on the main chart of account type. For example, Income will display a list of transactions that are generally considered an income type, and mapped to an income account

Example of categories filtered by income

Example of categories filtered by expense

Transactions are sorted by account type

Income, Expense, Current Liability, Current Asset, Tax, Other

Default search filter options

Default search filters for every A2X account includes the following:

Transaction, transaction details, marketplace, account and tax rate

Advanced search filters - advanced setup users have additional settings and filter options:

Filter by country and tracking

To enable advanced options, please enable your Registered Country settings by following the instructions HERE.

Transactions filters

This feature gives users the option to filter the list of transactions to one main transaction. Example below is the list of main transactions available for accounts connected to an Amazon store

Example below is a filtered list of transactions categorized as Product Sales or Product Refunds

Filter by country

This feature allows users to filter the transactions to display only the transactions shipped to their main registered country. Example below includes two filters: Transaction filtered to show "Product Sales" and the Country filter is set to "GB"

PRO TIP: Sorted by registered country

Automapping rules and transaction details are grouped by transactions shipped to your registered country, followed by transactions shipped outside of your registered country.

Note: For Amazon UK and EU accounts with VCS enabled, the transactions will be grouped by the VAT jurisdiction from Amazon's VAT report, rather than the shipped-to country.

PRO TIP: Exclude

Exclude allows users to exclude a specific transaction, description, country, marketplace, account, tax rate or tracking/class

Example below is the list of transactions excluding all transactions shipped to "GB"

PRO TIP: Search by tag (transaction detail)

Transaction Details TAG option allows users to filter the list of transactions by keyword. Choose the tag option to select all transactions including your preferred key word.

Example without tag

Example filter using tags (keywords)

Filter by account or tax rate

Accounts filter allows users to filter the transactions to display only the transactions mapped to a specific chart of account. The list displayed includes all active chart of accounts in your accounting system

Tax Rate filter gives users the option to filter the transactions to display only the transactions mapped to a specific tax rate. The list displayed includes all active tax rates in your accounting system

Use the Bulk Actions feature

Tick the checkboxes to the left to enable bulk actions. This will enable the option to set your preferred account, tax rate or tracking/class in bulk.

To select a list of transactions on bulk, you can tick each checkbox manually, or try using the SHIFT button to select multiple transactions at once.

Then, choose your account, tax rate or tracking/class to apply

Adjust your page view

Per page view default is set to 20 transactions per page. Increase your view by selecting from the available options

Understanding transaction descriptions

Hover over the information bubble to learn more about each transaction category

How to identify if a transaction is still missing and account or tax rate.

This message bar below is to notify you if a transaction does not have an account or tax rate mapped. All transactions lines will turn from yellow to white when mapping is complete.

Sort Columns: Use the sort option next to the Account or Tax Rate. This feature will bring all unmapped transactions to the top of your list

A2X can create suggested accounts in your Chart of Accounts

When you first go to set up your Accounts and Taxes mapping, you will see that A2X can create a number of generic default accounts for you to map transactions to.

Click 'Confirm' to allow A2X to create the following list of accounts in your accounting system

Set your Automapping rules

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. For example, to set a rule to map all sales transactions to an existing "shopify sales" account, find the transaction category for sales, and select "shopify sales" from the accounts dropdown list.

Click HERE to learn more about automapping rules.

Custom/Manual Mapping

Because A2X is connected to your accounting software, it is importing your complete chart of accounts. If A2X detects an account that already matches the default, then it will be pre-selected.

Instead of our generic default accounts, you can select your own account for any transaction type. Just click on down arrow to open the dropdown, and then scroll to find and select the account from your Chart of Accounts list.

Save your mappings!

Finally, always remember to click the Save Mapping button at the bottom of the page.
Your account mapping will now apply to your settlements consistently.

Pro tip for multichannel accounts:

Add tracking codes or classes for each marketplace in your invoice settings

This feature allows multichannel users to generate custom reports by marketplace like this example below:

Additional resources:

If you have any questions or need assistance with your account setup, feel free to email our support team at contact@a2xaccounting.com, and we will be happy to help you where we can.

Did this answer your question?