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

Bank account reconciliation using External doc. number

Like (4) Share

Report

Posted on 25 Mar 2025 12:56:14 by Frank Pellerin

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

All responses (4)

Answers (0)

gdrenteria 16,284 Most Valuable Professional on 26 Mar 2025 at 10:37:14

Like (1)

Report

Bank account reconciliation using External doc. number

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
Suggested answer

Jainam M. Kothari 3,007 on 26 Mar 2025 at 05:14:04

Like (1)

Report

Bank account reconciliation using External doc. number

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
Suggested answer

Khushbu Rajvi. 11,942 Super User 2025 Season 1 on 26 Mar 2025 at 04:52:40

Like (2)

Report

Bank account reconciliation using External doc. number

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
Suggested answer

Ramesh Kumar 1,949 on 25 Mar 2025 at 14:58:13

Like (1)

Report

Bank account reconciliation using External doc. number

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.

Community site session details

Bank account reconciliation using External doc. number

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Announcing Our 2025 Season 1 Super Users!

Kudos to the February Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

Bank account reconciliation using External doc. number

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Announcing Our 2025 Season 1 Super Users!

Kudos to the February Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates