web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Bank account reconcili...

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

Answered

Bank account reconciliation using External doc. number

(4) Share

Report

Report

Posted on by Frank Pellerin

176

We have a case where our system had entered multiple payments entries in cash receipt journals for invoice and associated finance charge memo (Theses entries has been created using API).
On the other hand, the client has made a single payment for the total amount of associated entries.

We would like to reconciliate journals entries (3 entries in my example) with payment (1 payment in my example) by using the external document number.

I tried to use "Match automatically" function to match entries, but system always return 0 match…

In the "Data exchange definition" associated to the bank account, I've tried to adjust the field mapping and set it up to table #271… without any success…

Any idea to reconciliate automatically transactions ?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (2)

Suggested answer

Ramesh Kumar 7,527 Super User 2025 Season 2 on at

Like (2)

Report

Hi Frank,

From what I have seen Bank reconciliation in Business Central isn't smart enough to match one-to-many transactions automatically. You'll need to do it manually and again you appsource products to automate.

https://www.youtube.com/watch?v=StTRSlqGQ4Y&ab_channel=WesternComputer

https://learn.microsoft.com/en-us/dynamics365/business-central/bank-how-reconcile-bank-accounts-separately

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,275 Super User 2025 Season 2 on at

Like (3)

Report

if this provide some hint: https://community.dynamics.com/forums/thread/details/?threadid=4e9a3c02-47dd-4f1d-b306-669b2504a4d7

https://forum.mibuso.com/discussion/41943/external-document-no-and-bank-reconciliation

Was this reply helpful? Yes No
Verified answer

Jainam M. Kothari 15,631 Super User 2025 Season 2 on at

Like (2)

Report

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/bank-how-reconcile-bank-accounts-separately

https://learn.microsoft.com/en-us/dynamics365/business-central/bank-reconciliation-with-copilot?tabs=fromlist

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,157 Most Valuable Professional on at

Like (2)

Report

Hi, good day
I hope this can help you, and give you some hints.

Bank Reconciliation matches very few transactions - Sharing The Righter Way - Cynthiapriebe.com

Reconcile payments using automatic application - Business Central | Microsoft Learn

Best Regards
Gerardo

Was this reply helpful? Yes No
Verified answer

Frank Pellerin 176 on at

Like (2)

Report

I was able to do my reconciliation by using Copilot action :)

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 3,229

#2

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

#3

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans