Viewing the Cash Forecast Table

Note:

An administrator must give access to roles that will use the Cash 360 SuiteApp. When access is not given, the role has no permission to view the cash forecasts. For more information, see Giving a Role Access to Cash 360.

Dates in the cash forecast table are based on the time zone preferences of the of the logged in user. For more information, see Setting Your Calendar Time Zone.

You can choose to display the cash forecast for a single subsidiary or for consolidated subsidiaries. To change reports by subsidiary or to view consolidated reports, go to the upper right corner of the page and select the subsidiary or consolidated subsidiary.

Note:

Inactive subsidiaries are not included in the list of subsidiary options. However, all posting transaction amounts from inactive subsidiaries are included in the cash forecast when viewing reports for a consolidated subsidiary. For more information about consolidated reports in OneWorld accounts, see Consolidated Reporting in OneWorld.

To view the cash forecast table:

Go to Financial > Cash 360 > Dashboard.

On the left pane, click Cash Forecast.

The default display of the cash forecast table is always based on the currently logged in user's subsidiary. To display the cash forecast table for another subsidiary, select the subsidiary on the upper right corner of the page.

The cash forecast table displays the following information.

Table Heading	Table Element	Description
Account Category	Column header	This column displays the account categories and additional values. The account categories are sorted per type, whether they are inflow or outflow. Additional values are marked with an asterisk (*). Accounts receivable and accounts payable are also displayed in this column.
Amount (Currency)	Column header	This column is divided into subcolumns that show the cash forecast amount for the date range specified in the SuiteApp's Preferences page. The cash forecast amount is shown in the currency of the selected subsidiary or consolidated subsidiary.
Date, Week, Month	Column subheader	This is the date range specified in the Forecast Period field on the SuiteApp's Preferences page. Each column shows the forecast amount for the date range and starts with the current date, week, or month. If you selected 3 Months in the Forecast Period field, the SuiteApp computes the next full 3 months after the current date. For example, if the current date is January 20, the table displays the next full 3 months of data after January. That is, data from February to April.
Opening Balance	Row header	This row displays the opening balance amount for the date range specified in the SuiteApp's Preferences page. The initial opening balance amount is the sum of all accounts in the chart of accounts with the type equal to bank for the selected subsidiary or consolidated subsidiary up to the current posting period. The succeeding opening balance amounts are taken from the closing balance amounts from the previous periods. This row is only displayed if the Include Opening Balance box is checked in the SuiteApp's Preferences page. For more information, see Setting Cash 360 Preferences. Clicking the opening balance amount opens a window that lists all accounts included in the opening balance amount calculation. You can only click the opening balance amount if it is greater than zero. For more information, see Viewing the Opening Balance Details.
Future-Dated Transactions	Row header	This row displays the bank transaction amounts for the date range specified that fall on the succeeding posting period. This row displays values if there is an overlap in the accounting periods within the same forecast period. For example, you have a forecast period that is set to 6 or 12 weeks and the report starts on the last week of March 2023 and you have bank transactions for April 1, 2023. The total bank transaction amount for April 1 is shown on this row. This row is only displayed if the Include Opening Balance box is checked in the SuiteApp's Preferences page. For more information, see Setting Cash 360 Preferences.
Inflow	Row separator	All entries below this row are inflow account categories, additional values, and accounts receivables. The forecast amount for the account categories are based on historical averages as set in the Forecast Period field on the SuiteApp's Preferences page. When there is no data available for the period specified, the forecast amount will contain zero values. If the cash forecast table displayed is for a consolidated subsidiary, the inflow amounts are grouped together per subsidiary. Expand the subsidiary name to show the account categories or additional values for that subsidiary. Additional values are marked with an asterisk. For information about how to add additional values, see Setting Cash 360 Preferences.
Accounts Receivable	Row	This row displays the accounts receivable from all A/R posting transactions that fall on the date specified. The amounts in this row include transactions with due dates in the future. Where due dates are not specified for transactions, the transaction date is used in place of the due date. This row is displayed even if there are no A/R posting transactions, account categories, or additional values entered. Clicking the accounts receivable amount opens a window that lists all accounts included in the accounts receivable amount calculation. You can only click the accounts receivable amount if it is greater than zero. For more information, see Viewing the Accounts Receivable Details.
Outflow	Row separator	All entries below this row are outflow account categories, additional values, and accounts payables. The forecast amount for the account categories are based on historical averages as set in the Forecast Period field on the SuiteApp's Preferences page. When there is no data available for the period specified, the forecast amount will contain zero values. If the cash forecast table displayed is for a consolidated subsidiary, the outflow amounts are grouped together per subsidiary. Expand the subsidiary name to show the account categories or additional values for that subsidiary. Additional values are marked with an asterisk. For information about how to add additional values, see Setting Cash 360 Preferences.
Accounts Payable	Row	This row displays the accounts payable from all A/P posting transactions that fall on the date specified. The amounts in this row include transactions with due dates in the future. Where due dates are not specified for transactions, the transaction date is used in place of the due date. This row is displayed even if there are no A/P posting transactions, account categories, or additional values entered. Clicking the accounts payable amount opens a window that lists all accounts included in the accounts payable amount calculation. You can only click the accounts payable amount if the it is greater than zero. For more information, see Viewing the Accounts Payable Details.
Net Balance	Row header	This row displays the net balance amount for a given period. The net balance amount is calculated as the total forecast inflow amount minus the total forecast outflow amount for a given period. This row is only displayed if the Include Opening Balance box is checked in the SuiteApp's Preferences page. For more information, see Setting Cash 360 Preferences.
Closing Balance	Row header	This row shows the closing balance amount for a given period. The closing balance amount is calculated as the opening balance amount, plus the future-dated transactions, plus the total forecast inflow amount, minus the total forecast outflow amount for a given period. Closing balance = Opening balance amount + Future-dated transactions amount + Total forecast inflow amount – Total forecast outflow amount This row is only displayed if the Include Opening Balance box is checked in the Preferences page of this SuiteApp. For more information, see Setting Cash 360 Preferences.

Table Heading

Table Element

Description

Account Category

Column header

This column displays the account categories and additional values. The account categories are sorted per type, whether they are inflow or outflow.

Additional values are marked with an asterisk (*).

Accounts receivable and accounts payable are also displayed in this column.

Amount (Currency)

Column header

This column is divided into subcolumns that show the cash forecast amount for the date range specified in the SuiteApp's Preferences page.

The cash forecast amount is shown in the currency of the selected subsidiary or consolidated subsidiary.

Date, Week, Month

Column subheader

This is the date range specified in the Forecast Period field on the SuiteApp's Preferences page.

Each column shows the forecast amount for the date range and starts with the current date, week, or month.

If you selected 3 Months in the Forecast Period field, the SuiteApp computes the next full 3 months after the current date.

For example, if the current date is January 20, the table displays the next full 3 months of data after January. That is, data from February to April.

Opening Balance

Row header

This row displays the opening balance amount for the date range specified in the SuiteApp's Preferences page.

The initial opening balance amount is the sum of all accounts in the chart of accounts with the type equal to bank for the selected subsidiary or consolidated subsidiary up to the current posting period.

The succeeding opening balance amounts are taken from the closing balance amounts from the previous periods.

This row is only displayed if the Include Opening Balance box is checked in the SuiteApp's Preferences page. For more information, see Setting Cash 360 Preferences.

Clicking the opening balance amount opens a window that lists all accounts included in the opening balance amount calculation. You can only click the opening balance amount if it is greater than zero. For more information, see Viewing the Opening Balance Details.

Future-Dated Transactions

Row header

This row displays the bank transaction amounts for the date range specified that fall on the succeeding posting period.

This row displays values if there is an overlap in the accounting periods within the same forecast period.

For example, you have a forecast period that is set to 6 or 12 weeks and the report starts on the last week of March 2023 and you have bank transactions for April 1, 2023. The total bank transaction amount for April 1 is shown on this row.

This row is only displayed if the Include Opening Balance box is checked in the SuiteApp's Preferences page. For more information, see Setting Cash 360 Preferences.

Inflow

Row separator

All entries below this row are inflow account categories, additional values, and accounts receivables.

The forecast amount for the account categories are based on historical averages as set in the Forecast Period field on the SuiteApp's Preferences page. When there is no data available for the period specified, the forecast amount will contain zero values.

If the cash forecast table displayed is for a consolidated subsidiary, the inflow amounts are grouped together per subsidiary. Expand the subsidiary name to show the account categories or additional values for that subsidiary. Additional values are marked with an asterisk. For information about how to add additional values, see Setting Cash 360 Preferences.

Accounts Receivable

Row

This row displays the accounts receivable from all A/R posting transactions that fall on the date specified.

The amounts in this row include transactions with due dates in the future. Where due dates are not specified for transactions, the transaction date is used in place of the due date.

This row is displayed even if there are no A/R posting transactions, account categories, or additional values entered.

Clicking the accounts receivable amount opens a window that lists all accounts included in the accounts receivable amount calculation. You can only click the accounts receivable amount if it is greater than zero. For more information, see Viewing the Accounts Receivable Details.

Outflow

Row separator

All entries below this row are outflow account categories, additional values, and accounts payables.

If the cash forecast table displayed is for a consolidated subsidiary, the outflow amounts are grouped together per subsidiary. Expand the subsidiary name to show the account categories or additional values for that subsidiary. Additional values are marked with an asterisk. For information about how to add additional values, see Setting Cash 360 Preferences.

Accounts Payable

Row

This row displays the accounts payable from all A/P posting transactions that fall on the date specified.

The amounts in this row include transactions with due dates in the future. Where due dates are not specified for transactions, the transaction date is used in place of the due date.

This row is displayed even if there are no A/P posting transactions, account categories, or additional values entered.

Clicking the accounts payable amount opens a window that lists all accounts included in the accounts payable amount calculation. You can only click the accounts payable amount if the it is greater than zero. For more information, see Viewing the Accounts Payable Details.

Net Balance

Row header

This row displays the net balance amount for a given period.

The net balance amount is calculated as the total forecast inflow amount minus the total forecast outflow amount for a given period.

This row is only displayed if the Include Opening Balance box is checked in the SuiteApp's Preferences page. For more information, see Setting Cash 360 Preferences.

Closing Balance

Row header

This row shows the closing balance amount for a given period.

The closing balance amount is calculated as the opening balance amount, plus the future-dated transactions, plus the total forecast inflow amount, minus the total forecast outflow amount for a given period.

Closing balance = Opening balance amount + Future-dated transactions amount + Total forecast inflow amount – Total forecast outflow amount

This row is only displayed if the Include Opening Balance box is checked in the Preferences page of this SuiteApp. For more information, see Setting Cash 360 Preferences.

To view the cash forecast table:

Related Topics