Reconcile Payments Automatically

You must routinely reconcile your bank, receivables, and payables accounts by applying payments recorded in your bank account to their related unpaid invoices and credit memos or other open entries in Microsoft Dynamics NAV, which you then post as payment applications.

In the Payment Reconciliation Journal window, you can import a file with bank transactions to quickly register the payments in Microsoft Dynamics NAV. During import, or when you activate it, an automatic application function will apply the payments to their related open entries based on a matching of data on payments with data on open entries. You can use various functionality to review and change automatic applications and to make manual applications before you post the payment reconciliation journal.

Note

If you do not reconcile payments based on imported bank transactions, or you do not need automatic application, you can perform the same tasks manually in the Payment Registration window. In this window you can use a simple overview of payments made, lump-sum posting, and other functions to find and create related sales documents. For more information, see Reconcile Customer Payments Manually.

The following table describes a sequence of tasks, with links to the topics that describe them. These tasks are listed in the order in which they are generally performed.

To See

Set up the rules that govern if payments are automatically applied to their related open entries when you use the Apply Automatically function in the Payment Reconciliation Journal window.

How to: Set Up Rules for Automatic Application of Payments

Import a bank statement file into the Payment Reconciliation Journal window as the first step in reconciling payments or into the Bank Acc. Reconciliation window as the first step in bank reconciliation.

How to: Import Bank Statements

Import a bank statement file into the Payment Reconciliation Journal window and automatically apply the involved payments to their related open entries.

How to: Reconcile Payments Using Automatic Application

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.

How to: Map Text on Recurring Payments to Accounts for Automatic Reconciliation

Manually apply payments by viewing detailed information about matched data and suggestions for candidate open entries to apply payments to.

How to: Review or Apply Payments After Automatic Application

See Also

Concepts

Process Customer Payments
Manage Receivables