Dynamics Community Forum Thread Details

Auto Bank reconciliation with Check ledger entries

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.

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

Quick Links

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