How to Add Cost in Microsoft Project

You opened Microsoft Project to track your budget. Now you’re staring at a grid of tasks and wondering: where exactly do I put the money? You’re not alone. Project managers at every level hit this wall.

Here’s the uncomfortable truth: cost overruns are the norm, not the exception. According to the Project Management Institute, only 43% of projects are completed within their original budget. McKinsey research found that large IT projects run an average of 45% over budget — and that figure doesn’t even account for scope creep.

Microsoft Project gives you a powerful cost management system — but only if you know how to use it. This guide walks you through every method to add, assign, and track costs so you stop guessing and start controlling.

Why Cost Tracking in Microsoft Project Actually Matters

Before we get into the how, let’s get clear on the why. The CHAOS Report by Standish Group consistently shows that projects with strong budget tracking are 2.5× more likely to succeed than those without structured cost management. Gartner data reinforces this: organisations that actively monitor project costs save an average of 15–20% compared to those that review costs only at milestones.

Microsoft Project handles three types of costs you can assign:

• Resource costs — people and equipment you pay per hour, per day, or per use
• Fixed costs — one-time amounts tied to a specific task
• Cost resources — variable expenses like travel, software licences, or vendor fees

Get all three right, and you have a real-time financial dashboard inside your project plan.

Understanding the Cost Fields in Microsoft Project

The Four Core Cost Views

Navigate to the View tab and explore these layouts before entering any numbers:

Switching between these views gives you a 360-degree picture of where money is going. Most people never leave Gantt Chart — and that’s exactly why their budgets blow up.

How to Add Resource Costs

Resource costs are the most common type in Microsoft Project. Every time a team member or piece of equipment works on a task, the cost accumulates automatically — but only after you set the rate.

Step-by-Step: Setting Rates on the Resource Sheet

Once rates are in, assign your resources to tasks via the Resource Names column in Gantt Chart view. Microsoft Project calculates the cost automatically using Duration × Rate = Cost. Change the duration and the cost updates instantly.

Pro Tip: Cost Rate Tables

Double-click any resource → go to the Costs tab. You’ll see five rate tables (A through E). Use these to set different rates for different phases or clients on the same resource — without creating duplicate resource entries. Most project managers never discover this feature and end up with cluttered resource lists.

How to Add Fixed Costs to Tasks

Fixed costs are one-time charges that don’t depend on how long a task takes. Think: venue hire, software licence, subcontractor flat fee, or courier costs.

Step-by-Step: Adding Fixed Costs

Fixed Cost Accrual controls when the cost hits your budget. If you pay upfront, choose Start. If you pay on delivery, choose End. For spread payments, Prorated distributes it evenly across the task duration.

According to a 2023 survey by Wellington, 63% of project managers underestimate fixed costs because they skip logging vendor payments and one-off expenses during execution. Building this discipline into your project file from day one is the difference between a clean audit and a financial surprise at handover.

How to Add Cost Resources

Cost resources are flexible variable expenses that you assign directly to tasks — travel, meals, third-party tools, printing. Unlike Work or Material resources, they don’t depend on duration or quantity. You enter the exact amount every time you assign them.

Step-by-Step: Creating a Cost Resource

Cost resources are perfect for repeating expense categories that vary by task. Create “Travel” once, then assign it to every relevant task with the actual spend. This keeps your resource list lean and your cost data accurate.

How to Set a Project Budget in Microsoft Project

Budgets in Microsoft Project work differently from regular resources. You need to create budget resources and assign them to the project summary task (Row 0). This gives you a top-level financial target to measure against.

Setting Up Budget Resources

With a budget resource in place, the Budget Cost vs. Total Cost comparison gives you an instant variance figure. Gartner reports that teams using formal budget baseline comparisons detect overruns an average of 3 weeks earlier than those relying on manual spreadsheet reconciliation.

How to Set and Use a Baseline for Cost Tracking

A baseline is a snapshot of your approved plan — tasks, durations, and costs — that you save before execution begins. Without it, there’s nothing to compare actual spend against.

Saving a Baseline

Go to Project → Set Baseline → Set Baseline → OK. Microsoft Project saves Baseline Cost, Baseline Work, and Baseline Duration for every task. You can store up to 11 baselines (Baseline through Baseline 10) to track major re-plans.

Viewing Cost Variance

Switch to View → Tables → Cost to see the Cost Variance column (Baseline Cost minus Total Cost). Negative numbers mean you’re over budget. A 2022 PMI Pulse of the Profession report found that only 57% of projects are completed within their original budget — and the gap most often starts during execution when no one is watching the variance column.

Tracking Actual Costs vs. Planned Costs

Entering Actual Costs Manually

By default, Microsoft Project calculates actual costs automatically based on % Complete × Planned Cost. If your real spend differs from that formula:

• Go to File → Options → Schedule
• Uncheck “Actual costs are always calculated by Microsoft Project”
• Now you can type actual costs directly into the Actual Cost column

This matters because automated calculation assumes costs accrue linearly — and they rarely do in real projects.

Using the Earned Value Table

Switch to View → Tables → Earned Value to access three critical metrics:

• BCWS (Budgeted Cost of Work Scheduled) — what you planned to spend by now
• BCWP (Budgeted Cost of Work Performed) — what the completed work was supposed to cost
• ACWP (Actual Cost of Work Performed) — what you actually spent

The Cost Performance Index (CPI = BCWP / ACWP) tells you how efficiently you’re using your budget. A CPI below 1.0 means you’re spending more than planned. A PMI study found that projects with a CPI below 0.8 at the 20% completion mark rarely recover — making early tracking non-negotiable.

Common Cost Mistakes in Microsoft Project (and How to Fix Them)

• No baseline saved: You have nothing to compare against. Save a baseline before your project kicks off.
• Mixing cost types: Using fixed costs for things that should be cost resources leads to inaccurate task-level reports.
• Forgetting overhead: Add overhead as a cost resource assigned to summary tasks to capture true project spend.
• Ignoring accrual settings: Wrong accrual timing distorts cash flow views — always set Accrue At deliberately.
• Not updating actuals: Planned cost is a forecast, not a fact. Enter actuals regularly for accurate variance tracking.

A Harvard Business Review analysis of 1,471 projects found that one in six projects experienced cost overruns of 200%. The root cause almost always traced back to poor real-time tracking — exactly what these habits prevent.

Cost Reporting: Sharing the Numbers with Stakeholders

Once your costs are entered and tracked, use these built-in reports to communicate budget status:

• Budget Report — Compare planned vs. actual vs. remaining costs across the project
• Overbudget Tasks Report — Instantly surface tasks where actual cost exceeds baseline cost
• Overbudget Resources Report — Identify which resources are driving variance
• Earned Value Report — Show CPI and SPI trends to leadership without manual calculation

Access all of these from Report → Dashboards or Report → Costs. Export any report to PDF or copy visuals into PowerPoint for board-ready presentations. Research by Wellingtone shows that 77% of high-performing project teams produce a weekly cost status report — making visibility a habit, not a crisis response.v

You opened Microsoft Project to track your budget. Now you’re staring at a grid of tasks and wondering: where exactly do I put the money? You’re not alone. Project managers at every level hit this wall.

Here’s the uncomfortable truth: cost overruns are the norm, not the exception. According to the Project Management Institute, only 43% of projects are completed within their original budget. McKinsey research found that large IT projects run an average of 45% over budget — and that figure doesn’t even account for scope creep.

Microsoft Project gives you a powerful cost management system — but only if you know how to use it. This guide walks you through every method to add, assign, and track costs so you stop guessing and start controlling.

Why Cost Tracking in Microsoft Project Actually Matters

Before we get into the how, let’s get clear on the why. The CHAOS Report by Standish Group consistently shows that projects with strong budget tracking are 2.5× more likely to succeed than those without structured cost management. Gartner data reinforces this: organisations that actively monitor project costs save an average of 15–20% compared to those that review costs only at milestones.

Microsoft Project handles three types of costs you can assign:

• Resource costs — people and equipment you pay per hour, per day, or per use
• Fixed costs — one-time amounts tied to a specific task
• Cost resources — variable expenses like travel, software licences, or vendor fees

Get all three right, and you have a real-time financial dashboard inside your project plan.

Understanding the Cost Fields in Microsoft Project

The Four Core Cost Views

Navigate to the View tab and explore these layouts before entering any numbers:

Switching between these views gives you a 360-degree picture of where money is going. Most people never leave Gantt Chart — and that’s exactly why their budgets blow up.

How to Add Resource Costs

Resource costs are the most common type in Microsoft Project. Every time a team member or piece of equipment works on a task, the cost accumulates automatically — but only after you set the rate.

Step-by-Step: Setting Rates on the Resource Sheet

Once rates are in, assign your resources to tasks via the Resource Names column in Gantt Chart view. Microsoft Project calculates the cost automatically using Duration × Rate = Cost. Change the duration and the cost updates instantly.

Pro Tip: Cost Rate Tables

Double-click any resource → go to the Costs tab. You’ll see five rate tables (A through E). Use these to set different rates for different phases or clients on the same resource — without creating duplicate resource entries. Most project managers never discover this feature and end up with cluttered resource lists.

How to Add Fixed Costs to Tasks

Fixed costs are one-time charges that don’t depend on how long a task takes. Think: venue hire, software licence, subcontractor flat fee, or courier costs.

Step-by-Step: Adding Fixed Costs

Fixed Cost Accrual controls when the cost hits your budget. If you pay upfront, choose Start. If you pay on delivery, choose End. For spread payments, Prorated distributes it evenly across the task duration.

According to a 2023 survey by Wellington, 63% of project managers underestimate fixed costs because they skip logging vendor payments and one-off expenses during execution. Building this discipline into your project file from day one is the difference between a clean audit and a financial surprise at handover.

How to Add Cost Resources

Cost resources are flexible variable expenses that you assign directly to tasks — travel, meals, third-party tools, printing. Unlike Work or Material resources, they don’t depend on duration or quantity. You enter the exact amount every time you assign them.

Step-by-Step: Creating a Cost Resource

Cost resources are perfect for repeating expense categories that vary by task. Create “Travel” once, then assign it to every relevant task with the actual spend. This keeps your resource list lean and your cost data accurate.

How to Set a Project Budget in Microsoft Project

Budgets in Microsoft Project work differently from regular resources. You need to create budget resources and assign them to the project summary task (Row 0). This gives you a top-level financial target to measure against.

Setting Up Budget Resources

With a budget resource in place, the Budget Cost vs. Total Cost comparison gives you an instant variance figure. Gartner reports that teams using formal budget baseline comparisons detect overruns an average of 3 weeks earlier than those relying on manual spreadsheet reconciliation.

How to Set and Use a Baseline for Cost Tracking

A baseline is a snapshot of your approved plan — tasks, durations, and costs — that you save before execution begins. Without it, there’s nothing to compare actual spend against.

Saving a Baseline

Go to Project → Set Baseline → Set Baseline → OK. Microsoft Project saves Baseline Cost, Baseline Work, and Baseline Duration for every task. You can store up to 11 baselines (Baseline through Baseline 10) to track major re-plans.

Viewing Cost Variance

Switch to View → Tables → Cost to see the Cost Variance column (Baseline Cost minus Total Cost). Negative numbers mean you’re over budget. A 2022 PMI Pulse of the Profession report found that only 57% of projects are completed within their original budget — and the gap most often starts during execution when no one is watching the variance column.

Tracking Actual Costs vs. Planned Costs

Entering Actual Costs Manually

By default, Microsoft Project calculates actual costs automatically based on % Complete × Planned Cost. If your real spend differs from that formula:

• Go to File → Options → Schedule
• Uncheck “Actual costs are always calculated by Microsoft Project”
• Now you can type actual costs directly into the Actual Cost column

This matters because automated calculation assumes costs accrue linearly — and they rarely do in real projects.

Using the Earned Value Table

Switch to View → Tables → Earned Value to access three critical metrics:

• BCWS (Budgeted Cost of Work Scheduled) — what you planned to spend by now
• BCWP (Budgeted Cost of Work Performed) — what the completed work was supposed to cost
• ACWP (Actual Cost of Work Performed) — what you actually spent

The Cost Performance Index (CPI = BCWP / ACWP) tells you how efficiently you’re using your budget. A CPI below 1.0 means you’re spending more than planned. A PMI study found that projects with a CPI below 0.8 at the 20% completion mark rarely recover — making early tracking non-negotiable.

Common Cost Mistakes in Microsoft Project (and How to Fix Them)

• No baseline saved: You have nothing to compare against. Save a baseline before your project kicks off.
• Mixing cost types: Using fixed costs for things that should be cost resources leads to inaccurate task-level reports.
• Forgetting overhead: Add overhead as a cost resource assigned to summary tasks to capture true project spend.
• Ignoring accrual settings: Wrong accrual timing distorts cash flow views — always set Accrue At deliberately.
• Not updating actuals: Planned cost is a forecast, not a fact. Enter actuals regularly for accurate variance tracking.

A Harvard Business Review analysis of 1,471 projects found that one in six projects experienced cost overruns of 200%. The root cause almost always traced back to poor real-time tracking — exactly what these habits prevent.

Cost Reporting: Sharing the Numbers with Stakeholders

Once your costs are entered and tracked, use these built-in reports to communicate budget status:

• Budget Report — Compare planned vs. actual vs. remaining costs across the project
• Overbudget Tasks Report — Instantly surface tasks where actual cost exceeds baseline cost
• Overbudget Resources Report — Identify which resources are driving variance
• Earned Value Report — Show CPI and SPI trends to leadership without manual calculation

Access all of these from Report → Dashboards or Report → Costs. Export any report to PDF or copy visuals into PowerPoint for board-ready presentations. Research by Wellingtone shows that 77% of high-performing project teams produce a weekly cost status report — making visibility a habit, not a crisis response.