OpenSolano / Experiments

Where the Money Flowed — Audited Actuals

The two budget lenses show the plan. This is what actually happened: Vacaville's FY2024 audited, government-wide results from the Annual Comprehensive Financial Report — full accrual, every activity, every grant.

Citywide revenue
$317.1M
FY2024 actuals, all activities
Citywide expense
$288.1M
Accrual basis — includes depreciation & pension expense
Added to net position
+$29.1M
Mostly restricted capital grants, not spendable cash
Public safety self-funded
12.8%
$12.1M earned against $94.8M of expense
Unrestricted net position
~2%
Of $898.5M total; 81% is locked in capital assets
View every published line item as a table
Side Group Line item Amount Note
revenue Charges for services Sewer charges $35824988
revenue Charges for services Water charges $24048742
revenue Charges for services Community services charges $9222144
revenue Charges for services Public safety charges $8482210
revenue Charges for services General government charges $5283880
revenue Charges for services Public works charges $4529941
revenue Charges for services Transit charges $283930
revenue Charges for services Housing charges $36919
revenue Grants & contributions Operating grants & contributions $45165889 Largest recipients — housing $26.2M, public works $6.7M (includes gas tax), transit $3.9M.
revenue Grants & contributions Capital grants & contributions $44879901 Largest recipients — public works $21.6M, transit $9.5M, water $5.0M, sewer $4.7M.
revenue Taxes Property taxes $60596937
revenue Taxes Sales taxes $49941242
revenue Taxes Franchise taxes $5669167
revenue Taxes Excise tax $2924066 Smaller than the budget's $9.4M excise line because Measure G is largely a charge on the City's own utility funds, reclassified in consolidation.
revenue Taxes Transient lodging tax $2051656
revenue Taxes Business license tax $429993
revenue Investment & other Investment income $16270321
revenue Investment & other Miscellaneous $1506101
spending Governmental activities Public safety $94818159 Earns $12.1M of program revenue — 12.8% self-funded; net cost $82.7M.
spending Governmental activities Public works $51452385 Earns $32.8M of program revenue — 63.8% self-funded; net cost $18.6M.
spending Governmental activities General government $26759850 Earns $9.1M of program revenue — 33.9% self-funded; net cost $17.7M.
spending Governmental activities Housing $25319854 Grant-funded: program revenue exceeds expense by $0.9M.
spending Governmental activities Community services $20638013 Earns $13.5M of program revenue — 65.2% self-funded; net cost $7.2M.
spending Governmental activities Interest on long-term debt $596564
spending Business-type activities Sewer $38360766 Fully ratepayer/grant funded; earned $2.6M more than it spent.
spending Business-type activities Water $25892107 Fully ratepayer/grant funded; earned $3.6M more than it spent.
spending Business-type activities Transit $4223248 Capital grants drove $9.4M of net position growth.
spending Added to net position Added to net position (surplus) $29087081 Revenues exceeded expenses — mostly restricted capital grants and enterprise-fund results, not spendable General Fund cash.

The net cost of services — who actually pays for what

Function Expense Program revenue it earns Self-funded Net cost, paid by taxes
Public safety $94.8M $12.1M 12.8% $82.7M
Public works $51.5M $32.8M 63.8% $18.6M
General government $26.8M $9.1M 33.9% $17.7M
Housing $25.3M $26.2M 103.6% +$0.9M surplus
Community services $20.6M $13.5M 65.2% $7.2M
Interest on long-term debt $0.6M $0.0M 0.0% $0.6M
Sewer $38.4M $41.0M 106.9% +$2.6M surplus
Water $25.9M $29.4M 113.7% +$3.6M surplus
Transit $4.2M $13.6M 322.0% +$9.4M surplus

How to read this

The ACFR's Statement of Activities is built around one question the budget never answers: after counting the fees and grants each function earns for itself, what does it really cost the taxpayer?

The table above is that statement, made legible. Sewer, water, transit, and housing fully fund themselves through charges and grants. Public works and community services cover roughly two-thirds of their own cost. Public safety earns almost nothing on its own — its $82.7M net cost is why property and sales taxes exist. In FY2024, the city's entire $121.6M of taxes went, in effect, to cover the $125.9M net cost of governmental activities.

Why these numbers differ from the budget lenses

  • Actuals vs. plan. This is what happened in FY2023-24; the budget lenses show what was appropriated for FY2025-26.
  • Accrual vs. appropriation. Accrual expense includes depreciation and actuarially measured pension expense, and capitalizes asset purchases instead of expensing them. Public safety here is $94.8M against $104.0M of budgeted police + fire appropriations — different measures of the same thing.
  • Consolidation. Money the city charges itself disappears government-wide. The clearest case: "excise tax" is $9.4M in the budget but $2.9M here, because Measure G is largely a charge on the city's own utility funds.
  • The surplus is not a windfall. The $29.1M added to net position is dominated by restricted capital grants and enterprise results. Citywide net position is $898.5M, but 81% is capital assets and 16% is restricted — unrestricted is about 2%, and was negative from 2015 (when GASB 68 put pension liabilities on the balance sheet) until FY2021-22.

Methodology & sources

All figures are exact dollars from the audited Annual Comprehensive Financial Report for the fiscal year ended June 30, 2024: the Statement of Activities (p. 24) and Management's Discussion and Analysis (pp. 7-9). Every function's expense, program revenue, and net cost reconciles to the statement's printed totals: $288,060,946 of expense, $317,148,027 of revenue, $29,087,081 change in net position. Interfund transfers net to zero government-wide and are excluded; the Note 21 error correction is a restatement, not a current-year flow.

Data with per-line provenance lives in the site repository (_data/budget_flows.yml). Pension and retiree-health detail from the same ACFR is tracked separately in the Public Funds work. Questions or corrections: ryan@civic.studio.