web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
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 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

I have the same question (0)
  • AD-22040756-1 Profile Picture
    642 on at

    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.

  • Louise H Profile Picture
    35 on at

    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!

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,111 Moderator on at

    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/.../

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,135

#2
YUN ZHU Profile Picture

YUN ZHU 733 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 612

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans