1. G/L Cash Account

Standard Elliott G/L Account Defaults from Bankbook Default Cash Account found in Bankbook Setup. At this point in time only one cash account at a time can be chosen. The first phase of the cash projection report works similar to the summary cash position report in order to capture the latest cash distributions for this account.

Please Note:

Elliott's individual modules do not distinguish revenue and expense sources by cash account. The projection report therefore applies all chosen revenue and expense sources (AR,AP and PO as well as manually entered revenues and expenses) to the cash account entered here.

Depending on the size of your Elliott data, this report may take several minutes to run.

2. Balance as of 03/29/00

Standard Date Format Default taken from Bankfile maintenance showing the last date an update for the chosen Cash Account was run.

3. Project Accounts Receivable?

Based on (D) ue Date

Based on (A) vg Days

“D” or “A””

Age Receivables by Invoice Due Date Age A/R using each Customer's Average Days to Pay.

4. Project Accounts Payable?

Based on (I) nvoice Date

Based on (D) ue Date

1 alphanumeric character Defaults to "Y" if Accounts Payable is installed as per your Elliott Company file.

Age A/P by Invoice Date. The default is "I".

Age A/P by Invoice Due Date

In addition to posted A/P Open Items, the report also includes any recurring vouchers that were entered into A/P for the periods chosen.

5. Project Purchase Orders?

1 alphanumeric character Defaults to "N" even if the Purchase Order module is installed as per your Elliott Company file.

If "Y" is chosen for this option, the report will run longer and include all open purchase orders, adding vendor terms due days to the P/O line request date for items that were not yet received.

Due to the fact that Elliott's Received but Not Invoiced Option in the P/O module does not work properly and many of you do not pay on a P/O Line item basis, we do not rely on the P/O quantity invoiced. Instead, this report will give you realistic expense projections based on open P/O's only.

6. Other Recurring Expenses/Period

Numeric Dollar Amount Defaults to Zero.

This field allows you to enter future expenses that are not part of your recurring A/P such as estimated periodic phone and utility expenses.

Please Note:

The amount entered here is deducted for each period chosen in #9 below.

7. Projected Payroll Expense/Period

Numeric Dollar Amount Defaults to Zero.

This field allows you to enter a periodic payroll expense since the cash projection report does not tally actual payroll expenses.

Please Note: The amount entered here is deducted for each period chosen in #9 below

8. Other Cash Receipts/Period

Numeric Dollar Amount Defaults to Zero.

This field allows you to enter periodic cash receipts for those users who do not have Elliott's A/R module installed. It also gives you the ability to record receipt of bank loans or transfers from investment accounts.

Please Note:

The amount entered here is added for each period chosen in #9 below.

9. Use Default Periods

1 alphanumeric character Defaults to "Y".

If Accounts Receivable is installed, the A/R setup default periods are used, otherwise a standard current, over 30, over 60 and over 90 day default is used.

If "N" is chosen, a window is displayed where the default periods can be changed. For example, instead of having period 4 go to infinity (999 days) you may want to use 120 days as your cutoff.

This method also allows you to project cash in 4 periods of your choice, e.g. for weekly periods use 7,14,21 and 28 days respectively.

10. Based on Projection Date

Numeric Date format MM/DD/YY Defaults to Today's System Date

This represents the Aging Date for A/R, A/P and Purchase Orders and can be entered as needed.