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

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Inaccurate Bank Reconciliation

(5) ShareShare
ReportReport
Posted on by 2,896
Hi:
 
In Business Central (BC), I'm trying to set up a January 2025 bank reconciliation.
 
This will be the first reconciliation conducted in BC, for this bank account.  BC thinks there is a reconciliation done, since the statement ending balance has $347,866.10 and it's starting with statement number 3 in the "Bank Account Reconciliations" screen.
 
The bank account that I'm trying to reconcile for is not showing up on the "Bank Account Statements" screen as reconciled.
 
There was a report posted for this account that I undid.  It no longer appears in the bank account statement list.
 
There's nothing in the list as completed statements.  So, when I started to conduct a new January bank account reconciliation, there was not one appearing in the list.
 
When I went to do a new one, the statement number was 2 and all of January items are gone to reconcile.  I deleted it and redid another one and, now, it is statement number 3.  The "balance last statement" has a balance of $347,866.10 which was January’s ending balance.
 
BC thinks a statement was posted, but it isn’t appearing on the posted bank account statement list.
 
I did try going into the Bank Account Card, changing the Last Statement No. and the Last Statement Balance to $0, and created a new reconciliation Statement No. 1.
 
But, on the right-hand side of the reconciliation, there's not enough data appearing. 
 
How do I fix this?
 
Thanks!
 
John
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    92,733 Super User 2025 Season 2 on at
    Inaccurate Bank Reconciliation
    Hi, re-run "Suggest Lines..." will any data be generated?
     
    Hope this can give you some hints.
    Thanks.
    ZHU
  • Suggested answer
    OussamaSabbouh Profile Picture
    366 on at
    Inaccurate Bank Reconciliation
    Hello,

    Can you try the below:
    First, you have to post all of your January transactions into BC using the journals.
    Once all those transactions are posted, do exactly what you tried before: go to the Bank Account Card and manually reset the Last Stmt. No. and Balance Last Statement back to zero.
    After that, create your new reconciliation. It will start fresh as statement #1 with a $0 balance, and all the transactions you just posted should now appear.

    Regards
    Oussama

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,308

#2
Sumit Singh Profile Picture

Sumit Singh 2,798

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,793

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans