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

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,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans