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

Announcements

News and Announcements icon
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
    668 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
    IB-29041624-0 Profile Picture
    1,191 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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,344 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,742 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,231

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans