Use this screen to print reports showing the detail transactions that make up each summary line shown on the Bank Reconciliation Summary Report. You can also print only a segment of the detail transactions from each summary line. Note that in lieu of printing reports, you can view the summary and detail bank reconciliation data in the Bank Reconciliation Inquiry screen for all qualified transactions.
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 printed from this screen are similar to the online detail transactions subtasks that can be viewed from the Bank Reconciliation Inquiry screen, except that there are additional selection criteria. To print one or more Bank Reconciliation Detail Reports, select a bank abbreviation, fiscal year, period, and subperiod(s), range of transaction dates and numbers, cash account/org(s), and the desired report(s) from the selection screen.
The bank statement reconciliation process should always be part of the internal procedures established by your Company. Once bank reconciliation is complete, you should retain a copy of this report with your permanent bank reconciliation files.
Before you can print data for any of these reports, you must first run the Create Bank Transactions History process to populate the Bank Transactions History table with the G/L transactions from your A/P, cash receipts, and/or payroll tables. For reports involving manual adjustment transactions (Transaction Type is "MAN"), the screen of original entry is the Accept Bank Transactions screen.
If you want 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 Batch Bank Transactions screens. Use the Accept Bank Transactions screen to view all G/L and manual adjustment transactions, clear/unclear these transactions, and match them to the bank transactions on a single or multiple-row basis. Use the Process Batch Bank Transactions screen to clear or unclear groups of transactions based on various selection parameters.
In this group box, you can enter or select the desired bank abbreviation for which the bank statement reconciliation detail report(s) can be printed.
Enter a valid bank abbreviation in this required field, or select a bank abbreviation from the drop-down box. The bank abbreviation represents the bank account that you are reconciling with your books. The bank abbreviation description that was set up in the Maintain Company Bank Accounts screen automatically displays.
In this group box, you can specify the cash account(s) for which the bank reconciliation detail report(s) will be printed. Most users will use only one cash account/org per bank account; the ability to select data by cash account/org is intended for use when the G/L cash account/org changes in your Chart of Accounts.
Enter the desired range or select a range from the drop-down box. Range options include "All," "One," "Range," "From Beginning," and "To End." The default option for this field is "All."
Enter the beginning cash account for the range or use Lookup to select a cash account. If you select "All" or "From Beginning" as the Range Option, this field will be inactive.
Enter the ending cash account for the range or use Lookup to select a cash account. If you select "All," "One," or "To End" as the Range Option, this field will be inactive.
In this group box, you can specify the cash organizations(s) for which the bank reconciliation detail report(s) will be printed.
Enter the range or select a range from the drop-down box. Range options include "All," "One," "Range," "From Beginning," and "To End." The default option for this field is "All."
Enter the beginning cash organization for the range or use Lookup to select a cash organization. If you select "All" or "From Beginning" as the Range Option, this field will be inactive.
Enter the ending cash organization for the range or use Lookup to select a cash organization. If you select "All," "One," or "To End" as the Range Option, this field will be inactive.
In this group box, you can specify the transaction date(s) for which the bank reconciliation detail report(s) will be printed. Transaction date sources are as follows:
For Transaction Type = "CR," the transaction date is the cash receipt date.
For Transaction Type = "AP" and/or "PR," the transaction date is the check date.
For Transaction Type = "MAN," the transaction date is the date entered in the Trans Date field in the Transactions subtask of the Accept Bank Transactions screen.
Enter the range or select a range from the drop-down box. Range options include "All," "One," "Range," "From Beginning," and "To End." The default option for this field is "All."
Enter the beginning transaction date for the range. If you select "All" or "From Beginning" as the Range Option, this field will be inactive.
Enter the ending transaction date for the range. If you select "All," "One," or "To End" as the Range Option, this field will be inactive.
In this group box, you can specify the transaction number(s) for which the bank reconciliation detail report(s) will be printed. Transaction number sources are as follows:
For Transaction Type = "CR," the transaction number is the cash receipt number.
For Transaction Type = "AP" and/or "PR," the transaction number is the check number.
For Transaction Type = "MAN," the transaction number is the number entered in the Trans Number field in the Transactions subtask of the Accept Bank Transactions screen.
Enter the range or select a range from the drop-down box. Range options include "All," "One," "Range," "From Beginning," and "To End." The default option for this field is "All."
Enter the beginning transaction number for the range. If you select "All" or "From Beginning" as the Range Option, this field will be inactive.
Enter the ending transaction number for the range. If you select "All," "One," or "To End" as the Range Option, this field will be inactive.
In this group box you can specify the fiscal year, period, and subperiod(s) for which the bank reconciliation detail report(s) will be printed.
Enter the range or select a range from the drop-down box. Range options include "All," "One," "Range," "From Beginning," and "To End." The default option for this field is "All."
If you select the "All" option, you can choose from all the detail reports listed on this screen.
If you select "One," "Range," "From Beginning," and "To End" as the Range Option, you will be able to select only the Cash Receipts Per Books, Cash Disbursements Per Books, and Manual Adjustments detail reports; the checkboxes for the bank statement-related detail reports will be disabled.
Enter a valid fiscal year for which you want to print detail bank reconciliation data, or select a fiscal year from the drop-down box.
Enter a valid accounting period for which you want to print detail bank reconciliation data, or select an accounting period from the drop-down box.
Enter the beginning subperiod for the range. If you select "All" or "From Beginning" as the Range Option, this field will be inactive.
Enter the ending subperiod for the range. If you select "All," "One," or "To End" as the Range Option, this field will be inactive.
This non-editable field displays your company's bank account currency.
In this group box, you can select the individual detail reports for printing. Select the checkboxes of the detail reports you want to print.
If you have selected the "All" Range Option in the Select Timing group box, you can choose from all the detail reports listed on this screen.
If you have selected "One," "Range," "From Beginning," or "To End" as the Range Option in the Select Timing group box, you will be able to select only the Cash Receipts Per Books, Cash Disbursements Per Books, and Manual Adjustments detail reports. For these Range Option selections, the checkboxes for the bank statement-related detail reports are disabled.
Select this checkbox 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/org.
The detail rows in this report include both cleared and outstanding C/R transactions (Trans Type = "CR," Code = "CLR" and/or "OUT"). To make the report easier to read, however, the Clr Cd column displays "CLR" for cleared transactions and blanks 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 G/L Amount and the Bank Amount for outstanding transactions only.
Data for this report is pulled 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:
Trans Type ("CR")
Clr Cd ("CLR" and /or "OUT")
Bank/GL Match (blanks for "Y" outstanding transactions and /or "N")
Subpd
Recpt Date
Recpt No
Recpt ID
Trans Description
G/L Amount
Bank Amount (displays only if different from G/L Amount)
Variance
Subtotals (by cash account/org)
Grand Total - If you have selected all records for this report, the Grand Total field will display the same total as the summary line for Cash Receipts in the Bank Statement Inquiry screen and the Bank Reconciliation Summary Report.
Select this checkbox to print the cash disbursements detail transactions from the General Ledger per your selection criteria.
When you select this checkbox, the A/P checkbox is also automatically selected as a default. If you accept the default, only AP type transactions will be printed on the report. You can uncheck this checkbox if you do not want to print the report for A/P detail transactions. You can select the PR checkbox in place of or in addition to the A/P checkbox to print detail transactions from payroll, where Trans Type = "PR." At least one of these two checkboxes must be selected 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/org. The detail rows in this report include both cleared and outstanding A/P and/or P/R transactions (Trans Type = "AP" and/or "PR," Code = "CLR" and/or "OUT"). To make the report easier to read, however, the Clr Cd column displays "CLR" for cleared transactions and blanks 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 G/L amount and the Bank amount for outstanding transactions.
Data for this report is pulled 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:
Trans Type ("AP" and/or "PR")
Clr Cd ("CLR" and/or "OUT")
Bank/GL Match (blanks for "Y" outstanding transactions and/or "N")
Subpd
Check Date
Check No
Vend/Empl ID
Trans Desc
G/L Amount
Bank Amount (displays only if different from G/L Amount)
Variance
Subtotals (by cash account/org)
Grand Total - If you have selected all records for this report, the Grand Total field will display the same total as the summary line for Cash Disbursements in the Bank Statement Inquiry screen and the Bank Reconciliation Summary Report.
Select this checkbox to print the manual adjustments data (entered in 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/org.
The detail rows in this report include both cleared and outstanding manual adjustment transactions (Trans Type = "MAN," Code = "CLR" and/or "OUT"). To make the report easier to read, however, the Clr Cd column displays "CLR" for cleared transactions and blanks 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 G/L amount and the Bank amount for outstanding transactions.
You should always keep manual adjustment entries to a minimum. Under normal circumstances, bank interest should be recorded as a cash receipt in Accounts Receivable, 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 pulled 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 ("CR")
Clr Cd ("CLR" and/or "OUT")
Bank/GL Match (blanks for "Y" outstanding transactions and/or "N")
Subpd
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/org)
Grand Total - If you have selected all records for this report, the Grand Total field will display the same total as the summary line for Manual Adjustments in the Bank Statement Inquiry screen and the Bank Reconciliation Summary Report.
Select this checkbox to print the deposits in transit detail transactions per your selection criteria. This checkbox is available only if you have selected the "All" Range Option in the Select Timing group box. The selected bank abbreviation, fiscal year, and period display in the report header, along with the bank account number and the cash account/org.
The detail rows in this report include all outstanding G/L cash receipts transactions (Trans Type = "CR," Code = "OUT") for all prior periods up to and including the selected G/L fiscal year and period. Since this report only prints outstanding transactions, blanks will always display in the Bank Amount and Variance columns.
Data for this report is pulled 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:
Trans Type ("CR")
Clr Cd ("OUT")
Subpd
Recpt Date
Recpt No
Recpt ID
Trans Desc
Receipt Amount
Subtotals (by cash account/org)
Grand Total - If you have selected all records for this report, the Grand Total field will display the same total as the summary line for Deposits in Transit in the Bank Statement Inquiry screen and the Bank Reconciliation Summary Report.
Select this checkbox to print the outstanding cash disbursements detail transactions from the General Ledger per your selection criteria. This checkbox is available only if you have selected the "All" Range Option in the Select Timing group box.
When you select this checkbox, the A/P checkbox is also automatically checked as a default. If you accept the default, only AP type transactions will be printed on the report. You can uncheck this checkbox if you do not want to print the report for A/P detail transactions. You can select the PR checkbox in place of or in addition to the A/P checkbox to print detail transactions from payroll, where Trans Type = "PR." At least one of these two checkboxes must be checked in order for any information to print.
The selected bank abbreviation, fiscal year, and period display in the report header, along with the bank account number and the cash account/org. The detail rows in this report include only outstanding A/P and/or P/R transactions (Trans Type = "AP" and/or "PR," Code = "OUT") for all prior periods up to and including the selected G/L fiscal year and period. Since this report only prints outstanding transactions, blanks will always display in the Bank Amount and Variance columns.
Data for this report is pulled 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:
Trans Type ("AP" and/or "PR")
Clr Cd ("OUT")
Subpd
Check Date
Check No
Vend/Empl ID
Trans Desc
Check Amount
Subtotals (by cash account/org)
Grand Total - If you have selected all records for this report, the Grand Total field will display the same total as the summary line for Outstanding Checks in the Bank Statement Inquiry screen and the Bank Reconciliation Summary Report.
Select this checkbox 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/org.
The detail rows in this report include outstanding manual adjustment transactions (Trans Type = "MAN," Code = "OUT") entered in 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. Since this report prints only outstanding transactions, blanks will always display in the Bank Amount and Variance columns.
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 pulled 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 ("CR")
Clr Cd ("OUT")
Subpd
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/org)
Grand Total - If you have selected all records for this report, the Grand Total field will display the same total as the summary line for Outstanding Manual Adjustments in the Bank Statement Inquiry screen and the Bank Reconciliation Summary Report.
Select this checkbox 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/org.
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/org)
Grand Total
Select this checkbox to print the unmatched G/L cash receipts transactions; i.e., 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/org. The detail rows in this report include only cleared cash receipts transactions that are unmatched (Trans Type = "CR," Code = "CLR," Unmatched = "Y").
Data for this report is pulled 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:
Trans Type ("CR")
Clr Cd ("CLR")
Subpd
Recpt Date
Recpt No
Recpt ID
Trans Name
G/L Amount
Bank Amount
Variance
Bank/GL Match ("N")
Subtotals (by cash account/org)
Grand Total - If you have selected all records for this report, the Grand Total field will display the same total as the summary line for Unmatched Cash Receipts in the Bank Statement Inquiry screen and the Bank Reconciliation Summary Report.
Select this checkbox to print the unmatched G/L cash disbursements transactions; i.e., 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 checkbox, the A/P checkbox is also automatically checked as a default. If you accept this default, only AP type transactions will be printed on the report. You can uncheck this checkbox if you do not want to print the report for A/P detail transactions. You can select the PR checkbox in place of or in addition to the A/P checkbox to print detail transactions from payroll, where Trans Type = "PR." At least one of these two checkboxes must be checked in order for any information to print.
The selected bank abbreviation, fiscal year, and period display in the report header, along with the bank account number and the cash account/org. The detail rows in this report include only cleared A/P and/or P/R transactions that are unmatched (Trans Type = "AP" and/or "PR," Code = "CLR," Unmatched = "Y").
Data for this report is pulled 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:
Trans Type ("AP" and/or "PR")
Clr Cd ("CLR")
Subpd
Check Date
Check No
Vend/Empl ID
Trans Desc
G/L Amount
Bank Amount
Variance
Bank/GL Match ("N")
Subtotals (by cash account/org)
Grand Total - If you have selected all records for this report, the Grand Total field will display the same total as the summary line for Unmatched Cash Disbursements in the Bank Statement Inquiry screen and the Bank Reconciliation Summary Report.
Select this checkbox to print the unmatched manual adjustments transactions. The report prints all the adjustments detail in which the G/L and bank statement amounts differ for the bank abbreviation, fiscal year, and period displayed in the screen header.
The selected bank abbreviation, fiscal year, and period display in the report header, along with the bank account number and the cash account/org.
Data for this report is pulled 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:
Trans Type
Clr Cd
Subpd
Trans Date
Trans No
Trans ID
Trans Desc
G/L Amount
Bank Amount
Variance
Bank/GL Match