Skip to main content

Notifications

Announcements

Forum Structure Changes Complete – Update Your Subscriptions!
News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Bank Reconciliation Ma...
Small and medium business | Business Central, N...
Suggested answer

Bank Reconciliation Many to Many Matching

(1) ShareShare
ReportReport
Posted on by KC-23051329-0 4
Does anybody have a work around for matching multiple Bank Statement items with multiple Bank postings as there is a Error warning that this is not possible. We are trying to bring previously manual reconciled Bank accounts upto date for a closed year so do not want any GL postings. 
 
Many thanks
Kevin
Categories:
Business Central
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 23,733 Super User 2024 Season 2 on at
    Bank Reconciliation Many to Many Matching
    Got it, thanks for the explanation. Your solution is a good one.
     
     
  • Suggested answer
    KC-23051329-0 Profile Picture
    KC-23051329-0 4 on at
    Bank Reconciliation Many to Many Matching
    Hi Valentin.
     
    When we have paid our employees monthly salary (net of taxes and other deductions) on the Bank Statement they were paid individually, along with Vendor Account Expenses payments or deductions but the posting the Bank Account Ledger entries were a consolidated Net Payroll payment plus the individual Vendor Account Payments - hence there are many to many entries.
     
    We have tried posting the difference to the GL even though it was in a closed year, but it did not post the reconciliation. The solution we are going for is to delete the individual lines in the imported bank statement and replace with a combined single Payroll Statement which we can then match to the Bank Account Payroll Journal and the Vendor Expense Payments i.e. the 1 to Many match. 
     
    Thanks for your interest   
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 71,565 Super User 2024 Season 2 on at
    Bank Reconciliation Many to Many Matching
    Unfortunately, this cannot be done.
    Unless you split Bank Account Ledger Entries and Bank Statement Lines before.
     
    PS: Missing a feature? Post or vote for ideas on: aka.ms/BCIdeas
     
     
    Thanks.
    ZHU
     
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 23,733 Super User 2024 Season 2 on at
    Bank Reconciliation Many to Many Matching
    As far as I know the system only allows many to one matching. So unfortunately, its not possible. Also, posting a bank rec. will not create GL entries, or do you mean that you might have to create GL entries to overcome the system not allowing many to many matching?
     
    But can i confirm why you need many to many matching, even if its for previously manually reconciled bank recs, what transactions do you have, or how were they entered that need many to many? Usually its many to 1, either 1 bank statement entry to many GL entries, or the other way around - one GL entry to many bank statement entries. 
     

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

News and Announcements

Forum Structure Changes Complete – Update Your Subscriptions!

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,275 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans