Reconcile Bank Accounts
At regular intervals, you must reconcile your bank accounts in Microsoft Dynamics NAV by matching bank ledger entries resulting from the posted payments with the related transactions on your electronic bank site and then post the balance to your bank account. For this purpose, the Bank Acc. Reconciliation window is divided in two panes, the leftmost pane that contains bank statement lines and a rightmost pane that contains the bank ledger entries. You can use either an automatic or a manual matching function to match lines in the two panes.
You use a bank file import function to quickly populate the leftmost pane in the Bank Acc. Reconciliation window.
Note
Bank statements in the SEPA CAMT format are supported out-of-the-box. Use the Date Exchange Framework to enable other bank or payroll file formats. For more information, see How to: Enable Import/Export of Bank or Payroll Files Using the Data Exchange Framework.
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 |
|---|---|
Fill in bank reconciliation lines, automatically or manually, to check the balance on your accounts against the statement from the bank. |
|
Import bank statements from your electronic bank site into the Bank Acc. Reconciliation window as the first step in bank reconciliation. |
|
After you have imported a bank statement file, view the content of the file, such as account number, posting date, and amount. |
|
Prepare to reconcile a bank account by automatically or manually matching bank statement lines in the leftmost pane with bank account ledger entries in the rightmost pane of the Bank Acc. Reconciliation window. |
How to: Match Bank Statement Lines with Bank Account Ledger Entries |
Compare the suggested lines with the transactions on the bank’s statement and if the reconciliation lines do not match the bank statement, correct the lines. |
|
Correct erroneous transactions so that they can be applied to a ledger entry. |
|
Post interest or fee bank transactions with a general journal. |
How to: Post Open Transactions Reflected in a Bank Statement |
Post the bank reconciliation after you have filled in the bank reconciliation, corrected the lines (if it is required), and applied entries (if it is required). |
|
View the entries in the Bank Account Ledger Entries window after transactions are posted to bank accounts. |
|
View heck ledger entries from the bank account from which the checks are issued. |
|
Void checks from the Check Ledger Entries window. |
|
View all posted reconciliations. |
See Also
Tasks
How to: Reverse Journal Postings
Concepts
Other Resources
How to: Enable Import/Export of Bank or Payroll Files Using the Data Exchange Framework