PRINT BANK RECONCILIATION SUMMARY REPORT
Use the Bank Reconciliation Summary Report screen to print a report that is identical to the online summary reconciliation that you can view from the View Bank Reconciliation Summary screen.
Before you can print data for this report, you must first run the Create Bank Transactions History process to create the Bank Transactions History, and then clear checks using either the Accept Bank Transactions or Process Bank Transactions Acceptances screens.
For General Ledger items, the report prints the beginning book balance and the period totals for cash receipts, cash disbursements, and manual adjustments. Costpoint calculates and prints the ending book balance from this data.
For Bank Statement items, the report prints the bank statement ending balance, deposits in transit, outstanding checks, and manual adjustments, as well as unmatched cash receipts and disbursements. Costpoint calculates and prints the adjusted bank statement balance.
The detail transactions that make up each summary line displayed on the report can be printed from the Bank Print Bank Reconciliation Detail Reports screen. As an alternative to printing report data, you can also view the summary and detail data from the View Bank Reconciliation Summary screen.
The bank statement reconciliation process should always be part of the internal procedures established by your company. After bank reconciliation is complete, retain a copy of this report with your bank reconciliation files.
Location
Identification
Use the fields in this block to create a new parameter ID or to retrieve
a previously saved parameter ID. A parameter ID represents a set of screen
selection parameters. After you have saved a parameter ID and its related
parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes
more efficiently and with greater consistency. The saved parameters are
also useful and necessary when you want to run the process as part of
a batch job. Many users save a unique set of parameters for each different
way they run a report or process. When you select a previously saved parameter
ID or parameter description, the associated saved screen selection parameters
automatically display as selection defaults. The page setup and print
options are also included in the saved parameter ID if there are any.
You can change any of the associated selection defaults as necessary.
Parameter ID
Enter, or click 
to select, a parameter
ID of up to 15 alphanumeric characters. Choose characters for your parameter
ID that help identify the type of selections you made in the screen, such
as PERIOD or QUARTERLY.
When you save your record, all the selections made in the screen are
stored with the parameter ID. Later, you can retrieve the parameter using
Query.
You can use the parameter to run the process more efficiently because
you can select the parameter ID with its previously defined screen selections.
After the default selections display in the screen, you can override the
defaults.
Description
Enter, or click to select, a parameter
description of up to 30 alphanumeric characters.
Selection Ranges
In this block, select the bank and the accounting period for which to print the Bank Reconciliation Summary report.
Bank Abbreviation
Enter a bank abbreviation, or click 
to select a bank abbreviation from a 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 automatically displays in the field to the right.
Accounting Period
In this row, specify the fiscal year and period for which to print the bank reconciliation summary.
Fiscal Year
Enter the fiscal year for which you want to print summary bank reconciliation data, or use Lookup to select a fiscal year from a list.
Period
Enter the accounting period for which you want to print summary bank reconciliation data, or use Lookup to select an accounting period from a list.
Report
The following data displays in the header of the report:
The following information displays in the body of the report:
-
Beginning Book Balance — This is the General Ledger balance for the G/L account/organization for the G/L period and fiscal year before the fiscal year and period that you selected for this report.
-
Cash Receipts — This is the total of the G/L cash receipts transactions for the G/L account/organizations for the G/L fiscal year and period that you selected for this report. This value includes both cleared (CLR) and outstanding (OUT) Cash Receipt transactions.
-
Cash Disbursements — This is the total of the G/L cash disbursements (from Accounts Payable or Payroll) transactions for the G/L account/organizations for the G/L fiscal year and period that you selected for this report. The value in this field includes both cleared (CLR) and outstanding (OUT) transactions.
-
Manual Adjustments — This is the total of all manual adjustment transaction data entered in the Accept Bank Transactions screen for the G/L fiscal year and period that you selected for this report. The value in this field includes both cleared (CLR) and outstanding (OUT) transactions.
-
Ending Book Balance — This is a calculated amount. The cash receipt, cash disbursement, and manual adjustment totals are added or subtracted to/from the Beginning Book Balance value. The ending book balance should be equal to the General Ledger balance for the G/L account/organizations for the G/L fiscal year and period ending date that you selected for this report.
-
Bank Statement Ending Balance — This is the balance for the bank statement ending date prior to the bank statement ending date that you selected for this report. This data was originally entered on the Manage Bank Statement Information screen.
-
Deposits in Transit — This is the total of all G/L cash receipts transactions for the G/L account/organizations for all outstanding (OUT) transactions. This value should include all outstanding transactions for all prior periods up to and including the G/L fiscal year and period that you selected for this report.
-
Outstanding Checks — This is the total of all G/L cash disbursements transactions for the G/L account/organizations for all outstanding (OUT) Accounts Payable and Payroll transactions. This value should include all outstanding transactions for all prior periods up to and including the G/L fiscal year and period that you selected for this report.
-
Outstanding Manual Adjustments — This is the total of all manual adjustments that were entered in the Accept Bank Transactions screen for all outstanding (OUT) manual adjustment transactions. This value should include all outstanding transactions for all prior periods up to and including the G/L fiscal year and period that you selected for this report.
-
Bank Statement Outstanding Items — This is the total of all bank statement outstanding items that were entered in the Accept Bank Transactions screen for all outstanding (OUT) items. This value should include all outstanding items for all prior periods up to and including the fiscal year and period that you selected for this report.
-
Unmatched Cash Receipts — This is the total of all General Ledger cash receipts transactions for the G/L account/organizations for all cleared (CLR) cash receipts transactions 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 that you entered for this report.
-
Unmatched Cash Disbursements — This is the total of all G/L disbursement transactions for the G/L account/organizations for all cleared (CLR) transactions 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 that you entered for this report.
-
Unmatched Manual Adjustments — This is the total of all the adjustments detail in which the G/L and bank statement amounts differ. These adjustments can be from either the current period or from prior periods.
-
Adjusted Bank Balance — This is a calculated field. The deposits in transit, outstanding checks, manual adjustments, unmatched cash receipts, and unmatched cash disbursements totals are added or subtracted to/from the Bank Statement Ending Balance value. In a reconciled condition, the adjusted bank balance should be equal to the General Ledger balance (Ending Book Balance in this screen) for the G/L account/organizations for the fiscal year and period ending date that you selected for this report.
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 on 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.
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.