There are many different types of transactions in ecommerce accounting including sales, discounts, refunds, fees, pending payments, gift cards, sales tax and more. You can map each of these types to an account within QuickBooks or Xero the first time you use A2X. This mapping can be used again in subsequent months or you can change it at any time. When you first set up A2X, default mapping is provided which you can follow if you prefer.
A2X offers three mapping features:
Basic: Map transactions at the category level
Intermediate: Map transactions at a sub-category level
Advanced: Create product groups, add classes or tracking codes at the invoice or transaction level
Add tracking codes to generate custom reports for multichannel sellers
How to Map your Chart of Accounts
Once you have an A2X account connected to an ecommerce platform and to QuickBooks Online or Xero, you can map your chart of accounts by going to your "Accounts and Taxes" page at the top of your A2X screen.
If you are in the UK, EU, AU, NZ or SG please enable your VAT settings for region specific mapping options.
As a default, your mapping page will include the information below.
On the left hand side of this page, you can view the main transaction types (ie: Sales, Refunds, Shipping, Tax). You will have the option to pick your preferred chart of account for each transaction type.
The tax rate column on the right is for our UK, EU, AU, NZ and SG sellers. For sellers in the Americas, please use No Tax or Tax Exempt, as all taxes collected will be categorized as a Sales Tax Liability.
Auto-mapping rules are enabled
You may notice additional transaction details in your A2X payouts invoices.
With auto-mapping rules enabled, A2X will map any new transaction types from your ecommerce platforms to the chart of accounts in your Accounts and Taxes settings, and display the details in your payouts summaries. These details will also be reflected in the journals or invoices in your accounting system.
For users in the UK, AU, NZ, SG and EU who have enabled the VAT feature, your mapping page would have additional columns as in the example below:
Please reference the transaction details and the country data to map at the detailed level for accurate VAT and GST returns.
For more information please refer to the articles below, or if you have any questions reach out to the support team.