Where city money comes from and where it goes

Of $2,021,062 not on vendor bills in FY2027 (July 2026 – June 2027), $770,094 was spent in ways the payables lists do not show (bond payments, transfers, payroll, developer rebates) and $1,250,969 was not spent: it stayed in the funds, mostly as borrowing not yet used.

The arithmetic, fund by fund

• For each fund, over the months with a Treasurer's report:
• money in = revenue + borrowing (Treasurer's revenue column)
• spent without a vendor bill = Treasurer's expenses − vendor payments (when positive)
• kept = money in − vendor payments − spent without a vendor bill (when positive)
• not on vendor bills = spent without a vendor bill + kept; spending beyond the money in is drawn from the fund's balance

What is estimated

• Estimates: Transfers to other funds, Payroll and benefits (estimate), TIF developer rebates. Payroll and benefits are modeled from the budget worksheets, not read from a payroll register; transfers and rebates that no worksheet prints to the dollar are placed by month and fund.
• "Transfers from other funds (internal)": $5,494 of the $69,085 transferred out is matched to a debt fund's revenue the same month and is not counted as revenue; the receiving fund of the other $63,591 is not identified, so it is still inside the revenue total (counted twice). Estimate
• Months left out of both sides (no Treasurer's report): 2026-10; $2,966,058 of vendor payments in those months is not in the chart.
• Fund 340 Recreation Center prints an actual ending balance of 0 in 3 report(s) while its calculated ending balance reaches $-746,572 (2026-08). source

Questions open for the City Clerk

• Where is the Recreation Center bond cash held? Fund 340 prints an actual ending balance of 0 every month while its calculated ending balance was about $11.4 million after the February 2026 bond sale. Treasurer's report, February 2026, fund 340 row
• Which developers received fund 125's December 2025 ($367,426) and June 2026 ($407,426) payments? The worksheet books the December one to 125-520-6421 Development agreement / tax rebates. FY2027 budget worksheet, fund 125
• Could the Clerk provide a payroll register (or the year's payroll journal totals by fund)? It would replace the modeled payroll and benefits.
• Are the January and May transfers out of the General Fund (001) and Sewer (610) as booked in accounts 6910? FY2027 budget worksheet, transfers out