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.
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).
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. Nothing else, unless you ask.
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.
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.
Trusted by the teams whose plans are public
“Every capital project now has a name and a phase next to it. Council asks what moved, and we answer in the meeting instead of the week after.”[Cleared client quote — same vertical only] — name, title, organization
City of Fort Lauderdale · Durham County · City of Coral Springs · City of Goldsboro · JEA
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.
All answers ship as text in the DOM — the accordion only hides them visually.
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.
Webinar · Sept 24 · One City, One Plan (Springfield, MO)
Save my seatThirty minutes, your projects, a live tracker you keep.
Book a 30-min demo