Running the Cleared Check Report

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

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

To run a Cleared Check Report:

  1. From the A/P > Check Reconciliation menu, select Cleared Check Report to display the Cleared Check Report screen.

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.

Created

The date the report design was created.

By

The name of the user who created the report design.

File Name

The name of the file from which the data for the report is obtained.

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

Title

The name of the report that displays on the heading of each page in the report, and as the Report Title on the Spooler Control screen of the Hold file.

Sample

If designated on the Report Writer/Mass Load Design screen, the number of selected records to which the report is limited.

  1. In the Bank ID field, enter the identification number of the bank that has the account that the checks were written against.

  2. In the REC.DATE > field, enter the first date for the range of time that you want information on.

  3. In the REC.DATE < field, enter the last date for the range of time that you want information on.

  1. To add additional data to this report, use the Column Data or the Selection Data hot keys to display the Column Data screen and the Selection Data screen, respectively. For more information, see Report Writer/Mass Load Overview.

  2. To view notes on this report, use the Notes hot key to display the View Notes For screen, which contains the user notes entered for this report design in the Report Writer/Mass Load Design screen. Notes display in view-only mode.

  3. Set options, if needed, and generate the 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.

See Also:

Report Writer/Mass Load Overview

Reconciling Checks Overview