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... / Reconcile 2 Bank State...
Small and medium business | Business Central, N...
Answered

Reconcile 2 Bank Statement Lines to 1 Bank Account Ledger Entry

(0) ShareShare
ReportReport
Posted on by KAY15 50

In Business Central 365, I have successfully reconciled two Bank Account Ledger Entries to a single Bank Statement Line. But, I cannot figure out how to do the reverse.

I have 2 Bank Statement Lines:

-$125,000

-$24,876.86

I need to reconcile to a single Bank Account Ledger Entry:

-$149,876.86

When I try to select multiple lines on the Bank Statement side and match manually to the Bank Account Ledger Entry, 365 only reconciles a single Bank Statement Line leaving a remainder.

I'm missing something.

  • tlhgolfer Profile Picture
    tlhgolfer 12 on at
    RE: Reconcile 2 Bank Statement Lines to 1 Bank Account Ledger Entry

    Thank you so much for the post!.  I am going to do a journal that will debit the bank and then do the entries in detail.

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 234 on at
    RE: Reconcile 2 Bank Statement Lines to 1 Bank Account Ledger Entry

    Hi,

    One statement line can be matched to more than one bank ledger entry but vice versa is not possible (that is your requirement).

    Another (not very appropriate) way to do is to remove these 2 bank statement lines and create one bank statement line instead with sum of those 2. Update Description of new statement line that it is sum of two lines for future reference.

    Regards,

    Bilal Haider  

  • tlhgolfer Profile Picture
    tlhgolfer 12 on at
    RE: Reconcile 2 Bank Statement Lines to 1 Bank Account Ledger Entry

    Is the only way to do this to reverse the entries?

    That seems strange looking for a work around maybe.

    Thanks!

  • Community Member Profile Picture
    Community Member on at
    RE: Reconcile 2 Bank Statement Lines to 1 Bank Account Ledger Entry

    Reconcile the general ledger balance to the bank balance by subtracting all outstanding checks shown in the ledger but not yet reflected in the bank statement from the bank total. Add any outstanding deposits shown on the ledger but not yet reflected on the bank statement to the bank balance total.

  • Suggested answer
    JAngle Profile Picture
    JAngle 63 on at
    RE: Reconcile 2 Bank Statement Lines to 1 Bank Account Ledger Entry

    The postings should marry up. That is part of the matching logic. Use the transfer to journal feature for those lines and reverse the existing one so you have the same as the statement.

  • Lucas Boewood Profile Picture
    Lucas Boewood on at
    RE: Reconcile 2 Bank Statement Lines to 1 Bank Account Ledger Entry

    Moving to Business Central forum.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,892 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,772 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans