Project status report
One template, tailored editions for steering committee, client and delivery team
- Template
- DOCX
- Export as
- PDF, DOCX, ODT, HTML, PNG +25 more
- Carbone
- 5.18+
Generate project status reports from your PMO tool
A programme management office sends a status report to its steering committee every reporting period, weekly or monthly. The same facts also go to the client sponsor and to the delivery team, each with a different cut: the board decides on contingency and dates, the client follows acceptance and change requests, the delivery team tracks environments and defects. Your PPM tool, PMO data warehouse or delivery platform sends the programme data to the Carbone API as JSON with an audience field, and one DOCX template produces each edition as a PDF.
The report follows the structure of a PRINCE2 Highlight Report and the earned value measures of the PMI: overall and per-dimension RAG status with trend, milestones against baseline, budget at completion, actual cost, estimate at completion and variance, CPI and SPI, top risks and issues, decisions requested and next period priorities. The published PDF is the steering committee edition of Keystone, a fictional ERP consolidation run by Corvane Advisory for Norrvik Industrial Group.
In this example, you will:
- Show or remove whole sections and tables per audience with
:drop(p)and:drop(table) - Remove single table rows per audience with
:drop(row)and a two-variable condition - Color RAG statuses from the data with
:color - Compute totals, variances and performance indexes in the template
How to build a status report per audience
1. Lay out the report in Word
Set an A4 portrait page in Arial with a masthead table, a meta strip (client, report date, version, next steering committee) and the sections below, each with a heading and a borderless table with hairline rows. Add {d.programme.name}, {d.report.date:formatD('D MMM YYYY')} and the other substitution tags. The edition name in the masthead and in the footer is a switch-case condition:
{d.audience:ifEQ(STEERCO):show('Steering committee edition'):ifEQ(CLIENT):show('Client sponsor edition'):elseShow('Delivery team edition')}2. Repeat the rows of each table
Fill each table with a loop: {d.milestones[i].name} in the first row, {d.milestones[i+1]} in the second. The variance of each milestone is computed with the diffD formatter: {d.milestones[i].baseline:diffD(.forecast, days)}.
3. Show the RAG status in color
Each status cell holds a dot, a label and a tag that colors the paragraph with the :color formatter:
● {d.dimensions[i].status:ifEQ(G):show('On track'):ifEQ(A):show('At risk'):elseShow('Off track')}{d.dimensions[i].status:ifEQ(G):show(2F7A4E):ifEQ(A):show(A86200):ifEQ(R):show(B42318):elseShow(6B6F7B):color(p)}The overall status box uses :color(cell, background) to tint the whole cell.
4. Compute the financials
Keep only raw inputs in the JSON (budget, actual and estimate to complete per cost category) and compute the rest with the aggregators and math formatters:
- EAC per row:
{d.costs[i].ac:add(.etc):formatN(0)} - Variance per row:
{d.costs[i].bac:sub(.ac):sub(.etc):formatN(0)} - Totals:
{d.costs[].bac:aggSum:formatN(0)}and{d.costs[].ac:add(.etc):aggSum:formatN(0)} - CPI:
{d.evm.ev:div(d.evm.ac):formatN(2)}
5. Show or hide sections per audience
Remove whole parts of the report with the smart conditions. Each tag sits in a paragraph or cell that already holds text, so nothing leaves an empty line:
- In the heading of the financials:
{d.audience:ifEQ(DELIVERY):drop(p)}, and in a header cell of each financial table:{d.audience:ifEQ(DELIVERY):drop(table)} - The decisions requested appear only in the steering committee edition:
{d.audience:ifNE(STEERCO):drop(p)}and{d.audience:ifNE(STEERCO):drop(table)} - Acceptance and change requests are removed for the delivery team, the delivery readiness section (environments, cutover criteria, defects) for the client:
{d.audience:ifEQ(CLIENT):drop(table)}
6. Filter rows per audience
A row can depend on two values with the and operator. The internal risks of the delivery firm are removed from the client edition:
{d.raid[i].internal:ifEQ(true):and(d.audience):ifEQ(CLIENT):drop(row)}The distribution list keeps only the readers of the current edition with ifNIN: {d.distribution[i].editions:ifNIN(d.audience):drop(row)}.
Send the same JSON with "audience": "STEERCO", "CLIENT" or "DELIVERY" to get the three editions from one template.
Related Examples
Check out these similar templates to learn more:
Trusted by 800+ paid customers in 40+ countries














