Excel-Based Capital Project Cost Tracker

I need an Excel-based Project Cost Tracking Workbook rebuilt from a template so that it functions like a real project controls tool. The current file is based on a personal-budget template, and I need it converted into a proper capital project tracker with AFE logic, PO commitments, actuals, contingency, and monthly performance views.

What the final workbook must do:

1. AFE-Based Budgeting

Allow me to enter a single AFE (Approved Funding Estimate) for the project.

This AFE becomes the master budget and feeds all months.

PAFE (pre-approval funding) should be separate and informational only.

2. Categories & Budget Allocation

I need to allocate the AFE into cost categories (labor, materials, subcontract, equipment, freight, other, TCDaily, contingency).

These budgets must automatically feed every monthly sheet.

3. PO Commitments (Hard Costs)

Include a PO table where I can enter PO number, vendor, category, PO value, invoiced to date, and remaining value.

Remaining commitment should automatically deduct from available AFE and appear in each month’s “Commitments” column.

Annual dashboard should show total and remaining PO commitments.

4. Actual Cost Tracking

ALL actuals must come from a Transaction Log (Date, Category, Subcategory, Amount, Description).

Monthly sheets pull their actuals from this log automatically.

5. Accruals

Ability to record accruals for each month.

Accruals count as actuals for that period and reduce remaining AFE.

6. Contingency & Unplanned Cost

Contingency is part of AFE but its own budget pool.

I need an Unplanned Cost section that burns contingency when unexpected costs occur.

Using contingency should adjust remaining AFE and remaining contingency separately.

7. Monthly Tabs (Jan–Dec)
Each month should:

Pull budget from the Categories tab

Show Actuals, Commitments, Accruals, Forecast, and Left-to-Spend

Update remaining AFE dynamically

Include charts (Budget vs Actual, Spend Breakdown, Cumulative Spend)

8. Annual Dashboard
Should summarize:

Total AFE

YTD actuals

Remaining AFE

PO commitments remaining

Contingency used

EAC (Estimate at Completion)

Variance to AFE

Monthly spend trend

Category breakdown

9. Core Logic

AFE should not change month to month

Remaining AFE recalculates continuously:

AFE – (YTD Actuals + Remaining Commitments + Accruals + Remaining Forecast)


Category budgets are fixed and compared to YTD totals

Transaction Log drives all actuals across the workbook

Goal
I want a clean, reliable Excel workbook that works like a real project budgeting tool used in industrial or capital project environments—accurate, automated, and easy to updat