How to: Reconcile Payments That Cannot be Applied

You may sometimes have to handle payments to your bank account that cannot be applied to a related open customer, vendor or bank account ledger entry. Reasons may be that no document exists in Microsoft Dynamics NAV that the payment can be applied to, or the related document in Microsoft Dynamics NAV has a different amount than the transaction amount, for example, because of currency exchange. In the Payment Reconciliation Journal window, all transaction amounts for payments that are not yet applied appear in the Difference field, including amounts that cannot be applied because of reasons such as the above.

Payments that cannot be applied can appear on payment reconciliation journal lines in the following different ways:

The value in the Difference field is equal to the value in the Transaction Amount field, which indicates that no part of the payment can be applied to a related open customer, vendor, or bank account ledger entry.
The value in the Difference field is lower than the value in the Transaction Amount field, which indicates that a part of the payment can be applied to a related open customer, vendor, or bank account ledger entry. The remaining part of the payment cannot be applied and must be reconciled manually or by posting it directly to an account.

To reconcile such payments, you can choose the Transfer Difference to Account button and then specify to which account the amount in the Difference field will be posted when you post the payment reconciliation journal.

Note
Similar functionality exists to set up automatic reconciliation of recurring payments that cannot be applied to related open customer, vendor, or bank account ledger entries. For more information, see How to: Map Text on Recurring Payments to Accounts for Automatic Reconciliation.

To reconcile payments that cannot be applied

In the Search box, enter Payment Reconciliation Journals, and then choose the related link.
Open a payment reconciliation journal. For more information, see How to: Reconcile Payments Using Automatic Application.
On the Home tab, in the Review group, choose Transfer Difference to Account. The Transfer Difference to Account window opens.
In the Account Type field, specify if the type of account that the payment amount will be posted to.
In the Account No. field, specify the account that the payment amount will be posted to.
In the Description field, specify text that describes this direct payment posting. By default, the text in the Transaction Text field on the payment reconciliation journal line is inserted.
Choose the OK button.

If the value in the Difference field was equal to the value in the Transaction Amount field when you post the payment reconciliation journal, the whole payment on the journal line will be posted directly to the specified balancing account.

If the value in the Difference field was lower than the value in the Transaction Amount field, then an additional journal line will be created with the same text and date and with the difference inserted in the Transaction Amount field. On the original journal line, the difference will be deducted from the value in the Transaction Amount field, and the payment will remain applied to its related customer, vendor, or bank account ledger entry. When you post the payment reconciliation journal, one part of the payment will be posted as an applied payment. The other part of the payment will be posted directly to the specified account.

Tip
For more information about how to work with fields and columns, see Working with Microsoft Dynamics NAV. For more information about how to find specific pages, see Search.

To reconcile payments that cannot be applied

See Also

Tasks

Concepts