Cash Requirements Report

Accounts Payable - Cash Requirements Report

Function

This report is a cash requirements analysis tool that groups open invoices into user defined time periods. Four time periods, defined either by the fiscal calendar or by number of days specified, are provided on the report. Both the Cash Requirements Report and the Aging Report provide detailed information for making payment selections.

=> To access this task...

Select Cash Requirements Report from the Accounts Payable main menu.

Cash Requirements Report

About the Fields

In the AP Type field...

This field is active only when the "Multiple AP Types" AP Parameter is checked.

Enter a valid AP type. If left blank, all AP Types will be included.
Click to select from a list of AP types.

In the Aging Date field...

Enter a date to use as a reference date for determining the projection periods. Each invoice is aged based on its invoice date, accounting date or due date Refer to Aging field.

Enter the beginning date for the report in mmddyyyy format.
Click to select a date by using the calendar tool.

From the Age by dropdown...

Select aging criteria from the dropdown selections of Due Date (D), Accounting Date (A), Invoice Date (I), or Discount Date (S).

The aging option determines the date used to calculate the invoice age. The task compares the selected date for each invoice to the aging date and determines the time period it falls into.

From the Report Sequence dropdown...

Select Alternate Sequence (A) to sort the report alphabetically.
Select Vendor ID (V) to sort by vendor number.

From the Summary or Detail dropdown...

Select Summary (S) to display only summary totals for each vendor.
Select Detail (D) to print each vendor invoice on a detail line.

From the Period or Days dropdown...

Select Period (P) to base the aging time periods on the fiscal calendar.
Select Days (D) to define time periods as a number of days.

In the Number of Days field...

This field is bypassed when the Period in the Period or Days field is selected.

Enter the number of days for the time periods.

Number of Days Example

Enter 7 to group invoices into 7 day periods

Include vendors paid via ACH checkbox...

Mark the box to include vendors paid via ACH in the report.
Unmark the box to exclude vendors paid via ACH from the report.

Export format checkbox...

Mark the box to create a report without blank data fields for manipulation in Excel.
Unmark the box to create a report of the raw data.

When done making selections...

Click to create the cash requirements report.
Click to save these report settings.
Click to clear the form and begin again.

Sample Cash Requirements Report

See Output Options.

When the Multiple AP Types parameter is checked, the report sorts and subtotals by accounts payable types. The Cash Requirement Report appears in the preview window. Select the desired output format and click [Create].

______________________________________________________________________________________