Create Cash Projections

Owned by Nancy Cohn (Deactivated)
Last updated: Jun 30, 2023 by Jacob Mathews (Deactivated)
4 min read

There are several ways that you can create cash projections:

  • Create and run a cash projection on a one time basis. Use the Create New option in the Cash Projections Viewer workspace to open the Create Projections tab. You can use this tab to set up and run the cash projection and display it in the Cash Projections Viewer. This section describes this method.

  • Schedule the cash projection to run on a regular basis. You must create panel profiles in order to add scheduled events for cash projections. You can use the global Create Cash Projections panel to save a panel profile. You can then schedule it.

  • Create and run a cash projection on an ad hoc basis using global processing. You can use the global Create Cash Projections panel to set up the cash projection and submit it for processing.

Create a Cash Projection Manually

You can create a new cash projection manually in the Cash Projection Viewer workspace. If you want to use different criteria for the projection later, you must create a new projection with new parameters. You can create or delete projections at any time. Be aware that the system uses some of the preferences selected when you set up projection preferences as default values when you create a cash projection manually.

To create a cash projection manually: 

  1. In Accounting Center, in the left navigation pane, click Reports > Cash Projections Viewer.
    You see the Cash Projections Viewer workspace. 

  2. On the Cash Projections Viewer tab, in the General group, click Create New.
    You see the Create Projections tab. 

  3. Complete the options for the cash projection.

  4. Click Save & Close.
    The system generates the projection based on your criteria. You see a message that the system successfully created the cash projection.

In the Cash Projections Viewer workspace grid, you see a row for the cash projection you created. The projection row initially has a status of  (Request Processing). When it completes processing, the status changes to  (Processed Successfully). You can review the status of the cash projection to see if it processed successfully, along with cash projection summary and detail information, or any errors that occurred. 

Create Projections Tab Options

In the Create Projections tab, when you create a cash projection manually, you can select various options based on the requirements of your business. 

Option

Description

Option

Description

Projection type

Identifies the type of cash projection. Options include:

  • All Currencies. Default. The cash projection applies to all currency.

  • One Currency. The cash projection applies to a single currency. The Currency field becomes available, where you can identify that currency.

Report name

Specifies the name of the cash projection report. Entering a name allows you to easily select the projection from a list of existing projections. For example, you can use a name that identifies the report time frame and entity used.

Include Zero Receipts and Disbursements

Indicates whether the cash projection includes rows with zero values. Options include No (Default) and Yes.

Report Type

Identifies the transaction types to include in the cash projection. The system includes all available transaction types by default, but you can select one or more specific transaction types instead. Options include:

  • Select All. Default.

  • Dividends.

  • Fixed Income.

  • Forwards.

  • Others Buys/Sells/Spots etc.

  • Unsettled Transactions.

Create By

Indicates whether to create the cash projection by entity, entity list, or Processing Center. Options include:

  • Entity. Default. The system creates the cash projection for a single account that you identify in the Entity ID field or the Entity Name field.

  • Entity List. The system creates the cash projection for a predefined list of accounts that you identify in the Entity List ID field or the Entity List Name field.

  • Processing Center. The system creates the cash projection based on a Processing Center that you identify in the Processing Center field..

Entity ID

Specifies the unique account identifier of the entity associated with the cash projection. If you set the Create By field to Entity, this option becomes available. You can click the arrow by the field name to display the Entity Name field in its place.

Entity Name

Specifies the descriptive name of the entity.

Entity Type

Specifies the type of entity associated with the cash projection. This field appears only if you set Create By to Entity. Options include:

  • Composite. A Reporting composite, which is a type of composite used expressly for reporting purposes and comprised of multiple underlying entities, each having the entity type of Portfolio.

  • Portfolio. A basis entity that stores accounts, positions, and history for trading purposes.

Currency

Specifies the currency associated with the cash projection. If you set the Projection Type to One Currency, this option becomes available.

Report Start Date

Specifies the first date of the cash projection. The field shows the current day by default.

Report End Date

Specifies the last date of the cash projection. The field displays a default value based on the Period Duration value you set in your Preferences, but you can change it. For example, it defaults to a date 30 calendar days from the Report Start Date.

Position

Identifies the Eagle Accounting solution to use for the cash projections. Options include:

  • ESTAR. Default. Uses the ESTAR database for Eagle's investment accounting solution.

  • ISTAR. Uses the ISTAR database for Eagle's insurance accounting solution. If you select this value, you do not see and cannot specify the Report Type option or the Report End Date option.

Accounting Basis

Specifies the primary accounting basis for the entity. If you select an entity that uses cash segregation, the custody accounting basis, CUST, appears by default.

Entity List ID

Identifies the unique identifier of the entity list associated with the cash projection. If you set the Create By field to Entity List, this option becomes available. You can click the arrow by the field name to display the Entity List Name field in its place.

Entity List Name

Identifies the name of the entity list associated with the cash projection.

Processing Center

Identifies the Processing Center associated with the cash projection. If you set the Create By field to Processing Center, this option becomes available.