Contents of the Print Bank Reconciliation Detail Reports Screen
Use the fields and options to configure the Print Bank Reconciliation Detail Reports screen.
Print Bank Reconciliation Detail Report
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
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
|
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
|
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
|
| End |
Enter the ending transaction date to include on reports. You can click
|
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
|
| End |
Enter the ending cash account to include on reports. You can click
|
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
|
| End |
Enter the ending cash organization to include on reports. You can click
|
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
|
| End |
Enter the ending transaction number to include on reports. You can click
|
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. |
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.
| Field | Description |
|---|---|
| Transactions Per Books |
Select this checkbox to print bank statement transactions. The selected bank abbreviation displays 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) transactions, labeled accordingly in the Clr Cd column of the report. 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 Transactions Per Books detail transactions report displays the following data:
If you select this checkbox, you must select at least one transaction type for this report option. |
| AP |
Select this checkbox to include cash disbursement detail transactions in the Transactions Per Books report.
|
| CR |
Select this checkbox to include cash receipts detail transactions in the Transactions Per Books report.
|
| PR |
Select this checkbox to include payroll detail transactions in the Transactions Per Books report. |
| 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 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), labeled accordingly in the Clr Cd column of the report. 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:
|
| Outstanding Transactions |
Select this checkbox to print the detail transactions for deposits in transit and outstanding checks. The selected bank abbreviation displays 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 AP, CR, PR) dated up to transaction end date you entered on the screen header . 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 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 displays in the report header, along with the bank account number and the cash account/organization. The detail rows in this report include outstanding (OUT) manual adjustment transactions (MAN and/or ADJ) 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:
|
| Outstanding Bank Statement Items |
Select this check box to print the bank statement outstanding items per your selection criteria. The report prints all bank statement outstanding items dated on or before the transaction end date you entered on the header of this screen. The selected bank abbreviation displays 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:
|
| Special Hint |
If there are no detail transactions on one or more of the reports—Transactions Per Books, Manual Adjustments, Outstanding Transactions, and Outstanding Adjustments—it may be the result of one of the following conditions:
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.
|
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.
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.
. Enter an alphanumeric identifying code and a short description to help you recognize the report parameters and click