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 vendor, customer, and bank account ledger entries based on a matching of data on payments with data on the 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.

Any open bank account ledger entries related to the applied vendor or customer ledger entries will be closed when you choose the Post Payments and Reconcile Bank Account action. This means that the bank account is automatically reconciled for payments that you post with the 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.

ToSee

Set up the rules that govern if payments are automatically applied to their related open vendor, customer, and bank account ledger 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 vendor, customer, or bank account ledger 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