Contents of the Print Bank Reconciliation Detail Reports Screen
Use the fields and options to configure the Print Bank Reconciliation Detail Reports 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, you can enter or select the desired bank abbreviation for which to print the bank statement reconciliation detail reports.
Field | Description |
---|---|
Bank Abbr |
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 bank abbreviation description that was set up on the Manage Company Bank Accounts screen displays in the field to the right. |
Cash Accounts
In this row, specify the cash accounts to include on the bank reconciliation detail reports. Most users will use only one cash account/organization per bank account. The ability to select data by cash account/organization is intended for use when the General Ledger cash account/organization changes in your Chart of Accounts.
Field | Description |
---|---|
Option |
From the drop-down list, select the range type for selecting a cash account to include on bank reconciliation detail reports. The options are:
|
Start |
Enter the starting cash account to include on reports. You can click to select a cash account from a list. This field is available only when you select One, Range, or To End in the Option (Cash Accounts) field. |
End |
Enter the ending cash account to include on reports. You can click to select a cash account from a list. This field is available only when you select Range or From Beginning in the Option (Cash Accounts) field. |
Transaction Date
In this row, specify the transaction date or dates for which to print the bank reconciliation detail reports.
Transaction date sources are as follows:
- CR transaction type: The transaction date is the cash receipt date.
- AP and/or PR transaction type: The transaction date is the check date.
- MAN transaction type: The transaction date is the date entered in the Trans Date field on the Accept Bank Transactions screen.
Field | Description |
---|---|
Option |
From the drop-down list, select the range type for selecting the transaction dates for the transactions to include on bank reconciliation detail reports. The options are:
|
Start |
Enter the starting transaction date to include on reports. You can click to select a transaction date from a list. This field is available only when you select One, Range, or To End in the Option (Transaction Date) field. |
End |
Enter the ending transaction date to include on reports. You can click to select a transaction date from a list. This field is available only when you select Range or From Beginning in the Option (Transaction Date) field. |
Transaction No.
In this row, specify the transaction number or numbers for which to print the bank reconciliation detail reports.
Transaction number sources are as follows:
- CR transaction type: The transaction number is the cash receipt number.
- AP and/or PR transaction type: The transaction number is the check number.
- MAN transaction type: The transaction number is the number entered in the Trans Number field on the Accept Bank Transactions screen.
Field | Description |
---|---|
Option |
From the drop-down list, select the range type for selecting the transaction numbers of the transactions to include on bank reconciliation detail reports. The options are:
|
Start |
Enter the starting transaction number to include on reports. You can click to select a transaction number from a list. This field is available only when you select One, Range, or To End in the Option (Transaction No.) field. |
End |
Enter the ending transaction number to include on reports. You can click to select a transaction number from a list. This field is available only when you select Range or From Beginning in the Option (Transaction No.) field. |
Cash Organizations
In this row, specify the cash organizations for which to print the bank reconciliation detail reports.
Field | Description |
---|---|
Option |
From the drop-down list, select the range type for selecting the cash organization to include on bank reconciliation detail reports. The options are:
|
Start |
Enter the starting cash organization to include on reports. You can click to select a cash organization from a list. This field is available only when you select One, Range, or To End in the Option (Cash Organization) field. |
End |
Enter the ending cash organization to include on reports. You can click to select a cash organization from a list. This field is available only when you select Range or From Beginning in the Option (Cash Organization) field. |
Accounting Period
In this row, specify the fiscal year and accounting period to include on bank reconciliation detail reports.
Field | Description |
---|---|
Option |
This field displays One to indicate that you can enter only one fiscal year and period. |
Fiscal Year |
Enter a fiscal year for which you want to print detail bank reconciliation data, or click to select a fiscal year from a list. |
Period |
Enter an accounting period for which to print detail bank reconciliation data, or click to select a period from a list. |
Subperiod
Field | Description |
---|---|
Option |
From the drop-down list, select the range type for selecting the subperiod to include on bank reconciliation detail reports. The options are:
|
Start |
Enter the starting subperiod to include on reports. You can click to select a subperiod from a list. This field is available only when you select One, Range, or To End in the Option (Subperiod) field. |
End |
Enter the ending subperiod to include on reports. You can click to select a subperiod from a list. This field is available only when you select Range or From Beginning in the Option (Subperiod) field. |
Currency
Field | Description |
---|---|
Option |
This field displays One to indicate that one currency displays in the Start Currency field. |
Start |
This field displays your company's bank account currency. |
Options
Select Reports
In this group box, select the individual detail reports that you want to print. Select the check boxes of the detail reports you want to print.
When you select All in the Option (Subperiod) field in the Selection Ranges block on this screen, you can choose from all the detail reports listed on this screen.
When you select One, Range, From Beginning, or To End in the Option (Subperiod) field in the Selection Ranges block on this screen, you can select only the Cash Receipts Per Books, Cash Disbursements Per Books, Manual Adjustments, and Bank Statement Outstanding Items detail reports. For the other six option selections (Deposits in Transit, Outstanding Checks, Outstanding Adjustments, Unmatched Cash Receipts , Unmatched Cash Disbursements , and Unmatched Adjustments ), the check boxes for the bank statement-related detail reports are disabled.
Field | Description |
---|---|
Cash Receipts Per Books |
Select this check box to print the cash receipts detail transactions from the General Ledger per your selection criteria. The selected bank abbreviation, fiscal year, and period display in the report header along with the bank account number and the cash account/organization. The detail rows in this report include both cleared (CLR) and outstanding (OUT) Cash Receipt (C/R) transactions. To make the report easier to read, however, the Clr Cd column on the report displays CLR for cleared transactions, and the column is blank for outstanding transactions. In addition, values in the Bank Amount and Variance columns print on the report only if there is a difference between the General Ledger Amount and the Bank Amount for outstanding transactions only. Data for this report is retrieved from existing data in the Bank Transactions History table. If no transactions print on this report, see the special Hint at the end of this section for possible reasons. The Cash Receipts Per Books detail transactions report displays the following data:
|
Cash Disbursements Per Books |
Select this check box to print the cash disbursements detail transactions from the General Ledger per your selection criteria. When you select this check box, the AP check box is automatically selected, and only AP-type transactions print on the report. Clear the AP check box if you do not want to print the report for AP detail transactions. You can select the PR check box in place of or in addition to the AP check box to print detail transactions from payroll, where the transaction type is PR. You must select at least one of these two check boxes (AP or PR) for any information to print. The selected bank abbreviation, fiscal year, and period display in the report, along with the bank account number and the cash account/organization. The detail rows in this report include both cleared (CLR)and outstanding (OUT) AP and/or PR transactions. To make the report easier to read, however, the Clr Cd column on the report displays CLR for cleared transactions, and the column is blank for outstanding transactions. The values in the Bank Amount and Variance columns print on the report only if there is a difference between the G/L amount and the Bank amount for outstanding transactions. Data for this report is retrieved from existing data in the Bank Transactions History table. If no transactions print on this report, see the special hint at the end of this section for possible reasons. The Cash Disbursements Per Books detail transactions report displays the following data:
|
Manual Adjustments |
Select this check box to print the manual adjustments data (entered on the Accept Bank Transactions screen) per your selection criteria. The selected bank abbreviation, fiscal year, and period display in the report header, along with the bank account number and the cash account/organization. The detail rows in this report include both cleared (CLR) and outstanding (OUT) manual adjustment transactions (MAN). To make the report easier to read, the Clr Cd column displays CLR for cleared transactions, and the column is blank for outstanding transactions. The values in the Bank Amount and Variance columns print on the report only if there is a difference between the General Ledger amount and the Bank amount for outstanding transactions. Always keep manual adjustment entries to a minimum. Under normal circumstances, bank interest is recorded as a cash receipt in Accounts Receivable, and bank charges are recorded in Accounts Payable. Manual entries are designed to facilitate bank reconciliations only in the rare circumstance in which the normal data entry source has not been used. Data for this report is retrieved from existing data in the Bank Transactions History table. If no transactions print on this report, see the special hint at the end of this section for possible reasons. The Manual Adjustments detail transactions report displays the following data:
|
Deposits in Transit |
Select this check box to print the deposits in transit detail transactions per your selection criteria. This check box is only available if you select All in the Subperiod field in the Selection Ranges group box of this screen. The selected bank abbreviation, fiscal year, and period display in the report header, along with the bank account number and the cash account/organization. The detail rows in this report include all outstanding General Ledger cash receipts transactions (transaction types CR and OUT) for all prior periods up to and including the selected General Ledger fiscal year and period. Because this report prints only outstanding transactions, the Bank Amount and Variance columns are blank. Data for this report is retrieved from existing data in the Bank Transactions History table. If no transactions print on this report, see the special hint at the end of this section for possible reasons. The Deposits in Transit detail transactions report displays the following data:
|
Outstanding Checks |
Select this check box to print the outstanding cash disbursements detail transactions from the General Ledger per your selection criteria. This check box is only available if you select All in the Subperiod field in the Selection Ranges group box of this screen. When you select this check box, the AP check box is also automatically selected, and only AP-type transactions print on the report. You can clear the AP check box if you do not want to print the report for AP detail transactions. You can select the PR check box in place of or in addition to the AP check box to print detail transactions from payroll, where Trans Type is PR. You must select at least one of these two AP or PR check boxes for any information to print on the report. The selected bank abbreviation, fiscal year, and period display in the report header, along with the bank account number and the cash account/organization. The detail rows in this report include only outstanding (OUT) AP and/or PR transactions for all prior periods up to and including the selected General Ledger fiscal year and period. Because this report prints only outstanding transactions, the Bank Amount and Variance columns are blank. Data for this report is retrieved from existing data in the Bank Transactions History table. If no transactions print on this report, see the special hint at the end of this section for possible reasons. The Outstanding Checks detail transactions report displays the following data:
|
Outstanding Adjustments |
Select this check box to print the outstanding manual adjustments data per your selection criteria. The selected bank abbreviation, fiscal year, and period display in the report header, along with the bank account number and the cash account/organization. This check box is only available if you select All in the Subperiod field in the Selection Ranges group box of this screen. The detail rows in this report include outstanding (OUT) manual adjustment transactions (MAN) entered on the Accept Bank Transactions screen for this bank abbreviation. The report prints outstanding transactions for all prior periods up to and including the selected fiscal year and period. Because this report prints only outstanding transactions, the Bank Amount and Variance columns are blank. You should always keep manual adjustment entries to a minimum. Under normal circumstances, bank interest should be recorded as a Cash Receipt and bank charges should be recorded in Accounts Payable. Manual entries are designed to facilitate bank reconciliations only in the rare circumstance in which the normal data entry source has not been used. Data for this report is retrieved from existing data in the Bank Transactions History table. If no transactions print on this report, see the special hint at the end of this section for possible reasons. The Outstanding Adjustments detail transactions report displays the following data:
|
Bank Statement Outstanding Items |
Select this check box to print the bank statement outstanding items per your selection criteria. The report prints all bank statement outstanding items for all prior periods up to and including the selected fiscal year and period. The selected bank abbreviation, fiscal year, and period display in the report header, along with the bank account number and the cash account/organization. The Bank Statement Outstanding Items report displays the following data:
|
Unmatched Cash Receipts |
Select this check box to print the unmatched G/L cash receipts transactions (all cleared transactions that do not match items from the bank statement). The report prints all unmatched cash receipts transactions that have not yet been resolved for all prior periods up to and including the selected fiscal year and period. This check box is only available if you select All in the Subperiod field in the Selection Ranges group box of this screen. The selected bank abbreviation, fiscal year, and period display in the report header, along with the bank account number and the cash account/organization. The detail rows in this report include only cleared cash receipts transactions that are unmatched (Trans Type is CR, Code is CLR, and Unmatched is Y). Data for this report is retrieved from existing data in the Bank Transactions History table. If no transactions print on this report, see the special hint at the end of this section for possible reasons. The Unmatched Cash Receipts detail transactions report displays the following data:
|
Unmatched Cash Disbursements |
Select this check box to print the unmatched G/L cash disbursements transactions (all cleared transactions that do not match items from the bank statement). The report prints all unmatched A/P and/or P/R transactions that have not yet been resolved for all prior periods up to and including the selected fiscal year and period. This check box is only available if you select All in the Subperiod field in the Selection Ranges group box of this screen. When you select this check box, the AP check box is also automatically selected, and only AP-type transactions are printed on the report. Clear this check box if you do not want to print the report for A/P detail transactions. Select the PR check box in place of or in addition to the AP check box to print detail transactions from payroll, where Trans Type is PR. At least one of these two check boxes must be selected for any information to print on the report. The selected bank abbreviation, fiscal year, and period display in the report header, along with the bank account number and the cash account/organization. The detail rows in this report include only cleared A/P and/or P/R transactions that are unmatched (Trans Type is AP and/or PR, Code is CLR, and Unmatched is Y). Data for this report is retrieved from existing data in the Bank Transactions History table. If no transactions print on this report, see the special hint at the end of this section for possible reasons. The Unmatched Cash Disbursements detail transactions report displays the following data:
|
Unmatched Adjustments |
Select this check box to print the unmatched manual adjustments transactions. The report prints all the adjustments detail in which the G/L and bank statement amounts differ. This check box is only available if you select All in the Subperiod field in the Selection Ranges group box of this screen. The bank abbreviation, fiscal year, and period that you selected display in the report header, along with the bank account number and the cash account/organization. Data for this report is retrieved from existing data in the Bank Transactions History table. If no transactions print on this report, see the special hint at the end of this section for possible reasons. The Unmatched Manual Adjustments report displays the following data:
|
Special Hint |
If there are no detail transactions on one or more of the reports—Cash Receipts Per Books, Cash Disbursements Per Books, Manual Adjustments, Deposits in Transit, Outstanding Checks, Outstanding Adjustments, Unmatched Cash Receipts, and/or Unmatched Cash Disbursements—it may be the result of one of the following conditions:
Additionally, the following situation may cause the Unmatched Cash Receipts and/or Unmatched Cash Disbursements reports to have no detail:
Note: You can save your selection criteria for this report with or without printing. After making your selections, click
. Enter an alphanumeric identifying code and a short description to help you recognize the report parameters and click
OK. Later, you can click
to access the print parameters you previously created and saved. In this manner, you can print a report using your pre-defined parameters without having to re-enter the selection options. Stored report parameters are especially helpful if reports are to be run through Process Manager.
|