PRINT BANK RECONCILIATION DETAIL REPORTS

Use the Print Bank Reconciliation Detail Reports screen to print reports that show the detail transactions that make up each summary line shown on the Bank Reconciliation Summary Report.

Before you can view data on this screen, you must first run the Create Bank Transactions History process. For reports that include manual adjustment transactions (Transaction Type is MAN), the screen of original entry is the Accept Bank Transactions screen.

You can also print only a segment of the detail transactions from each summary line.

For General Ledger items, you can use this screen to print transactions detail for cash receipts, cash disbursements, and/or manual adjustments.

For Bank Statement items, you can print transactions detail for deposits in transit, outstanding checks, outstanding manual adjustments, unmatched cash receipts, and/or unmatched cash disbursements.

The detail reports that you print from this screen are similar to the online detail transactions subtasks that can be viewed from the View Bank Reconciliation Summary screen, except that there are additional selection criteria.

To print one or more Bank Reconciliation Detail reports, select a bank abbreviation, fiscal year, period, subperiods, range of transaction dates and numbers, cash account/organizations, and the desired reports from the Print Bank Reconciliation Detail Reports screen.

The bank statement reconciliation process should always be part of the internal procedures established by your company. After a bank reconciliation is complete, retain a copy of this report with your permanent bank reconciliation files.

To print reports that relate to the bank statement, you should first clear and/or unclear G/L and manual transactions using either the Accept Bank Transactions or Process Bank Transactions Acceptances screens.

Instead of printing reports, you can view the summary and detail bank reconciliation data on the View Bank Reconciliation Summary screen for all qualified transactions.

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 are also included in the saved parameter ID if there are any. You can change any of the associated selection defaults as necessary.

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 in the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made in 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 in 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.

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.

Option

From the drop-down list, select the range type for selecting a cash account to include on bank reconciliation detail reports.

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.

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.

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.

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.

Option

From the drop-down list, select the range type for selecting the cash organization to include on bank reconciliation detail reports.

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.

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

Option

From the drop-down list, select the range type for selecting the subperiod to include on bank reconciliation detail reports.

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

Option

This field displays One to indicate that one currency displays in the Start Currency field.

Start

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, and Manual Adjustments detail reports. For these option selections, the check boxes for the bank statement-related detail reports are disabled.

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.

Deposits in Transit

Select this check box to print the deposits in transit detail transactions per your selection criteria. This check box is available only if you selected the All in the Subperiod Options field in the Selection Ranges section 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.

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 available only if you selected the All in the Subperiod Option field in the Selection Ranges section on 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.

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.

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.

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.

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.

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

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.

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

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.

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.

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: