Use the fields and options to configure the Print Bank Reconciliation Summary Report screen.
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, if there are any, are also included in the saved parameter ID. You can change any of the associated selection defaults as necessary.
Field | Description |
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 on the screen, such as PERIOD or QUARTERLY.
When you save your record, all the selections made on 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 on 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.
Field | Description |
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.
Field | Description |
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:
- Bank Abbreviation
- Bank Abbreviation Description
- Bank Account Number
- Bank Name
- Bank Statement Ending Date
- Fiscal Year
- Period
- G/L Period Ending Date
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 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.
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.
|