Period Cash Forecast
PURPOSE
This document sets out the detailed steps for how to view the Period Cash Forecast screen.
WHY IS IT IMPORTANT
The Period Cash Forecast screen allows the user to view the overall cash projection for transactions that are booked in the system and overlay the forecast data maintained in the system for one entity or across a group of entities.
PROCEDURE
1. From the welcome screen, select Cash Management > Cash Activities > By Period.
Note: To access this screen, please ensure you have the access rights 12322 Access Cash Activity By Period assigned.
2. The Period Cash Forecast screen is displayed. To view the cash projection, fill all fields marked with an asterisk, as they are mandatory.
3. Select the Accounting Centre or Accounting Centre groups. Accounting Centre groups have a “+” sign in front of the short name.
4. Set the From Date and To Date to specify the date range to view the cash projection.
5. Select the Report Ccy.
6. Select the SSI. The user can choose a specific SSI or group of SSIs. Groups of SSIs appear under “+Groups” in the drop-down list.
7. The cycle field is set to default. If chosen, the default cycle will allow maintaining forecasts for an open-ended period. This can also be defined. For more information on how to set rolling forecast cycles, click here.
8. The source field is also set to default. Source can be used to maintain forecasts for different purposes. For example, you may want to keep an aggressive forecast in the system. This can be done by creating a source called “Aggressive Forecast,” and then forecasts can be maintained under this source. For more information on how to set up the source, click here.
9. Select the Period whether to view Daily, Weekly or Monthly.
10. After all mandatory fields are filled in, click Refresh and the screen below displays. In this example, it shows a weekly cash projection by SSI group from 3-Jul-2017.
11. While the user can set a flexible date range to view the cash projection, the screen allows viewing up to 12 periods only at one time. Users can use the date toggle feature to scroll to view future dates.
12. The forecasts are uneditable if the cash projection is viewed by accounting centre group or SSI group. To allow editing forecasts, please ensure you select a specific accounting centre, SSI and ensure the reporting currency is set to the same as the SSI currency. Only forecasts within the period dates of the forecast cycle selected can be edited.
13. When there are forecast edits, you’ll see the forecast cells change to yellow.
14. Forecast edits can be discarded or saved.
15. To discard edits, click Action > Discard edits. This will discard all unsaved edits.
16. To save edits, click Action > Save Edit. This will save all the changes made to the forecasts. Upon clicking Save Edit, users can enter comments and then click Yes once done.
Note: To save edits, you will need to have access rights 12323 Save Cash Activity By Period.
17. You will see a message when forecasts are saved successfully. Hovering over the forecast cells allows you to view any comments entered for the forecast changes.
18. To export the cash projection data on the screen to CSV, click Action > Export CSV.
19. To take a snapshot of the cash projection, check the Snapshot checkbox at the bottom left of the screen. Enter a subject, enter any comments and click Save Snapshot. At the confirmation pop-up prompt, click Yes.
20. Once done, you will see a message that the snapshot was saved successfully.
21. Snapshots saved can be retrieved in the system by clicking the File/Note button > Documents tab.
Note: To access Document and Notes, you will need to have access rights 12317 Access File Storage.
22. Click on the Filename to download the snapshot in Excel.
23. Click Back button to return to Period Cash Forecast screen.
FREQUENTLY ASKED QUESTIONS
RELATED INFORMATION
CHANGE HISTORY
