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. |
|
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. |
|
Import a bank statement file into the Payment Reconciliation Journal window and automatically apply the involved payments to their related open entries. |
|
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 |