For Amazon and Shopify, your tax transactions are separated from the sales transactions in A2X.
This tax separation gives users two options to map the sales and taxes:
exclude sales and taxes transactions from your tax module
Recommended for US and Canadian sellers, and sellers registered in countries with more than one tax rate
Recommended for sellers who are not tax registered, or do not use the tax module in the accounting system
include sales and taxes transactions in your tax module
Recommended for sellers registered in countries with one tax rate per country (UK, EU, NZ, AU, etc)
The same mapping rules can be applied to users with zero-rated and mixed rated product groups
Recommended for sellers who are tax registered, and use the tax module in the accounting system
The examples below explain how the tax mapping in A2X affects the information in your accounting system tax modules. We've used a UK VAT registered account for the example but the same mapping principles apply to users outside of the UK.
1. Exclude sales and taxes transactions in your tax module:
If you are not using your accounting system for VAT/GST filing and prefer not to map each transaction in detail, then simply map "No VAT", "BAS Excluded" or your preferred tax rate in the tax rate column as shown in the example below.
Example mapping in A2X excluding VAT (UK Seller)
Example Amazon Invoice in Xero excluding VAT (UK Seller)
2. Include sales and taxes transactions in your tax module
To include your sales and tax transactions in your tax module, you'll need to wrap the taxes separated in A2X back in the applicable income accounts so that the accounting system sees the full gross sales amounts and then accounts for the taxes by way of tax rates, accurately.
Example mapping in A2X including VAT (UK Seller)
Example Amazon Invoice in Xero excluding VAT (UK Seller)
Example VAT Return in Xero (UK Seller)
Tax mapping can be complicated if you don't understand the different tax transactions from your e-commerce store and how to account for them. Some channels only have Marketplace Facilitator Tax transactions available in the data files, and others include tax transactions in addition to Marketplace Facilitator Tax transactions.
The example above does not include shipping income or other ecommerce expense examples. However, the same mapping principles apply.
This article is intended solely for technical configuration of A2X, there is no guarantee or assurance provided that the detail in this tutorial is best suited to your specific business needs or that it directly suits your tax obligations.
Related articles:
Do you need help with your A2X set up?
Are you struggling with setting up your Accounts and Taxes page and you would like some help from an accountant or bookkeeper? 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
If you have further questions or need assistance, feel free to reach out to us at contact@a2xaccounting.com. We would be glad to help you.