Enter Bank Statement Transactions

Use the Bank Reconciliation (NBC) program to set up a cash account for reconciliation and 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.

Existing reconciliation accounts are listed:

Field Name	Displays
Bank org	The GL organization code for the paying organization
Bank acct no	The GL account number for the bank cash account
Passbook no	The passbook number for the account
Stmt date	The date of this bank statement
Last stmt date	The date of the most recently reconciled statement

Choose the appropriate options:

To	Do This
Set up an account for reconciliation	Click Add. See step 2.
Delete an account	Highlight the line and click Delete. See Delete.
Copy an account	Highlight the line and click Copy. See Copy.
Display account details	Highlight the line and click Select. or double click the line. See step 2.
Print the list of accounts	Click Print. See Print.
Exit the program	Click Exit.

Enter or change data in the following fields:

Field Name	Type / Max Length	Action / Description
Bank org code	Required	Enter or select the GL organization code for the account. This field cannot be changed after the reconciliation account is created.
Bank account no	Required	Enter or select the GL account number for the bank cash account or click the Lookup icon and use the standard lookup options to select an account from a list. This field cannot be changed after the reconciliation account is created.
Passbook number	Optional 14 alphanumeric	Enter the passbook number for the account.
Statement date	Optional 10 date	Accept the displayed date, select the date of the bank statement, or enter a date shortcut.
Last statement date	Display	The date of the most recently reconciled statement
Starting balance	Display	The starting balance
Deposits/Credits	Display	The sum of deposits selected for reconciliation and other credits entered for this statement
Withdrawals/Debits	Display	The sum of withdrawals selected for reconciliation and debits entered for this statement
Statement balance	Display	The statement balance based on the deposits and withdrawals selected for reconciliation and interest, service charge, transfer and miscellaneous transactions entered

Choose the appropriate options:

To	Do This
Change the passbook number or statement date	Move the cursor to the field and make changes. Click Apply to accept the changes or click Cancel to reject them.
Delete a saved record	Click Delete. See Delete.
Enter or change notes	Click Notes. See Enter or Change Notes.
Enter interest, a service charge, transfer or a miscellaneous charge	Click Transactions. See step 4.
Select checks, alternate payments, and deposits to reconcile	Click Cleared items. See Select Checks and Deposits to Clear.
Print the Bank Reconciliation Register	Click Register. See Print the Bank Reconciliation Register.
Return to the list of accounts	Click OK. See step 1.

The selected organization and account are displayed followed by a list of previously entered interest, service charge, transfer and miscellaneous transactions:

Field Name	Displays
Type	A code for the type of transaction
Description	The description of the type
Seq	The sequence number of the transaction
Trans amount	The amount of the transaction
Trans date	The date the transaction was entered
Reference	The comment or reference entered with the transaction

Choose the appropriate options:

To	Do This
Add a transaction	Click Add. See step 5.
Delete a transaction	Highlight the line and click Delete. See Delete.
Copy a transaction	Highlight the line and click Copy. See Copy.
Display or change a transaction	Highlight the line and click Select or double click the line. See step 5.
Print the transaction listing	Click Print. See Print.
Return to the previous screen	Click OK. See step 2.

Enter or change data in the following fields:

Field Name	Type / Max Length	Action / Description
Bank org code	Display	The GL organization code
Bank account no	Display	The GL account number
Transaction type	Required	Select the type of transaction you are entering: I Interest M Miscellaneous (for example, an error correction) S Service charge T Transfer G General journal (a charge or credit that does not post to GL; used to sync bank reconciliation with your cash account) This field cannot be changed after the transaction is entered.
Sequence number	Required 15 alphanumeric	Accept the displayed sequence number or enter a different one.
Transaction amount	Required 14 numeric in the format 999999999999.99	Enter the transaction amount. Miscellaneous and general journal transactions can be either positive or negative; for all other transaction types, you should enter a positive amount.
Transaction date	Required 10 date	Enter or select the transaction date or enter a date shortcut.
Reference	Optional 30 alphanumeric	Accept the displayed reference or enter a different reference.
Expense/Revenue org To cash org	Conditional	Enter an organization code or accept the default if one is displayed. This field is not required for General journal transaction types.
Expense/Revenue account To cash account	Conditional	Enter an account number or accept the default if one is displayed. This field is not required for General journal transaction types.

Choose the appropriate options:

To	Do This
Change a field	Move the cursor to the field and make changes. Click Apply to accept the changes or click Cancel to reject the changes.
Delete the transaction	Click Delete. See Delete.
Change the Sequence number for a new transaction	Click Change no. This button is active only for when you are entering a new transaction.
Return to the list of transactions	Click OK. See step 4. If this is a new entry, the program prompts Transaction type. Click OK again to return to the list of transactions.