Single settlement reconciliation
This is the simplest scenario for reconciling:
1. Amazon generates one settlement for the period from February 1st - February 15th:
2. A2X fetches the settlement and you can either manually send it from A2X to Sage 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). Find out more about Auto-Posting here
3. The settlement is sent to Sage and appears as a single Sales Invoice. You can find the Sales invoice by clicking ‘Sales’ and in the drop down options select ‘Sales invoices’.
--> You can also search for an invoice by type.
Go to ‘Sales’ > ‘Sales Invoice’ then by clicking on More and navigate to Status. Filter invoices by Outstanding, Overdue, Unpaid, Part Paid, Paid, Void, Draft and Pro-Forma.
--> Select the Sales invoice you've just posted to review its contents.
4. Reconcile the sales invoice to the Amazon deposit in your bank account.
--> Go to the Banking tab and click on imported transactions.
--> As you see below, the sales invoice for £3,273.84 has appeared. You will need to click 'Match'.
--> Tick the payout which matches the payment transaction of £3,273.84
--> And click 'Match' and the settlement will be entered into Sage and reconciled to the bank deposit.
Split month settlement reconciliation
Our next settlement has now been generated by Amazon, covering period from January 18th to February 1st, with a total settlement value of £8,545.56
In Sage, the first invoice will come through as a 0.00 value and the second invoice comes through as the total of the combined two invoices:
The first invoice will have the correct transactions lines as seen in A2X, and will have the carried balance transaction which makes the invoice total 0.00.
The second invoice has the other line items as seen in A2X and also has the carried balance brought forward.
The total amount in the second invoice will reconcile exactly with what the bank has deposited in the bank account. This means you do not need to find the two invoices, just the later of the two to reconcile.
1. To reconcile this settlement click record payment. Allocate the bank account and method of payment and click record.
2. Then go into the Banking page and click on import:
3. Find the matching settlement amount and make sure to select match.
4. From there, select the transaction that makes up the total amount.
5. Click 'Match' and you have successfully reconciled a split month settlement.
Please note: The first invoice totaling 0.00 is not currently reconcilable. The team at A2X are working on bringing this functionality to our Sage users. Watch this space!
Multi-currency settlement reconciliation
We recommend checking this article to see how are settlements/payouts in different currencies (e.g.EUR) reconciled to GBP deposits via a bank clearing account.
If you have further questions, our friendly support team will be happy to assist. Feel free to click the chat bubble in the bottom right corner to chat with our team.
Hint: If you are in chat and wish to view the article outside of the chat window, please click HERE