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 Processing menu.

 

Cash Requirements Report

 

About the Fields

 

In the Aging Date field...

  • Enter the beginning date for the report in mmddyyyy format.

  • Click Calendar button to select a date by using the calendar tool.

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.

 

In 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.

 

In 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.

In 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.

In 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...

  • Check the box to create a report without blank data fields for manipulation in Excel.

  • Uncheck 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.