How to Track Project Budget in Excel (Free Template)

Four project budget numbers to understand

Use the same definitions throughout your sheet. In particular, decide whether your actual-cost column records costs as they are incurred or only after an invoice is paid, and apply that choice consistently.

Planned budget

The planned budget is the amount you expect or approve for the project or an expense category. It is your comparison point—not a record of what has already been spent.

Actual spending

Actual spending is the cost recorded so far. Enter known actual costs and leave an amount blank until you have a figure; do not enter zero just to fill an empty cell, because zero can look like confirmed no spending.

Remaining budget

Remaining budget is planned budget minus actual spending. A positive result is the amount left against the plan; a negative result means actual spending has gone beyond the planned amount.

Budget variance

In this guide and the NextRise tracker, variance means planned cost minus actual cost. Positive variance means under budget; negative variance means over budget. Some tools use the opposite sign convention, so label the meaning wherever you show a variance.

Worked example: a project budget in AED

Imagine a small project with four cost areas. For each row, variance is planned minus actual. The figures below are an illustrative example, not financial advice.

The planned total is AED 1,200 + AED 500 + AED 800 + AED 300 = AED 2,800. Actual spending is AED 1,100 + AED 560 + AED 650 + AED 360 = AED 2,670. The project therefore has AED 2,800 − AED 2,670 = AED 130 remaining, and its total variance is also AED 130 under budget.

Notice that Software and Travel each have negative variance (AED 60 over plan), while the savings in Design and Marketing more than offset those overruns. A positive total does not mean every category is under budget—review both the overall number and the individual rows.

Set up a simple Excel expense table

Start with one expense per row. Include the columns you need to explain or act on each cost:

• Category and Item / Description identify the cost.
• Planned Cost and Actual Cost hold the comparable amounts.
• Variance calculates the difference.
• Due Date, Status, and Notes help you follow up.

In the NextRise workbook, the header row is row 5 and example expense entries begin on row 6. The columns are A: Category, B: Item / Description, C: Planned Cost, D: Actual Cost, E: Variance, F: Due Date, G: Status, and H: Notes.

Calculate variance for each expense row

In cell E6, the workbook uses:

=IF(OR(C6="",D6=""),"",C6-D6)

C6 is the planned amount and D6 is the actual amount. The formula leaves variance blank if either input is missing; otherwise it subtracts actual from planned. Copy the pattern down the Variance column when building your own sheet. In an Excel Table, entering the formula in the first data row can fill the column automatically.

Summarise the project

If your own expense table uses columns C, D, and E with data rows 6 through 9, these basic formulas calculate the example totals:

Planned total:   =SUM(C6:C9)       → AED 2,800
Actual total:    =SUM(D6:D9)       → AED 2,670
Remaining:       =SUM(C6:C9)-SUM(D6:D9) → AED 130
Total variance:  =SUM(C6:C9)-SUM(D6:D9) → AED 130

The workbook uses a formatted Excel Table named ExpenseTable, so its Budget Overview can instead use structured references that expand with the table:

Planned total (Budget Overview!A6):
=SUM(ExpenseTable[Planned Cost])

Actual total (Budget Overview!C6):
=SUM(ExpenseTable[Actual Cost])

Remaining budget (Budget Overview!E6):
=A6-C6

Budget variance (Budget Overview!G6):
=A6-C6

Remaining budget and budget variance have different labels and explanations, but the tracker intentionally calculates both as planned total minus actual total. The workbook also calculates spend versus budget in F9 with =IFERROR(C6/A6,0); this is the actual total divided by the planned total, with zero returned if the planned total is zero.

A simple weekly budget-tracking workflow

1. List project costs. Group related expenses and write one clearly described item per row.
2. Set a planned amount. Record your expected cost before spending so there is a useful baseline.
3. Update actuals consistently. Add confirmed costs on a regular schedule and keep supporting notes where useful.
4. Review differences. Check negative row variances for overruns and positive ones for savings. Look at both category-level and total figures.
5. Choose a next action. If a cost is over plan, confirm the amount, update your forecast if appropriate, and decide whether the project plan needs attention.

A spreadsheet is only as current as its inputs. Agree who updates it, what “actual” means for your project, and how often you review it. Keep original estimates or change notes if you need an audit trail; the template is a practical tracker, not an accounting system.

How to use the free NextRise template

The Project Budget Tracker detail page explains the included sheets and offers the Excel workbook and a CSV download. The Excel file has Budget Overview, Expense Tracker, and Instructions sheets. Its expense table includes filters and dropdowns for Category and Status, formulas for variance, and a category breakdown on the dashboard.

1. Download and open the Excel workbook. Read the Instructions sheet before replacing example rows.
2. In Expense Tracker, edit the blue input cells and enter your own category, description, planned cost, actual cost, due date, status, and notes.
3. Leave Actual Cost blank until you know the amount. Enter new expenses in blank rows inside the existing table so its filters and formulas can include them.
4. Review Budget Overview for planned budget, actual spending, remaining budget, budget variance, spend versus budget, and the category comparison chart.
5. The default number format is AED. If your project uses another currency, follow the Instructions sheet to change the number format on the amount cells.

The CSV is a simpler, portable data format; it does not preserve the workbook’s dashboard, formulas, dropdowns, or table styling.

More practical resources

Explore the full collection of free productivity templates, or visit the AI workflow guides for ideas on turning recurring work into clearer prompts. Always verify project figures before sharing or acting on generated content.

For another spreadsheet habit, read the other NextRise blog notes on making spreadsheets easier to review and maintain.