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

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 Reconciliation Issue
Small and medium business | Business Central, N...
Answered

Bank Reconciliation Issue

(2) ShareShare
ReportReport
Posted on by Peter Taylor FP 96

I have a Bank Account ledger entry that is showing as Closed (open = unticked), but I have NOT done a bank reconciliation for that transaction, so how can it show as closed? This means I cannot reconcile my bank account as the transaction is not showing on the right hand side of the bank reconciliation page (because the system is saying it is closed). I only have 1 bank account statement showing for the account (the opening balance bank reconciliation) and the transaction I am querying is NOT on that bank statement. Why is it showing as closed when I have not done a bank reconciliation for that transaction?

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels Microsoft Employee on at

    Hello,

    If you do not get further traction from the community, feel free to raise this issue to Microsoft via your partner or CSP.

    Thanks.

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 235 User Group Leader on at

    Check the fields on the ledger entry for statement number.

    Check the status, was it voided.

    BC doesn't just close a ledger entry, so it somehow was closed by a transaction.

  • Suggested answer
    Amit Profile Picture
    Amit 2,563 on at

    Hi,

    Refer the below link.

    https://learn.microsoft.com/en-us/dynamics365/business-central/bank-how-reconcile-bank-accounts-separately

    Regards

    Amit Sharma

    www.erpconsultors.com

  • Peter Taylor FP Profile Picture
    Peter Taylor FP 96 on at

    Hi, thanks for your feedback. The statement no. is '3', but there is no bank statement no. 3 for that account? Could it have been deleted?

  • Verified answer
    Peter Taylor FP Profile Picture
    Peter Taylor FP 96 on at

    As I thought, this was found to be a bug in standard MS code. The transaction had been reconciled, then an 'Undo' bank reconciliation was done but the transaction was not re-opened, which it should have been. MS support kindly gave me a utility (app) to re-open the entry (and delete the statement number on the bank account ledger entry), and i just used it to re-open the transaction and now i can reconcile it again.

  • DLDlutavia Profile Picture
    DLDlutavia 14 on at
    How can I obtain this utility?  Is it in the Partner Center or do we need to go through support?
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 23,157 Super User 2026 Season 2 on at

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 Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 750 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 534 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 287 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans