top of page

This project budget template for Excel and Google Sheets shows what you have spent, what you have committed and what your project will cost by the end. It works as a live project budget tracker and project cost tracker, designed by a practising Senior Project Manager for project managers, project support and PMO teams.

Most project budgets record what has been spent but say nothing about where the project will finish, so overspend shows up late, when it is hardest to fix. This tracker is built to prevent that. You phase your budget by month, log every purchase order and invoice, and update a forecast for each cost line once a month. The workbook then works out the variance and status of every line, controls contingency through approved changes, and fills in the Dashboard, Monthly Spend and Budget Report for your sponsor and steering group.

What the workbook includes

  • Budget Plan: up to 40 cost lines, each phased across 12 months, with a check that the months add up to the budget.

  • Actuals Log: up to 300 purchase orders and invoices, recorded as Committed and then Paid.

  • Forecast: an Estimate to Complete, forecast at completion, variance and status for every cost line.

  • Contingency and Change Log: up to 50 changes, how each is funded and the contingency remaining.

  • Dashboard: headline figures, budget health, spend by category, the S-curve, top suppliers and the lines needing attention.

  • Monthly Spend and Budget Report: planned against actual spend by month, and a one-page report ready for your sponsor.

  • Start Here, Definitions and Guide, and Lists tabs, so every figure and status is explained.

What you receive: one zip file containing four files

  1. Setup Guide (PDF): how to set up, use and keep your budget live, with a 20-minute quick start.

  2. Project Budget Tracker, READY TO USE (Excel): your blank workbook.

  3. Project Budget Tracker, EXAMPLE (Excel): a fully worked project with 17 cost lines, 44 spend entries and 5 changes.

  4. BONUS, Controlling a Project Budget (PDF): a practitioner's guide to phasing, forecasting, contingency and reporting.

Compatibility

  • Microsoft Excel 2019 or later, including Microsoft 365, or Google Sheets.

  • No macros, add-ins or subscription.

  • Figures are shown in US dollars. The Setup Guide shows how to change the currency to pounds or any other currency.

This is a digital download and no physical item will be sent. If you have any questions about the files, please get in touch.

Project Budget Template | Excel and Google Sheets Budget Tracker

£9.99 Regular Price
£7.50Sale Price
VAT Included

Early Black Friday: 25% off

bottom of page