How to: Fill In Bank Reconciliations

To reconcile bank accounts in Microsoft Dynamics NAV to statements received from the bank, you must first create a bank account reconciliation by filling in the lines in the Bank Acc. Reconciliation window.

You can enter the bank statements on the lines in the following ways:

• Automatically, by using the Import Bank Statement function to fill the lines according to actual bank statements based on a file provided by the bank. This is covered in steps 6 through 7 in the following procedure.

  Note

  You can also import bank statements into the General Journal window. This is the first step in matching payments with open documents or entries. For more information, see How to: Import Bank Statements.

• Manually, by using the Suggest Lines function to fill the lines with suggested lines according to outstanding payments and then adjust the values manually according to actual bank data. This is covered in steps 8 through 11 in the following procedure.

To fill in bank reconciliations

1. In the Search box, enter Bank Account Reconciliation, and then choose the related link.

2. Create a new bank account reconciliation.

3. In the Bank Account No. field, select the correct bank account code. The Statement No. and the Balance Last Statement fields are filled in automatically based on the information on the bank account card.

4. In the Statement Date field, enter the date of the statement from the bank.

5. In the Statement Ending Balance field, enter the balance from the bank’s statement.

   If you have a file that has the current bank statement, proceed to fill the lines automatically.

6. On the Actions tab, in the Functions group, choose Import Bank Statement.

7. Locate the file, and then choose Open to import the bank transactions into the lines of the Bank Acc. Reconciliation window.

   The format of the file is specified in the Bank Statement Format field in the Bank Account Card window.

   If you do not have a file with the bank statement, then proceed to fill the lines with suggested entries and then manually check and adjust any differences from the actual bank statement.

8. On the Actions tab, in the Functions group, choose Suggest Lines.

9. In the Starting Date field, enter the starting posting date for the ledger entries to be reconciled. In the Ending Date field, enter the ending date for these ledger entries.

10. If you want to suggest check ledger entries instead of bank account ledger entries, select the Include Checks field.

11. Choose the OK button to generate the lines based on expected payments for outstanding invoices.

To complete the reconciliation, you must correct the lines and match the entries, if necessary, and post the reconciliation.

For more information about completing reconciliations, see How to: Correct Bank Reconciliation Lines, How to: Match Bank Statement Lines with Bank Account Ledger Entries, and How to: Post Bank Reconciliations.

See Also

Tasks

How to: Import Bank Statements
How to: Match Bank Statement Lines with Bank Account Ledger Entries
How to: Post Open Transactions Reflected in a Bank Statement
How to: Handle Erroneous Bank Statement Transactions

Other Resources

Bank Acc. Reconciliation
Bank Account Card
Bank Statement Format