Opening Balance is 0 when performing first Bank Reconciliation after migration

(1) Share

Report

Posted on by Maria Nastevska

171

Hi everyone,

My client recently migrated to D365 &O and I'm they're currently stuck to do the bank reconciliation as the opening balance is not showing in the account reconciliation page.

When i check the trial balance, the balance is there. We have migrated the Bank OB.

What am I missing?

Account reconciliation page:

TB:

I have the same question (0)

All responses (2)

Answers (1)

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

What is "Bank OB"? Outstanding balance? Does this mean you migrated individual outstanding transactions or just the bank balance?

Was this reply helpful? Yes No
Verified answer

K_G 142 on at

Like (1)

Report

When performing the bank migration, you need to identify the total bank balance that will be migrated. This will be made up of a reconciled amount, and the unreconciled amount.

1. Post a journal for the reconciled amount to the bank.

2. Create a dummy bank statement for the same value as this reconciled amount.

3. Perform a bank reconciliation, matching the single entry from your dummy statement to the bank ledger balance.

Now, for the bank balance made up of unreconciled entries, these need to be posted in an itemised format, this will ensure each entry appears as a separate line in your bank reconciliation worksheet and contains the details needed to perform a successful reconciliation.

4. Post detailed itemised entries for the amount of your bank balance that has yet to be reconciled.

This should now bring your total bank balance up to the correct figure, ensure the correct balance is showing as reconciled, and allow you to perform subsequent bank reconciliations.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Opening Balance is 0 when performing first Bank Reconciliation after migration

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Opening Balance is 0 when performing first Bank Reconciliation after migration

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates