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)

Sort by

Suggested answer

Ramesh Kumar 7,549 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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. 22,340 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

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,891 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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... 26,108 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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 1,825 Super User 2026 Season 1

#2

YUN ZHU 967 Super User 2026 Season 1

#3

Teagen Boll 652 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans