Share via


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.

How to: Fill In Bank Reconciliations

Import bank statements from your electronic bank site into the Bank Acc. Reconciliation window as the first step in bank reconciliation.

How to: Import Bank Statements

After you have imported a bank statement file, view the content of the file, such as account number, posting date, and amount.

How to: View Details of Imported Bank Statements

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.

How to: Correct Bank Reconciliation Lines

Correct erroneous transactions so that they can be applied to a ledger entry.

How to: Handle Erroneous Bank Statement Transactions

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).

How to: Post Bank Reconciliations

View the entries in the Bank Account Ledger Entries window after transactions are posted to bank accounts.

How to: View Bank Account Ledger Entries

View heck ledger entries from the bank account from which the checks are issued.

How to: View Check Ledger Entries

Void checks from the Check Ledger Entries window.

How to: Void Checks

View all posted reconciliations.

How to: View Bank Statements

See Also

Tasks

How to: Reverse Journal Postings

Concepts

Manage Cash

Other Resources

How to: Enable Import/Export of Bank or Payroll Files Using the Data Exchange Framework