|
|
|
|
|
|
|
Contents |
Check Reconciliation reports allow you to generate a report of check information for a specific bank or for all banks. The following reports are available:
Report for "Bank Cash Account" Only
This report generates a report of check information for the highlighted bank in the Existing Cash Accounts list.
Menu Path: Financial Mngmnt / A/P / Check Rec.
On the Check Reconciliation screen, from the Existing Cash Accounts list, highlight the Cash Acct on which you wish to report.
In the Sequence frame, select the order in which you want the report to print. Reports can print in either Check Number or Payee Key order.
Click the Report button.
Select the Report for "Bank Cash Account" Only. The name between the quotation marks is the selected Cash Account. The Check Ranges screen opens.
As necessary, enter a low and high Check Nbr range. All checks with check numbers in this range are included on the report, provided they meet the other criteria you set.
As necessary, enter a low and high Vendor Key range. All vendors with checks in this range are included on the report, provided they meet the other criteria you set.
As necessary, enter a low and high Check Date range. All checks with check dates in this range are included on the report, provided they meet the other criteria you set.
As necessary, enter a low and high Amount range. All checks whose total amounts are within this range are included on the report, provided they meet the other criteria you set.
Continuous Void – is a Remittance Overflow check. If the invoices contained on a check exceed 14 lines, the check is voided and continues to the next check. The voided check is a "Continuous Void".
Select the Check Types you wish to print on the report. All are checked by default:
Regular (includes Regular, Hold, Single, Pay, and Continuous Void)
Manual
Void
Quick Void
Payables Expense
Payables Reversal
From the Open Checks drop down list, select Yes or No to determine whether to report checks that are open. A check is "Open" if it has not yet been reconciled.
The Open As Of field is active only if the Open Checks drop down list is set to Yes. The default is the current date but may be updated. Only checks open as of this date are included on the report, provided they meet the other criteria you set.
The Statement Date field is active only if the Open Checks drop down list is set to No. As necessary, enter a low and high Statement Date. All checks with Statement Dates in this range are included on the report, provided they meet the other criteria you set.
Click the Print button. The Output Destination screen opens.
The system prompts you to select a print option. You can choose to print the reports to screen, to a printer, or to save the report for later viewing.
Click the OK button.
After the report prints, click the Close button to return to the Check Reconciliation.
The Report for All Banks generates a report for all of the banks listed in the Existing Cash Accounts list.
Menu Path: Financial Mngmnt / A/P / Check Rec.
On the Check Reconciliation screen, in the Sequence frame, select the order in which you want the report to print. Reports can print in either Check Number or Payee Key order.
Click the Reports button.
Select Report for All Banks. The Check Ranges screen opens.
As necessary, enter a low and high Check Nbr range. All checks with check numbers in this range are included on the report, provided they meet the other criteria you set.
As necessary, enter a low and high Vendor Key range. All vendors with checks in this range are included on the report, provided they meet the other criteria you set.
As necessary, enter a low and high Check Date range. All checks with check dates in this range are included on the report, provided they meet the other criteria you set.
As necessary, enter a low and high Amount range. All checks whose total amounts are within this range are included on the display, provided they meet the other criteria you set.
Continuous Void – is a Remittance Overflow check. If the invoices contained on a check exceed 14 lines, the check is voided and continues to the next check. The voided check is a "Continuous Void".
Select the Check Types you wish to print on the report. All are checked by default:
Regular (includes Regular, Hold, Single, Pay, and Continuous Void)
Manual
Void
Quick Void
Payables Expense
Payables Reversal
From the Open Checks drop down list, select Yes or No to determine whether to report checks that are open. A check is "Open" if it has not yet been reconciled.
The Open As Of field is active only if the Open Checks drop down list is set to Yes. The default is the current date but may be updated. Only checks open as of that date are included on the report, provided they meet the other criteria you set.
The Statement Date field is active only if the Open Checks drop down list is set to No. As necessary, enter a low and high Statement Date. All checks with Statement Dates in this range will be included on the report, provided they meet the other criteria you set.
Click the Print button. The Output Destination screen opens.
The system prompts you to select a print option. You can choose to print the reports to screen, to a printer, or to save the report for later viewing.
Click the OK button.
After the report prints, click the Close button to return to the Check Reconciliation screen.
The Report for Multiple Banks generates a report for a range of the banks listed in Existing Cash Accounts list.
Menu Path: Financial Mngmnt / A/P / Check Rec.
On the Check Reconciliation screen, in the Sequence frame, select the order in which you want the report to print. Reports can print in either Check Number or Payee Key order.
Click the Reports button.
Select Report for Multiple Banks. The Check Ranges screen opens.
As necessary, enter a low and high Bank Code range. All checks within in this range are included on the report, provided they meet the other criteria you set.
As necessary, enter a low and high Check Nbr range. All checks with check numbers in this range are included on the report, provided they meet the other criteria you set.
As necessary, enter a low and high Vendor Key range. All vendors with checks in this range are included on the report, provided they meet the other criteria you set.
As necessary, enter a low and high Check Date range. All checks with check dates in this range are included on the report, provided they meet the other criteria you set.
As necessary, enter a low and high Amount range. All checks whose total amounts are within this range are included on the display, provided they meet the other criteria you set.
Continuous Void – is a Remittance Overflow check. If the invoices contained on a check exceed 14 lines, the check is voided and continues to the next check. The voided check is a "Continuous Void".
Select the Check Types you wish to print on the report. All are checked by default.
Regular (includes Regular, Hold, Single, Pay, and Continuous Void)
Manual
Void
Quick Void
Payables Expense
Payables Reversal
From the Open Checks drop down list, select Yes or No to determine whether to report checks that are open. A check is "Open" if it has not yet been reconciled.
The Open As Of field is active only if the Open Checks drop down list is set to Yes. The default is the current date but may be updated. Only checks open as of that date are included on the report, provided they meet the other criteria you set.
The Statement Date field is active only if the Open Checks drop down list is set to No. As necessary, enter a low and high Statement Date. All checks with Statement Dates in this range will be included on the report, provided they meet the other criteria you set.
Click the Print button. The Output Destination screen opens.
The system prompts you to select a print option. You can choose to print the reports to screen, to a printer, or to save the report for later viewing.
Click the OK button.
After the report prints, click the Close button to return to the Check Reconciliation screen.
The Reconciliation Summary Report generates a report that displays summary information for a selected Cash Account. This information includes a summary of the ending cash balance, outstanding checks and reconciled checks for a selected month/year period.
Menu Path: Financial Mngmnt / A/P / Check Rec.
On the Check Reconciliation screen, in the Sequence frame, select the order in which you want the report to print. Reports can print in either Check Number or Payee Key order.
Click the Reports button.
Select Reconciliation Summary Report. The Reconciliation Summary Report Parameter screen opens.
From the Select Reporting Month list, select the Month/Year period on which you want to report.
Select a Bank code:
Begin typing the Bank code in the Bank EEL. Select from the list that appears.
Click on the Bank button. The Bank Cash Accounts List screen opens:
From the Available Cash Accounts list, highlight the Code you want to use.
Click the Select button.
The Cash Account # is the account assigned to the bank’s cash account.
The Banks Included in the Reconciliation lists all banks that may share the same cash account.
Click the Print button. The Output Destination screen opens.
The system prompts you to select a print option. You can choose to print the reports to screen, to a printer, or to save the report for later viewing.
Click the OK button.
After the report prints, click the Close button to return to the Check Reconciliation screen.
Version 01.04.07.0 – 010234