Where city money comes from and where it goes

Of $7,210,575 not on vendor bills in FY2023 (July 2022 – June 2023), $5,608,839 was spent in ways the payables lists do not show (bond payments, transfers, payroll, developer rebates) and $1,601,736 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)": $117,269 of the $263,361 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 $146,092 is not identified, so it is still inside the revenue total (counted twice). Estimate
• Months left out of both sides (no Treasurer's report): 2022-07, 2022-08, 2022-10; $1,143,723 of vendor payments in those months is not in the chart.

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