Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Bank Reconciliations s...
Small and medium business | Business Central, N...
Answered

Bank Reconciliations showing a difference when there is none (for the past 2 weeks only)

(0) ShareShare
ReportReport
Posted on by Louise H 35

We use BC version 20 (Germany) and have had an issue in a number of our Country Offices for the past few weeks whereby Bank reconciliations show a 'difference' even the GL balance and bank statement balance are in agreement.  It is possible to post the reconciliation, but the 'test report' that we use as evidence of the Bank reconciliation (since the bank statement report is not sufficient) still shows this difference. Does anyone know how we can get rid of this 'difference'?

pastedimage1659012769286v2.png

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,021 Moderator on at
    RE: Bank Reconciliations showing a difference when there is none (for the past 2 weeks only)

    Hi Louise,

    You can give feedback to Microsoft through this site and suggest improvements to the system. Microsoft monitors all the product ideas closely and other users can vote for them.

    experience.dynamics.com/.../

  • Louise H Profile Picture
    Louise H 35 on at
    RE: Bank Reconciliations showing a difference when there is none (for the past 2 weeks only)

    Thanks for replying - that's really helpful.  

    If I switch to using the Bank Statement Report (which is better than it was before), I can't get a list of the 'outstanding bank transactions' or 'outstanding checks' which are shown at the top on the right hand side (in my example above these are shown as zero....but will not always be).  This is why I had always advised our offices to print the 'test report' before posting it.  Now the test report doesn't look good to auditors (the balance not being zero is confusing), and the alternative doesn't show the outstanding items, again as needed by auditors.  

    Is there a way to feedback to Microsoft that this is not how a Bank Reconciliation should be shown?  This is causing quite some serious headaches for our offices around the world!

  • AD-22040756-1 Profile Picture
    AD-22040756-1 632 on at
    RE: Bank Reconciliations showing a difference when there is none (for the past 2 weeks only)

    The reason there is a difference, but it still lets you post the bank rec., is because when this field is calculated on the report it starts with the total balance on the bank account and it ignores statement date. Essentially the difference of 445,138.22 are transactions on the bank subledger that occurred after the statement date.

    There is no way of getting rid of it other than customizing the report to change the calculation. In version 20 Microsoft updated the bank statement report and it looks very similar, I would use that one as it will not have this difference field.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,141 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,881 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans