By Jonas Tyrone Lobaton, MSc Quantitative Finance, FMVA®
Founder, Frac CFO · Updated October 5, 2026
A useful project budget tracker in Excel should tell you more than how much you have spent. It should show the approved budget, actual costs, committed costs, remaining work, forecast cost at completion, and the variance you are likely to finish with. For projects that use earned value management, it should also connect cost performance to measurable progress instead of treating “under budget” as automatically healthy.
TL;DR:
- A useful tracker should separate original budget, approved changes, current budget, actual cost, committed cost, ETC, EAC, and variance at completion.
- Use Excel Tables and structured references for transaction rollups; SUMIFS handles category and period totals, while XLOOKUP or INDEX/MATCH handles lookups.
- Earned value works only when percent complete is measured objectively through milestones, units completed, 0/100, 50/50, or another documented progress rule.
- Contingency reserve addresses identified risks within the baseline; management reserve covers unforeseen in-scope work outside the performance measurement baseline.
- Use both cumulative and period performance views: cumulative CPI/SPI show the stable trend, while period metrics reveal recent improvement or deterioration.
Table of Contents
- What your project budget tracker should contain
- Which downloadable template fits your project?
- Inside the file: line items, cost codes, and WBS mapping
- Budget, commitments, and change control
- Setting up and running your tracker without breaking the formulas
- What PV, EV, AC, CPI, SPI, and EAC actually tell you
- Fixing the Excel problems that quietly wreck a tracker
- When a ready-made template is enough, and when it is not
- Planned vs. actual tracking and color-coded alerts
- Customizing templates for different project types or industries
- Tips for improving accuracy in budget forecasting
- Connecting your tracker to other project tools
- Visualizing your budget with charts and dashboards in Excel
- What a spreadsheet tracker can’t tell you on its own
- Get your tracker and the setup support that goes with it
- FAQ
- Sources
What your project budget tracker should contain
Before choosing a template, make sure the file can separate current spending from future obligations and forecast the likely final cost.
| Field | Why it matters |
|---|---|
| WBS / cost code | Connects every cost to a defined work package or control account. |
| Owner | Makes responsibility for each budget line explicit. |
| Original budget | Preserves the amount approved at baseline. |
| Approved changes | Separates authorized scope or budget changes from the original plan. |
| Current approved budget | Original budget plus approved changes. |
| Actual cost | What has already been incurred or posted. |
| Committed cost | Purchase orders, signed contracts, or other obligations not yet fully invoiced. |
| ETC | Best estimate of the cost still required to finish the remaining work. |
| EAC | Forecast total cost at completion: actual cost plus the remaining forecast. |
| Variance at completion | Shows whether the project is forecast to finish above or below the approved budget. |
| % complete / EV | Measures progress so cost performance can be compared with work actually delivered. |
| Period / status | Supports weekly or monthly reporting and clear exception flags. |
Which downloadable template fits your project?
The right template depends on how complex your project is and how often money moves. Here is how the three main options stack up.
- Inventory & Budget Tracker: best for medium-sized projects with item-level costs, like construction or event budgets, where you need dashboard rollups across materials, labor, and equipment.
- Bookkeeping Excel Template: best for simple projects or ongoing expense reconciliation, where the main job is matching transactions to categorize rather than forecasting performance.
- Budget and Forecast Build: best for projects that need time-phased planning and an earned-value-ready baseline from day one, especially multi-month efforts with several cost accounts.
Most trackers worth using share a common file structure: an input sheet for planned costs, an actuals or transactions sheet, a time-phased planned-cost table, and a dashboard summarizing planned value (PV), earned value (EV), and actual cost (AC). When you are deciding which to download, ask three questions: how many line items does the project have, how frequently do transactions post, and do you need forecasted cost-at-completion figures or just a running total. Formal earned-value tracking is most useful when scope, schedule, and cost need to be measured together. For example, on projects with multiple work packages, contractual reporting, objective progress measurement, significant cost risk, or a real need to forecast EAC. Project duration by itself is not the deciding factor.
Inside the file: line items, cost codes, and WBS mapping
Once you have a template open, the anatomy matters more than the brand name on the tab. A well-built tracker organizes costs into recognizable groups so nothing gets buried in a catch-all “misc” row.
- Labor: hours and rates by role or crew, often the largest and most volatile line item.
- Materials: direct purchases tied to deliverables, ideally coded to the task that consumes them.
- Subcontractors: third-party work billed separately from in-house labor.
- Equipment: rented or owned equipment costs, sometimes split into fixed and usage-based charges.
- Travel: per diem, lodging, and transportation tied to specific tasks or milestones.
- Fixed costs: licenses, permits, or flat fees that do not vary with activity level.
- Contingency reserve: budget for identified risks and uncertainty that is included within the cost baseline.
- Management reserve: budget held outside the performance measurement baseline for unforeseen work that is still within the project’s overall scope.
Contingency and management reserve are different parts of project cost governance. Contingency reserve addresses identified risks and uncertainty that are already reflected in the baseline. Management reserve is held outside the performance measurement baseline for unforeseen but still in-scope work. Approval authority is defined by the organization’s governance; it is not automatically “the project manager versus the sponsor.” Keeping the two reserves separate prevents teams from treating all available funding as freely spendable project budget.
Beyond the cost groups, each row needs coding: a WBS or task ID, a cost account, an owner, and a time period. This is what lets your dashboard roll individual transactions up into meaningful totals. Time-phasing, typically monthly or weekly columns, lets you build a cumulative PV curve that you compare against actual spending as the project progresses.
Pro Tip: Code every line item to a WBS element before you enter a single dollar. Retrofitting cost codes after the fact is where most trackers fall apart.
Budget, commitments, and change control
Actual cost alone is not enough. A project can show only $40,000 of actual spend against a $100,000 budget while another $50,000 is already committed through purchase orders and signed contracts. A tracker that ignores commitments can make a nearly consumed budget look healthy.
Keep Original Budget, Approved Changes, and Current Approved Budget in separate fields. Do not overwrite the original baseline every time scope changes. That preserves the audit trail and lets you explain whether a variance came from execution, a change in scope, or both.
A practical forecast chain is: Current Approved Budget → Actual Cost → Committed Cost → ETC → EAC → Variance at Completion. This turns the tracker from a historical expense log into a forward-looking project finance tool.
Setting up and running your tracker without breaking the formulas
Getting a tracker from blank template to working dashboard follows a predictable sequence. Skip a step and the formulas downstream tend to break quietly, which is worse than breaking loudly.
- Define scope and structure. Build your WBS, assign cost accounts, and set your Budget at Completion (BAC), the total approved budget for the work.
- Enter time-phased planned costs. Spread the BAC across your schedule to create your planned value (PV) curve, then lock the baseline so it cannot be overwritten accidentally.
- Record actuals as they happen. Keep a single transaction table with columns for date, category, cost account, and amount rather than scattering entries across multiple sheets.
- Build rollups with Excel Tables and structured references. If your transaction table is named
Transactions, a formula like=SUMIFS(Transactions[Amount],Transactions[Period],B2,Transactions[Category],A2)pulls actuals for a given period and category. UseXLOOKUPfor modern lookup logic, withINDEX/MATCHas a compatible alternative where needed. - Add cumulative PV, EV, and AC rows, then layer in CPI, SPI, and EAC formulas on your dashboard so performance trends are visible at a glance rather than buried in raw numbers.
Microsoft’s SUMIFS documentation shows the correct sum-range and criteria-range structure. Pairing SUMIFS with Excel Tables keeps aggregation ranges expandable as new transactions are added, while XLOOKUP or INDEX/MATCH can handle dimension lookups such as owners, WBS descriptions, or cost-account mappings.
A sample reading: if your tracker shows EV of $40,000 against AC of $60,000, the cost performance index (CPI) comes out to 0.67, meaning you are getting roughly 67 cents of earned value for every dollar spent, a signal worth acting on before the gap widens, based on PMI’s earned value walkthrough.
What PV, EV, AC, CPI, SPI, and EAC actually tell you
Earned value metrics sound technical, but they answer a simple question: are you getting what you paid for, on the schedule you planned.
- Planned Value (PV): the budgeted cost of work scheduled to be done by a given date.
- Earned Value (EV): the budgeted cost of work actually completed by that date.
- Actual Cost (AC): what you really spent to get that work done.
EV is only useful if progress is measured objectively. Depending on the work package, use methods such as weighted milestones, units completed, 0/100, 50/50, or another documented rule tied to observable deliverables. Avoid typing a subjective “80% complete” estimate with no measurement basis; that can make CPI and SPI look precise while the underlying progress number is not.
From these three numbers, PMI’s earned value framework derives the variances and indices that matter for decision-making: Cost Variance (CV = EV − AC), Schedule Variance (SV = EV − PV), Cost Performance Index (CPI = EV ÷ AC), and Schedule Performance Index (SPI = EV ÷ PV). A Cost Performance Index (CPI) below 1.0 suggests spending is higher than the earned value, indicating cost overruns. A Schedule Performance Index (SPI) below 1.0 indicates the project is behind schedule relative to plan.
Estimate at Completion (EAC) should reflect the assumption you are making about the remaining work. If the past cost variance is considered non-recurring, use EAC = AC + (BAC − EV). If current cost efficiency is expected to continue, use EAC = BAC ÷ CPI. If both cost and schedule efficiency are expected to affect the remaining work, a more conservative option is EAC = AC + (BAC − EV) ÷ (CPI × SPI). These are different forecasting assumptions, not interchangeable labels for the same formula. The GAO Cost Estimating and Assessment Guide provides broader guidance on using performance data to update cost estimates.
To-Complete Performance Index (TCPI) shows the efficiency required on the remaining work to hit a target. To finish within BAC, use TCPI = (BAC − EV) ÷ (BAC − AC). If management has adopted a revised EAC target, use TCPI = (BAC − EV) ÷ (EAC − AC). If the required TCPI is materially stronger than the performance the project has achieved so far, the target deserves challenge rather than wishful formatting.
Use both period and cumulative views. Cumulative PV, EV, AC, CPI, and SPI give a stable read on the project’s overall trend. Period metrics show whether performance is improving or deteriorating recently. A good dashboard keeps both: cumulative for the strategic trend, period data for early warning.
Fixing the Excel problems that quietly wreck a tracker
Most tracker failures are not dramatic. They are small structural choices that compound over a few months.
- Hard-to-read references become fragile as the workbook grows. Excel often adjusts a reference such as
Sheet2!B14when rows are inserted, so it does not automatically break. The bigger control advantage of Excel Tables is that structured references are easier to audit, expand automatically with new rows, and make formulas less dependent on remembering fixed cell coordinates. - CSV imports introduce category drift. One month’s export calls it “travel,” the next calls it “Travel & Lodging.” Standardize category names before they hit your transaction table, and keep that table as the single source of truth your dashboard pulls from.
- Double counting and timing mismatches hide in plain sight. An invoice entered in two periods, or a cost booked a month before the work it funds actually happens, will distort your cumulative PV and AC without triggering any obvious error.
- Loose data entry invites inconsistency. Dropdown lists and data validation on your WBS and cost-account columns stop typos from splitting one cost account into three slightly different labels across the sheet.
Pro Tip: Add a simple reconciliation check on your dashboard, like a cell that flags when the sum of transaction-table amounts does not match your dashboard total. It catches broken formulas before they cost you a week of bad reporting.
When a ready-made template is enough, and when it is not
A ready-made tracker works well for a project with stable scope, straightforward cost accounts, and limited reporting requirements. It starts to strain when you add multiple funding sources, frequent approved changes, formal EVM, committed-cost tracking, or reporting that must roll into company-level forecasts.
- A structured tracker improves visibility when the team uses one transaction source, consistent cost coding, and a repeatable reporting cadence.
- A Budget Build makes sense when you need baseline PV curves, EAC logic, and dashboard formulas built correctly the first time rather than debugged after the fact.
- A Custom Finance Project fits when project budgeting needs to connect to company-level cash flow, not just a single initiative.
Move toward a custom build when you need integrated schedule-and-cost reporting, formal earned-value management, multiple funding sources, frequent approved changes, committed-cost tracking, or project forecasts that need to roll into company-level cash flow.
Planned vs. actual tracking and color-coded alerts
The core job of any budget tracker is a simple comparison: what did you plan to spend by this point, and what have you actually spent. Every useful dashboard puts these two numbers side by side, period by period, rather than only showing a single lifetime total.
Color-coded alerts turn that comparison into something you can act on at a glance. For earned-value projects, use ratio-based measures such as CPI and SPI when you want thresholds that scale across large and small work packages, or use percentage variances such as CV% and SV%. Avoid treating raw Schedule Variance (SV = EV − PV) as though it were a ratio; it is a currency-valued variance.
The mistake to avoid is coloring based on actual cost alone. A line item can be under budget simply because work has not started yet, which looks “green” but tells you nothing about performance. Tying the alert to the relationship between planned value, earned value, and actual cost gives you a signal that actually reflects whether the work is on pace, not just whether money has moved.
Customizing templates for different project types or industries
A construction project, a marketing campaign, and a software rollout do not share a cost structure, even though the underlying tracking logic is the same. Customizing a template usually means adjusting the line-item categories, not rebuilding the formulas.
For construction or physical builds, materials and subcontractor costs dominate, and tracking by WBS phase (foundation, framing, finishing) tends to matter more than tracking by month. For marketing or creative projects, the categories shift toward media spend, agency fees, and production costs, often with a shorter time-phasing cycle since campaigns move faster than builds. For software or product projects, labor hours and the cost of contracted development work carry most of the budget, and time-phasing by sprint or milestone fits better than a flat monthly grid.
![]()
The underlying mechanics, PV, EV, AC, and the SUMIFS or INDEX/MATCH formulas behind them, stay identical across all three. Only the category labels, the time-phasing cadence, and which cost group carries the most weight need to change. If your projects involve supplier or contractor costs heavy enough to need their own tracking layer, a dedicated procurement and supplier management template can sit alongside your main tracker rather than cramming every vendor transaction into one sheet.
Tips for improving accuracy in budget forecasting
Forecasting accuracy comes down to discipline in a few specific habits, more than any formula.
Update your estimate with actual data regularly rather than defaulting back to the original budget when questions come up. GAO’s cost-estimating guidance stresses continually revising the estimate and documenting why the forecast changed, which keeps your EAC grounded in reality instead of optimism.
Document your assumptions at the start, not after a variance shows up. Recording why a cost account was budgeted the way it was makes it possible to tell whether a variance reflects a real problem or a planning assumption that changed. Separate contingency from management reserve in your reporting, since blending them makes your remaining budget look larger than what you actually control, a distinction cost-management guidance on reserves treats as essential for accurate forecasting.
Finally, pair dollar-based schedule variance with a milestone or percent-complete check. PMI’s guidance on schedule variance warns that monetary SV can mask real delays in work that is not cost-intensive, so a project can look fine in dollar terms while slipping in actual progress.
Connecting your tracker to other project tools
An Excel tracker rarely lives in isolation for long. Most project managers eventually need it to talk to a scheduling tool, a procurement system, or company-level financial reporting.
The simplest integration point is the transaction table. If your project management software exports actuals as CSV, that export should map directly into your tracker’s transaction table, with categories standardized to match your existing cost accounts rather than reinvented each export. For projects pulling in operational data, like inventory draws or production costs, a dedicated ERP-style template can bridge that operational detail into your financial tracker without manual re-entry.
For organizations that need project budgets to roll up into broader company forecasting, the same PV/EV/AC data that feeds your project dashboard can feed a three-statement financial model at the company level. The key is keeping one transaction table as the source of truth and letting every other sheet, whether it is a project dashboard or a company model, pull from it rather than maintaining parallel copies that drift apart over time.
Visualizing your budget with charts and dashboards in Excel
Numbers in a table tell you what happened. A chart tells you what is happening, which matters more when you are trying to catch a problem early.
The standard earned-value chart is a line graph with cumulative PV, EV, and AC plotted against time on the same axes. When EV drops below PV, you are behind schedule. When AC climbs above EV, you are over budget. The gap between the lines is often more informative than any single number on the dashboard.
Beyond the core EVM line chart, a few additions make a tracker genuinely usable day to day: a stacked bar chart breaking planned versus actual spend by cost category for the current period, a simple gauge or colored indicator cell showing current CPI and SPI, and a trend line projecting EAC based on your current cost performance index. Build these from the cumulative rollup rows you already created with SUMIFS, not from raw transaction data, since charting raw transactions tends to produce noisy, hard-to-read visuals. If your dashboard needs to double as a reporting tool for stakeholders beyond the project team, a performance scorecard template offers a cleaner layout for presenting the same CPI and SPI figures outside the working tracker itself.

What a spreadsheet tracker can’t tell you on its own
The conventional advice on budget tracking treats Excel as a stopgap, something to use until a project “graduates” to dedicated project controls software. That framing gets it backward for most small and midsize teams. A well-built spreadsheet with correct earned-value logic will outperform an expensive platform that nobody on the team actually understands, because the formulas are visible and the team can see exactly how a number was derived.
What is genuinely overrated is chasing more automation before the underlying structure is sound. A tracker with a messy WBS and inconsistent cost codes will produce misleading CPI and SPI numbers no matter how many integrations you bolt on. What the reader should prioritize first is the boring part: a clean WBS, consistent cost-account coding, and a single transaction table as the source of truth. Get that right, and the formulas, charts, and alerts fall into place on their own. Skip it, and no amount of dashboard polish will fix numbers that were wrong at the source.
Get your tracker and the setup support that goes with it
The Inventory & Budget Tracker Excel template is available for project managers who want item-level cost rollups and a working dashboard without starting from a blank sheet. It is one of several Excel Templates offered for teams that want to stay in spreadsheets rather than adopt new software.
If your project needs a time-phased baseline with EAC logic built around your specific cost accounts, our Budget and Forecast Build service sets that up for you, with onboarding so your team knows exactly how every formula works. Download the tracker that fits your project now, or browse our shop to compare options before you commit.
FAQ
What should a project budget tracker in Excel include?
At minimum, include WBS or cost code, owner, original budget, approved changes, current approved budget, actual cost, committed cost, estimate to complete, estimate at completion, variance at completion, reporting period, and status. If you use earned value management, also include objective percent-complete rules plus PV, EV, AC, CPI, and SPI.
How do I calculate CPI and SPI in a budget tracker?
Cost Performance Index (CPI) is Earned Value divided by Actual Cost, and Schedule Performance Index (SPI) is Earned Value divided by Planned Value, as defined in PMI’s earned value framework. A result below 1.0 for either index signals you are over budget or behind schedule relative to plan.
What is EAC and how do I calculate it in Excel?
Estimate at Completion (EAC) forecasts total project cost, but the formula should match your assumption. Use BAC ÷ CPI when current cost efficiency is expected to continue; use AC + (BAC − EV) when past cost variance is considered non-recurring; or use a CPI × SPI approach when both cost and schedule efficiency are expected to affect the remaining work.
When should I upgrade from a ready-made template to professional help?
A ready-made template works well for projects with clear scope, manageable cost accounts, and straightforward reporting. Move to professional help when you need an expert-built baseline, formal EVM, committed-cost tracking, frequent change control, investor-ready forecasting, or a tracker that connects to company-level financial reporting. A Budget and Forecast Build or Custom Finance Project can then be built around the actual project structure.
Should I use cumulative or monthly data to monitor my budget?
Use both. Cumulative Planned Value, Earned Value, Actual Cost, CPI, and SPI show the stable overall trend, while monthly or weekly period metrics show whether recent performance is improving or deteriorating. The two views answer different questions.
About the author
Jonas Tyrone Lobaton is the founder of Frac CFO. He holds a Master’s degree in Quantitative Finance and the FMVA® certification, with work spanning financial modeling, forecasting, optimization, dashboards, business finance, and spreadsheet automation.
Sources
- Earned Value Management – Project Management Institute
- Managing Fixed-Price Projects with Earned Value Management – PMI
- Contingency and Management Reserve Guidance – PMI
- GAO Cost Estimating and Assessment Guide
- SUMIFS Function – Microsoft Support

3 Responses