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 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.

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:

  • All: Select this option to include all transaction dates. The Start Transaction Date and End Transaction Date fields are disabled for this option.
  • One: Select this option to include one transaction date. Enter the transaction date in the Start Transaction Date field. The End Transaction Date field is disabled for this option.
  • Range: Select this option to include a contiguous range of transaction dates. Enter the starting and ending transaction date in the Start Transaction Date and End Transaction Date fields.
  • From Beginning: Select this option to choose a range of transaction dates that starts from the beginning of all available transaction dates and ends with the transaction date that you enter in the End Transaction Date field. The Start Transaction Date field is disabled for this option.
  • To End: Select this option to choose a range of transaction dates that starts with the transaction date that you enter in the Start Transaction Date field and ends with the last transaction date of all the available transaction dates. The End Transaction Date field is disabled for this option.
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.

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:

  • All: Select this option to display all cash accounts. The Start Cash Accounts and End Cash Accounts fields are disabled for this option.
  • One: Select this option to display one cash account. Enter the cash account in the Start Cash Accounts field. The End Cash Accounts field is disabled for this option.
  • Range: Select this option to display cash accounts for a contiguous range. Then, enter the starting and ending cash account in the Start Cash Accounts and End Cash Accounts fields.
  • From Beginning: Select this option to choose a range of cash accounts that starts from the beginning of all available cash accounts and ends with the cash account that you enter in the End Cash Accounts field. The Start Cash Accounts field is disabled for this option.
  • To End: Select this option to choose a range of cash accounts that starts with the cash account that you enter in the Start Cash Accounts field and ends with the last cash account of all the available cash accounts. The End Cash Accounts field is disabled for this option.
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.

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:

  • All: Select this option to include all cash organizations. The Start Cash Organizations and End Cash Organizations fields are disabled for this option.
  • One: Select this option to include one cash organization. Enter the cash organization in the Start Cash Organizations field. The End Cash Organizations field is disabled for this option.
  • Range: Select this option to include a contiguous range of cash organizations. Enter the starting and ending cash organization in the Start Cash Organizations and End Cash Organizations fields.
  • From Beginning: Select this option to choose a range of cash organizations that starts from the beginning of all available cash organizations and ends with the cash organization that you enter in the End Cash Organizations field. The Start Cash Organizations field is disabled for this option.
  • To End: Select this option to choose a range of cash organizations that starts with the cash organization that you enter in the Start Cash Organizations field and ends with the last cash organization of all the available cash organizations. The End Cash Organization field is disabled for this option.
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.

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:

  • All: Select this option to include all transaction numbers. The Start Transaction Number and End Transaction Number fields are disabled for this option.
  • One: Select this option to include one transaction number. Enter the transaction number in the Start Transaction Number field. The End Transaction Number field is disabled for this option.
  • Range: Select this option to include a contiguous range of transaction numbers. Enter the starting and ending transaction number in the Start Transaction Number and End Transaction Number fields.
  • From Beginning: Select this option to choose a range of transaction numbers that starts from the beginning of all available transaction numbers and ends with the transaction number that you enter in the End Transaction Number field. The Start Transaction Number field is disabled for this option.
  • To End: Select this option to choose a range of transaction numbers that starts with the transaction number that you enter in the Start Transaction Number field and ends with the last transaction number of all the available transaction number. The End Transaction Number field is disabled for this option.
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.

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:

  • Trans Type (AP, CR, and/or PR)
  • Clr Cd (CLR and/or OUT)
  • Trans Date
  • Trans No
  • Trans ID
  • Trans Description
  • G/L Amount
  • Bank Amount (displays only if different from G/L Amount)
  • Variance
  • Subtotals (by cash account/organization)
  • Grand Total: These fields display the sums of the Trans Totals and Func Totals in the G/L Amount column.

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:

  • Trans Type (ADJ and/or MAN)
  • Clr Cd (CLR and/or OUT)
  • Trans Date
  • Trans No
  • Trans ID
  • Trans Desc
  • G/L Amount
  • Bank Amount (displays only if different from G/L Amount)
  • Variance
  • Subtotals (by cash account/organization)
  • Grand Total: If you selected all records for this report, the Grand Total field displays the same total as the summary line for Manual Adjustments on the View Bank Reconciliation Summary screen and the Bank Reconciliation Summary Report.
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:

  • Trans Type (AP, CR, and/or PR)
  • Clr Cd (OUT)
  • Trans Date
  • Trans No
  • Trans ID
  • Trans Desc
  • G/L Amount
  • Subtotals (by cash account/organization)
  • Grand Total: If you selected all records for this report, the Grand Total field displays the same total as the summary line for Outstanding Transactions on the View Bank Reconciliation Summary screen and the Bank Reconciliation Summary Report.
  • Grand Total: These fields display the result of the Trans Totals and Func Totals in the G/L Amount column when accounts payable and payroll totals are subtracted from cash receipt totals.
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:

  • Trans Type (MAN)
  • Clear Code (OUT)
  • Trans Date
  • Trans No
  • Trans ID
  • Trans Desc
  • Adjusted Amount
  • Bank Amount (displays only if different from G/L Amount)
  • Variance
  • Subtotals (by cash account/organization)
  • Grand Total: If you selected all records for this report, the Grand Total field displays the same total as the summary line for Outstanding Manual Adjustments on the View Bank Reconciliation Summary screen and the Bank Reconciliation Summary Report.
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:

  • Trans Date
  • Trans No
  • Trans Description
  • Deposit Amt
  • Check/Withdrawal Amt
  • Subtotals (by cash account/organization)
  • Grand Total
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:

  • 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.
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.