We analyzed 20,582 strategic plans. Get a copy of the full report.
Free tool ·
Local Government
A working tracker for every capital project — owner, phase, target, last update. Edit the 18 example rows or start from yours. Free to use in the browser; email only if you want to export it.
Free to use. No account. Email only to export.
Example register — City of Metropolis (illustrative). 18 capital projects, 9 columns. As of September 2026: 5 rows carry no owner, 3 are past their target and still open, and 8 have not been updated in 90 days. The seven phases the tool ships with: Planning · Scoping · Design · Bid & award · Construction · Closeout · Complete.
| Project | Asset class | Owner | Phase | Start | Target | Last update | Status | Budget (yours) |
|---|---|---|---|---|---|---|---|---|
| Elm Street Bridge Rehabilitation | Roads & transportation | Clarice Strong | Construction | 2025-03-04 | 2027-06-30 | 2026-08-18 | ↑ On Target | $4,200,000 |
| Water Main Replacement — District 4 | Water, sewer, utilities | Maggie Sawyer | Bid & award | 2025-01-13 | 2027-02-27 | 2026-06-02 | ↕ Caution | $1,850,000 |
| Fire Station 12 Roof Replacement | Buildings & facilities | — | Scoping | 2025-04-01 | 2026-05-15 | 2026-01-09 | ↓ Below Plan | $610,000 |
| Riverside Park Playground Rebuild | Parks & recreation | Lance Cummins | Design | 2025-02-18 | 2027-08-14 | 2026-08-26 | ↑ On Target | $920,000 |
| Downtown Signal Timing Upgrade | Roads & transportation | Jimmy Olspon | Construction | 2025-06-02 | 2027-03-31 | 2026-03-03 | ↕ Caution | $780,000 |
| Municipal Court HVAC Replacement | Buildings & facilities | — | Planning | 2025-05-12 | 2027-12-18 | 2026-02-21 | — Not Defined | $475,000 |
| Lift Station 7 Rehabilitation | Water, sewer, utilities | Ron Troupe | Closeout | 2024-09-08 | 2026-07-30 | 2026-08-15 | ↓ Below Plan | $2,300,000 |
| Greenway Trail Extension Phase 2 | Parks & recreation | Clarice Strong | Bid & award | 2025-07-21 | 2027-09-30 | 2026-04-27 | ↕ Caution | $1,140,000 |
| Library Branch Accessibility Retrofit | Buildings & facilities | Maggie Sawyer | Design | 2025-08-04 | 2027-05-29 | 2026-08-30 | ↑ On Target | $690,000 |
| Stormwater Culvert — Oak Avenue | Water, sewer, utilities | — | Scoping | 2025-10-06 | 2027-11-13 | 2026-05-14 | — Not Defined | $1,020,000 |
| Airport Road Resurfacing (Mile 2–5) | Roads & transportation | Jimmy Olspon | Construction | 2025-04-14 | 2026-11-20 | 2026-08-29 | ↑ On Target | $3,350,000 |
| Public Works Fleet Garage Expansion | Buildings & facilities | Lance Cummins | Planning | 2025-11-03 | 2028-03-31 | 2026-01-30 | ↕ Caution | $5,600,000 |
| Riverwalk Lighting Replacement | Parks & recreation | — | Design | 2025-09-15 | 2027-04-30 | 2026-08-12 | ↑ On Target | $310,000 |
| Sanitary Sewer Lining — Zone B | Water, sewer, utilities | Ron Troupe | Construction | 2025-02-03 | 2027-01-15 | 2026-07-22 | ↑ On Target | $1,480,000 |
| Pedestrian Bridge — Union Station | Roads & transportation | Clarice Strong | Scoping | 2026-01-12 | 2028-06-30 | 2026-08-05 | — Not Defined | $2,900,000 |
| Senior Center Kitchen Renovation | Buildings & facilities | Maggie Sawyer | Closeout | 2024-11-18 | 2026-08-31 | 2026-08-20 | ↕ Caution | $540,000 |
| Community Pool Filtration Upgrade | Parks & recreation | — | Bid & award | 2025-12-01 | 2027-06-15 | 2026-05-08 | ↕ Caution | $430,000 |
| Citywide Traffic Camera Network | Other capital projects | Jimmy Olspon | Planning | 2026-02-09 | 2028-01-31 | 2026-08-27 | ↑ On Target | $1,750,000 |
Reuse freely with attribution. Canonical source: https://www.clearpointstrategy.com/free-tools/capital-project-tracker
.svg){kind=icon}
| Project | Asset class | Owner | Phase | Start | Target | Last update | Status | Budget (yours) |
|---|---|---|---|---|---|---|---|---|
| | | | | | | | | |
| | | | | | | | | |
| | | | | | | | | |
Source: ClearPoint Strategy — https://www.clearpointstrategy.com/free-tools/capital-project-trackerReuse freely with attribution. Canonical source: https://www.clearpointstrategy.com/free-tools/capital-project-tracker
| Project | Asset class | Owner | Phase | Start | Target | Last update | Status | Budget (yours) |
|---|---|---|---|---|---|---|---|---|
| | | | | | | | | |
| | | | | | | | | |
| | | | | | | | | |
Source: ClearPoint Strategy — https://www.clearpointstrategy.com/free-tools/capital-project-trackerReuse freely with attribution. Canonical source: https://www.clearpointstrategy.com/free-tools/capital-project-tracker
| Project | Asset class | Owner | Phase | Start | Target | Last update | Status | Budget (yours) |
|---|---|---|---|---|---|---|---|---|
| | | | | | | | | |
| | | | | | | | | |
| | | | | | | | | |
Source: ClearPoint Strategy — https://www.clearpointstrategy.com/free-tools/capital-project-trackerReuse freely with attribution. Canonical source: https://www.clearpointstrategy.com/free-tools/capital-project-tracker
| Project | Asset class | Owner | Phase | Start | Target | Last update | Status | Budget (yours) |
|---|---|---|---|---|---|---|---|---|
| | | | | | | | | |
| | | | | | | | | |
| | | | | | | | | |
Source: ClearPoint Strategy — https://www.clearpointstrategy.com/free-tools/capital-project-trackerReuse freely with attribution. Canonical source: https://www.clearpointstrategy.com/free-tools/capital-project-tracker
| Project | Asset class | Owner | Phase | Start | Target | Last update | Status | Budget (yours) |
|---|---|---|---|---|---|---|---|---|
| | | | | | | | | |
| | | | | | | | | |
| | | | | | | | | |
Source: ClearPoint Strategy — https://www.clearpointstrategy.com/free-tools/capital-project-trackerReuse freely with attribution. Canonical source: https://www.clearpointstrategy.com/free-tools/capital-project-tracker
| Project | Asset class | Owner | Phase | Start | Target | Last update | Status | Budget (yours) |
|---|---|---|---|---|---|---|---|---|
| | | | | | | | | |
| | | | | | | | | |
| | | | | | | | | |
Source: ClearPoint Strategy — https://www.clearpointstrategy.com/free-tools/capital-project-trackerWe’ll email a CSV of your register and a one-page council summary. After that, occasional examples from teams doing this work. Unsubscribe in one click.
Nothing is saved on our side until you export.
On its way to your inbox
That’s the pattern we see break first. In a 30-minute session we show how a city like yours puts a name on every line and keeps it updated — on your real projects, not ours.
80.5%
of capital projects had no recorded update in 90+ days · n = 3,026 · Jan 2026
7 of 3,026
capital projects record a phase anywhere · Jan 2026
58.0%
of named owners logged nothing in 2025 · n = 1,431 owned projects
83.0%
of past-due capital projects are still open · Jan 2026
ClearPoint platform data · 93 local governments · January 2026 snapshot
A capital project tracker is a register of every capital project a city or county has funded — with an owner, a phase, a target date, a last-update date and the budget — kept current between council meetings. In the ClearPoint data, 80.5% of capital projects went 90 days without an update and 83.0% of past-due projects are still open (93 local governments, January 2026).
Case studies
Published ClearPoint customer stories, matched to this tool.
Local government · fewer than 500 employees
In 2017 the city tracked results without a full strategy or council buy-in, and reporting was limited to annual council retreats.
A new city manager aligned department goals and metrics to the mayor and council's goals. Department heads own their measures and rank their capital projects by priority in ClearPoint.
A $411 million capital plan in one dashboard
The 10-year CIP shows fund use from planning and design to construction, with its funding sources, and department heads benchmark against 14 other North Carolina municipalities.
Utilities · electric cooperative
Before 2014 each department tracked goals differently and reporting was sporadic. By 2017, Excel reports existed in several versions as different people updated them.
In Q1 2017, strategic goal data moved into departmental, divisional and corporate scorecards. From 2018, projects were tracked next to KPIs, including approved staff ideas that become linked projects with an accountable manager.
SWOT participation from 85% to 98%
Division heads get a short exported snapshot of progress, and the first three-year strategic plan aligns department projects to corporate strategy.
Banking · 1 million+ customers
The bank had no cohesive strategic plan. Data arrived in silos, collection was poorly defined, and leaders did not trust it enough to make decisions.
A formal plan defined strategic objectives and the projects behind them. ClearPoint holds goals, project data and status, and rolls project progress up to objectives automatically.
Meetings focused on the projects that move the plan
Leadership sees which projects affect the plan and spends meeting time on those, and year-over-year visibility shows where recurring issues need fixing.
Why capital projects go quiet
Because the register lives in a spreadsheet that is rebuilt for the council packet and nowhere in between. Across 93 local governments on the ClearPoint platform, 80.5% of capital projects went 90 days without an update; of projects past their target date, 83.0% were still open; and an owned project was 2.2× more likely to get updated than an unowned one (January 2026).
Seven of 3,026 capital projects carried a phase. The rest were a name and a dollar figure.
A CIP spreadsheet template gives you columns; the tracker counts what is missing — no owner, past target, no update in 90 days — while you type, and exports a council summary with those counts on it.
| CIP spreadsheet template | This tool | |
|---|---|---|
| Owner, phase, target, last update | Columns you add | Built in, counted |
| Stale-project flag | Manual | Automatic at 90 days |
| Council one-pager | Build it yourself | Printable, generated |
| Budget on unowned projects | Not shown | In the summary |
| Email required | To download | Only to export |
Planning, scoping, design, bid and award, construction, closeout, complete — seven, not five. Without “Complete” you cannot compute what share of projects ever finish; without a way to close a dead project it keeps counting as late.
Customer stories on this page
City of Goldsboro · Cobb EMC · Banco de la Provincia de Córdoba
Yes. Build, edit and read everything without an account. Email is only asked when you export.
A CSV of your register and a one-page council summary with your counts.
ClearPoint platform data: 3,026 capital projects across 93 local governments, January 2026 snapshot. Method below.
Yes. The Budget column is yours; we don’t hold or benchmark dollar amounts.
In our data, 7 of 3,026 capital projects recorded a phase anywhere. The tool ships with seven so yours does.
Nothing automatic. If you want to see how a city keeps this register live, book a demo.
Method
93 local governments on the ClearPoint platform with capital projects, January 2026 snapshot; 3,026 projects. Staleness = no update in 90 days; past-due = target date passed and project not marked complete or closed.
The example register is the fictional City of Metropolis. The 2.2× owner effect is a correlation: owned projects are more likely to be updated, not more likely to succeed.