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.

Field	Description
Bank Account No.	The bank account number to reconcile.
Statement No.	The bank statement number to reconcile.
Statement Date	The bank statement date.
Statement Balance	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.

Field Description

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.

Field	Description
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.