ARCSHSCN Accounts Receivable Cash Projection Report
Cash Projection Report
Application Overview
The Cash Projection Report graph application facilitates Elliott reporting features by plotting the anticipated future revenue outlook of your organization. It processes information obtained from the A/R Open Item File, and creates a report that projects the amount each customer account will contribute to the overall projection within a given period of time. This resource can provide a powerful visual representation of important business variables such as the comparative amount of anticipated future gross receipts generated by your most valued customers. It can also be used as a tool to set organizational goals, and plan future resources.
You can create a report that projects cash receipts generated in any combination of the following variables:
- A range of customers
- Projected cash receipts to be generated by a specified date
- A Period of time that you define
- Projected cash receipts based on the current amounts generated in a given period, Year to date or both of these variables
You may also choose to calculate the Projected Revenue based on the invoices' due dates or the customers average number of days to pay during the current year. If one or more of your customers have a tendency to pay early or late, basing the report on average days to pay can provide a more realistic picture of when to expect cash receipts.
Run Instructions
Select Cash Projection Report from the pull down A/R Reports window. The following screen will then be displayed:
Cash Projection Report Entry Screen
After entering the required information another window will display the following options:
- Print the cash projection report by customer, by collector, based on a certain date, in detail or summary with cash due from customers or all customers
To return to the menu bar, press the ESC or F10 key. To leave this application, press X for EXIT when positioned at the menu bar.
Entry Field Descriptions
Name | Type and Description |
1. Starting Customer No | 6 alphanumeric characters. Enter the starting customer number, in the range that you want to plot. If you press RETURN for the entry of the starting customer, the field will default to Allcustomers, and the ending customer will be skipped. |
2. Ending Customer No | 6 alphanumeric characters. Enter the ending customer number in the range you want to plot. |
3. Based On What Date ? | A date In the standard date format. Enter the future date that you want to forecast projected cash receipts. This field automatically defaults to the present date. |
4. Days In Period 1 | 3 numeric characters. This field automatically defaults to the predefined settings in you’re a/R Setup. For the purpose of this graph you can enter a different number of days to be considered in Period 1. |
5. Period 1 Description | 8 alphanumeric characters. This field automatically defaults to the predefined settings in you’re a/R Setup. You may substitute this with the description entered here. This information will appear when the resulting graph is printed. |
6. Days In Period 2 | 3 numeric characters. This field automatically defaults to the predefined settings in your A/R Setup. For the purpose of this graph you can enter a different number of days to be considered in Period 2. |
7. Period 2 Description | 8 alphanumeric characters. This field automatically defaults to the predefined settings in your A/R Setup. You may substitute this with the description entered here. This information will appear when the resulting graph is printed. |
8. Days In Period 3 | 3 numeric characters. This field automatically defaults to the predefined settings in your A/R Setup. For the purpose of this graph you can enter a different number of days to be considered in Period 3. |
9. Period 3 Description | 8 alphanumeric characters. This field automatically defaults to the predefined settings in your A/R Setup. You may substitute this with the description entered here. This information will appear when the resulting graph is printed. |
10. Days In Period 4 | 3 numeric characters. This field automatically defaults to the predefined settings in your A/R Setup. For the purpose of this graph you can enter a different number of days to be considered in Period 4. |
11. Period 4 Description | 8 alphanumeric characters. This field automatically defaults to the predefined settings in your A/R Setup. You may substitute this with the description entered here. This information will appear when the resulting graph is printed. |
12. Starting Collector | 3 alphanumeric characters. Enter the starting collector number, in the range that you want to plot. If you press RETURN for the entry of the starting collector, the field will default to Allcollectors and the ending collector will be skipped. |
13. Ending Collector | 1 alphabetic character. Enter the ending customer number in the range you want to plot. |
14. Print Detail ? | Y or N. Enter Y to see all customer detail, otherwise a summary will print. |
15. Print Customers With Cash Due Only ? | Y or N. Enter Y to see only the customers that have open invoices that are expected to be paid. |
16. Calculate Based on ? | 1 alphabetic character. Valid entries are: A = Customer Average Days To Pay B = Document Due Date Enter A to calculate projected revenue based on each customer's average days to pay during the current year. If customers tend to pay their bills early or late, this option can provide a more realistic idea of when to expect cash receipts. Enter B to calculate projected revenue based on the due date for each document in the Open Item file. This field defaults to A. |
Related Articles
BB17S4 Bank Book Cash Projection Report
Cash Projection Report Application Overview Without needing the use of extensive financial analysis software the Cash Projection Application allows for a compact view of future cash needs. The application looks at the current cash requirements ...PO0700 Purchase Order and Receiving Cash Requirements Projection Report
Cash Requirements Projection Report Application Overview When you enter a purchase order line item you specify, by means of the request date, when you would like to receive the item. If the vendor cannot deliver by the request date but offers a later ...ARCSHENT Accounts Receivable Cash Receipts Processing
Cash Receipts Processing Application Overview Cash Receipts Processing is an application that you will use quite often. You will use it whenever you have received payments from any of your customers and want to apply those payments to the customer's ...ARMENU Accounts Receivable Package Overview
Package Overview How to Use This Manual When most people receive a new product they want to use it right away. Unfortunately, this is not quite possible when dealing with computer hardware and software. This manual is intended to serve as a reference ...AP07S1 Accounts Payable Cash Requirements Report
Cash Requirements Report Application Overview The Cash Requirements Report can be used to determine, on a general basis, which invoices can be paid with the available cash or to determine exactly how much cash would be required to bring your A/P up ...