Steps: Use Cash Forecasting with Worksheets
Set up cash forecasting with Worksheets.
You can model and prepare your cash forecast data in Worksheets. After generating your cash
forecast, you can view your results and evaluate the forecasted cash position of
your company using cash forecast reports and the Cash Management dashboard.
- Create your cash forecast using Workday data.You can:
- Create custom reports with live operational data to link to a model workbook in Worksheets. You can also configure the custom reports to capture data that's not provided by the data source sets.
- (Optional) Access theSchedule Cash Forecasttask.You can schedule cash forecasts to automatically generate on regular intervals, or once in the future. Workday saves each generated cash forecast as a separate workbook in Drive.Example: Use the scheduler to automatically generate a cash forecast workbook daily for a predefined number of days, instead of manually generating the cash forecast each day.Security:Process: Cash Forecast Reportingdomain in the Cash Management functional area.
- Run cash forecast reports.Use the cash forecast standard reports to view and analyze your projected income and expenses.
- (Optional) Create a custom dashboard with cash forecast worklets.You can create custom worklets using theCash Forecast Cells 2.0data source to display on a custom dashboard. The worklets are up-to-date, graphical reports that display your cash forecast information such as:
- Cash forecasts for the next 5 days.
- Funding needs.
- Large supplier payments over a specified period.
Use the cash forecast results to:
- Estimate your cash inflows, outflows, and bank account balances over a specified period.
- Determine where you might have shortfalls or surplus funds so that you can make the necessary fund transfers.
- View insights into your overall financial performance.