Skip to main content
Administrator Guide
Last Updated: 2023-06-23
Steps: Use Cash Forecasting with Worksheets

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.
  1. Create your cash forecast using Workday data.
    You can:
  2. (Optional) Access the
    Schedule Cash Forecast
    task.
    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 Reporting
    domain in the Cash Management functional area.
  3. Run cash forecast reports.
    Use the cash forecast standard reports to view and analyze your projected income and expenses.
  4. (Optional) Create a custom dashboard with cash forecast worklets.
    You can create custom worklets using the
    Cash Forecast Cells 2.0
    data 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.