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

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,
 

 
  • Suggested answer
    Valentin Castravet Profile Picture
    32,808 Super User 2026 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
    104,136 Super User 2026 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 633 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 419 Super User 2026 Season 2

#3
Teagen Boll Profile Picture

Teagen Boll 236 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans