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:
Enable Registered Country settings for region specific mapping settings
VAT Settings by Marketplace
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.