How to: Reconcile Bank Accounts by Using Bank Statements
Microsoft Dynamics NAV provides a Bank Rec.Worksheet that you can use to reconcile bank account ledger entries with bank statements.
To reconcile bank accounts with bank statements
In the Search box, enter Bank Account Reconciliations, and then choose the related link.
On the Home tab, in the New group, choose New.
On the General FastTab, fill in the required fields as described in the following table.
Bank Account No.
The bank account number to reconcile.
The bank statement number to reconcile.
The bank statement date.
The bank statement balance.
On the Actions tab, in the Functions group, choose Mark Lines.
Note In the Functions group, you can also select the following bank reconciliation functions: suggest lines, clear lines, record adjustments, and recalculate the general ledger balance.
In the Bank Rec. Process Lines batch job, on the Options FastTab, fill in the fields as described in the following table.
Record type to process
Specify the type as Checks, Deposits, or Both.
Mark lines as cleared
Select to process the option selected in the Record type to process field.
On the Bank Rec. Line FastTab, select the appropriate filters.
Choose the OK button.
In the Bank Rec.Worksheet window, on the Adjustments FastTab, on the Bank Rec. Adj. Lines Subform FastTab, enter information into the remaining fields to make adjustments.
Note If needed, you can also use the Bank Rec.Worksheet window to view the Bank Reconciliation Comments card or the Bank Reconciliation card. This feature is available on the Navigate tab.
On the Actions tab, in the Posting group, choose Post.