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 QBO or set A2X to automatically post it for you.
Handy Hint: To enable auto-posting of settlements, go to A2X Settings > Auto Invoicing > Enable Auto-posting Settlements).
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 Match action to appear (typically required for transactions older than 3 months).
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!
If you have further questions, please reach out to us at firstname.lastname@example.org. We would be happy to help you.
Hint: If you are in chat and wish to view the article outside of the chat window, please click HERE