In this guide we will walk through how to setup A2X for a manual integration and how to export your Amazon settlement data for accounting and reconciliation.
There are 3 steps to using A2X on a manual integration:
Set up A2X - accounts, tax rates, and bank accounts.
Map your accounts and taxes
Export your settlement data from A2X
We will work through each step below, but first there are some things you need:
You need to sign-up for A2X and should connect your A2X account to your Amazon account.
You need to export your chart of accounts from your accounting system
Step 1: Set up A2X
For manual integration connections, go to your Home page and click on the 'Custom Integration' blue link next to the 'Use without a connected accounting platform?' to begin with the setup.
You will be taken directly to your Settings > Connections page to set up your chart of accounts, tax rates and bank accounts.
Upload your Chart of Accounts & Tax Files
A2X needs your chart of accounts and tax rates in order to configure your accounting for Amazon settlements.
Firstly you will need to create your chart of accounts file and then you will upload your chart of accounts file into A2X.
You can begin by exporting a sample accounts file from within A2X.
A simplified example of an Accounts upload file is shown below.
Next, confirm the Export Format is General Journal Export (csv).
And finally, select bank accounts.
Select your bank account where Amazon deposits your settlements, your credit card where Amazon charges any amounts owed and an asset account that can hold your month-end pending payout.
Save your settings.
Step 2: Map your accounts and taxes
A2X needs to know how you want to map your Amazon transactions into your accounting system. To do that we A2X has an Accounts and Taxes page. You can learn more about the mapping process HERE.
This is a standard part of the A2X set up process for all users (both direct and manual integrations). If you’d like some help with this our support team can give you some tips and pointers, but in general, you’ll want to discuss this with your accountant as it affects the way your financial statements will appear.
Step 3: Export your settlement data
A2X will export a CSV file or iif for each of your settlements. You will import the file to your accounting system.
Export one A2X settlement data - Click the export link for any given settlement as shown below
Or export the data in bulk by selecting a range of payouts, and the "post settlements" feature. This will combine the data into one csv of iif file.
Hint: If you are in chat and wish to view the article outside of the chat window, please click HERE