Accounts Payable - Cash Requirements Report



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 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 Calendar button to select a date by using the calendar tool.

From the Age by dropdown...

  • Select Accounting Date (A) from the dropdown box to age each invoice based on the accounting date.

  • Select Due Date (D) from the dropdown box to age each invoice based on the invoice due date.

  • Select Invoice Date (I) from the dropdown box to age each invoice based on the invoice date.

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) from the drop down box to sort the report alphabetically.

  • Select Vendor ID (V)from the drop down box to sort by vendor number.

From the Summary or Detail dropdown...

  • Select Summary (S) from the dropdown box to display only summary totals for each vendor.

  • Select Detail (D) from the dropdown box to print each vendor invoice on a detail line.

From the Period or Days dropdown...

  • Select Period (P) from the dropdown box to base the aging time periods on the fiscal calendar.

  • Select Days (D) from the drop down box 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


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 Run Process button to create the cash requirements report.

  • Click  Save button to save these report settings.

  • Click  Clear Form button 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].


Copyright BASIS International Ltd. AddonSoftware® and Barista® Application Framework are registered trademarks.