Project or Shell Cash Flow Properties (General Pane - More Options)

The following explains the fields under the General block: More Options.

Note: The red asterisk next to a field box indicates that the field is a required field. You will not be able to save your changes without entering a value in that field.

When you click More Options, the More Options window opens which contains the following tabs on the left pane. Each tab provides additional options for the cash flow which are described below.

Period Close Settings tab

This tab lets you set the option: Enable auto snapshot

The Period Close Settings tab lets you choose some automatic settings that will happen at the end of each period (month or year, as chosen in the Time Scale field).

When you select the Enable auto snapshot option, you determine when the system must take an automatic snapshot of the data.

If you selected Month for Time Scale:

You can choose a specific date each month to automatically take a snapshot, or you can specify a particular day (such as the first Monday of the month).

If you selected Year for Time Scale:

You can specify the exact date to take the snapshot each year (or a particular day such as the first Monday of January).

After an auto snapshot is taken, the curve will be refreshed immediately. Actuals (Spends) will resume after the auto snapshot is complete.

Examples of using the options: Enable auto snapshot, Cutoff spends, and Resume Spends

Company A wants to take an auto snapshot of its cash flow data every time period. Company A would choose a particular date (such as the 3rd of the month for Month, or January 3 for Year). The system would take the snapshot and refresh the cash flow curve. They do not select the Cut off spends option.

Company B regularly reviews and revises forecast projections during fixed days every time period. Because it does not want new Spends records to hit the cash flow worksheet during this period, they choose the Cut off spends option. This option requires that you select the Enable auto snapshot first. The company sets this option so that an auto snapshot is taken of their changes just before spends are resumed. Snapshots can then be used for comparison of previous forecasts with the current month. Any spends records that came in during the forecast period are not lost; the Resume Spends option determines whether those spends records will be included in the previous month's cash flow or pushed to the next time period.

Cutoff spends

This option is applicable for Actuals (Spends) type curves.

Selecting this option will temporarily stop spends business processes (for example, Invoices) from hitting the cash flow worksheet during analysis periods.

The Enable auto snapshot option must be selected first. Actuals (Spends) will resume after the auto snapshot is complete.

If no value is specified, then the last date of the current month is presumed.

The system marks the time of the Cutoff spends date at the beginning of the day. For example, on June 30, the data can become locked at the beginning of the day and not at the end of the day, therefore, preventing the user from making any last minute changes before the start of the next month.

Apply Spends to

The selections under this period close settings option let you apply spends to an effective date or before/after a Cutoff spends date.

By default, Cutoff spends will resume immediately after an auto-snapshot is taken.

Note: If there is a gap between the Cutoff spends date and the Enable auto snapshot date, any spends that came during that period are not lost.

For example, if a Cutoff spends date is October 26 and the Enable auto snapshot on date is November 2, (and the Time Scale is monthly) that defines the freeze period. Any spends that come in on October 27, 28, 29, 30, 31, and November 1 will not hit the cash flow sheet during the freeze period. After the Enable auto snapshot on date is reached, spends will be included back in October for spends (Oct 27-31) or November for spends (Nov 1-2), and the effective date will be retained.

The same month/year as the effective date

The text of the options under Apply Spends to change based on the selection that you made for the Time Scale (By: Month or By: Year).

If this option is chosen, spends data is included back in the current period after the freeze period is lifted. The final output is similar to the case where no period close settings are applied because the effective date is retained. Spends for Oct 26-31 will be included in October and Nov. 1-2 spends will be included for November.

For example, if the cutoff date is the 26th of October and the snapshot date is the 2nd of November, the freeze period is Oct 26 - Nov 2. Any spends that come in on Oct 27, 28, 29, 30, 31 and Nov 1 and 2 will not show on the cash flow sheet during the freeze period. After the auto snapshot date is reached, these spends will be included back in either Oct for spends (Oct 27-31) or Nov for spends (Nov 1-2) and the effective date will be retained.

The next month/year if after the cutoff date

After the freeze period is lifted, spends data from the cutoff date to the end of the month will be included in the next month/year. Spends for Oct 26-31 will be included in November and Nov 1-2 spends will be included for November.

The previous month/year if on or before the cutoff date

After the freeze period is lifted, spends data from the start of the month up to the cutoff date will be included in the previous month/year. Spends for Oct 26-31 will be included in September and Nov 1-2 spends will be included for November.

During the Cutoff spends period, even if automatic refresh of the curve occurs as set in the Schedule tab, spends data will not hit the cash flow sheet until spends are resumed again.

Summary tab

This tab lets you automatically add the selected curve to a selected summary curve. This tab contains a list of available summary curves to choose from.

Decimal Options tab

This tab provides two options:


Last Published Wednesday, June 26, 2024