Use this subtask to display a non-editable bank reconciliation in summary format for a specified fiscal year and period.
For General Ledger items, the screen displays the beginning book balance and the period totals for cash receipts, cash disbursements, and manual adjustments. The system calculates and displays the ending book balance from this data.
For Bank Statement items, the screen displays the last bank statement ending balance, deposits in transit, outstanding checks and manual adjustments, and unmatched cash receipts and disbursements. The system calculates and displays the adjusted bank statement balance.
Once the summary bank reconciliation displays, you can access each line on the reconciliation by using a pushbutton to view the detail transactions that make up each subtotal.
The system calculates the summary totals that display in this screen 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.
These non-editable fields display the bank abbreviation and description, currency, fiscal year, and period that were selected in the main screen.
The G/L period ending date for the selected period automatically displays in the screen header and cannot be edited.
The bank statement ending date set up in the Maintain Bank Statement Info screen for the fiscal year and period selected automatically displays in the screen header and cannot be edited.
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 period and fiscal year before the fiscal year and period displayed in the screen header.
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 for the G/L fiscal year and period displayed in the screen header. The value in this field includes both cleared and outstanding C/R transactions (Code = "CLR" and/or "OUT"). You can use the C/R Per Books pushbutton to 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.
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 for the G/L fiscal year and period displayed in the screen header. The value in this field includes both cleared and outstanding transactions (Code = "CLR" and/or "OUT"). You can select the C/D Per Books pushbutton to 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.
This non-editable field displays the total of all manual adjustment transaction data entered in the Accept Bank Transactions screen for the G/L fiscal year and period displayed in the screen header. The value in this field includes both cleared and outstanding transactions (Code = "CLR" and/or "OUT").
You can select the Manual Adjustment pushbutton to 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.
The system calculates the value that displays in this non-editable field. The system 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 should be equal to the General Ledger balance for the G/L account/org(s) linked with this bank abbreviation for the G/L fiscal year and period ending date displayed in the screen header.
This non-editable field displays the balance for the bank statement ending date displayed in the screen header. This data was originally entered in the Maintain Bank Statement Info screen.
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 = "OUT"). This value should include all outstanding transactions for all prior periods up to and including the G/L fiscal year and period displayed in the screen header. You can select the Deposits in Transit pushbutton to 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.
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 = "OUT"). This value should include all outstanding transactions for all prior periods up to and including the G/L fiscal year and period displayed in the screen header. You can use the Outstanding Chks pushbutton to 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.
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 = "OUT"). This value should include all outstanding transactions for all prior periods up to and including the G/L fiscal year and period displayed in the screen header. You can use the Outstanding Adj pushbutton to 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.
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 = "OUT"). This value should include all outstanding transactions for all prior periods up to and including the G/L fiscal year and period displayed in the screen header. You can use the Bank Stmt O/I pushbutton to view the detail transactions that comprise this total.
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 = "CLR") that do not match items from the bank statement. This value should include all unmatched C/R transactions that have not yet been resolved for all prior periods up to and including the G/L fiscal year and period displayed in the screen header. You can use the Unmatched C/R pushbutton to 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.
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 = "CLR") that do not match items from the bank statement. This value should include all unmatched A/P and/or P/R transactions that have not yet been resolved for all prior periods up to and including the G/L fiscal year and period displayed in the screen header. You can use the Unmatched C/D pushbutton to 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.
This non-editable field displays the total of unmatched manual adjustments. These adjustments can be from either the current period or from prior periods.
The system calculates the value that displays in this non-editable field. The system 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 should be equal to the General Ledger balance (Ending Book Balance in this screen) for the G/L account/org(s) linked with this bank abbreviation for the G/L fiscal year and period ending date displayed in the screen header.
Use these pushbuttons to view the detail transactions for each summary subtotal displayed on the bank reconciliation form.
Select this pushbutton to access the Cash Receipts Per Books subtask. Use this subtask to view the cash receipts detail transactions per the General Ledger for the bank abbreviation, fiscal year, and period displayed in the screen header. The detail rows in this table window include both cleared and outstanding C/R transactions (Code = "CLR" and/or "OUT").
Select this pushbutton to access the Cash Disbursements Per Books subtask. Use this subtask to view the cash disbursements (from A/P or P/R) per the General Ledger for the bank abbreviation, fiscal year, and period displayed in the screen header. The detail rows in this table window include both cleared and outstanding A/P and/or P/R transactions (Code = "CLR" and/or "OUT").
Select this pushbutton to access the Manual Adjustments subtask. Use this subtask to view manual adjustment transaction data (Trans Type = "MAN") entered in the Accept Bank Transactions screen for the bank abbreviation, fiscal year, and period displayed in the screen header. The detail rows in this table window include both cleared and outstanding manual adjustment transactions (Code = "CLR" and/or "OUT").
Select this pushbutton to access the Deposits in Transit subtask. Use this subtask to view the G/L cash receipts transactions for the G/L account/org(s) linked with this bank abbreviation for all outstanding transactions (Code = "OUT"). Transactions are included for all prior periods up to and including the fiscal year and period displayed in the screen header.
Select this pushbutton to access the Outstanding Checks subtask. Use this subtask to view the G/L cash disbursements transactions for the G/L account/org(s) linked with this bank abbreviation for all outstanding transactions (Code = "OUT"). Transactions are included for all prior periods up to and including the fiscal year and period displayed in the screen header.
Select this pushbutton to access the Outstanding Manual Adjustments subtask. Use this subtask to view the manual adjustments entered in the Accept Bank Transactions screen for this bank abbreviation for all outstanding transactions (Code = "OUT"). Transactions are included for all prior periods up to and including the fiscal year and period displayed in the screen header.
Select this pushbutton to access the Bank Statement Outstanding Items subtask. Use this subtask to view the bank statement outstanding items entered in the Accept Bank Transactions screen for this bank abbreviation for all outstanding transactions (Code = "OUT"). Transactions are included for all prior periods up to and including the fiscal year and period displayed in the screen header.
Select this pushbutton to access the Unmatched Cash Receipts subtask. Use this subtask to view the G/L cash receipts transactions for the bank abbreviation displayed in the screen header for all cleared transactions (Code = "CLR") that do not match items from the bank statement. This value should include all unmatched C/R transactions that have not yet been resolved for all prior periods up to and including the fiscal year and period displayed in the screen header.
Select this pushbutton to access the Unmatched Cash Disbursements subtask. Use this subtask to view the G/L cash disbursements transactions for the bank abbreviation displayed in the screen header for all cleared transactions (Code = "CLR") that do not match items from the bank statement. This value should include all unmatched A/P and/or P/R transactions that have not yet been resolved for all prior periods up to and including the fiscal year and period displayed in the screen header.
Note that a zero balance in any of the transactions fields on the inquiry screen - 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 selecting the appropriate pushbutton(s) to view the detail for the affected type(s) of transaction(s).
Additionally, 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.
Select this pushbutton to access the Unmatched Manual Adjustments subtask. Use this subtask to view the G/L bank balance, the bank amount, and the variance for the bank abbreviation displayed in the screen header. This value will include all transactions that have not yet been resolved for all prior periods up to and including the fiscal year and period displayed in the screen header.