APPX Software Library

4Reports and Inquiry

Option 5Cash Requirements Projection

Use this function to project the amount of cash needed to pay invoices for a given period. The time periods for projection can be varied and can be based either on the invoice due date or the discount due date. The following processing steps accomplish this job.

  1. Step 1You can use this function to enter a projection date, choose which date to use when projecting cash required, and choose the lengths of the projection periods.

On the following pages, the screen displayed by this function is shown.

The screen shown below allows you to enter information required to print the Cash Requirements Projection.

Cash Requirements Projection screen

The Accounts Payable Cash Requirements Projection Screen
Figure 55

Data items for the preceding screen are described below:

Projection Date

Date (YMD)

The system defaults today’s date as the date upon which you want the cash requirements projection to be based. You may change this entry.

Due Date to Project

Positive number, 1 digit

Indicate which due date to use when projecting the cash required for the unpaid invoices. Valid options are:

1
Transaction Due Date
2
Discount Due Date

If the Transaction Due Date is used to determine the projection period, the gross amount of the invoice is added to the column representing the number of days from the date entered as the Projection Date until the invoice is due.

If the Discount Due Date is used, the net amount of the invoice (gross amount less any applicable discount) is added into the projection period representing the number of days until the discount due date. If no discount due date is present for an invoice, the transaction due date is used to determine the correct projection period.

Projection Periods

Number, up to 3 digits

Weekly periods are defaulted for the projection periods. If you wish the projection to be based on different periods, enter the number of days for each period.

Period Ending Dates

Date (YMD) Display only

This date shows you the actual ending date for each projection period to be printed. This date is determined by adding the number of days in the corresponding Projection Period to the Projection Date. For example, if the projection date is 7/01/90 and the projection periods are 7, 14, 21, and 28 days, the Period Ending Dates are 7/08/90, 7/15/90, 7/22/90, and 7/29/90.

The entered data is validated. During validation, including access to other files, conditions may be found which cause messages to be displayed. Errors (E), Warnings (W), and Messages (M) that may result are shown below:

  • EProjection Periods Must Be in Ascending Order

Press ENTER to save the information on this screen.

  1. Step 2In preparation for performing a sort/selection process on the Transactions information, this step provides you with a default sequencing of data records by Vendor Alpha, Vendor, Apply To, Invoice Type and Date/Time Stamp, giving additional sort order choice by Liability Account, Post Year and Post Month, with the option to change modifiable parameters at run time. Selection of data records is provided by Liability Account, Vendor, Post Month and Post Year, with the option to enter user-specified comparisons at run time.
  2. Step 3This disposition type is used for all standard Accounts Payable reports.
  3. Step 4According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
  4. Step 5In order to print the Cash Requirements Projection, this step formats the Transactions information. As appropriate, group headings appear whenever a change occurs in Post Month, Liability Account or Vendor. If requested, totals appear whenever a change occurs in Apply To, Vendor, Liability Account or Post Month. When totals are specified, the following items are accumulated: Total Balance and Amount Total. Grand totals print at the end, showing Total Balance, Amount Total, Total Number of Invoices and Total Number of Vendors.

A sample output is shown below.

                                                       Expert Computing, Inc.
11/08/94 09:59                                                                                                       LGG Page:  1
                                                    Cash Requirements Projection

                                           Projected as of 11/08/94   Using Trx Due Date

                                                                   11/15/94      11/22/94      11/29/94      12/06/94
Apply To Description               Trx Due Date       Balance    7  & Under    8  To  14    15  To  21    22  To  28   Over  28
=================================================================================================================================

Vendor  00000040  Albert Materials, Inc.

1006     materials                      08/25/89        79.50         79.50
103      Albert Materials, Inc.                        441.60        441.60
104      Albert Materials, Inc.                        352.00        352.00
105      Albert Materials, Inc.                        200.00        200.00
106      Albert Materials, Inc.                         80.00         80.00
204      Albert Materials, Inc.                        100.42        100.42
308      stock                          08/25/89       126.17        126.17
311      stock                          08/10/89        76.25         76.25
5521     Albert Materials, Inc.                         26.82         26.82
8090     Albert Materials, Inc.                        222.31        222.31
96215    Materials                      09/10/89        63.00         63.00
                                                 ____________  ____________  ____________  ____________  __________  ____________
                — Vendor Totals —>                  1768.07       1768.07            0.            0.            0.            0.
                                                 ============  ============  ============  ============  ==========  ============


Vendor  00000080  Sam Jones

12345678 Invoice Description            08/31/94      1000.00       1000.00
ER1005   Aug. expenses thru 8/10        08/31/89      1216.90       1216.90
                                                 ____________  ____________  ____________  ____________  __________  ____________
                — Vendor Totals —>                  2216.90       2216.90            0.            0.            0.            0.
                                                 ============  ============  ============  ============  =========== ============


Vendor  00000010  Miscellaneous Supplier

221      New lobby plants               08/31/90       305.00        305.00
         Northwest Interiors
89071001 CUSTOMER REFUNDS               08/31/89       100.00        100.00
         Master Sellers Company
DEP6/89  convention room                07/31/89      1200.00-      1200.00-
         Westin Hotel
L9980    Office landscaping             08/31/89       620.00        620.00
         Evergreen Landscaping
P09844   Yellow page ad                 08/31/89       250.00        250.00
         Neighborhood Directory

                                                 ____________  ____________  ____________  ____________  __________  ____________
                — Vendor Totals —>                    75.00         75.00            0.            0.            0.            0.
                                                 ============  ============  ============  ============  ==========  ============


Vendor  00000020  Pool and Associates

9852-6   brochure                       08/31/89      2410.00       2410.00
9877DEP  deposit on mailer production   08/10/89      1500.00-      1500.00-
                                                 ____________  ____________  ____________  ____________  __________  ____________
                — Vendor Totals —>                   910.00        910.00            0.            0.            0.            0.
                                                 ============  ============  ============  ============  =========== ============


Vendor  00000060  Travel Planners

11102-1  Williams to Sacramento         09/13/89       386.10        386.10
11562-0  Williams to San Diego          09/03/89       487.00        487.00
11596-1  Jones to DC                    08/31/89       985.60        985.60
11598-1  Jones to Columbus              09/04/89       742.50        742.50
11600-0  Peters to Memphis              09/08/89       802.00        802.00
11651-1  VP to New York                 09/08/89      1125.60       1125.60
                                                 ____________  ____________  ____________  ____________  __________  ____________
                — Vendor Totals —>                  4528.80       4528.80            0.            0.            0.            0.
                                                 ============  ============  ============  ============  ============ ===========