The accounts and taxes page is where our users can map their preferred income, expense, asset and liability accounts and tax rates to the corresponding ecommerce transactions.

This article includes tips and tricks for our users to customize filters and settings available to complete the accounts and taxes mapping.

*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

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.

Did this answer your question?