Running the Cleared Check Report

Use the Cleared Check Report to create a list of all the checks that have cleared as of a designated reconciliation date.

For a description of the report, see What the Report Shows at the end of the topic.

To run a Cleared Check Report:

From the A/P > Check Reconciliation menu, select Cleared Check Report to display the Report Driver window for cleared checks.

The system populates the header area with the following information:

Field	Description
Design ID*	The system's ID name of the report design, in this instance, CK.CLR.
File Name*	The name of the Solar Eclipse file from which the data for the report is obtained.
Width*	The width of the report, based on the number of characters, from the left side of the report to the right side of the report, including the spaces between columns.
Sample	If designated on the Report Writer/Mass Load Design screen, the number of selected records to which the report was limited.
Created*	The date the report design was last created.
By*	The name of the user who created the report design.
Title*	The name of the report that displays on the heading of each page in the report, and as the Report Title in the Report Queue window.

* View Only

Prompt	Description
Multi Value Pos	Enter a numeric value for which you want information for the report.
REC.DATE =	Enter the first date for the range of time you want information on.
Detail/Summary	Enter one of the following to determine at what level you want the report printed: Detail - Creates a report that includes the check number, posting date, vendor, check amount, and total for all checks. This is the default. Summary - Creates a report that includes the total amount of all the checks.

Column	Column Header	Prompt	Data
3*	POST.DATE	Multi Value Pos	Enter the value for which you want to information for the report in the Post Date field.
5*	CHECK.AMT	Enter End/As of Date	Enter a date for which you want to report.

Selection	Prompt	Data
$MV.POS$	Multi Value Pos	Enter the value for which you want to information for the report.
$REC.DATE$	REC.DATE =	Enter the first date for the range of time you want information on.
$BANK.ID$	Bank Id=	Enter the bank ID number for which you want information.

To view notes on this report, click the Notes tab to display the user notes that were entered for this report design in the Report Writer/Mass Load Design window. Notes display in a view only mode.
Set options, if needed, and generate report.

What the Report Shows

The Cleared Check Report shows the following information:

Column	Description
Bank ID	The identification number of the bank that has the account against which the checks were written.
Check No	The check number.
Post Date	The date the amount due was posted.
Rec Date	The date the amount was reconciled.
Name	The name of the person or company to whom the check was written.
Check Amt	The amount of the check.