Troy runs Information Technology as an internal service fund, so 21 years of audited financial reports show its full cost as a single line of business — and the city's Adopted Budgets show what that money actually runs. Here is what the numbers say, FY2004 through FY2026.
Sources: 21 City of Troy Annual Comprehensive Financial Reports (ACFRs, FY2005–FY2025) and 18 Adopted Budget documents (FY2006–FY2026) with an IT-division Performance Indicators table. Every figure is reproducible from the scripts in the cot-it repository.
· · ·
1. IT runs as an internal service fund
Troy does not bury IT inside the general fund. It runs as an internal service fund (ISF): a self-contained business that bills every other city department for the technology services it provides. That structure is why 21 years of ACFRs each carry IT as its own set of financial statements — and why "what does Troy spend on IT?" has a clean answer.
The measure used here is the total operating expenses of the IT internal service fund — personnel, supplies, and other service charges, plus depreciation. It excludes capital-asset purchases, which flow through the fund's balance sheet rather than its operating statement (those are covered in Section 3).
IT internal service fund: operating expenses vs. operating revenues, FY2005–FY2025
Operating expenses (what it costs to run IT) against operating revenues (what the fund bills other departments). From FY2017 onward the fund consistently bills slightly more than it spends — a deliberate, modest surplus that rebuilds fund balance.
Source: City of Troy ACFRs FY2005–FY2025, Internal Service Funds combining statement (IT column). Extracted by extract_it_spend.py; series in it_spend.csv.
+78%
Growth in IT operating expenses, FY2005 → FY2025 (~2.9%/yr)
$2.68M
FY2025 IT operating expenses — the most recent audited year
$1.35M
FY2010 low point, after the 2008 financial crisis
~9.7
Full-time-equivalent IT staff — roughly flat across the whole period
Over the full span IT spending grew a little faster than inflation — the US CPI rose about 67% across FY2005–FY2025 against IT's 78% — but not dramatically so. The real change is not in the dollar total; it is in what those dollars now have to cover.
Sources & full data — IT operating spend
City of Troy Annual Comprehensive Financial Reports, FY2005–FY2025 (21 documents). The figure used is the IT internal service fund's total operating expenses from each ACFR's Internal Service Funds revenues/expenses combining statement. FY2011's ACFR is a scanned PDF and was OCR'd before extraction.
extract_it_spend.py prints every figure with its source row.
Fiscal-year convention: FY2005 = fiscal year 2004/05, ending June 30, 2005.
Fiscal year
Operating expenses
YoY
Operating revenues
· · ·
2. What IT maintains — devices and applications
Every Adopted Budget's IT section carries a Performance Indicators table: how many personal computers, printers, servers, and software applications the department keeps running. The tables overlap two-to-four years between budgets, so most years are cross-checked against several documents. Stitched together, 18 budgets cover FY2004–FY2026.
Devices and applications the IT department supports, FY2004–FY2026
Personal computers are essentially flat for 22 years. Applications supported more than doubled. Printers and servers were first reported in the FY2014 budget — the printer jump in FY2020–FY2022 is a counting-scope change (label printers "not all previously counted"), not new hardware.
Source: City of Troy Adopted Budgets, IT-division Performance Indicators tables. Extracted by extract_it_assets.py; series in it_assets.csv.
Servers supported in FY2026, up ~40% from the first count in FY2011
~2,000
Annual computer help-desk requests — down from a FY2018 peak near 3,700
The same ~9–10-person team runs 2.4× as many applications as it did in 2004 — on a device fleet that has barely grown.
That is the core finding of the budget data. A city's IT department is not judged by how many PCs it owns — that number tracks headcount, and Troy's is stable. It is judged by the surface area it has to keep running: financial systems, permitting, assessing, GIS, the public website, email, telecom, and dozens of line-of-business applications. That surface area has more than doubled while staffing held flat.
Sources & full data — assets and applications
City of Troy Adopted Budgets with an IT Performance Indicators table (18 documents, budget years FY2006–FY2026). Each table reports ~4 fiscal years (two Actual columns, one Projected, one Budget); the extractor resolves each year to the best available value — Actual over Projected over Budget, newest budget winning ties.
Gaps and quirks. The FY2011 budget is a 50-page abridged document and the FY2012–FY2013 budgets dropped the Performance Indicators table — so FY2011–FY2013 device counts come only from neighboring budgets. The FY2022 budget's IT pages use a non-extractable encoded font; they were OCR'd into Budget_FY2022_IT_ocr.pdf. "Applications supported" was re-baselined at least twice (the ~137→154 step at FY2017 is a reclassification); printers were re-scoped to include label printers in FY2020–FY2022. Values are shown as published.
FY
Applications
PCs
Printers
Servers
Help-desk requests
· · ·
3. What IT spends on assets
"IT asset spend" has two parts in the budgets, and they behave very differently. Capital — new servers, major software, infrastructure — is the adopted IT capital budget, and it is lumpy: it spikes when a big project lands and falls back otherwise. Equipment maintenance is the running cost of keeping the existing fleet alive, and it is comparatively steady.
IT capital budget vs. equipment maintenance, FY2004–FY2026
Bars are the adopted IT capital budget (left axis); the line is equipment maintenance cost (right axis — note the different scale). Black dots mark the few years the internal service fund actually booked capital outlay in its own statements — most years it shows $0 because IT capital was historically funded by transfers from the Capital Projects Fund.
Source: City of Troy Adopted Budgets — adopted IT capital budget and Performance-Indicators equipment-maintenance line; ISF capital actuals from the IT fund statements. Series in it_assets.csv.
~$190K
Average adopted IT capital budget per year, FY2008–FY2026
$749K
FY2008 capital budget — the largest, for a financial-system replacement
$6K–$43K
Annual equipment-maintenance range — the steady cost of fleet upkeep
5 of 23
Years the ISF booked non-zero capital in its own statements — the rest ran through the Capital Projects Fund
The accounting here is genuinely subtle, and worth stating plainly: the adopted capital budget is the consistent, comparable series — but in most years the IT fund's own statements show $0 of capital actually booked, because historically the city funded IT capital through operating transfers from its Capital Projects Fund rather than through the ISF's capital line. Only five years (FY2007, FY2008, FY2017, FY2023, FY2024) show non-zero ISF capital actuals. The bars below are therefore "what the city planned to invest," and should be read as such.
Sources & full data — asset spend
Adopted IT capital budget — taken from each budget's own budget-year column (the "Proposed"/"Final"/budget figure). It is the most consistently reported capital measure across all 18 budgets.
ISF capital actuals — the IT internal service fund's "Capital Outlay" / "Capital Expenditures" line, which is $0 in most years; the non-zero years are in the isf_capital_actual column of it_assets.csv.
Equipment maintenance — the Performance-Indicators "Equipment Maintenance Costs" line, an operating (not capital) figure: the cost of maintaining the existing device fleet.
FY
IT capital budget (adopted)
ISF capital actually booked
Equipment maintenance
· · ·
4. Method & caveats
This is a working analytical record, not an audit. Everything is reproducible from the cot-it repository — the source PDFs, the extraction scripts, and the resulting CSVs are all there.
How the numbers were pulled
Two pdfplumber-based extractors do the work. extract_it_spend.py finds the Internal Service Funds combining statement in each ACFR and pulls the IT column's operating expenses and revenues. extract_it_assets.py encodes every Performance-Indicators cell read from the budgets — each tagged with its source budget and column type — then resolves each fiscal year to a single best value (Actual beats Projected beats Budget; the newest budget wins ties) and prints the full provenance.
What to be careful about
"IT spend" is the ISF operating-expense figure — the most consistent measure across all 21 ACFRs. It is not a "general fund IT department budget"; the fund recovers its costs by billing other departments.
Capital is budget, not actuals. The adopted IT capital budget is consistent and comparable; the ISF capital actuals are $0 in most years because IT capital ran through the Capital Projects Fund. See Section 3.
"Applications supported" is the budgets' own metric — commercial/publicly-available software, not in-house code, and not broken out by web service. It was re-baselined at least twice.
FY2011 sources were OCR'd. The FY2011 ACFR is a scanned PDF; the FY2022 budget's IT pages were a non-extractable encoded font. Both were OCR'd before extraction — the FY2022 OCR corrected two previously-estimated figures.
FY2011–FY2013 have no device counts from their own budgets (abridged or table-dropped); those years lean on neighboring budgets.