Run a Cash Projection Manually

Owned by Nancy Cohn (Deactivated)
Last updated: Jul 06, 2023 by Pamela Totas (Deactivated)
5 min read

In the global Create Cash Projections panel, you can process a cash projection on a one time basis. You can also use this panel to create a panel profile for cash projections that you plan to schedule and have the system process automatically. The typical workflow is to schedule cash projection events after cash settlements.

The options in this panel are similar to those used when when you use the Cash Projections Viewer workspace to create a cash projection manually. However, this global process panel does not use the preferences you set up for the Cash Projections Viewer tool as default values.

Run a Cash Projection

You can globally process a cash projection. You can use Accounting Center or Automation Center to run global processes. 

To create a cash projection:

  1. In Accounting Center, do one of the following: 
    - In the left navigation pane, click Processing and Exceptions > Global Processes > Cash > Create Cash Projections. 
    - In the left navigation pane, click Reports > Cash Projections Viewer > Create Projections.
    You see the Create Cash Projections panel.

  2. Complete the options in the panel. 

  3. Click Submit.
    The Loopbacks pane appears at the bottom of the panel. You can monitor the global processing results.

After the cash projection processes, you can use the Cash Projection Viewer to review the projection results.

Create an Entry Profile for a Cash Projection

You can create a profile to create cash projections in order to schedule global cash projection processing to run at a later time. 

To create a cash projection entry profile:

  1. In Accounting Center, do one of the following: 
    - In the left navigation pane, click Processing and Exceptions > Global Processes > Cash > Create Cash Projections. 
    - In the left navigation pane, click Reports > Cash Projections Viewer > Create Projections.
    You see the Create Projections panel

  2. Complete the options in the panel.

    NOTE:  Do not click Submit. 

  3. Under Form Tools, on the Form tab, in the Profiles group, click Save Profile, and then click Save Profile.
    You see the Save Entry Profile window.

  4. In the Profile Name box, specify the name of the profile.

  5. In the Publish section, indicate whether you want the profile to be Public or Private. Do one of the following: 
    - Select the Publish this profile to all users check box if you want the profile to be public. Public profiles are available for use by all members that belong to your Report Profile group.
    - Clear the Publish this profile to all users check box if you want the profile to be private. Private profiles are only available for use by your User ID. 

  6. In the grid, review the fields and field values included in the profile. 

  7. If you want to change which fields are included, select or clear the check boxes beside each row to change which fields are included. Or click Undo all changes to revert to your original field selections.

  8. Click Save.
    The system saves the profile.

  9. Click Cancel to close the window.
    Because you did not submit the panel for processing, no global processing occurs.

Create Projections Panel Options

In the Create Projections panel, when you create a cash projection for use in global processing, you can select various options based on the requirements of your business. 

Option

Tag

Description

Option

Tag

Description

Cash Projection Information





Projection type

1256

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 that you identify in the Currency field.

Report name

5362

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

1257

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

Currency

85

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

Projection Details





Created By

988

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

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

  • Processing Center. The system creates the cash projection based on a Processing Center that you identify in the Process Center Desc and Process Center fields.

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

  • Composite. The system creates the cash projection for 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. You identify the composite in the Entity ID field and the Accounting Basis field.

Entity ID

1163

Specifies the unique account identifier of the entity or reporting composite associated with the cash projection. If you set the Created By field to Entity or Composite, this option becomes available.

Entity List

1164

Specifies the name of the entity list associated with the cash projection. If you set the Created By field to Entity List, this option becomes available.

Accounting Basis

21

Specifies the primary accounting basis for the entity or reporting composite. If you select an entity that uses cash segregation, the custody accounting basis, CUST, appears by default. If you set the Created By field to Entity or Composite, this option becomes available.

Process Center Desc

4898

Specifies the process center description associated with the entity. If you set the Created By field to Processing Center, this option becomes available.

Process Center

4896

Displays the process center code associated with the entity. If you set the Created By field to Processing Center, this option becomes available.

Report Dates





Position

990

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

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

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

Report Start Date

220

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

Report End Date

221

Specifies the last date of the cash projection.

Projection Options





Include Tax Reclaims - Adjustment

9187

Indicates whether to create projections net of withholding tax. Options include:

  • Yes. Default. The projection is net of withholding tax.

  • No. The projection is a gross amount and includes tax withholding.

Write Log

9152

Indicates whether to record a log of projection activity. Options include Yes and No (Default).

Pending Actions

9153

Indicates whether to include corporate actions with a Pending status in the projection, along with corporate actions with a Released status. Options include Yes and No (Default).

SMF Projections

9154

Indicates whether to include future corporate actions based on SMF data in the projection, along with corporate actions with a Released status. Options include Yes (Default) and No.

Report Type





Include Fixed Income

331

Indicates whether the cash projection includes fixed income transactions. Options include Yes (Default) and No.

Include Dividends

332

Indicates whether the cash projection includes dividend transactions. Options include Yes (Default) and No.

Include Forwards

333

Indicates whether the cash projection includes forwards transactions. Options include Yes (Default) and No.

Include Others Buys/Sells/Spots etc

334

Indicates whether the cash projection includes other transactions, such as buys, sells, spots, and so on. Options include Yes (Default) and No.

Include Unsettled Transactions

335

Indicates whether the cash projection includes unsettled transactions. Options include Yes (Default) and No.