Contents of the View Bank Reconciliation Summary Screen

Select Bank Account

Field	Description
Bank Abbr	Enter, or click to select, the bank abbreviation for the bank whose account you are reconciling with your books. When you enter a bank abbreviation, the description for the bank abbreviation automatically displays in the field to the right.
Currency	This non-editable field displays the currency in which the bank is keeping your company's funds.

Field

Description

Bank Abbr

Enter, or click to select, the bank abbreviation for the bank whose account you are reconciling with your books.

When you enter a bank abbreviation, the description for the bank abbreviation automatically displays in the field to the right.

Currency

This non-editable field displays the currency in which the bank is keeping your company's funds.

Select Timing

Bank Reconciliation Date

In this group box, enter the date range of transactions you want to view.

Field	Description
Start Date	Enter, or click to select the beginning of the date range.
Through Date	Enter, or click to select the end of the date range.

Bank Statement Table Window

This table window displays non-editable bank reconciliation in summary format for a range of records based on their transaction date.

For General Ledger items, the table displays the beginning book balance and the period totals for cash receipts, cash disbursements, and manual adjustments. Costpoint calculates and displays the ending book balance from this data.

For Bank Statement items, the table displays the last bank statement ending balance, deposits in transit, outstanding checks and manual adjustments, and unmatched cash receipts and disbursements. Costpoint calculates and displays the adjusted bank statement balance.

Costpoint calculates the summary totals that display in this table from data that exists in the Bank Transactions History table. Before you can view data in this screen, you must first run the Create Bank Transactions History process and/or have entered manual adjustment data. Detail G/L transactions that were copied from A/P, C/R, and/or P/R tables, as well as previously entered manual adjustments, can be viewed, matched to bank transactions, and cleared or uncleared in the Accept Bank Transactions screen.

As an alternative to viewing the data in this screen, you can print the displayed summary data from the Print Bank Reconciliation Summary Report screen. You can print the transactions detail data from the Print Bank Reconciliation Detail Reports screen.

Field	Description
Beginning Book Balance	This non-editable field displays the General Ledger balance for the G/L account/org(s) linked with this bank abbreviation for the G/L fiscal year/period/subperiod combination with a subperiod end date prior to the reconciliation Start Date you entered.
Cash Receipts	This non-editable field displays the total of the G/L cash receipts transactions for the G/L account/org(s) linked with this bank abbreviation that have a transaction date within the reconciliation Start Date and Through Date you entered. The value in this field includes both cleared and outstanding C/R transactions (Code is CLR and/or OUT). Click the link in this field to access the C/R Per Books subtask and view the detail transactions that comprise this total. If you have a zero balance in this field, refer to the Hint at the end of this section for some possible reasons.
Cash Disbursements	This non-editable field displays the total of the G/L cash disbursements (from A/P or P/R) transactions for the G/L account/org(s) linked with this bank abbreviation that have a transaction date within the reconciliation Start Date and Through Date you entered. The value in this field includes both cleared and outstanding transactions (Code is CLR and/or OUT). Click the link in this field to access the C/D Per Books subtask and view the detail transactions that comprise this total. If you have a zero balance in this field, refer to the Hint at the end of this section for a list of possible reasons.
Manual Adjustments	This non-editable field displays the total of all manual adjustment transaction data entered in the Accept Bank Transactions screen that have a transaction date within the reconciliation Start Date and Through Date you entered. The value in this field includes both cleared and outstanding transactions (Code is CLR and/or OUT). Click the link in this field to access the Manual Adj subtask and view the detail transactions that comprise this total. If you have a zero balance in this field, refer to the Hint at the end of this section for some possible reasons.
Ending Book Balance	Costpoint calculates the value that displays in this non-editable field. Costpoint adds or subtracts (as appropriate) the Cash Receipts, Cash Disbursements, and Manual Adjustments totals to/from the Beginning Book Balance value. The ending book balance must be equal to the General Ledger balance for the G/L account/org(s) linked with this bank abbreviation for the reconciliation Through Date you entered.
Bank Statement Ending Balance	This non-editable field displays the balance for the reconciliation Through Date you entered. This data was originally entered on the Enter/Manage Bank Statement Information screen.
Deposits in Transit	This non-editable field displays the total of all G/L cash receipts transactions for the G/L account/org(s) linked with this bank abbreviation for all outstanding transactions (Code is OUT). This value must include all outstanding transactions dated within the reconciliation Start Date and Through Date you entered. Click the link in this field to access the Deposits in Transit subtask and view the detail transactions that comprise this total. If you have a zero balance in this field, refer to the Hint at the end of this section for some possible reasons.
Outstanding Checks	This non-editable field displays the total of all G/L cash disbursements transactions for the G/L account/org(s) linked with this bank abbreviation for all outstanding transactions (Code is OUT). This value must include all outstanding transactions dated within the reconciliation Start Date and Through Date you entered. Click the link in this field to access the Outstanding Chks subtask and view the detail transactions that comprise this total. If you have a zero balance in this field, refer to the Hint at the end of this section for some possible reasons.
Outstanding Manual Adjustments	This non-editable field displays the total of all manual adjustments entered in the Accept Bank Transactions screen for this bank abbreviation for all outstanding transactions (Code is OUT). This value must include all outstanding transactions dated within the reconciliation Start Date and Through Date you entered. Click the link in this field to access the Outstanding Adj subtask and view the detail transactions that comprise this total. If you have a zero balance in this field, refer to the Hint at the end of this section for some possible reasons.
Outstanding Bank Statement Items	This non-editable field displays the total of all bank statement outstanding items entered in the Accept Bank Transactions screen for this bank abbreviation for all outstanding transactions (Code is OUT). This value must include all outstanding transactions dated within the reconciliation Start Date and Through Date you entered. Click the link in this field to access the Outstanding Bank Stmt Items subtask and view the detail transactions that comprise this total.
Unmatched Cash Receipts	This non-editable field displays the total of all G/L cash receipts transactions for the G/L account/org(s) linked with this bank abbreviation for all cleared transactions (Code is CLR) that do not match items from the bank statement. This value must include all unmatched C/R transactions that have not yet been resolved on or before the reconciliation Through Date you entered. Click the link in this field to access the Unmatched C/R subtask and view the detail transactions that comprise this total. If you have a zero balance in this field, refer to the Hint at the end of this section for some possible reasons.
Unmatched Cash Disbursements	This non-editable field displays the total of all G/L disbursement transactions for the G/L account/org(s) linked with this bank abbreviation for all cleared transactions (Code is CLR) that do not match items from the bank statement. This value must include all unmatched A/P and/or P/R transactions that have not yet been resolvedon or before the reconciliation Through Date you entered. Click the link in this field to access the Unmatched C/D subtask and view the detail transactions that comprise this total. If you have a zero balance in this field, refer to the Hint at the end of this section for some possible reasons.
Unmatched Manual Adjustments	This non-editable field displays the total of unmatched manual adjustments. These adjustments can be dated before or up to the reconciliation Through Date you entered.
Adjusted Bank Balance	Costpoint calculates the value that displays in this non-editable field. Costpoint adds or subtracts (as appropriate) the Deposits in Transit, Outstanding Checks, Manual Adjustments, Unmatched Cash Receipts, and Unmatched Cash Disbursements totals to/from the Bank Statement Ending Balance value. In a reconciled condition, the adjusted bank balance value must be equal to the General Ledger balance (Ending Book Balance on this screen) for the G/L account/org(s) linked with this bank abbreviation for reconciliation Start Date and Through Date you entered. Note that a zero balance in any of the transactions fields - Cash Receipts, Cash Disbursements, Manual Adjustments, Deposits in Transit, Outstanding Checks, Outstanding Manual Adjustments, Unmatched Cash Receipts, and/or Unmatched Cash Disbursements - may be the result of any of the following conditions: You have not run the Create Bank Transactions History process and/or entered any manual adjustments in the Accept Bank Transactions screen. As a result, there are no detail transactions in the Bank Transactions History table. There are no transactions in the Bank Transactions History table that qualify against your selection criteria. Transactions exist, but one or more positive entries offset one or more negative entries so that the net result is zero. You can confirm this situation by viewing the appropriate subtasks to view the detail for the affected types of transactions. In addition, the following situation may cause Unmatched Cash Receipts and/or Unmatched Cash Disbursements to have a zero balance: You have not cleared cash receipts and/or checks using the Accept Bank Transactions and/or Process Batch Bank Transactions screens. As a result, there are no instances of unmatched transactions in the Bank Transactions History table.

Subtasks

Subtask	Description
C/R per Books	Click the Cash Receipts field to view a bank's cash receipts detail transactions per the General Ledger.
C/D per Books	Click the Cash Disbursements field to view a bank's cash disbursements detail transactions (from Accounts Payable and/or Payroll) per the General Ledger.
Manual Adj	Click theManual Adjustments field to view the manual adjustment transaction data that was entered on the Accept Bank Transactions screen for the bank.
Deposits in Transit	Click the Deposits in Transit field to view the cash receipts transactions for the General Ledger account and organizations linked with this bank for all outstanding transactions (Code = OUT).
Outstanding Chks	Click the Outstanding Checks field to view the outstanding cash disbursements transactions (from Accounts Payable or Payroll) for the General Ledger account and organizations that are linked with this bank.
Outstanding Adj	Click the Outstanding Manual Adjustments field to view the outstanding manual adjustment transactions that were entered on the Accept Bank Transactions screen for the bank.
Outstanding Bank Stmt Items	Click the Outstanding Bank Statement Items field to view bank statement outstanding items.
Unmatched C/R	Click the Unmatched Cash Receipts field to view the cash receipts transactions for the General Ledger account and organizations that are linked with this bank for all cleared transactions (Code = CLR) that do not match items from the bank statement.
Unmatched C/D	Click the Unmatched Cash Disbursements field to view the cash disbursements transactions for the General Ledger account and organizations that are linked with this bank for all cleared transactions (Code = CLR) that do not match items from the bank statement
Unmatched Adj	Click the Unmatched Manual Adjustments field to view the outstanding manual adjustment transactions that were entered in the Accept Bank Transactions screen for the bank.

Costpoint Online Help