Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2025-09-19
Steps: Manage Project Budgets with Worksheets

Steps: Manage Project Budgets with Worksheets

  • Set up and configure Worksheets in your tenant.
  • Create project budgets.
  • Configure the
    Planning Event
     business process and security policy in the Planning functional area.
  • Security:
    • Manage: Project Budget
       domain in the Projects functional area.
    • Set Up: Budget General
       domain in the Budgets functional area.
    • Worksheets
       domain in the System functional area.
With Worksheets, you can use a spreadsheet framework to:
  • Create project budget scenarios based on different assumptions.
  • Model nonlabor expenses and materials for a project budget or forecast.
  • Collaborate with project members on planning project budgets and forecasts.
  1. From the related actions menu of the plan, select
    Generate Plan Workbook
    .
    Workday generates a plan workbook with a status of
    In Worksheets
    , preventing all other modifications to the plan.
  2. (Optional) Select
    Plan Workbook
    Enter Worksheets Draft Mode
     from the related actions menu of the plan.
    Suspend validations during editing. Workday doesn't display custom validations in the related workbooks.
    When the plan is in draft mode, Workday changes the status to
    In Worksheets Draft
    .
  3. (Optional) Select
    Create Plan Version
     from the related actions menu of the plan.
    Create versions of your workbook. Take a snapshot of your edited workbook at any time while the plan status is
    In Worksheets
    . The original plan and workbook remain active and editable. Workday creates read-only copies with a status of
    Versioned
    .
  4. (Optional) From the related actions menu of the plan, select
    Plan Workbook
    Update Plan from Workbook
    .
    Update the plan with your changes from the active plan entry area in the workbook while the plan status is
    In Worksheets
    .
  6. (Optional) Lock your workbook from the related actions menu of the plan, or lock workbooks in mass with the
    Schedule Project Budget Workbook Mass Lock
     task.
    When you lock the workbook, Workday returns the plan to a status of
    Draft
    .
  7. (Optional) From the related actions menu of the plan, select
    Update Budget
    .
    Sync your workbook when updating your project budget.
  8. (Optional) Select the
    Update Plan Workbook
     check box.
    Sync the associated workbook. Workday overwrites any changes you make on the sheet containing the plan entry area. You can only update project budgets with a plan status of
    Draft
    .
Submit and route your plan for approval.