Run the Outstanding Check report to create a list of all the checks that have 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:
From the A/P > Check Reconciliation menu, select Outstanding Check Report to display the Outstanding Check Report screen.
The system populates the header fields with the following information:
Field |
Description |
Design ID |
The system's ID name of the report design, in this instance, CK.REC. |
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, in this instance, CHECK.XREF. |
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. |
In the Br/Tr/All field, enter the branch, territory, or All to include in this report. To include multiple branches, enter the branch numbers separated by a comma. You are limited to eight.
In the Enter End/As of Date field, 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.
In the Post Date >= field, enter the first date for the range that you want to include.
In the Post Date <= field, enter the last date for the range you want to include.
In the Bank ID = field, enter the identification number of the bank that has the account that the checks were written against.
In the REC.DATE > field, enter the first date for the range of time that you want information on.
In the Detail/Summary field, 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.
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.
To view notes on this report, use the Notes hot key to display the View Notes 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.
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: