BeyondERP.Newsletter
Menu

Setup step on the Advanced bank reconciliation data upgrade page · Cash and bank management

Upgrade reconciliation data for Modern bank reconciliation

Convert existing advanced bank reconciliation data before the first reconciliation with Modern bank reconciliation.

Business process
Perform advanced bank reconciliation in Dynamics 365 Finance
Menu item
BankModernReconciliationUpgradeWizard
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA wizard that upgrades existing bank reconciliation data so that it works with the Modern bank reconciliation feature.
What you do hereUse this wizard to upgrade bank statement transactions marked as new, matching rules and matched transactions, and to review the result, before you start a new bank reconciliation after the feature is turned on.
ExampleFor example, before turning on Modern bank reconciliation BEAT reconciles its two statements that still have New lines; it then runs the wizard, which upgrades 12 lines marked as new, 6 matching rules and 3,400 matched transactions, and reviews the result before the next reconciliation.
Advanced bank reconciliation data upgrade page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itAfter the Modern bank reconciliation feature is turned on and before you start the next bank reconciliation.
How oftenOne time, when you move to Modern bank reconciliation.
What the output showsBank statement transactions marked as new, matching rules and matched transactions converted so they work with Modern bank reconciliation, summarized at the Review step. Problems with reconciliation reversal later usually mean statements with new lines weren't reconciled before the switch.

Source: Microsoft Learn

Setup steps on this page

Upgrade reconciliation data for Modern bank reconciliation

Convert existing advanced bank reconciliation data before the first reconciliation with Modern bank reconciliation.

Steps from Microsoft

  1. Go to Cash and bank management > Setup > Advanced bank reconciliation setup > Advanced bank reconciliation data upgrade.
  2. Before you start, reconcile all existing bank statements that have new lines, as Microsoft advises before you enable Modern bank reconciliation.
  3. Read the Introduction step, which lists the data that will be upgraded.
  4. Move with Next through Upgrade 'Mark as new' transactions, Upgrade matching rules and Upgrade matched transactions.
  5. Finish at the Review step and look over the result before you create a new bank reconciliation.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Upgrade 'Mark as new' transactionsConverts statement lines marked as New for Modern bank reconciliation, where Mark new transactions isn't used.Microsoft Learn
Upgrade matching rulesConverts the existing reconciliation matching rules.Checked in Dynamics 365
Upgrade matched transactionsConverts the existing matched transactions.Checked in Dynamics 365
ReviewThe last step, where you check the result before you finish.Checked in Dynamics 365

Common errors and fixes

MessageWhat to do
Reconciliation reversal causes problems after Modern bank reconciliation is turned onReconcile all existing bank statements that have new lines before you enable the feature and run the upgrade. Microsoft Learn

Test checklist

  1. Reconcile all statements that have New lines.
  2. Run the wizard to the Review step and finish.
  3. Open the matching rules and check they are still active.
  4. Create a new bank reconciliation and run the default set.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Upgrade reconciliation data for Modern bank reconciliationReconcile every statement with New lines first, then run the wizard once and review the result before the next reconciliation.Learn advises reconciling statements with new lines before enabling the feature to avoid reconciliation reversal problems.When should the move to Modern bank reconciliation happen?Running the upgrade with statements still holding New lines. Their reversal can then fail.Test: Upgrade keeps rules and matches

Feature management and licence

Feature to turn onModern bank reconciliation (On by default from 10.0.43)
Licence or add-inIn this system 2 roles can open this page, among them Treasurer and Accountant.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: it upgrades the reconciliation data of the current legal entity; matching rules are shared by all legal entities. Microsoft Learn
Can it be undoneNo: Treat the upgrade as one-way: Back and Cancel work only before you finish.
If you change it laterConverts existing advanced bank reconciliation data (statement lines marked as new, matching rules and matched transactions) for Modern bank reconciliation. Microsoft Learn
Technical architect

6Technical

Menu itemBankModernReconciliationUpgradeWizard Checked in Dynamics 365
FormBankModernReconciliationUpgradeWizard Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itTreasurer PaymTreasurerAccountant LedgerAccountantGive people one of these roles. On this system, 2 roles can open this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=BankModernReconciliationUpgradeWizard
Data migrationLoad order: The data upgrade has no data entity in Data management, so it can't be loaded from a file or a configuration template. It converts data already in the environment; run it in each environment after Modern bank reconciliation is turned on.Microsoft Learn
Everyone

8Sources

To cite this step: CB-ABR-010, Upgrade reconciliation data for Modern bank reconciliation. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/CB-ABR-010