Enter a valid bank abbreviation in this required field. You can use to select a bank from the list. The bank abbreviation represents the bank account that you are reconciling with your books. The description for the bank abbreviation that was set up on the Manage Company Bank Accounts screen displays to the right of the Bank Abbr field.

This non-editable field displays your company’s bank account currency.

Enter the start date for transactions you want to display.

Enter the end date for transactions you want to display.

This field displays the sum of all values in the Amount column of the GL Transactions table window.

This field displays the sum of all values in the Tran Amount column of the Bank Statement table window.

This field displays the result of subtracting the Bank Statement field value from the GL Transactions field value.

Click this button to display the Process Status pop-up window and view the procedures you need to perform for bank reconciliation and the last time each process was completed.

Click this button to match rows in the GL Transactions table window with those in the Bank Statement Transactions table window. Before you click this button, you must first highlight the transaction rows to be matched.

Click this button to unmatch rows in the GL Transactions table window against those in the Bank Statement Transactions table window. Before you click this button, you must first highlight the transaction rows to be unmatched.

Click this button to automatically match rows in the GL Transactions table window with those in the Bank Statement Transactions table window. When you click this button, Costpoint matches the GL and bank transactions using the following criteria:

Select whether to display cleared, outstanding, or all transactions in the table windows.

This column displays whether a bank transaction is CLR (cleared) or OUT (outstanding). You can use the drop-down list to change it.

There are no restrictions on changing the code in this field. The following S_STATUS_CDs are used in the VEND_CHK table to integrate the bank reconciliation records and the Accounts Payable records:

• O: Outstanding
• C: Cleared
• V: Void or Unused
• S: Stop Payment
• P: Zero Balance Check

When the bank transactions are accepted and the bank reconciliation items are set to CLR, the S_STATUS_CD in the VEND_CHK table is changed to C (Cleared).

Bank reconciliation items that have status of V (Void) or S (Stop Payment) cannot be reset to C (Cleared) in the VEND_CHK table. They are cleared in the BANK_TRN_HS table. Clearing a void or stop payment transaction has no effect on the VEND_CHK table.

For CR, AP, and/or PR transactions that were not previously edited, OUT automatically displays as the default. If the transaction cleared the bank, enter CLR (or C). To change a cleared code to outstanding, enter OUT.

For a new MAN transaction row, there is no automatic default for this column. If the transaction has cleared the bank, enter CLR (or C). If the transaction is still outstanding, enter OUT (or O).

For CR, AP, and/or PR transaction types, the following takes place in the GL Transactions table window when you enter or change a code to CLR:

• The value in the Amount column displays in the Bank Amount column. You cannot  edit it.
• If you entered a bank acceptance default date when you selected the transactions for display, the date from that field automatically displays in the Bank Accept Date column. Data in this column is required for cleared transactions, but you can edit default data as long as it falls within the date range of the bank acceptance fiscal year/ period/subperiod.
• If you entered a bank acceptance default fiscal year, period, and subperiod when you selected the transactions for display, these default entries display in the Bank Accept Fiscal Year, Bank Accept Period, and Bank Accept Subperiod columns, respectively. You must have data in these columns in order to clear transactions.

For a MAN transaction type, the following takes place in the GL Transactions table window:

• There is no automatic code default for a new row. You must enter CLR or OUT in this required column.
• Defaults for the Bank Acceptance Date, Fiscal Year, Period, and Subperiod fields function in the same manner as for CR, AP, and PR, for both the CLR and OUT codes. If the code is CLR, these fields are required, and the defaults, if specified on this screen, display in these fields. If the code is OUT, these fields are cleared, and you cannot enter data in them.
• There is no G/L amount associated with a new row. As a result, there is no automatic display of that amount in the Bank Amount column. You must manually enter data for the G/L Amount column.

Click the Set to CLR and the Set to OUT buttons to select multiple rows in which to change the status code from CLR to OUT or from OUT to CLR.

This column displays the transaction type (AP, CR, PR, or MAN).

• A/P, C/R, and/or P/R Transactions: Accounts Payable transactions display AP in this column. Cash Receipts transactions display CR in this column. Payroll transactions display PR in this column.
• Manual Adjustments: Manual adjustment transactions display MAN in this column. To enter a new manual adjustment row, click . MAN automatically displays in this column for the new row.

For CR, AP, and/or PR transaction types, the date from the historical transaction displays in this column, and you cannot edit it.

For CR transactions, the receipt date displays in this column.

For AP and PR transactions, the check date (or direct deposit date, as appropriate) displays in this column.

For previously entered manual (MAN) transactions, user-entered data displays in this column. For new MAN transaction type rows, enter a transaction date in this required field in the MM/DD/YYYY format.

This field displays the transaction ID.

For CR, AP, and/or PR transaction types, the number from the historical transaction displays in this column, and you cannot edit it.

For CR transactions, the receipt number displays in this column.

For AP and PR transactions, the check number displays in this column.

For previously entered manual (MAN) transactions, user-entered data displays in this column. For new MAN transaction type rows, enter a transaction number in this required field.

This column displays the charge amount.

This column displays the charge amount in the transaction currency.

For CR, AP, and/or PR transaction types, the name from the historical transaction displays in this column, and you cannot edit it. For CR transactions, this column is blank. For AP transactions, the pay vendor name displays in this column. For PR transactions, the last and first name of the employee display in this column.

For previously entered manual (MAN) transactions, user-entered data displays in this column. For a new MAN transaction type row, enter an optional transaction name in this column.

This column displays the match number.

This field displays the date when a transaction was cleared. When you clear CR, AP, and PR transaction types, this field defaults to the current date, but is editable as long as the date falls within the Start Date and Through Date.

If you change the code from CLR to OUT, data in this field automatically is cleared.

For new MAN transaction-type rows for which the code is CLR, enter or select the cleared date. The system validates that the cleared date falls within the start and end date of the specified fiscal year, period, and subperiod.

For all transaction types, when you enter or change a code to CLR, the value in the Amount column displays in the Bank Amount column, where you can edit it.

If, after reviewing your bank statement, you determine that there is a discrepancy between the booked transaction and the transaction from the bank statement, enter the different bank amount in this field.

For CR, AP, and/or PR transaction types, the fiscal year, period, and subperiod from the historical transaction  displays in these columns. You cannot edit them.

For CR transactions, the fiscal year, period, and subperiod from the Cash Receipts Header History table display in these columns.

For AP transactions, the fiscal year, period, and subperiod from the Vendor Check table display in these columns.

For PR transactions, the fiscal year, period, and subperiod from the Employee Earnings table display in these columns.

For previously entered manual (MAN) transactions, user-entered data displays in these columns.

For a new MAN transaction type row, enter the fiscal year, period, and subperiod in these required columns.

For CR, AP, and/or PR transaction types, the account from the cash acct/org/ref1/ref2 combination from the historical transaction displays in this column. You cannot edit it.

For CR transactions, the cash account from the Cash Receipts Transaction History table displays in this column.

For AP transactions, the cash account from the Vendor Check table displays in this column.

For PR transactions, the cash account from the Employee Earnings table displays in this column.

For previously entered manual (MAN) transactions, user-entered data displays in these columns. For a new MAN transaction type row, enter the cash account in this required column or use to select one.

For CR, AP, and/or PR transaction types, the organization from the cash acct/org/ref1/ref2 combination from the historical transaction displays in this column. You cannot edit it.

For CR transactions, the cash organization from the Cash Receipts Transaction History table displays in this column.

For AP transactions, the cash organization from the Vendor Check table displays in this column.

For PR transactions, the cash organization from the Employee Earnings table displays in this column.

For previously entered manual (MAN) transactions, user-entered data displays in these columns. For a new MAN transaction type row, enter the cash organization in this required column or use to select one.

If you use reference numbers, the label that is entered for Reference 1 on the Configure General Ledger Settings screen displays as this column heading.

For CR, AP, and/or PR transaction types, the reference 1 number from the cash acct/org/ref1/ref2 combination from the historical transaction displays in this column. You cannot edit it.

For CR transactions, the cash reference 1 number from the Cash Receipts Transaction History table displays in this column.

For AP transactions, the cash reference 1 number from the Vendor Check table displays in this column.

For PR transactions, the cash reference 1 number from the Employee Earnings table displays in this column.

For previously entered manual (MAN) transactions, user-entered data displays in these columns. For a new MAN transaction type row, enter the cash reference 1 number in this optional column or use to select one.

If you use reference numbers, the label entered for Reference 2 in the Configure General Ledger Settings screen displays as this column heading.

For CR, AP, and/or PR transaction types, the reference 2 number from the cash acct/org/ref1/ref2 combination from the historical transaction displays in this column. You cannot edit it.

For CR transactions, the cash reference 2 number from the Cash Receipts Transaction History table displays in this column.

For AP transactions, the cash reference 2 number from the Vendor Check table displays in this column.

For PR transactions, the cash reference 2 number from the Employee Earnings table displays in this column.

For previously entered manual (MAN) transactions, user-entered data displays in these columns. For a new MAN transaction type row, enter the cash reference 2 number in this optional column or use to select one.

This column displays whether a bank transaction is CLR (cleared) or OUT (outstanding).

This column displays the transaction amount.

This column displays the transaction date.

This column displays the transaction description.

This column displays the transaction ID.

This column displays the running balance.

This column displays the match number.