Select Checks and Deposits to Clear

Use the Bank Reconciliation (NBC) program to set up a cash account for reconciliation, enter bank statement transactions, select checks and deposits to clear, and print the Bank Reconciliation Register and clear transactions. See Background and Road Map for more information.

  1. Select the GL org code and account number that you want to reconcile and click Select.

  2. Enter the data in these fields:

Field Name

Type / Max Length

Action / Description

Passbook number

Optional
14 alphanumeric

Accept the displayed passbook number for the account or enter a different number.

Statement date

Optional
10 date

Select the date on the bank statement or enter a date shortcut.

If no date is entered, the program uses the system's terminal date.

The program also displays these fields:

Field Name

Displays

Bank org code

The GL organization code for the paying organization

Bank account no

The GL account number for the bank cash account

Starting balance

Last month's bank statement balance

The Bank Reconciliation Register updates this field.

Transactions total

The sum of interest, service charges, and miscellaneous transactions for the current month

Cleared checks sum

The sum of the checks selected for reconciliation in this program

Cleared deposits sum

The sum of the deposits selected for reconciliation in this program

Statement balance

A running balance for the current month

This balance changes as you select checks and deposits or enter interest, service charges, and miscellaneous transactions.

Last statement date

The date of the last statement

  1. Click Cleared items.

    The program displays these fields:

Field Name

Displays

Cleared checks

The total amount of the checks you have selected

Cleared deposits

The total amount of the deposits you have selected

Sel

Selected: This transaction is selected to be cleared
Blank
: It is not selected

Source

A/P: Check or alternate payment
A/R
: Deposit

Check/Dep no

The number of the check, alternate payment, or deposit

Check/Dep

The date of the check, alternate payment, or deposit

Check/Dep amount

The transaction amount

Reconciliation

S: Previously selected for reconciliation, but the register has not been run
V
: Check was voided

  1. Click Sel to the left of the check or deposit you want to select for reconciliation.

OR

Click Range to select a range of consecutively numbered checks or deposits.

  1. Enter data in these fields:

Field Name

Type / Max Length

Action / Description

Enter beginning source

Optional
3 alphanumeric

Enter A/P to begin with a range of checks, A/R to limit the range to deposits, or leave blank to select both check and deposit numbers.

Beginning check or deposit

Required
15 alphanumeric

Enter the number of the first check or deposit you want to select.

Enter ending source

Optional
3 alphanumeric

Enter A/P to limit the range to checks, A/R to limit the range to deposits, or leave blank to select both check and deposit numbers.

Ending check or deposit

Required
15 alphanumeric

Enter the number of the last check or deposit you want to select.

    1. Choose the appropriate options:

To

Do This

Change a field

Click Modify.

Exit without selecting this range of checks or deposits

Click Cancel.

Accept the range

Click OK.

  1. (Optional) Click the check or alternate payment (not Sel) to highlight it and then click Detail to display information about it. See Display AP-Purchasing Detail by Check Number. Click OK to return to this program.

  2. Choose the appropriate options:

To

Do This

Review your options for this program

Click Prog opts. See Set Options for Reports and Inquiries.

Display all checks or only selected checks

Click Selected/All.

Enter a range of checks or deposits to reconcile

Click Range. See step 5.

Print the transaction listing

Click Print all. See Print an Inquiry

Exit transaction selection

Click Exit.

  1. When you click Exit, click Register to print the Bank Reconciliation Register or choose the appropriate options:

To

Do This

Print the Bank Reconciliation Register

Click Register. See Print the Bank Reconciliation Register.

Accept the data

Click OK.

Exit without saving changes to header fields

Click Cancel.

Update the record

Click Apply.

Delete this reconciliation

Click Delete. See Delete.

Enter or change notes

Click Notes. See Enter Notes or Change Notes.

Enter a deposit, interest, bank charge, or miscellaneous charge

Click Transactions. See Enter Bank Statement Transactions.

Select checks, alternate payments, and deposits to reconcile

Click Cleared items.

  1. Choose the appropriate options when you click OK or Cancel:

To

Do This

Add another organization and account

Click Add.

Delete the selected organization and account

Click Delete. See Delete.

Copy the selected organization and account

Click Copy. See Copy.

Display the selected organization and account

Click Select.

Print the organization and account listing

Click Print. See Print.

Exit the program

Click Exit.