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

Notifications

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... / Old Bank Acc. Ledger E...
Small and medium business | Business Central, N...
Suggested Answer

Old Bank Acc. Ledger Entries Stuck in Bank Reconciliations

(0) ShareShare
ReportReport
Posted on by MinaDang 5

Hi,

I have some old and 'matched' ledger entries in the bank reconciliation that seems to be stuck and just rolls forward every single month in the bank recs. These transactions have been stuck there since I started taking over bank reconciliations from a previous accountant but they do not know what had happened, how it got stuck and how to get rid of it. You can't remove match them either. Doesn't really affect me in any way except it just sits there. it would just be nice if it clear away. Would be great if anyone knows how to get rid of them.

5658.pastedimage1629934552531v1.png

Thanks!

Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    JAngle 133 on at

    If you use “about this page“ on that page part - ctrl+alt+windows key+f1 when cursor is set in that part of the page.

    This should reveal which bank account reconciliation the applied entries relate/related to. If it doesn’t exist anymore for some reason. If you note down the current “Statement No.” on the bank account and then change it to the number before whatever you found from the unwanted applied entries.

    Create a “new” bank reconciliation with the “old” number. This step is only necessary if you don’t have the old one.

    Try to post the bank rec.

  • MinaDang Profile Picture
    MinaDang 5 on at

    Hi Josh, thank you for responding. Had to wait to close off the month of August before I tried this - just in case. I was able to use ctrl+alt+windows key+f1 on one of the entries which did reveal which "Statement No." it was from. When I open a new "Bank Acc Rec" I cannot change the Statement No because it will come up with an error staying that it already exists. So the Statement would have been posted and closed off at that time.

  • Suggested answer
    Kavisha Profile Picture
    Kavisha 310 on at

    Hi Mina

    These looks to be all reversals, so their sum should be 0 (Zero). 

    Make a fake Bank Acc. Reconciliation. 

    Select the bank account and the statement date as 31/12/2017  (To only bring the lines which needs to be cleared on the right side). Hope they are all in 2017 year. if not then put the date accordingly as per the latest entry's to be cleared. Select Suggest lines and click OK. Check the system should only bring the lines on your left side (Bank statement lines) which needs to be cleared. 

    Balance last statement will be auto populated from last statement. Let it be.

    Copy the Balance last statement and put in the Statement ending balance. 

    Once the total Balance = Statement ending balance, post the Bank recon. 

    Note :- All the outstanding entries from 2017 should sum to 0 (as it looks in the screenshot)

    Hope that helps. 

    Regards

    Kavisha Ahuja

  • MinaDang Profile Picture
    MinaDang 5 on at

    Hi Kavisha,

    Thank you for your reply! When I created a new Bank Acc. Rec, I changed the Statement Date to 31/12/2017 (also tested 01/06/17 and 30/06/2017). The lines that appear on the right side are the matched 2017 entries (the ones that are stuck), 2 x August entries and new entries for September 2021. If I click Suggest Lines with Ending Date of 01/06/17 or 30/06/17 or 31/12/17, nothing appears.

    If I change the Statement Date to 31/08/21 (last entry date, and had closed off bank recons for August as well) and click suggest lines from 01/06/17 to 31/08/21 or just an ending date of 31/08/21, the 2 x August entries was brought over to the left side and nothing else.

    Wondering if it could be the version I'm on or if the entries were relating to a customer and was matched to an invoice and therefore can not be unmatched?

    Thanks!

  • Kavisha Profile Picture
    Kavisha 310 on at

    Hi Mina

    As they are stuck with another statement no. , From bank acc. ledger entries running from the dev environment , Make the fields blank (Statement No. and statement Line no.) and the run the above process from bank recon again as suggested before)

    This is required so that those entries can be properly closed. 

    regards

    Kavisha

  • John Murdock Profile Picture
    John Murdock 20 on at

    I have this same issue.  How to you clear the statement # and lines?   Thank you.

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…

Congratulations to the November 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,135

#2
YUN ZHU Profile Picture

YUN ZHU 733 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 612

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans