How to do a Payment gateway reconciliation between clearing account and payment settlement report

Odoo Payment gateway clearing account vs Merchant settlement report

The main purpose of this reconciliation is to make sure that all the odoo recorded payments are received from the merchant

To do this,

1. Download the merchant settlements for the month

01. Lets take poli as the example, and below is a sample merchant settlement report we created 


Here the transaction number is the unique field we are going to use for the reconciliation process, this is similar to the authorization key in Odoo


2. Reconcile Merchant settlements Vs Journal Items Using Authorization key

01. Go to Odoo Dashboard > Accounting > Accounting> Journal Items

02. Filter the period as shown in the image below

03. Then Filter the related clearing account for which your going to do the reconciliation

04. This Filter will show you the transactions for the specific clearing account for the selected period, also here you will see the  Authentication Key which is the base field in odoo what we are going to use for the reconciliation.

05. Now click on the box next to Date and click Action and Export

06.  Then select the  "Clearing account rec template"  and click on  Export (Please note template is already saved for you)

07.   This is how the exported sheet will look like, and you will find the authorization key here 

08. Then do a Vlookup for authorization key and get the amount from Merchant settlement report we got above

09. Finally calculate the variance between two reports in the next column(Column K - Column J)