Skip to content
Project Budget Tracker cover: a sample sheet with planned budget, spent to date and remaining and a bar chart, beside the Summary, Budget and Payments tabs

Project Budget Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

The Project Budget Tracker suits project managers, consultants and team leads who must keep spending within an agreed plan. On the Budget tab, every cost line shows with its category, planned amount, spent to date, amount left and percentage used. The Payments tab is the single log of money paid, with the date, cost line, category and payee. The Summary tab shows planned and spent totals, the share of budget used and a category breakdown with a chart.

The sample project runs for twelve weeks and includes staff, contractor, software, travel and materials costs, with the contingency line still unused. Keep cost line names exactly the same on both tabs, because each payment finds its line by name. Review the Summary before each steering meeting. When a line needs more money, change its planned amount and add a note explaining why, so the history stays visible.

Useful for

  • Tracking spend against an approved project budget
  • Showing a sponsor what has been spent by category
  • Watching which cost lines are close to their limit

What's included

  • 4 tabs: Summary, Budget, Payments, How to use
  • Summary: a dashboard with 4 summary figures
  • Budget: a table
  • Payments: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Budget tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Why is a cost line showing red?

A row turns red on the Budget tab when the amount spent is greater than the planned amount, and its Left figure goes negative. Look through the Payments tab for entries on that line, or raise the plan and leave a note explaining why.

Can one workbook cover several projects?

Keep one project per file. Each Summary total counts every row on its tabs, so two projects in one set of tabs would be added together. Duplicate the workbook for each project and rename it.

Should I log payments made before I set up the file?

Yes, if you want the Spent column to be complete. Add each past payment to the Payments tab along with its date and cost line, and the totals will match your records.

  • #project-tracker
  • #project-budget-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More project tracker templates

See all 8

Also in Project management

All project management templates
Get this template

Preparing your template…