Edit

Share via

Advanced bank reconciliation overview

  • Article

This article describes the flow for the advanced bank reconciliation process. The advanced bank reconciliation feature lets you import bank statements that can be automatically reconciled from within bank transactions.

The advanced bank reconciliation feature lets you import bank statements. The imported bank statement can then be automatically reconciled from within bank transactions. Here are the steps in the advanced bank reconciliation flow.

  1. Set up a bank statement import.

    • Import bank statements through the data entity framework.
    • Three typical bank statement formats are built in: ISO20022, BAI2, and MT940.
    • The functionality can be extended to any format.

  2. Set up a number sequence to use for advanced bank reconciliation, and define the bank reconciliation matching rules.

    • A reconciliation matching rule is a set of criteria that are used to filter bank statement lines and Microsoft Dynamics 365 Finance bank transaction lines during the reconciliation process. Depending on your business practice, you can set up more than one matching rule to automate and optimize your reconciliation process.

  3. Reconcile bank statements with Finance bank transactions.

    • Perform automatic matching and creation of reconciliation journals.
    • View bank statements and Finance bank transactions side by side.
    • Automatically post Finance bank transactions if they appear on a bank statement but don't appear in the Finance app.
    • Generate a reconciliation statement.

Note

As of the 10.0.39 release, a new feature that's named Modern bank reconciliation enhances the capabilities in advanced bank reconciliation. Because modern bank reconciliation is in preview in Finance version 10.0.39, the objects and code that this feature introduces are subject to change before the feature goes to general availability (GA). Therefore, to help provide a better functional experience and address feedback from users, breaking changes might be introduced. The expectation is that the following classes, forms, and tables won't be customized.

Classes:

  • BankReconciliationHeaderReconcileDP
  • BankReconciliationHeaderUnreconDP
  • BankReconciliationLineReconcileDP
  • BankReconciliationLineUnreconDP

Forms:

  • BankAutomationReconciliationWorksheet
  • BankAutomationStatementForm
  • BankAutomationStatementGenerateVoucherDialog
  • BankAutomationStatementMatchingRelationPreviewFormPart
  • BankAutomationStatementStatusStatisticsCardFormPart
  • BankAutomationStatementUnmatchedCardFormPart
  • BankStatementLineDetails
  • BankBridgingInquiryV2

Tables:

  • BankReconciliationElectronicReportDocumentTmp
  • BankReconciliationElectronicReportStatementTmp