Others

Fix Microsoft Project Actual Cost for Cost Resources

Aamir Naveed AkramAamir Naveed Akram Nov 14, 2026 869 views

Question details

The user needs to record actual costs for a cost-resource assignment on a partially completed task.

How to Update Actual Cost for Cost Resources in Microsoft Project
Product
Microsoft Project
Device & OS
not provided
Scenario
A task has work, material, and cost resources assigned and is marked partially complete.
Observed behavior
Actual Cost updates for work and material resources, but the cost-resource actual cost does not update from the task's percentage complete.
Before you start

Identify the task and its cost-resource assignment, and determine the actual amount incurred. Check that the resource is set to the Cost type in Resource Sheet.

Solution 1Recommended

Enter the Cost-Resource Actual Cost in a Usage View

Use this method to record the amount incurred for a cost-resource assignment.

This is expected behavior: a cost resource does not have assignment units or a rate that Project can use to calculate actual cost from task progress. Enter the actual amount rather than relying on percent complete.

1
Open a usage view

In Microsoft Project, select View > Task Usage. Alternatively, select View > Resource Usage.

2
Find the assignment

In Task Usage, expand the relevant task and locate its cost-resource assignment. In Resource Usage, expand the cost resource and locate the assigned task.

3
Show Actual Cost

Right-click a column heading, choose Insert Column, and select Actual Cost if the column is not already visible.

4
Enter the incurred amount

On the cost-resource assignment row, enter the amount incurred in the Actual Cost column. Review the assignment's Cost and Actual Cost values to confirm the entry.

Enter the Cost-Resource Actual Cost in a Usage View
If the field cannot be edited: Check File > Options > Schedule for the project calculation option labeled Actual costs are always calculated by Project. Changing this setting can affect actual-cost entry for other resources, so review its effect before turning it off.
Free Microsoft Office alternative

Track Project Expenses in WPS Spreadsheets

WPS Office is a free, lightweight alternative for everyday office work. Use its familiar spreadsheet interface to maintain a separate expense tracker and migrate compatible Office documents, though it does not fix Microsoft Project's cost-resource behavior.

Track planned and actual project expenses in a spreadsheetOpen and edit Microsoft Excel XLSX filesWork with Microsoft Word and PowerPoint formatsUse a familiar interface for everyday office tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't Actual Cost change when I mark a task 50% complete?

Microsoft Project does not calculate a cost resource's actual cost from task percentage complete. Enter the amount incurred on the cost-resource assignment in Task Usage or Resource Usage.

Where can I find the Actual Cost field?

Select View > Task Usage or View > Resource Usage. If Actual Cost is not visible, right-click a column heading, choose Insert Column, and select Actual Cost.

Why do work and material resources update differently?

Work-resource costs can be calculated from actual work and rates, while material-resource costs can be calculated from actual units and rates. Cost resources do not use those assignment units for progress-based actual-cost calculation.

Does entering a planned cost automatically record it as an actual cost?

Do not assume that a planned cost becomes an actual cost as the task progresses. Review the Cost and Actual Cost fields on the assignment and enter the amount actually incurred.