Reconciling Bank Accounts | Microsoft Docs

Use the Bank Rec. Worksheet page to reconcile bank account ledger entries with bank statements.

NOTE

This topic describes the North American bank reconciliation functionality. You can also use the standard functionality. For more information, see Reconcile Bank Accounts Separately.

To reconcile bank accounts with bank statements

Choose the icon, enter Bank Account Reconciliations, and then choose the related link.
Choose the New action.

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.

Choose the Mark Lines action.
On the Bank Rec. Process Lines page, 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.
On the Bank Rec. Worksheet page, on the Bank Rec. Adj. Lines Subform FastTab, enter information in the remaining fields to make adjustments.

NOTE
If needed, you can also use the Bank Rec. Worksheet page to view the Bank Reconciliation Comments card or the Bank Reconciliation card.

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.

To post a bank reconciliation

You can post bank reconciliation if you have reconciled the bank accounts on the Bank Rec. Worksheet page. After the bank reconciliation has been posted a bank account statement is created and can be viewed on the bank account card.

Choose the icon, enter Bank Account Reconciliations, and then choose the related link.
Choose the bank account reconciliation that you want to post, and then choose the Edit action.

NOTE
On the General FastTab, the value in the Difference field be must be zero before you can post the bank reconciliation.

When the bank reconciliation is posted, all of the related files are posted to the historical Post Bank Rec. Worksheet table. Any adjustments are posted to the G/L Entry table.

Choose the Post action.
To review a preliminary draft of the bank reconciliation statement, choose the Test Report action. The Bank Rec. Test Report shows the entries that will result if you post.

To view the posted bank account reconciliations

Choose the icon, enter Bank Accounts, and then choose the related link.
Choose the bank account that you want to view the posted reconciliations for, and then choose the Statements action.
Choose the Close button.

To print a bank reconciliation test report

You can print the following bank reconciliation reports:

Bank Rec. Test Report - Displays the list of errors that are found in the bank reconciliation statement. You can generate this report before you post the bank reconciliation statement to make sure that there are no errors in the statement.
Bank Account – Reconcile - Displays the reconciliation details for each bank account. This report lists deposits, withdrawals, and adjustments for a bank account.

Choose the icon, enter Bank Account Reconciliations, and then choose the related link.
Choose the Bank Rec. Test Report action.

On the Options FastTab, fill in the fields as described in the following table.

Field	Description
Print details	Include reconciliation details in the report. If you select this check box, all of the other print check boxes are automatically selected. You can clear a check box if you do not want to include its details in the report.
Print checks	Print check details in the report.
Print depositsPrint deposit details in the report.
Print adjustments	Print adjustment details in the report.
Print outstanding checks	Print outstanding check details in the report.
Print outstanding deposits	Print outstanding deposit details in the report.

On the Bank Rec. Header FastTab, select the appropriate filters.
Choose the Print button to print the report. Choose the Preview button to view it on the screen.

To print a bank reconciliation report

Choose the icon, enter Bank Account Reconciliations, and then choose the related link.
Choose the Bank Account – Reconcile action.
To print each bank account on a new page, choose the New Page per Bank Account check box.
On the Bank Account FastTab, choose the appropriate filters.
Choose the Print button to print the report. Choose the Preview button to view it.

Reconciling Bank Accounts | Microsoft Docs

NOTE

To reconcile bank accounts with bank statements

NOTE

To post a bank reconciliation

NOTE

To view the posted bank account reconciliations

To print a bank reconciliation test report

To print a bank reconciliation report

See Also