Others

Why Microsoft Project Adds Actual Cost to the Cost Column Explained

Maira Mehtab Sep 27, 2026 872 views

Question details

The user needs to understand the calculation logic behind Microsoft Project adding manually entered Actual Cost to the Cost column while remaining work is still present.

Product: Microsoft Project
Device & OS: not provided
Scenario: Manually updating actual project costs during project execution and observing unexpected increases in the total Cost calculation.
Observed behavior: When Actual Cost is entered manually, it is added to the Cost column along with the cost of remaining work, inflating the total Cost, whereas the Baseline Cost remains unchanged.

Before you start

Ensure you have saved a baseline for your project before tracking actual costs to accurately compare your planned performance against actual execution.

Solution 1Recommended

Adjust Actual Work to Correct the Cost Column Calculation

Update the Actual Work value so Microsoft Project accurately decreases Remaining Work, preventing inflated total costs.

Microsoft Project calculates Total Cost by adding Actual Cost to the cost of Remaining Work. If you enter an Actual Cost but leave Actual Work at zero, the Remaining Work still equals the originally planned Work.

Because Remaining Work hasn't decreased, Project multiplies this remaining work by the assigned resource's rate and adds it to your manually entered Actual Cost, resulting in a higher total in the Cost column.

Check the Actual Work value

Navigate to the Task Usage or Resource Usage view and locate the 'Actual Work' column for the affected task.

Update the Actual Work

Enter the correct number of completed hours in the 'Actual Work' field. This action will automatically reduce the 'Remaining Work' value accordingly.

Verify the updated Cost

Check the 'Cost' (Total Cost) column again. The cost of remaining work should now be reduced, reflecting an accurate total cost without duplicating the planned amount.

Baseline Cost Stability: Your Baseline Cost will remain unchanged during this process, allowing you to accurately track cost variances against your original plan.

Free Microsoft Office alternative

Track Project Costs Easily with WPS Office

While Microsoft Project is built for complex scheduling, managing project budgets and tracking actual costs can often be simplified using spreadsheets. WPS Office provides a powerful, free alternative to Microsoft Office, enabling you to build transparent, custom cost-tracking templates without unexpected automated calculations.

1. Open WPS Spreadsheet: Launch WPS Office and create a new blank spreadsheet or choose a pre-designed Project Management template.
2. Set Up Cost Columns: Create dedicated columns for Planned Cost, Actual Work, Actual Cost, Remaining Cost, and Total Cost.
3. Apply Transparent Formulas: Use simple sum formulas (e.g., =Actual Cost + Remaining Cost) to calculate Total Cost accurately without hidden automated recalculations.

Easily manage project budgets with customizable tracking spreadsheetsFully compatible with Microsoft Excel (.xlsx, .xls) formatsLightweight, fast, and completely free alternative to the MS Office suiteFamiliar user interface ensures seamless migration with zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Total Cost exceed my Baseline Cost in MS Project?

Total Cost updates dynamically based on Actual Cost and Remaining Work. If a task requires more actual work hours or incurs higher costs than originally planned, the calculated Total Cost will exceed your saved Baseline Cost.

How do I stop Microsoft Project from automatically calculating actual costs?

You can disable automatic actual cost calculation by going to File > Options > Schedule, and unchecking the box for 'Actual costs are always calculated by Project'. This allows you to manually input actual costs without the software overwriting them based on resource rates.

What is the exact formula Microsoft Project uses for the Cost column?

In Microsoft Project, the Cost (or Total Cost) column is calculated as: Actual Cost + Remaining Cost. The Remaining Cost is calculated by multiplying the Remaining Work by the Standard Rate of the assigned resources.

Office Quick Solutions