Apply payments automatically and reconcile bank accounts

Path: Business functionality > Finance > Manage receivables > Apply payments automatically and reconcile bank accounts · tier official · system finance · narrative reviewed (checked by Opus)

Overview

This section covers how to match bank transactions to open invoices and reconcile bank accounts using the Payment Reconciliation Journal. You import a bank statement or use a bank feed. Business Central then applies payments automatically to open customer and vendor entries, using matching rules and a match confidence level.

Two pages give the overall process and the automatic application steps. The rules page explains how to set matching criteria, such as document number, related party and amount tolerance, along with priority sorting and confidence levels. The Text-to-Account page covers automatic posting of recurring payments to specified accounts when match confidence is Low or Medium. Two more pages cover what to do when automatic application is not enough. You can review and reapply payments on the Payment Application page, or use Transfer Difference to Account for payments that have no matching document or have amount differences.

Start with “Reconcile bank accounts and apply payments” for the overview, then “Reconcile payments using automatic application” for the working steps. Read the rules page if matches are wrong or missing.

Key points

• Payments are reconciled on the Payment Reconciliation Journal, after a bank statement import or bank feed.
• Automatic application matches payments to open customer and vendor entries and assigns a match confidence.
• Payment application rules set matching criteria: document number, related party, amount tolerance, with priority sorting and confidence levels.
• Text-to-Account mapping posts recurring payments directly to debit and credit accounts when match confidence is Low or Medium.
• The Payment Application page lets you review automatic results and manually apply or reapply payments, including split payments.
• Manual application accounts for currency conversion, payment discounts, and a candidate lookback days parameter.
• Transfer Difference to Account handles payments with no matching document or with amount differences.

Learn pages

• Reconcile bank accounts and apply payments: Outlines tasks to reconcile your bank, receivables, and payables accounts, post cash receipts or expenses, and apply payments automatically.
• Reconcile payments using automatic application: Describes how to reconcile payments using automatic application to apply payments or cash receipts to related open entries.
• Review and apply payments manually after automatic application: After payments are applied automatically, you can review all the entries for a payment and manually reapply those that were applied incorrectly.
• Rules for automatic application of payments: Read about how to set Up Rules for the Automatic Application of Payments on the Payment Application Rules page.
• Setting up Text-to-Account mapping for recurring payments: Link text on payments with specific accounts, so that payments are posted to the accounts when you post the payment reconciliation journal.
• Using the transfer difference to account feature to reconcile payments: Describes how to process payments that can’t be applied to a document, for example, when an exchange rate causes amounts to differ.

Videos, posts and code changes

Linked by a Haiku matcher with a grounding quote from the item’s summary (link/topics.ts); machine-generated.

• #10376 [Main] Fix unbalanced G/L when a Credit Memo is applied to a rejected/redraw… (code change): “Credit memos applied to rejected bills now post the Rejected Bills Account”
• #10412 Fixes in Excel reports for Aged Accounts. (code change): “Aged Accounts Excel reports now properly handle customers and vendors”
• #10819 [Pmt. Recon. Journal] Re-fire OnAfterGetLedgEntryInfo on proposal fast path (code change): “OnAfterGetLedgEntryInfo event is re-fired during payment proposal creation”
• #8953 [Master]-Aged account receivable EXCEL and Aged account payable EXCEL ignores “Period Count” specified by user. (code change): “Aged Accounts Receivable and Payable Excel reports now correctly respect the Period Count parameter”
• #9673 Bug 643235: Payment Reconciliation Journal does not round imported bank fee amounts (code change): “Payment reconciliation journal posting now rounds imported bank fee amounts”
• Dynamics 365 Business Central – Three ways to post Sales Ledger Cash Receipts in Business Central (community post): “Cash receipts and reconciling them simultaneously when importing bank statements”

Business Central pages and reports

The pages, reports and queries this hub’s Learn pages name (ms.search.form, API reference), joined to the code by exact object id (data/index/docs-objects.json); a page shows the table it runs on.

• Page 389 “Bank Account Statement List” · on Table 275 “Bank Account Statement”
• Page 1287 “Payment Application Review” · on Table 274 “Bank Acc. Reconciliation Line”
• Page 1290 “Payment Reconciliation Journal” · on Table 274 “Bank Acc. Reconciliation Line”
• Page 1291 “Pmt. Recon. Journal Overview” · captioned “Payment Reconciliation Journal Overview” · on Table 274 “Bank Acc. Reconciliation Line”
• Page 1293 “Pmt. Rec. Journals Overview” · captioned “Unprocessed Payments” · on Table 273 “Bank Acc. Reconciliation”
• Page 1294 “Pmt. Reconciliation Journals” · captioned “Payment Reconciliation Journals” · on Table 273 “Bank Acc. Reconciliation”

Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn’s own.