-
Accounting Dashboard
-
General Accounting Set up
-
Chart of Accounts
-
Day to Day Transactions
-
Sales
-
Banks & Bank Reconciliations
-
Fixed Assets
-
Year/Month End
-
Reports
-
Purchase Order approval
-
POS
-
Purchasing
-
Non stock purchasing
-
Expense Module
-
Shopify Sales
-
Invoice Reminders
-
Customer Statements
-
Tax
-
Supplier Batch Payment
-
Product Categories
-
Inventory Valuation Journals
-
Analytic Accounts
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)
Views | |
---|---|
45 | Total Views |
1 | Members Views |
44 | Public Views |