The steps below will walk you through getting started with QuickBooks Online and A2X.
STEP 1: Log in to your A2X and start the connection process
Before connecting to QuickBooks, log in to your A2X account. You can also connect to Amazon - but this can be done either before or after connecting to QuickBooks.
Click on the 'Connect to QuickBooks Online' button in Settings > Connections and then either:
choose to 'Connect to an existing organization', if you already have an A2X account connected to the same QuickBooks Online,
or select the 'Connect to a new organization' button, if you wish to connect this A2X account to a new QuickBooks Online company:
STEP 2: Connect to QuickBooks
After you click the 'Connect to QuickBooks' button, a new window will open where you need to log into your QuickBooks Online account.
Next, you need to tell A2X which company you would like to connect with. If you have only one company, then you will only have one option; if you have multiple companies, then you will need to select the correct company to link A2X to.
When selected, you will be taken to the next window, where you need to click on the 'Connect' button to grant A2X permission to connect:
Lastly, you should see the connection being created before you are redirected back to A2X and the connection window will close automatically.
Back in A2X, you should see the QuickBooks Bank account settings screen as shown below:
STEP 3: Set the bank accounts
In A2X Settings > Connections, select the bank/credit card accounts that you use with Amazon. You will need to map to the bank account that Amazon deposits settlements into and also to the credit card account that is used to pay amounts owed to Amazon.
Please Note: If you sell on Amazon in multiple currencies - for example, Amazon.com in USD and Amazon.ca in CAD, or Amazon.co.uk in GBP and Amazon.de in EUR - then you will need to set up multiple deposit accounts for QuickBooks in your A2X settings.
For complete instructions on handling multiple currency deposits from Amazon, please see our guide HERE
STEP 4: Configure/review your mappings on the 'Accounts and Taxes' screen
Now, we can configure A2X with accounts and taxes for each transaction type and send the financial data to QuickBooks.
You'll need to select accounts from QuickBooks Online and assign tax rates for each type of Amazon transaction. The easiest way to do this is to use the A2X mapping screen called 'Accounts and Taxes'.
Please Note: In the beginning or during the trial phase, you might want to choose fairly broad categories, but when you are setting up your account for more detailed accounting, you will probably want to choose more granular account mappings, which will give you better data in your financial reporting.
To review, add or edit your account and tax rate mappings, click 'Accounts and Taxes' in the top menu of your A2X account.
When you first go to set up your Accounts and Taxes mapping, you will see a pop-up appear asking you to 'select the main country your business operates in'. This step is to help allow A2X to enable settings best suited for your sales channel accounting needs.
Once you have selected the country the next step will be to confirm whether your business is tax registered and collecting or remitting sales tax:
A2X will then ask you to select any additional countries that you may be registered in.
From here A2X will ask if you would like to use our Assisted Setup option or the Custom Setup option. Assisted Setup will allow A2X to automate the whole accounts and taxes mapping process, while the Custom Setup option is catered towards more sophisticated users who would prefer to fully customize their settings and accounts and taxes mapping.
If you decide to choose the Assisted Setup option A2X will display the list of default accounts we will setup in your accounting system, which you can then save and continue.
Once the mapping is saved the next step will be do view your settlements and send them across to your accounting system.
A note on tax rates in QuickBooks
A2X currently requires at least one QuickBooks tax rate to be configured - it can be simply 'no tax', which means your taxes will be calculated outside of QuickBooks (in the case of US merchants, that might mean using a tool like TaxJar or Taxify to help). This is the most typical scenario for US sellers, as Amazon.com will calculate sales tax on your behalf.
In our example below, you see that there is currently one sales tax rate defined within this QuickBooks account. There can be as many preset tax rates as you need.
They can be created in QuickBooks by selecting the 'Taxes' menu on the left side of the QuickBooks screen and then selecting 'New'.
Please Note: We recommend that you consult with your accountant or tax adviser regarding the applicable tax codes/rates for your state, country, or business structure.
STEP 5: Review your first A2X settlement and send it over to QuickBooks
Click 'Settlements' in the top menu of A2X and then click 'Review' next to one of them:
The invoice details for the settlement period will be displayed, and you may see one or two invoices, depending on whether the settlement period covers 1 or 2 months of sales and fees.
The details on the invoice can be reviewed by clicking the little down arrow. Once you are happy with it, send it over to QuickBooks Online by pressing the 'Send invoice to QuickBooks' button.
STEP 6: Review the A2X journal entry in QuickBooks
In QuickBooks, you will see one (or two) journal entries that A2X has created. Each journal entry will have a date (the date the transactions are applied - which is important if the settlement covers more than one month), and the list of debit and credit transactions that apply in that period.
The final entry on the journal will be the deposit into the nominated bank account (or withdraw, if you owe Amazon money for that period).
Since the journal entry includes the debit or credit to the bank account, you can then reconcile the deposits from Amazon to the journals. In the bellow example, QuickBooks has automatically matched the incoming deposit to the Journal entry created by A2X:
In the event that QuickBooks doesn't automatically match it, as there may be two journals to match to the one deposit, then you can select 'Find other matching transactions'.
Now, all of the sales and fees Amazon paid/deducted have been properly accounted for and reconciled to every $ paid into your bank account.
A note on Amazon balances carried
If your settlement period covers only a single month (e.g April 10th to April 24th), then there will be one journal entry in QuickBooks, where the final line item in the journal will be the single deposit to your bank account.
However, if your settlement period runs across a month-end (e.g April 24th to May 8th), then A2X will create two journals; one for the first month and one for the second month. This is important for keeping the transaction data in the correct month for business financial reporting.
The effect of this split is that at the end of the first month the amount that Amazon owes you for the first month's of transactions will be collected in a carried balance account and carried into the second journal period.
Then, at the end of the final journal, the total deposit will be made. This will ensure that the total deposit in your bank account from Amazon will perfectly match the journal that A2X creates, and QuickBooks will offer it as a match on the bank transactions screen.
If you have any questions regarding the A2X integration with QuickBooks Online, please don't hesitate to contact our support team.
Hint: If you are in chat and wish to view the article outside of the chat window, please click HERE