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 :
Small and medium business | Business Central, N...
Suggested Answer

Bank statement opening and ending balance error

(1) ShareShare
ReportReport
Posted on by 130

Hi All - I am facing an issue after posting my bank reconciliation statement it's automatically taking some wrong amount. Now I am on 65 number statement since the last two statements having the issue. attached the screenshot. Please need your help. Thanks

pastedimage1625250806334v1.png 

I have the same question (0)
  • Bilal Haider Profile Picture
    442 on at

    Hi,

    Can you please elaborate. How you are getting issue. What is statement balance and what it should show?

  • Rajendra sahu Profile Picture
    130 on at

    Just I try to undo statement no.63 it has the same issue. Opening balance with 9,091.61

    pastedimage1625253382563v1.png

  • Rajendra sahu Profile Picture
    130 on at

    It should show as no.62 ending balance 132,719.93 then it should be opening balance of 63. but it shows 9091.61 which is the ending balance of sta no.9. just now I tried to undo statement no.63 again it's opening balance shows 9091.61

  • Suggested answer
    Bilal Haider Profile Picture
    442 on at

    Yes, it should show 132,719.93 as Balance Last Statement. Can you check Bank Ledger Entries and balance of related Bank Account?

    Are you sure no body has updated something in tables.

  • Rajendra sahu Profile Picture
    130 on at

    Nobody has updated I am sure. Any new statement creates or undo any old one its opening balance automatically generates with 9091.61 after post..even after changing the last statement balance amount. Why it's opening balance always with 9091.61. I think if I solve this one then all will be good.

  • Bilal Haider Profile Picture
    442 on at

    On reconciliation page are you putting balance last statement manually or system picks automatically. And what is that?

  • Suggested answer
    Bilal Haider Profile Picture
    442 on at

    By default when you create a new bank account reconciliation system picks the balance from the related bank account and populates its value in balance last statement. Can you check balance of your bank account UNITED OPERATING?

  • Rajendra sahu Profile Picture
    130 on at

    Generally, it takes automatic but for the last two statements manually putting due to facing this issue

  • Suggested answer
    Bilal Haider Profile Picture
    442 on at

    May be your bank account BANKUNITED OPERATING has a balance of 9091.61 that is why system is picking it as balance last statement.

  • Rajendra sahu Profile Picture
    130 on at

    No. That's ok. There is something else

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,091 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,032 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 946 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans