web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Auto Bank reconciliation with Check ledger entries

(0) ShareShare
ReportReport
Posted on by

What is the process to match Check ledger entries in the Auto bank reconciliation process?

When we use Auto match or Match manual function it doesn't work. 

The 2nd note section in below link says to use Apply function. but I don't find an Apply function on the bank reconciliation window.

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

We can match the document by manually changing the type to Bank Account Ledger entry.

But if I do that,  the Test report gives wrong amounts in Outstanding Payments and Outstanding Transaction fields.  

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at

    Gayan,

    This requires a little setup on the Matching Rule/Confidence and also any Text-to-Account mapping for specific transactions. Here is a few links to helpful documents to get you started to make sure you have setup Auto-Reconcile:

    Apply payments to open customer or vendor ledger entries by importing a bank statement, and reconcile the bank account when all payments are applied. Reconcile Payments Using Automatic Application
    Manually apply payments by viewing detailed information about matched data and suggestions for candidate open entries to apply payments to. Review or Apply Payments After Automatic Application
    Resolve payments that cannot be applied automatically to their related open ledger entries. For example because the amounts differ, or because a related ledger entry does not exist. Reconcile Payments that Cannot be Applied Automatically
    Link text on payments to specific customer, vendor, or general ledger accounts to always post recurring cash receipts or expenses to those accounts when no documents exist to apply to. Map Text on Recurring Payments to Accounts for Automatic Reconciliation
    Set up the rules to govern how payments/bank transactions should be automatically applied to their related open ledger entries when you use the Apply Automatically function on the Payment Reconciliation Journal page. Set Up Rules for Automatic Application of Payments

    https://docs.microsoft.com/en-us/dynamics365/business-central/receivables-apply-payments-auto-reconcile-bank-accounts

    Hope all these links help. Just remember to setup Payment Application Rules. Then try testing the Automatic Application or manually application steps.

    Thanks,

    Steve

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

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,457

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 742 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 669 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans