Specialist technology and software for state and local government info@hqt.orgCommunitiesGlossarySearch

Technology

Capital improvement program tracking from budget to capitalized asset

How multi-year CIP budgets, multiple funding sources, change orders, retention, and construction in progress fit together in one system.

A capital improvement program exists in several places at once. It is a multi-year plan adopted by the governing body, appropriations in one or more funds, a stack of contracts and pay applications held by public works, and a line on the financial statements called construction in progress. When each view lives in its own workbook, the numbers stop agreeing and staff spend their time reconciling rather than managing.

Two questions expose the gap. One comes from a department head: how much is left on this project, and whose money is it? The other comes from the auditor: why has construction in progress carried a balance for years on a building that opened long ago? Both are tracking problems before they are accounting problems, and both are answered by keeping the project, its funding, its contracts, and its assets under one identifier.

Where the project record starts

The project, not the fund or the contract, is the spine. A usable project record carries one identifier that finance, engineering, and the grant office all use, a phase structure that costs can be coded to, an owning department, and dates for authorization, substantial completion, acceptance, and closeout. Decide early whether a phase holds its own budget, and how the project maps to the assets it will produce, since one project often yields a building, site improvements, and equipment with different lives.

Multi-year budget against periodic appropriation

A CIP plan spans several years while appropriation authority often follows a shorter cycle, though many governments use project-length budgets for capital projects funds. Practice varies by state law and charter, so confirm your own rules with your finance officer and counsel. Whatever the model, show these together:

  • Project-to-date budget and spending. The life-of-project view the governing body and the public use.
  • Current appropriation and carryforward. The legal spending authority, including amounts re-appropriated from prior years.
  • Encumbrances. Open purchase orders and contract balances. A balance that ignores them overstates what is left.
  • Amendments. Each budget change, who approved it, and which source it hit.

Funding sources are the hard part

Most capital projects draw on more than one source: fund transfers, debt proceeds, impact fees, special district revenue, state grants, and federal awards. Each carries eligibility rules, a period in which the money must be obligated or spent, and its own reporting. Federal awards under the Uniform Guidance also bring procurement standards and property rules that outlive construction, and those requirements change, so work from the current text and your award.

Funding belongs in a ledger, not a field. Track each source's authorized amount, the draw order, the required match, and the amounts billed, received, and still available. Allocate cost across sources when the invoice is coded, not at year end from memory. Remaining balance by source then becomes a standing report rather than a research project.

Contracts, change orders, and retention

Capital spending is contract spending, so the contract register belongs in the same system: original value, executed change orders with approval date and reason, current value, payments to date, and remaining balance. Change orders kept only in the engineer's files never reach the encumbrance.

Retention needs separate handling. Amounts withheld from progress payments are payable later, not savings. Record them as a liability tied to the contract, age them, and release them against substantial completion and acceptance. Many states cap retainage, regulate escrow or securities substitution, and set timelines for release, so confirm your state's requirements before configuring defaults.

Construction in progress and capitalization

Construction in progress accumulates capitalizable cost for projects not yet placed in service, and it is generally not depreciated while it sits there. A stale balance is a common audit finding, and the cause is usually a process nobody triggered:

  • Define the event. Capitalization follows placement in service, not the final invoice, and substantial completion or beneficial occupancy normally starts depreciation.
  • Apply the policy consistently. Use your written capitalization threshold, and treat design, construction management, and similar costs the same way every time. Confirm the treatment of interest cost during construction with your auditor.
  • Split into assets. Allocate cost to land, buildings, infrastructure, and equipment, with useful lives and components tracked separately.
  • Carry the provenance forward. Funding source, award number, and acquisition date should follow the asset into the fixed asset ledger, since disposition rules may apply to grant-funded property for years.
  • Close the project. Release remaining encumbrances, return unspent restricted funds where required, and mark it closed.

What to ask vendors, and how to start

Ask for a demonstration on a project with three funding sources, a grant, an approved change order, and retention held. Watch the screens, not slides:

  • How is remaining balance by funding source calculated, and can a user override an allocation after posting?
  • How does a project move from construction in progress into one or more capital assets, and what entry does that produce?
  • What happens to a change order that is approved but not yet invoiced?
  • Which reports are standard, and how do project data and attachments leave the system?

In the contract, require conversion of open projects with their funding splits, encumbrances, retention balances, and construction in progress detail, and tie acceptance to a reconciliation with your general and asset ledgers rather than to a go-live date. Before any of that, list every open project, confirm who owns it, and write down the capitalization and closeout rules you mean to enforce. A new system carries those rules forward, and the gaps too.

HQT works with state and local agencies on financial and asset management systems, including capital project accounting and capitalization workflows.

Frequently asked questions

Why has our construction in progress balance not moved in years?

Almost always because no one owns the trigger that moves a finished project out of construction in progress. Capitalization should follow placement in service, usually substantial completion or beneficial occupancy, not the arrival of the last invoice. Run a standing report of projects with no recent cost activity or a completion date already past, and assign a named person to review it. Confirm your capitalization and depreciation timing with your auditor before changing practice.

How do we track one capital project funded by a grant, bond proceeds, and local money?

Treat funding as a ledger attached to the project rather than a single code on the transaction. Record each source's authorized amount, its spending rules, the draw order, any required local match, and amounts billed, received, and remaining. Allocate cost across sources at the time each invoice is coded so remaining balance by funding source is always current instead of being rebuilt at year end.

Should retention be tracked in the project system or in accounting?

In both, from one record. Retention withheld from a progress payment is a liability tied to the contract, so it belongs on the books, and it also has to be visible to the project manager who will release it at substantial completion and acceptance. Retainage limits, escrow or securities substitution, and release timelines are set by state law and sometimes by the funding source, so verify current requirements with your counsel before configuring system defaults.

What should a city ask vendors about capital project accounting before buying?

Ask for a live demonstration on a project that has several funding sources, a grant, an approved change order, and retention held, and watch the actual screens. Ask how remaining balance by funding source is calculated, how a project converts into one or more capital assets, what entry that produces, and how approved but uninvoiced change orders are reflected. Also ask what it takes to modify a standard report and how your data and attachments come out of the system.

What should we do before implementing a new CIP system?

Inventory what you have: every open project, who owns it, its funding splits, encumbrances, retention balances, and which projects are already in service but still sitting in construction in progress. Write down the capitalization threshold, closeout steps, and approval rules you intend to enforce. Then require in the contract that converted balances reconcile to your general ledger and fixed asset ledger, with acceptance tied to that reconciliation rather than a go-live date.

Get in touch

Have a project or a solicitation coming up?

Talk with an HQT engineer. We respond to agency, corporate, and partner inquiries promptly.