Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesProject & Task ManagementProject PlanningProject Portfolio Dashboard

SpreadsheetProject PlanningFree

Project Portfolio Dashboard

Every project’s budget, spend, progress and RAG status in one place, rolled up by programme.

Shown with sample data

Colour

Project Portfolio Dashboard

Every project’s budget, spend, progress and RAG status in one place, rolled up by programme.

Portfolio budget
$3,305,000
Spent to date
$2,027,500
Portfolio CPI
1
Earned value ÷ actual cost; below 1.00 = over budget
Red projects
2
Amber projects
4
Green or complete
30%
Budget by programme
  • Digital$1,160,000
  • Operations$910,000
  • Customer$820,000
  • Compliance$415,000
Budget vs earned value by project
  • ERP finance upgrade$536,800
  • Data centre exit to cloud$522,500
  • CRM migration$302,400
  • Warehouse scanning rollout$180,000
  • Mobile app version 3$147,000
  • Identity and access management$136,000
  • Customer self-service portal$78,000
  • Fleet telematics$74,400

How to use it

  1. 1Set the status date and RAG thresholds on the Settings sheet.
  2. 2Add each project with its programme, project manager, start and finish dates and approved budget.
  3. 3Each reporting period, update Actual to date from finance and % complete from the project manager.
  4. 4Review red and amber projects first, then the By programme roll-up.
  5. 5Copy the sheet at each period end to keep a history.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

One view of every project for the portfolio review. Enter each project’s dates, budget, spend to date and percent complete; the dashboard works out where it should be by the status date, the schedule and cost variance, and a RAG status from thresholds you set, then rolls budget, earned value and red projects up by programme.

Who it’s for

  • Monthly portfolio and steering-committee reviews
  • PMOs moving off slide-deck status reporting
  • Spotting which projects need executive attention
  • Comparing programmes on cost performance

What’s included

  • Projects sheet: One row per project, measured at the status date on the Settings sheet.
  • By programme sheet: Budget, spend, earned value and RAG rolled up for each programme.
  • Settings sheet: Status date and RAG thresholds.

How to use it

  1. 1Set the status date and RAG thresholds on the Settings sheet.
  2. 2Add each project with its programme, project manager, start and finish dates and approved budget.
  3. 3Each reporting period, update Actual to date from finance and % complete from the project manager.
  4. 4Review red and amber projects first, then the By programme roll-up.
  5. 5Copy the sheet at each period end to keep a history.

Tips

  • Agree a definition of % complete across the portfolio, for example the share of the budgeted work actually finished (earned value), not time elapsed or money spent.
  • A project can be green on cost and red on schedule. The RAG takes the worse of the two, so read both variance columns before acting.
  • Keep thresholds stable for a year. Changing them to turn projects green defeats the purpose.

Questions

How is the RAG status calculated?

Red if schedule or cost variance is worse than the red threshold (15% by default), amber if worse than the amber threshold (5%), otherwise green. Projects at 100% show Complete and projects not yet due to start show Not started.

What is planned % complete?

The share of the project’s duration that has passed by the status date. It assumes even progress, which is a reasonable first check; replace it with baseline figures from your schedule for more precision.

What is the difference between a portfolio and a programme?

A programme is a group of related projects managed together towards a shared outcome. A portfolio is everything the organisation is investing in, across programmes, managed to fit strategy and capacity.

Related searchesproject portfolio dashboardportfolio management templatepmo dashboardmultiple project trackerrag status reportprogramme dashboard

Details

Format
Spreadsheet
Category
Project Planning
Sheets
3
Setup
25 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetProject PlanningFree

Project Portfolio Dashboard

Every project’s budget, spend, progress and RAG status in one place, rolled up by programme.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Project Planning
Sheets
3
Setup
25 min
Level
Intermediate
Price
Free

Your copy is private to you.

More project planning templates

View all
Project Plan with Gantt Timeline
Task
W1W2W3W4W5W6W7W8W9W10
Kick-off and charter sign-off
Stakeholder interviews
Requirements document
Budget and resource plan
Plan approved
Wireframes
SpreadsheetProject Planning

Project Plan with Gantt Timeline

A real Gantt chart: tasks by phase with dates, owners, dependencies, progress bars across 16 weeks and schedule status.

10 min setupPreview
Project Tracker
Task
OctNov
Customer survey launched
Pricing page copy
Partner contract signed
Onboarding email sequence
Analytics dashboard
Sales training deck
SpreadsheetProject Planning

Project Tracker

Deliverables with owner, priority, dates, progress, health and a workload view by person.

10 min setupPreview
Work Breakdown Structure (WBS)2 sheets

Work packages

9

Total effort (hours)

386

Total cost

$42,040

ABCD
1WBS codeStageDeliverableWork package
21.11 DiscoveryRequirementsStakeholder interviews
31.21 DiscoveryRequirementsRequirements document and sign-off
42.12 DesignExperience designUser flows and wireframes
52.22 DesignVisual designDesign system and page designs
WBS
SpreadsheetProject Planning

Work Breakdown Structure (WBS)

Break a project into phases, deliverables and work packages with effort, cost and owner rolled up by phase.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ