Cash Requirements Report

Run this report prior to issuing vendor checks. You can limit the report to EFT (Electronic Fund Transfer) or non-EFT payments. You also can include both. The report can help you to:

• Identify the amounts required for paying invoices.
• Determine if funds are available for payments on a specific due date.
• Verify purchase order and invoice information.
• Identify any vendors who should not be paid.
• Determine if any holds on payments should be released.
• Identify payments that fall below the minimum check amount requirements.

Menu Path

From the Fund Accounting menu, select Reports. In the Accounts Payable Reports menu, select 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

• Selection Criteria shows the Bank account selection used by the user if the report is run by selecting the Bank Account number.

• The report is grouped by Bank Account first and then by Fund. The Default Cash Account Number information is provided in the Bank Account grouping header.

• Cash Account is added as a field to display in the report under the Account Number.

  • The Cash Account Number is displayed as just the Cash Account if Full Account Format is not selected or Use Fund Only is selected in the Fund Accounting profile. The title in this case is Cash Account.

  • The Cash Account Number is displayed in the full account format if Full Account Format is selected and Use Fund Only is not selected in the Fund Accounting profile.

    • The Cash Account Number is displayed in the Fund Accounting GL Translation table format.

    • The title is Cash + <Account Number from the Fund accounting profile>

  • The records are sorted by Cash Account number under the Fund grouping.

• Totals: Totals are displayed for Due Date, Cash Account, Fund, and Bank Accounts.

Report Output in Excel

• Bank Account Number and Title are displayed before the Fund.

• Cash Account is added as a field to display in the report after the Account/Account Number.

  • The Cash Account Number is displayed as just the Cash Account if Full Account Format is not selected or Use Fund Only is selected in the Fund Accounting profile. The title in this case is Cash Account.

  • The Cash Account Number is displayed in the full account format if Full Account Format is selected and Use Fund Only is not selected in the Fund Accounting profile.

    • The Cash Account Number is displayed in the Fund Accounting GL Translation table format.

    • The title is Cash + <Account Number from the Fund accounting profile>

  • The records are sorted by Cash Account number under the Fund grouping.

• Totals: Totals are displayed (when run with all information Option).

Invoice Data

The report's Cash Requirements section groups invoices under their related funds. The data for each invoice includes:

If your criteria returns payables on hold or beneath a vendor's minimum check requirements, the system identifies these records in separate sections of the report. A separate section is also provided for payments awaiting AP approval. R, For information on running a version of this report that shows the checks assigned to invoices, refer to the next section, Cash Requirements in Check Format Report.

Format Options

The Cash Requirements Report page provides the following options for formatting the report:

Both of these options also provide a listing of payments meeting your criteria that are beneath a vendor's minimum check requirements or on hold based on other considerations. The report's final pages show payments awaiting accounts payable approval processing.