Use this screen to print a report that is identical to the online summary reconciliation that you can view from the Bank Reconciliation Inquiry screen. To print the Bank Reconciliation Summary Report, select a bank abbreviation, fiscal year, and period from the selection screen.
For General Ledger items, the report prints the beginning book balance and the period totals for cash receipts, cash disbursements, and manual adjustments. The system 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. The system calculates and prints the adjusted bank statement balance.
Note that the detail transactions that make up each summary line displayed on the report can be printed from the Bank Reconciliation Detail Reports screen. As an alternative to printing report data, you can also view the summary and detail data from the Bank Reconciliation Inquiry screen.
The bank statement reconciliation process should always be part of the internal procedures established by your company. Once bank reconciliation is complete, you should retain a copy of this report with your bank reconciliation files.
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 Batch Bank Transactions screens.
In this group box, you can enter or select the desired bank abbreviation for which the bank statement reconciliation can be printed.
Enter a valid bank abbreviation in this required field, or select a bank abbreviation from the drop-down 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 in the Maintain Company Bank Accounts screen automatically displays.
In this group box, you can specify the fiscal year and period for which the bank reconciliation summary will be printed.
Enter a valid fiscal year for which you want to print summary bank reconciliation data, or select a fiscal year from the drop-down list.
Enter a valid accounting period for which you want to print summary bank reconciliation data, or select an accounting period from the drop-down list.
The following data displays in the header of the report:
Bank Abbreviation
Bank Abbreviation Description
Bank Account Number
Bank Name
Bank Statement Ending Date
Fiscal Year
Period
G/L Period Ending Date
In the body of the report, the following information displays:
Beginning Book Balance - The value printed in this field is 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.
Cash Receipts - The value printed in this field is 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).
Cash Disbursements - The value printed in this field is 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).
Manual Adjustments - The value printed in this field is 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).
Ending Book Balance - The value printed in this field is calculated by the system. 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.
Bank Statement Ending Balance - The value printed in this field is the balance for the bank statement ending date prior to the bank statement ending date displayed in the screen header. This data was originally entered in the Maintain Bank Statement Info screen.
Deposits in Transit - The value printed in this field is 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.
Outstanding Checks - The value printed in this field is the total of all G/L cash disbursements transactions for the G/L account/org(s) linked with this bank abbreviation for all outstanding A/P and/or P/R 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.
Outstanding Manual Adjustments - The value printed in this field is the total of all manual adjustments entered in the Accept Bank Transactions screen for this bank abbreviation for all outstanding manual adjustment 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.
Bank Statement Outstanding Items - The value printed in this field is the total of all bank statement outstanding items entered in the Accept Bank Transactions screen for this bank abbreviation for all outstanding items (Code = OUT). This value should include all outstanding items for all prior periods up to and including the fiscal year and period displayed in the screen header.
Unmatched Cash Receipts - The value printed in this field is the total of all G/L cash receipts transactions for the G/L account/org(s) linked with this bank abbreviation for all cleared cash receipts 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.
Unmatched Cash Disbursements - The value printed in this field is 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.
Unmatched Manual Adjustments - The value printed in this field 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 - The value printed in this field is calculated by the system. 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 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 fiscal year and period ending date displayed in the screen header.
Note that a zero balance in any of the transactions fields on the report - 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; or
There are no transactions in the Bank Transactions History table that qualify against your selection criteria; or
Transactions exist, but one or more positive entries offset one or more negative entries so that the net result is zero. You can confirm that this is the situation by printing the appropriate Bank Reconciliation Detail Report(s) 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.