Cash Requirements in Check Format Report

Use this option to generate a Cash Requirements report that shows invoices along with the checks and credit memos issued for payment.

With the Cash Requirements option, you can:

Run the report in detail or summary format.
Limit the report to EFT (Electronic Fund Transfer) or non-EFT payments. If needed, you also can include both payment types.
Limit the report to invoices that include discounts.

For the standard procedure for generating Accounts Payable reports, refer to Accounts Payable Reports Menu.

Menu Path: Fund Accounting > Reports > Accounts Payable Reports > Cash Requirements

Selection Criteria

If the Print Checks by Bank Account option is selected in the Fund Accounting profile, the Bank Account field appears as part of the selection criteria. In this case, the output in PDF and Excel is as follows:

Report Output in PDF or Excel

The report is sorted by the bank account instead of the disbursement fund.
Totals: Totals are displayed by the bank account instead of the disbursement fund.

Detail and Summary Reports

The detailed version of the Cash Requirements in Check Format report includes the following data for each invoice:

Vendor Number	Account	Amount
Vendor Name	PO/Encumb Number	Invoice Description
Budget Unit	Invoice Number

The summary version only includes Vendor Number, Vendor Name, Invoice Number, and Amount. With both versions, you must enter a due date. Based on your other criteria, the system selects invoices up to and including that date.

The report does not include invoices that have been put on hold either by users or by the system when the amounts due do not meet minimum check requirements. The listing ends with payments awaiting approval. The report's default file name is cashreq.rpt.

Checkbox

The Cash Requirements in Check Format page includes the following checkbox:

Discounted Payments Only	Generates the following formats, depending on whether the box is selected or blank.
Full Listing	Leaving the box blank (default) allows the report to list all selected invoices.
Discounts Only	Selecting the box limits the report to selected invoices that include discounts. For another report that focuses on discounts, refer to Year to Date Discounts Report.