Payment Reconciliation Journal (window)

Open the Payment Reconciliation Journal window.

Specifies payments, either incoming from customers or outgoing to vendors, that have been recorded as transactions on your electronic bank site and that need to be applied to their related open entries. A payment reconciliation journal is related to one bank account that reflects the electronic bank site where the payment transactions are recorded.

You perform the following main activities in the Payment Reconciliation Journal window:

Import files with bank transaction for payments that have been made to or from your bank account and then automatically apply the payments to their related open entries. The automatic applications are mere suggestions until you post the lines in the journal. For more information, see How to: Reconcile Payments Using Automatic Application.
Review and manually apply payments that were applied automatically to wrong open entries or not applied at all. From the Payment Reconciliation Journal window, you open the Payment Application window to use various functionality to get detailed information about matched data and suggestions for candidate open entries to apply payments to. For more information, see How to: Review or Apply Payments After Automatic Application.

The automatic applications are made based on payment application rules that are defined in the Payment Application Rules window. Here you choose which types of data on a payment reconciliation journal line must match with data on one or more open entries before the related payment is automatically applied to the open entries. The quality of each automatic application is shown as a value of Low to High in the Match Confidence field in the Payment Reconciliation Journal window according to the payment application rule that was used. For more information, see How to: Set Up Rules for Automatic Application of Payments.

In the Text-to-Account Mapping, which you can open from the Payment Reconciliation Journal window, you can specify mappings between text on payments and specific debit, credit, and balancing accounts in the general ledger so that such payments are posted to the specified accounts when you post payments in the Payment Reconciliation Journal window. Payments posted based on text-to-account mapping are not applied to invoices or credit memos, but are merely posted to the specified accounts in addition to creating bank account ledger entries. Accordingly, text-to-account mapping is suited for recurring cash receipts or expenses, such as frequent purchases of car fuel, that regularly occur on the bank account and do not need a related business document. For more information, How to: Map Text on Recurring Payments to Accounts for Automatic Reconciliation.

The Match Confidence field specifies the status of the journal line or the quality of an automatic payment application on the line. You can choose the field to see detailed Information in the Additional Match Details window about why the payment was automatically applied or not. One of the following values will be displayed in the Match Confidence field.

Option	Description
Accepted	Specifies that you have chosen the Accept Application action in the Payment Application window. For more information, see How to: Review or Apply Payments After Automatic Application.
High	Specifies that the payment has been applied automatically with high match confidence.
High - Text-to-Account Mapping	Specifies that the payment has been set to posting directly to specified customer, vendor, or general ledger accounts based on text-to-account mapping. Such payments are not applied to open entries. For more information, see How to: Map Text on Recurring Payments to Accounts for Automatic Reconciliation.
Medium	Specifies that the payment has been applied automatically with medium match confidence.
Low	Specifies that the payment has been applied automatically with low match confidence.
Manual	Specifies that you have applied the payment manually in the Payment Application window. For more information, see How to: Review or Apply Payments After Automatic Application. When you choose Accept Application in the Payment Reconciliation Journal window, the value changes to Accepted.
None	Specifies that the payment is not applied, either because it could not be automatically applied, you have removed an application, or you have manually created the line.

When you post the payment reconciliation journal, the related customer and vendor accounts are updated and fully applied invoices or credit memos are closed. For payments on journal lines based on text-to-account mapping, the specified general ledger accounts are updated. For all journal lines, bank account ledger entries are created. The Balance on Bank Account After Posting field at the bottom of the journal is updated every time you post.

You can compare the value in the Balance on Bank Account After Posting field with the value in the Statement Ending Balance field to track when the bank account is reconciled based on payments that you post.

Note
The actual reconciliation of the bank account based on bank ledger entries that you create by posting payments in the Payment Reconciliation Journal, you perform in the Bank Acc. Reconciliation window. For more information, see Reconcile Bank Accounts.

Tip
For more information about how to navigate in the user interface, see Work with Microsoft Dynamics NAV. For more information about how to find specific pages, see Search.

See Also

Reference