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

How to reconcile a bank ledger entries that are open more than a year?

(1) ShareShare
ReportReport
Posted on by 184
Hi Everyone,
 
Good evening.
 
What is the best way to clear out old G/L entries still showing as bank reconciliation open items.
 
Most of them have a debit and credit that canceled each other out.  Let me know what is the cleanest way to do you.  I have already did the December 2023 Bank Rec so let me know if it’s best that delete it and start over.
 
Please share us your thoughts.
 
Thanks,
 

 
I have the same question (0)
  • Suggested answer
    Valentin Castravet Profile Picture
    31,340 Super User 2025 Season 2 on at
    You can add those reversed entries to a bank rec. to clear them out. This can either be done in your new back rec., or you can reopen and do it in December's bank rec. This is how it would work:
     
    1. In a bank rec. select Suggest Lines
     
     
    2. Select your dates and ensure the Exclude Reversed Entries is not checked
     
     
    3. This will populate the left pane, the Bank Statement Lines with transactions from your bank account ledger entries, and will include the reversed entries.
     
    The reversed entries in the Bank Statement Lines will also be reconciled automatically with the reversed entries in the Bank Account Ledger Entries pane (the 2 green lines in my screenshot). And when you run Suggest Lines, you can delete all the transactions you don't need that were populated. Here is my example, where i brought 2 entries that make up a reversed transaction:
     
     
     
    Valentin Castravet
    Zander ERP Services
  • Jaunt Profile Picture
    184 on at
    Hi Valentin,
     
    Thank you for your prompt response.
     
    The aforementioned process is really helpful. However, I wanted to confirm 2 things with you.
     
    When I create a new reconciliation to match those entries, then the Balance Last Statement and Statement Ending Balance should be 'Zero'? 
     
    Also please confirm that it will not affect the balance of posted reconciliations.
     
    Thanks.
  • Jaunt Profile Picture
    184 on at
    Hi Valentin,
     
    Can I have an update for my previous comment? Please.
     
    Thanks & Regards,
    Jaunt
  • Suggested answer
    YUN ZHU Profile Picture
    95,331 Super User 2025 Season 2 on at
    Hi, how about Reverse it directly from Bank Account Ledger Entries?
     
    Hopefully other experts can give you better advice.
     
    Thanks.
    ZHU

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 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans