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:
Does your page have a different view? Click HERE for more information
Filters by Transactions, Details, Country, Marketplace, Account, Tax Rate, Tracking/Classes and by Account Type
Your filter options in A2X will vary based on your ecommerce channel integration, registered country and invoice settings enabled in your account.
Default filters for every A2X account includes the following:
Advanced users have additional settings and filter options:
To enable advanced mapping options, please enable your Registered Country settings by following the instructions HERE.
Please note that advanced mapping options allow users to map transactions at a detailed level including the shipped-to country of the orders. As new transaction details are fetched in from the ecommerce channel integration, users will be required to update and maintain the mapping for the new transactions that haven't been previously mapped.
Transactions filter 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
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
Country 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"
Transaction Category 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 transactions filtered by income
Example of transactions filtered by expense
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 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.
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
Filter Columns: Use the Account or Tax Rate filter to show only Unmapped fields
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
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:
If you have any questions or need assistance with your account setup, feel free to email our support team at firstname.lastname@example.org, and we will be happy to help you where we can.