DotPe is a payment gateway that is built to accept payments through UPI, scanning QR codes, WhatsApp-based scan-order-pay etc. It specifically enables customers to make payments at brick-and-mortar stores. It is extremely helpful to several stores as a lot of people prefer going cashless so they hence need DotPe to make online payments at offline stores. Essentially DotPe is a one-stop solution for businesses as they provide everything from inventory management, marketing, ePOS, and CRM to Dashboard integration for restaurants.
As an offline store, it might get really difficult to keep track of each payment made on Dotpe. Sometimes it is possible that the transaction does not get completed or that some payments are made incorrectly. If this keeps happening, it accumulates and leads to a loss. So that’s why it is important to verify all transactions processed on DotPe.
This is where our software comes in use, it helps automate the Reconciliation of DotPe Transactions process. It reconciles the DotPe transaction report with the POS and settlement report. It cleans and transforms the data loaded after applying logic computations. After which it displays the reconciliation results in an easy-to-analyse format.
Reports Required for Reconciliation
DotPe Offline Reports
This report consists of all the transactions carried out through DotPe at the physical store.
POS Order Detail
All the orders placed and their details entered in the point-of-sale system are recorded here.
DotPe Settlement Report
In this report, all the payments and their final settlement amount settled in the bank are recorded here.
DotPe Instore – POS Reconciliation
The DotPe report is linked with the POS report to check all the transactions made and the amount recorded in both reports for comparison. It shows which orders recorded in the DotPe report are reflected in the POS system so that we can check if any amount is paid incorrectly and by how much.
Reconciled with POS Details:
These orders and their respective amounts match in the DotPe report and the POS reports. Hence, they are said to be reconciled. So, you have been correctly paid for these orders.
Less payment Recorded in POS
Shown here are the orders for which a lesser amount is recorded in the POS report than in the DotPereport. Hence you have been Overpaid on these orders
More Payments Recorded in POS
These are the orders for which the payment amount recorded in the POS report is more than the amount recorded in the DotPe report. So, you have been underpaid for these orders.
DotPe Instore – Bank Reconciliation
The DotPe Settlement is linked with the Bank Statement for comparison so that we can check DotPe has rightly transferred the amount to your bank account.
DotPe Transactions Found in Bank
These are the transactions that are recorded in the DotPe Settlement report and in the Bank statement. So,it means that DotPe has rightly transferred these payments to your bank account.
DotPe Transactions Not Found in Bank
Shown here are the transactions that are recorded in the DotPe Settlement report but are not reflected in the bank statement. So, it means that these payments were not completed correctly by DotPe.
So Cointab fully automates the Reconciliation of DotPe Transactions process for you. It automatically loads data in various input formats such as PDF, XLXS, CSV etc. without any manual effort. The software links reports so that you can easily compare reports and reconcile data. The reconciliation result then displayed after data cleaning makes it easier for finance teams to analyze the results and track each payment made in-store.
