Small and medium business | Business Central, N...

Bank Reconciliation Many to Many Matching

(1) Share

Report

Posted on by KC-23051329-0

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:

Dynamics 365 Business Central

I have the same question (1)

All responses (4)

Answers (0)

Suggested answer

Valentin Castravet 31,340 Super User 2025 Season 2 on at

Like (0)

Report

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.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

KC-23051329-0 4 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,340 Super User 2025 Season 2 on at

Like (0)

Report

Got it, thanks for the explanation. Your solution is a good one.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No

Join the conversation

Community site session details

Bank Reconciliation Many to Many Matching

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Bank Reconciliation Many to Many Matching

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates