Running the Outstanding Check Report

Run the Outstanding Check Report to create a list of all the checks that have been posted but have not yet cleared the bank.

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

To run an Outstanding Check Report:

  1. From the A/P > Check Reconciliation menu, select Outstanding Check Report to display the Report Driver window for outstanding checks

The system populates the header area with the following information. Only the Sample field is editable:

Column

Description

Design ID

The system's ID name of the report design, in this instance, CK.REC.

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 window, the number of selected records to which the report was limited.

Created

The date the report design was created.

By

The name of the user who created the report design.

Title

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

  1. In the User Inputs tab, enter the following information:

Prompt

Data

Multi Value Pos

Enter the value for which you want to information for the report.

Enter End/As of Date

Enter the date to determine which checks to include in the report. Only checks with dates that are open prior to or equal to this date are included.

POST.DATE <=

Enter the last date for the range you want to include.

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.

  1. In the Column Data tab, enter the following information:

Column

Column Header

Prompt

Data

1*

Br

Multi Value Pos

Enter the value for which you want to information for the report on the Branch column.

6*

REC.DATE

Multi Value Pos

Enter the value for which you want to information for the report on the receive date.

  1. In the Selection Data tab, enter the following information:

Selection

Prompt

Data

$MV.POS$

Multi Value Pos

Enter the value for which you want to information for the report.

$POST.DATE$

POST.DATE <=

Enter the last date for the range you want to include.

$REC.DATE$

REC.DATE >

Enter the first date for the range of time you want information on.

  1. 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 are displayed in a view only mode.

  1. Set options, if needed, and generate report.

What the Report Shows

The Outstanding Check Report shows the following information:

Column

Description

Br.

The branch for which the report was run.

Check No.

The check number.

Post Date

The date the amount was posted.

Bank ID

The identification number of the bank that has the account against which the checks were written.

Name

The name of the person or company to whom the check was written.

Check Amt

The amount of the check.

Rec Date

The date the amount was reconciled.

See Also:

Report Writer/Mass Load Overview

Reconciling Checks Overview