Users of the QuickBooks Desktop and QuickBooks Enterprise products can use A2X to account for their Amazon sales.
This guide will show you how to setup A2X for use with QuickBooks Desktop and Enterprise, and how to export your Amazon settlement data for accounting and reconciliation.
You will be ready to use A2X with QuickBooks Desktop or QuickBooks Enterprise by completing these 3 steps:
- Setting up A2X - accounts, tax rates, bank accounts
- Mapping your accounts and taxes
- Exporting your settlement data into QuickBooks Desktop or QuickBooks Enterprise
Before proceeding, please ensure that you have:
- signed-up for A2X and connected your A2X account to your Amazon account
- exported your chart of accounts from QuickBooks
Please Note: If you need assistance with the creation of your chart of accounts CSV file, read our article HERE
STEP 1: Set up A2X
Go to your Home page, and click on the down arrow next to the 'Using A2X without a connected accounting system?' to display the drop-down.
In the drop-down box that will appear, click on the 'Custom Integration button' to begin with the setup.
You can also do this step by going to your Settings > Connections and clicking on the orange link 'custom integration'.
You will be taken directly to your Settings > Connections to set up your chart of accounts, tax rates and bank accounts.
Upload Chart of Accounts & Tax Files
A2X needs your chart of accounts and tax rates in order to configure your accounting for Amazon settlements. Read our article HERE
Confirm Export Format and select bank accounts
Confirm the export format is 'QuickBooks Desktop or QuickBooks Enterprise (IIF)'
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. The mapping process is performed on the Accounts and Taxes page.
This is a standard part of the A2X set up process for all users (both Online and Desktop). If you’d like some help with this step, our support team can give you some tips and pointers, but in general, you’ll want to discuss this with your accountant given that it affects the way your financial statements will appear.
STEP 3: Export your settlement data
A2X will export a specially formatted IIF file for each of your settlements. You will import the IIF file to your version of QuickBooks Desktop or QuickBooks Enterprise.
Export the A2X settlement data in IIF
Click the export link for any settlement as shown below:
Import IIF into QuickBooks
(Windows) File → Utilities → Import → IIF Files
(Mac) File → Import → From IIF Files
Uploading your Chart of Accounts File: For more information on uploading your chart of accounts, read our article HERE
Carry Forward Balance: A "carry forward balance" account is required. For more information on the carry forward balance, read our article HERE
Enabling Account Numbers: Account numbers are required for A2X / QuickBooks Desktop or QuickBooks Enterprise users. For more information on enabling chart of account numbers, read our article HERE
Hint: If you are in chat and wish to view the article outside of the chat window, please click HERE