Others

How to Unlink Cost and Actual Cost Fields in Microsoft Project

John Wilson Oct 16, 2026 868 views

Question details

The user wants to manage forecast costs and actual costs independently, but finds that entering a value in the Cost field automatically overwrites the Actual Cost field.

How to Unlink Cost and Actual Cost Fields in Microsoft Project

Product: Microsoft Project
Device & OS: not provided
Scenario: Entering forecast cost data and tracking real expenditures during project planning or execution.
Observed behavior: The Actual Cost field is automatically populated with the value entered in the Cost field, linking the two values and preventing independent manual tracking.

Before you start

Verify your current Microsoft Project version and ensure you have added both the 'Cost' and 'Actual Cost' columns to your active Gantt Chart or Task Sheet view to see the changes take effect.

Solution 1Recommended

Disable Automatic Actual Cost Calculation

Change the calculation options in Microsoft Project so that actual costs are no longer automatically updated based on the total or baseline cost.

By default, Microsoft Project is configured to automatically calculate actual costs based on resource rates and task progress. Disabling this global setting forces the software to let you enter actuals manually.

Open Project Options

Click on the 'File' tab in the top ribbon and select 'Options' from the bottom of the left-hand menu.

Navigate to Schedule Settings

In the Project Options dialog box, select the 'Schedule' tab located on the left panel.

Disable Auto-Calculation

Scroll down to the 'Calculation options for this project' section at the bottom. Uncheck the box labeled 'Actual costs are always calculated by Project'.

Apply Changes

Click 'OK' to save your settings. You can now manually type distinct values into the Actual Cost column without it mirroring the planned Cost.

Disable Automatic Actual Cost Calculation

Settings Applied: Future updates to the task's completion percentage or baseline cost will no longer overwrite your manual actual cost entries.

Solution 2

Verify Task Completion Status

Ensure the task isn't marked as 100% complete, as completed tasks automatically align actual costs with total costs regardless of some settings.

Free Microsoft Office alternative

Track Project Budgets Easily with WPS Spreadsheet

Need a simpler way to manage project budgets without fighting complex auto-calculation settings? WPS Spreadsheet offers a lightweight, highly flexible solution for independent cost tracking. Fully compatible with Microsoft Excel formats, it is the perfect tool for teams wanting straightforward manual control over their financial data.

1. Create a Project Tracker: Launch WPS Office and open a blank Spreadsheet to set up your project task list.
2. Set Up Custom Columns: Create entirely separate columns for 'Forecast Cost' and 'Actual Cost' to guarantee they remain unlinked.
3. Manage Costs Manually: Input your budget data directly into the cells, retaining 100% control over both estimated and actual expenditures.

Free and lightweight alternative for project budget trackingSeamless compatibility with Microsoft Excel (.xlsx) formatsFamiliar user interface with no steep learning curveTotal manual control over cost, baseline, and actual columns without forced linking

microsoft office alternative - wps office

Frequently Asked Questions

Why do my actual costs change when I update the completion percentage in Microsoft Project?

If the 'Actual costs are always calculated by Project' option is enabled, Project automatically prorates your actual costs based on the task's % Complete. Disabling this setting in the Schedule options stops this behavior.

Can I reset actual costs to zero in Microsoft Project?

Yes. First, ensure the automatic calculation option is disabled in your Project Schedule options. Once disabled, you can manually type '0' into the Actual Cost field for any given task.

How do I show the Actual Cost column in my current view?

In the Gantt Chart or Task Sheet view, right-click on any existing column header, select 'Insert Column', and type 'Actual Cost' into the search bar. Press Enter to add it to your table.

Office Quick Solutions