Reconciliation Of Microsoft Dynamics NAV with Payment Gateways

Microsoft Dynamic NAV is an enterprise resource planning application that looks after business intelligence, warehouse management, retail and ecommerce, financial management, human resources, service management, project management and other supply chains. It is a business management solution for small organizations, mid-sized organizations and local subsidiaries of large international groups that automates and streamline business processes.

ERP reconciliation system differs from Cointabs software as the ERP systems usually track the number of orders placed, dispatched orders, returned orders along with the amount paid or refunded whereas Cointab understands the importance of connected business ecosystem, and hence the software not only tracks these order reports but also with the help of our software you can verify if all these orders and the final settlement amount paid by the vendors are correct or not. It compares your MS Dynamic NAV ledger report and your Payment gateway report and reconciles the data. This enables you to manage the financial information and have accurate financial reports for better decision making.

Reports required for reconciliation

  • Microsoft Dynamic NAV ledger report


  • Payment gateway report


  • Reconcile Microsoft Dynamics NAV with Payment Gateway

    Cointab’s software compares both the Microsoft dynamic NAV report with Payment gateway report and checks if the payments recorded are present and recorded correctly in both these reports. Incase of the payment being underpaid you can claim the amount from the payment gateway partner.

    Microsoft Dynamics NAV
    Total transactions

    These are the total transactions recorded in the Microsoft Dynamics NAV report.

    Reconciled with Payment gateway

    These are the transactions that are present in the ERP report as well as the payment gateway report.

    More amount received from the payment gateway

    These are the reports that show that the amount found in the payment gateway is more than the amount given in the Microsoft Dynamic NAV report.

    Not found in the payment gateway report

    These are the payments that are not recorded in the payment gateway report but are present in the Microsoft dynamics NAV report.

    Payment Gateway with Microsoft dynamic NAV Reconciliation
    The software links the payment gateway report with the Microsoft dynamic NAV report to get the transactions accurately.

    Total Payment gateway report transaction

    These are the total transactions reported in the payment gateways reports.

    Reconciled with internal data

    These are the reports that show the transactions are present in both, ERP reports as well as the Payment gateway reports and the amount matches in both these reports.

    Less Amount Recorded in Internal Data

    This report shows that the transactions of the amount recorded are less in the Microsoft Dynamics NAV report than in the payment gateway report.

    More Amount Recorded in Internal Data

    In case case, that the transactions where the amount recorded are more in the Microsoft Dynamics NAV report than in the payment gateway report

    Not found in Internal Data

    This report shows that the transactions that are present in the payment gateway reports but not in the Microsoft Dynamics NAV report.

    Our reconciliation software simplifies reconciling Microsoft Dynamics NAV reports with payment gateway reports. It automatically loads data via API, SFTP, and email, cleaning and applying logic conditions. The reconciliation results help finance teams track payments received from payment gateway partners, highlighting underpaid amounts for claims. This eliminates manual labor and ensures timely payment processing.

    Start Reconciling
    with us

    Scroll to Top