About Cash Projections

A cash projection is the sum of all expected cash flows during a specified date range based on a combination of known confirmed future cash flows plus assumptions on future cash flows with uncertain or estimated values. 

About Processing and Viewing Cash Projections

You can create a cash projection using the Create New option in the Cash Projections Viewer workspace, process it, and then view it. Or, you can process a cash projection on an ad hoc basis using the global processing panel, Create Cash Projections. You can also set up a schedule for the system to automatically generate a cash projection based on that global process. 

After the system processes a cash projection, you can view that cash projection in the Cash Projections Viewer workspace. If your organization prefers not to use the Cash Projections Viewer to view processed projections, you can use the Query Cash Projections panel to execute a query based on a cash projection and provide results in a grid format.

About the Cash Projection Status

A cash projection has one  of the following current status values. You can view a colored icon that represents the status for each row in the Cash Projections Viewer workspace grid.

Icon

Color

Status

Icon

Color

Status

Processed icon

Green circle

Processed successfully

Pending icon

Yellow triangle

Processed with warnings

Rejected icon

Red square

Processed with errors

Processing icon

Yellow cog

Request processing

About Cash Projection Summary Level Information

In the Cash Projections Viewer workspace, you can select a processed cash projection, and then view summary information for that projection, The Projection Summary tab provides an overview of the cash position for the period requested, by date and currency. It shows the Account, Currency, Effective Date, Cash Receipts, Cash Disbursements, Cash Balance, and Balance Type.

Cash Projections Viewer - Projection Summary tab

About Cash Projection Detail Level Information

In the Cash Projections Viewer workspace, you can select a processed cash projection, and then view detail information for that projection, The Projection Detail tab displays all activity and includes details for each transaction.

Cash projection results show the Start of Day settled cash balance and Current Day settled activity for each settlement currency for the specified accounting basis. In the Projection Detail tab's Balance Type column, you see values of Start of Day Settled Cash,  Current Day Settled Activity. Current Balance, and Activity. The sum of the Start of Day Settled Cash balance and the Current Day settlement activity is the Current Balance.

Cash Projections Viewer - Projection Detail tab

The following Projection Detail tab example shows projection results for a standard accounting basis, USTAX. In the Balance Type column, note that the projection results show the Start of Day Settled Cash balance and the Current Day Settled Activity for each settlement currency.

Cash Projection Viewer - USTAX Sample Results

These projection results correspond to the following figure, which illustrates how the USD projected settled cash balance is $7,785.

USTAX USD Projected Settled Cash Balance Example

About Projection Errors

In the Cash Projections Viewer workspace, you can select a processed cash projection, and then view projection errors information for that projection, The Projection Errors tab lists any errors that occurred when the system processed the cash projection. 

Cash Projections Viewer - Projection Errors tab

About Segregated Cash Projections

If you use cash segregation, the Cash Projections Viewer tool can generate segregated cash projections. You can create segregated projections when you select an entity that uses cash segregation and you choose the entity's custody (CUST) accounting basis for the projection. Cash projections run for custody basis are segregated by settlement cash account. When you run cash projections for the custody basis, the projection results shows the Start of Day settled cash balance and Current Day settled activity for each entity, cash account, and /or settlement currency. The sum of the Start of Day settled cash balance plus the Current Day settlement activity is the Current Balance.

When you view results in the Projection Detail tab, note that the results are segregated by cash account, and each account has its own Start of Day Settled Cash balance and Current Day Settled Activity entry. The results show additional data fields such as cash account, principal, and income.

The following Projection Detail tab example shows projection results for the custody accounting basis, CUST. The Cash Account Name column identifies the cash account. Results are segregated by cash account and each account has its own Start of Day Settled Cash balance and Current Day Settled Activity entry.

Cash Projections Viewer - Projection Detail tab

These projection results correspond to the following figure, which illustrates how the USD projected settled cash balance is $7,785 for the CUST basis. You can see the entries segregated by cash account.

Cash Projection CUST Basis Example

About Generating Cash Projections for ISTAR

The Export Cash Projections to ISTAR panel enables you to copy cash projection data to Eagle's insurance accounting solution (ISTAR). For more information, see the Eagle STAR for Insurance User Guide.