Share

Budget and Contract Tables

Cost Management provides two ways to view your project's financial information through the Budget and Contract tables. These tables help you track all incoming and outgoing cash for your project:

  • Budget table: Organizes incoming budget, outgoing costs, and changes by your preferred budget coding structure.
  • Contract table: Organizes the same financial data by supplier contract.

Both tables contain identical financial information but present it differently based on your tracking needs.

Each table is organized into five main sections:

  • General: Contains defining information about each line item, such as the budget code.
  • Budget: Shows incoming values that will be paid to your company.
  • Cost: Shows outgoing project expenditures.
  • Forecast: Shows cost projections.
  • Variance: Shows money gained or lost for budget items.

Tip: For detailed information about these tables, see the Work with Budgets and Work with Contracts articles.

Change Order Scope Types

When creating change orders, the scope you select determines how the change order affects your budget and cost data. You can set the scope in the Change Order tool:

  1. Navigate to the Change Order tool from the left navigation.

  2. In the Scope column, select one of these options for each item:

    • In Scope: Updates only the Cost section of the table. The change order amount will increase your project's total cost but won't affect the budget.
    • Budget Only: Updates only the Budget section of the table. The change order amount will increase your project's budget but won't affect the total cost.
    • Out of Scope: Updates both the Budget and Cost sections of the table. The change order amount will increase both your project's budget and total cost.
    • Contingency: Updates both Budget and Cost sections. This option helps you track changes that use your contingency funds. It lets you distinguish between change orders that increase your overall budget and changes that simply use money you've already set aside in your contingency budget.

Tip: You can customize the names of these change order scope options in Change Order Settings to match your company's terminology.

Budget Columns

The values in these columns update as the budget status changes:

  • Original Budget: Populates as the budget is entered or imported.
  • Internal Budget Transfers: Populates by internal budget transfers.
  • Approved Owner Changes: The sum of the approved value of cost items with a budget status of Approved or Executed.
  • Revised Budget: Populates with the sum of the Original Budget, Internal Adjustments, and Approved Owner Changes.
  • Pending Owner Changes: The sum of the value of cost items with a budget status of Open, Submitted, Accepted, or Revise and Resubmit.
  • Projected Budget: The sum of the Revised Budget and Pending Owner Changes.

The colors in the following image represent the column where values appear based on their budget status. The value entered comes from the budget stage of the cost item.

Note: Draft, Rejected, and Void budget statuses don't appear in the table.

Cost Columns

The values in these columns update as the cost status changes:

  • Original Commitment: The projected or actual initial contract cost.

    Note: If there is no contract linked with this budget, the Original Commitment value will be equal to the Revised Budget value. Therefore, the Variance column will display zero.
  • Approved Change Orders: Approved contract change orders.

  • Uncommitted Change Orders: Cost items that have their budget status approved or executed, but cost status is not approved or executed.

  • Pending Change Orders: Contract change orders that are calculated on the cost item's Proposed Value (if Committed Value is empty) or Committed Value with a cost status of Proposed or Accepted.

  • Reserves: Allowance calculated using the "Estimated" value of a cost item with a cost status of Open, Pricing, or Revise and Resubmit.

  • Commitment & Changes: The sum of Original Commitment, Approved Change Orders, Pending Change Orders, and Reserves. The Original Commitment column populates Contracted Commitment unless it's empty - then, Revised Budget.

  • Projected Cost: Populates the value from the Actual Cost when it's greater than the Commitment & Changes column's value calculation. Otherwise, the Commitment & Changes column's value is shown.

  • Actual Cost: The sum of Approved Expense, Approved Cost Payment Application, and Direct Input. Direct Input shows any expenses processed in a company's ERP system and integrated into Cost Management.

The colors in the following image represent the column where values appear based on their cost status. The value entered comes from the cost stage of the cost item.

Note: Draft and Void cost statuses don't appear in the table.

Forecast Columns

The values populate and move across the columns in the forecast section as the cost status changes.

  • Forecast Adjustments: Manual adjustments for expected cost changes.
  • Forecast Cost to Complete: The projected amount to be spent to complete the project.
  • Forecast Final Cost: Sum of Original Commitments, Approved Owner Changes, Pending Owner Changes, and Reserves.

Variance Columns

The values populate and move across the columns in the variance section as the cost status changes.

  • Variance: The difference between Projected Budget and Projected Costs. If the Projected Budget value is 11,900 and the Projected Costs value is 9,900, the value in the Variance column is 2,000.
  • Forecast Variance: The amount of money made or lost due to midproject adjustments.
Note: You can customize the budget and contract tables to provide unique columns for more individual calculations. To learn more, see the Create Custom Columns article.

Was this information helpful?