Setting Cash 360 Preferences
The preferences you specify determine the cash forecast display in the Forecast Details table and in the Cash 360 dashboard. Set Cash 360 preferences to define the forecast period, the display in the Forecast Details table, and what and how account categories and additional values are used in the cash forecast.
To set Cash 360 preferences:
-
Go to Financial > Cash 360 > Dashboard.
-
On the left pane, click Preferences.
-
In the General Preferences section, specify forecast preferences:
General preferences are shared across all custom roles that have access to the SuiteApp within the same subsidiary.
-
In the Forecast Period field, select a forecast period.
This field lets you specify the period to include in the cash forecast. The default forecast period is 3 months.
The forecast period is counted from the current day, week, or month.
-
Check the Include Opening Balance box to display the opening balance, undeposited/future-period funds, closing balance, and net balance in the Forecast Details table.
-
Check the Include Sales Orders box to include sales orders in forecast computations.
When this box is checked, sales orders are included in the computation of inflow amounts and in the cash forecasts, as shown in the Forecast Details table and in the Cash 360 dashboard. Only sales orders without billing schedules, installments, and subscriptions are included in forecast computations.
-
Check the Include Purchase Orders box to include purchase orders in forecast computations.
When this box is checked, purchase orders are included in the computation of outflow amounts and in the cash forecasts, as shown in the Forecast Details table and in the Cash 360 dashboard. Only purchase orders without billing schedules, installments, and subscriptions are included in forecast computations.
-
-
In the Subsidiary-Wide Preferences section, set preferences for your selected subsidiary.
-
In the Subsidiary selector, select a subsidiary where to apply the account categories and additional values.
-
(Optional) In the Account Categories tab, specify what and how account categories are used in the cash forecast.
Note:You must first add account categories before you can specify them for inclusion and set preferences for them in this tab. For information, see Adding Cash 360 Account Categories.
-
In the Category column, select an account category.
Account categories are arranged by category type. Inflow and outflow account categories are grouped together. Inflow account categories appear first and the outflow account categories next.
-
In the Use In Forecasting column, check the box for the account category if you want to include it in the cash forecast.
-
In the Data To Use column, specify the time frame of the data you want to use in the cash forecast.
You can use the historical average for the last 3 months or the last 6 months.
Note:The cash forecast does not include the current month but considers the last full 3 or 6 months before the current month. For example, if the current date is June 22, and you want to use data for the last 3 months, the cash forecast considers data from March, April, and May.
-
In the % Movement column, specify the movement of cash flow in percent for the account category.
The percentage of cash movement represents the increment or decrement of cash flow. A positive value indicates increment and a negative value indicates decrement. The value specified is evenly applied to the account category and is not cumulative. The movement of cash flow is calculated considering the average amount for each category and the value specified in the Data To Use column. In the Forecast Details table, the percent movement is only applied to the succeeding periods and not to the current date, month, or week.
-
Click Add.
-
-
(Optional) In the Additional Values tab, add additional values to include in the cash forecast. This tab lets you add values that have no corresponding chart of account items.
Note:The additional values are shared across users within the same subsidiary.
-
In the Name column, add a name for the additional value.
-
In the Date column, enter or select a date from the calendar popup window.
-
In the Amount column, enter an amount for the additional value.
-
In the Type column, select the account type.
Select from Inflow or Outflow.
Inflow accounts are accounts with cash projected to flow into your company, such as dividend income. Outflow accounts are accounts with cash projected to flow out of your company, such as utility expenses.
-
In the Recurrence column, enter a number to specify how often the additional value is used in the cash forecast.
You can enter a number from 1 through 12.
-
In the Recurrence Type column, select the frequency the additional value is used in the cash forecast.
For example, if you entered 2 in the Recurrence column and selected Monthly in the Recurrence Type column, the additional value appears in two consecutive months starting from the date specified in the Date column and is included as such in the cash forecast.
-
Click Add.
-
-
(Optional) In the Order Billing Lead Time tab, manually enter the order billing lead time for customers without closed sales orders and vendors without closed purchase orders.
Order billing lead time is the average number of days it takes to fully bill sales orders and purchase orders for each customer and vendor. This value is system-calculated for all fully billed and closed sales orders and purchase orders. The system-calculated order billing lead time is displayed in the customer record for sales orders and in the vendor record for purchase orders. For more information, see Viewing the System-Calculated Order Billing Lead Time.
For customers without closed sales orders and vendors without closed purchase orders, you can manually enter the order billing lead time in this tab. The preferences you set here apply to all customers without closed sales orders and all vendors without closed purchase orders for the selected subsidiary.
The order billing lead time is added to the sales order or purchase order transaction date along with payment terms (if any) to calculate forecast dates as shown in the Forecast Details table and in the Cash 360 dashboard.
If both the manually entered and system-calculated order billing lead time values are specified, the system-calculated value takes precedence over the manually entered one and is used to calculate forecast dates.
-
In the Sales Order Billing Lead Time field, enter the order billing lead time in days for sales orders. You can enter a maximum of 999 days.
-
In the Purchase Order Billing Lead Time field, enter the order billing lead time in days for purchase orders. You can enter a maximum of 999 days.
-
-
-
Click Save.
Related Topics
- Cash 360
- Cash 360 Prerequisites
- Installing Cash 360
- Cash 360 Terms and Definitions
- Cash 360 Roles and Permissions
- Enabling Support for Custom Transactions
- Cash 360 Excluded Transactions
- Cash 360 Account Categories
- Excluding Bank Accounts from Cash 360 Calculations
- Cash 360 Subsidiary Consolidation
- Viewing the System-Calculated Order Billing Lead Time
- Rescheduling the Order Billing Lead Time Script Run
- Cash Forecasts in Cash 360
- Cash 360 Dashboard
- Cash 360 Limitations