All Collections
QuickBooks Support
Where do settlements go when A2X sends them to QuickBooks Online?
Where do settlements go when A2X sends them to QuickBooks Online?

QuickBooks Online - Journals - Reconcile QuickBooks Online

Iona Bird avatar
Written by Iona Bird
Updated over a week ago

Single settlement reconciliation

This is the simplest scenario for reconciling:

1/ Amazon generates one settlement for the period from Sep 15th - Sep 29th:

2/ A2X fetches the settlement and you can either manually send it from A2X to QuickBooks Online or set A2X to automatically post it for you.

Handy Hint: To enable auto-posting of settlements, go to A2X Settings > Automation > Enable Payouts auto-posting.

3/ The settlement is sent to QuickBooks Online as a Journal 

One of the easiest ways to find the journal straight after posting it is to click the magnifying glass at the top right of the page in QuickBooks Online, and display a drop-down showing your recent transactions:

You can select the journal you've just posted to review its contents:

4/ And finally, reconcile the journal entry to the Amazon deposit in your bank account

Go to the Banking tab.

As you see above, the journal for $18,596.90 has been auto-matched by QuickBooks Online, because the amount of the journal matches the amount of the settlement deposit amount.

All you need to do is click 'Match' and the settlement will be entered into QuickBooks Online and reconciled to the bank deposit.

Please Note: You may need to click on the transaction line for the 'Find match' action to appear (QuickBooks Online only auto-matches about 3 months back).

Split month settlement reconciliation

Your next settlement has now been generated by Amazon, covering a period from July 21st to August 4th, with a total settlement value of $13,255.14.

A2X will split your settlement of $13,255.14 into two journals:

  • one journal for the amount of $10,067.52 in July

  • one journal for the amount of $3,187.62 in August 

Since the settlement period actually covers two months, A2X splits the settlement to ensure your sales and fees are accounted for in the correct month.

When you send it over to QuickBooks Online, you will have two journals dated accordingly. The beauty with the split settlements in QuickBooks Online is that you still have to reconcile only to one entry, as shown below:

The journal for $13,255.14 has been auto-matched by QuickBooks Online because the amount of the journal matched the amount of the settlement deposit amount.

All you need to do is click 'Match' and the settlement will be entered into QuickBooks Online and reconciled to the bank deposit.

Multi-currency settlement reconciliation

If you sell in multiple marketplaces with different currencies in Amazon, you might have noticed that settlements are always in the currency of that marketplace (e.g Amazon.ca settlements are in CAD and Amazon.com settlements are in USD). 

Amazon offers a currency conversion feature, which you can enable and let Amazon convert the marketplace currency of the settlement into your preferred currency right before they pay it out to you.

Let's say your home currency is USD. By default, QuickBooks Online will not recognize that the $40.55 USD payment from Amazon is actually for the journal amount of CA$52.17 CAD.

When you expand the transaction line panel in the QuickBooks Online banking screen, you will see the radio button 'Find Match'. 

After selecting the 'Find Match' radio button QuickBooks Online will automatically look for matching transactions in your home currency (USD). To see entries in other currencies (in our example: CAD), select the 'Foreign Currency' radio button as highlighted below:

This will trigger QuickBooks Online to look for transactions in other currencies.
In our example, QuickBooks Online has found the CAD journal entry:

We just need to select it to tell QuickBooks Online we want to match the USD deposit to the CAD journal entry, click 'Save' and that is it - reconciled!

Hint: If you are in chat and wish to view the article outside of the chat window, please click HERE

Did this answer your question?