Tiffin Civic Chronicletiffin.cc

Cash-flow reconciliation, FY2022 (July 2021 – June 2022)

Every fund's money in and out over the months with a Treasurer's report: the Treasurer's revenue and expenses as printed, the vendor payments on the approved payables lists, and the spending that is not on those lists, split by kind (debt service, transfers, payroll and benefits, developer rebates) and what each fund kept. The totals tie to the cash-flow chart; what "not on vendor bills" means.
Compiled from the payables lists and Treasurer's reports the City of Tiffin published with its council agendas; not official accounting. Every figure links to the page it was read from. Where a payables list's parsed lines do not reach its printed total the spending is a lower bound, and months without a Treasurer's report in the archive are missing from the revenue.
CSV by fund · CSV by fund and month · JSON
$13,783,043revenue As printed, 10 of 12 months; ≈ $2,056,210 of it transfers between funds Estimate
$478,714borrowing Derived
$11,331,127Treasurer's expenses As printed
$4,849,177vendor payments, same months Derived
$6,481,950spent without a vendor bill Derived
$5,891,948kept in the funds (incl. unspent borrowing) Derived

Months without a Treasurer's report are left out of both sides: 2022-03, 2022-06 ($1,073,601 of vendor payments).

By fund

Per fund, FY2022. Revenue and expenses as printed in the Treasurer's reports As printed; vendor payments and the split derived Derived; payroll and unmatched transfers are estimates Estimate.
FundRevenueof which transfers inBorrowingTreasurer's expensesVendor paymentsSpent without a vendor bill Debt service (paying agent)Transfers to other fundsPayroll and benefits (estimate)TIF developer rebatesUnclassified (not on vendor bills)Unspent borrowing (still in the fund)Kept in fund balancesFrom balanceChange in balance (printed)
001 General Fund $2,643,800 $1,970,624$897,539$1,073,085 $454,087$482,665$136,333$673,175 $674,837
005 Community Reserve $0 $0$0 $0
110 Road Use Tax $712,501 $512,652$351,481$161,171 $148,819$12,351$199,849 $199,849
111 IJOBS $0 $0$0 $0
112 Employee Benefit $203,738 $109,046$56,810$52,236 $47,587$4,649$94,692 $94,692
119 Emergency Fund $1,528 $0$0 $1,528 $1,528
121 Local Option Sales Tax $0 $0$0 $0
125 TIF $1,502,454 $1,037,934$0$1,037,934 $925,204$70,057$42,674$464,519 $464,519
160 Economic Development $0 $0$0 $0
168 ARPA - FEDERAL GRANT $0 $0$0 $0
170 FEMA $0 $0$0 $0
200 Debt Service $1,682,816$1,409,452 $1,991,494$2,550$1,988,944 $1,988,944$308,678 −$308,678
301 DEVELOPER - ESCROW $252,582 $0$0 $252,582 $252,582
302 CAP Street Projects $0 $0$0 $0
303 Ireland Ave $0 $0$0 $0
304 TIFFIN WEST - DEVELOPER REIMBURSEMENT $0 $0$0 $0
305 Park/Ball Fld Improv Pr $0 $0$0 $0
306 Cap S Ireland Patch/Mil $0 $0$0 $0
307 Park Road Paving $0 $0$0 $0
308 Landswap/Watershed ZE $0 $0$0 $0
309 US HWY 6 RECONSTRUCTION $0 $0$0 $0
310 Trail Project $0 $107,627$107,627 $107,627 −$97,801
311 Comprehensive Park Plng $0 $0$0 $0
312 Robert's Ferry Road Project $0 $0$0 $0
313 CIP-Indsl Pk Wtrmain Ex $0 $0$0 $0
314 Water Tower Press Upgrd $0 $0$0 $0
315 Cap City Parks Proj $0 $0$0 $0
316 GO Bonds $17,164 $0$0 $17,164 $17,164
317 Village Dr Expansion $0 $0$0 $0
318 Solar Project-City Hall $0 $0$0 $0
319 CCA MS/HS Trail Proj $0 $0$0 $0
320 Roundabout Park Rd $0 $136,468$136,468 $136,468 −$136,468
321 Original Town Urbanization $2,017 $1,377,516$1,377,516 $1,375,498 −$1,375,498
322 Traffic Lights $138,421 $2,380$2,380 $136,041 $136,041
323 Timber Ridge Trail $0 $0$0 $0
324 City Pond Improvmt $0 $0$0 $0
325 Water Main Relocation for IDOT $0 $0$0 $0
326 Town Center Land Purch $0 $0$0 $0
327 State St Reloc/Dry Deten $0 $0$0 $0
328 San Sewer Ovrsz N Hwy6 $0 $0$0 $0
329 Deerview/HWY6 $0 $1,511$1,511 $1,511 −$1,511
330 Tiffin Firetruck $0 $0$0 $0
331 Trunk Sewer Upsize $0 $0$0 $0
332 Wtr Quality Sponsored PJT $0$478,714 $80,032$80,032 $398,682 $398,682
333 Soccer Field Exp $0 $0$0 $0
334 Ballfield Pk Lot $0 $0$0 $0
335 Forevergreen Rd Pjt $0 $104,087$86,572$17,514 $17,514$104,087 −$104,087
336 Public Works Building $1,600,000 $375,707$241,301$134,406 $134,406$1,224,293 $1,224,293
337 Kimberlite Extension $0 $0$0 $0
338 Frontage Road City Park $0 $0$0 $0
339 Original Town PH3 $0 $0$0 $0
340 Recreation Center $0 $0$0 $0
341 RFR Park $0 $0$0 $0
342 Railroad Replacement $0 $0$0 $0
343 PERMEABLE PAVERS $0 $370,532$370,532 $370,532 −$220,194
344 PW - EQUIPMENT $130,750 $0$0 $130,750 $130,750
345 JOINT PUBLIC SAFETY BUILDING $700,000 $0$0 $700,000 $700,000
346 FIRE EQUIPMENT $275,000 $0$0 $275,000 $275,000
600 Water $1,058,604 $796,451$534,319$262,131 $25,168$169,654$21,812$45,497$262,153 $262,153
601 Water Sinking $33,305 $385$0$385 $385$32,920 $32,920
602 CAP WATER MAIN PROJ $0 $0$0 $0
603 Cap Water Tower Proj $0 $0$0 $0
604 Cap School Water Extens $0 $0$0 $0
605 Cap Water Plant Extens $0 $0$0 $0
606 City Pond Improvement Project $0 $0$0 $0
607 Second Well $0 $31,176$30,426$750 $750$31,176 −$31,176
610 Sewer $967,097 $1,461,946$201,654$1,260,291 $586,365$159,062$514,864$494,849 −$494,449
611 Sewer Sinking $1,070,985$646,758 $458,729$0$458,729 $458,729$612,255 $612,255
612 Sewer I & I Project $0 $0$0 $0
613 Schl Sewer Ext/Lift St $0 $0$0 $0
614 WWTP Expansion Project $384,699 $210$210 $384,489 $384,489
615 Sewer Main Upsz Hwy 6 $0 $0$0 $0
616 City Pond Improvements $0 $0$0 $0
617 Sanitary Sewer Infrastructure Improvement $0 $5,182$5,182 $5,182 −$5,182
618 Sewer Main Upsize Railroad $0 $0$0 $0
670 Recycling/Garbage $332,896 $358,606$324,234$34,372 $34,372$25,709 −$25,709
740 Storm Water $72,687 $40,831$40,831 $31,856 $31,856
Total (ties to the chart)$13,783,043$2,056,210$478,714$11,331,127$4,849,177$6,481,950 $2,448,059$2,125,231$1,007,787$228,202$672,672$398,682$5,493,266$2,961,319$3,092,856

Spent without a vendor bill = Treasurer's expenses − vendor payments (when positive), split into the parts to its right; kept = money in − vendor payments − spent without a vendor bill. "Change in balance" adds each month's printed actual ending minus beginning balance; it differs from "kept" where the report's arithmetic includes asset and liability changes, and fund 340 prints an actual ending of 0.

By fund and month

001 General Fund: $1,746,261 not on vendor bills

Transfers to other funds $454,087 Estimate · Payroll and benefits (estimate) $482,665 Estimate · TIF developer rebates $136,333 Estimate · Kept in fund balances $673,175 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$1,120,515 $594,210$383,323$210,886 payroll benefits $210,886 (estimate) $526,306 page
2021-11$430,953 $239,844$72,383$167,461 payroll benefits $45,296 (estimate); rebates $122,165 (medium) $191,109 page
2021-12$39,120 $149,427$88,363$61,065 payroll benefits $45,296 (estimate); transfers $15,768 (medium) −$110,308 page
2022-01$67,699 $464,010$118,449$345,561 payroll benefits $45,296 (estimate); transfers $300,265 (medium) −$396,312 page
2022-02$46,625 $124,116$64,651$59,465 payroll benefits $45,296 (estimate); rebates $14,168 (medium) −$77,491 page
2022-04$807,044 $219,965$49,076$170,889 payroll benefits $45,296 (estimate); transfers $125,592 (medium) $588,743 page
2022-05$131,843 $179,052$121,294$57,759 payroll benefits $45,296 (estimate); transfers $12,462 (medium) −$47,209 page

Fund page

005 Community Reserve: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page

Fund page

110 Road Use Tax: $361,019 not on vendor bills

Payroll and benefits (estimate) $148,819 Estimate · Unclassified (not on vendor bills) $12,351 Derived · Kept in fund balances $199,849 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$174,369 $200,164$139,630$60,533 payroll benefits $60,533 (estimate) −$25,794 page
2021-11$169,310 $24,219$10,587$13,633 payroll benefits $13,633 (estimate) $145,090 page
2021-12$70,871 $45,027$30,308$14,719 payroll benefits $14,719 (estimate) $25,844 page
2022-01$77,083 $54,415$39,330$15,085 payroll benefits $15,085 (estimate) $22,668 page
2022-02$75,586 $25,898$11,360$14,538 payroll benefits $14,538 (estimate) $49,687 page
2022-04$93,429 $127,087$99,243$27,844 payroll benefits $15,493 (estimate); unclassified $12,351 −$33,658 page
2022-05$51,853 $35,842$21,023$14,819 payroll benefits $14,819 (estimate) $16,012 page

Fund page

111 IJOBS: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

112 Employee Benefit: $146,928 not on vendor bills

Payroll and benefits (estimate) $47,587 Estimate · Unclassified (not on vendor bills) $4,649 Derived · Kept in fund balances $94,692 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$100,634 $42,989$25,329$17,659 payroll benefits $17,659 (estimate) $57,645 page
2021-11$5,101 $6,298$6,298$0 −$1,198 page
2021-12$5,816 $6,298$6,298$0 −$482 page
2022-01$1,597 $13,190$6,287$6,903 payroll benefits $6,903 (estimate) −$11,593 page
2022-02$479 $11,997$6,298$5,699 payroll benefits $5,699 (estimate) −$11,518 page
2022-04$83,959 $15,849$0$15,849 payroll benefits $11,200 (estimate); unclassified $4,649 $68,110 page
2022-05$6,151 $12,424$6,298$6,126 payroll benefits $6,126 (estimate) −$6,274 page

Fund page

119 Emergency Fund: $1,528 not on vendor bills

Kept in fund balances $1,528 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$18,716 $0$0$0 $18,716 page
2021-11$950 $0$0$0 $950 page
2021-12$1,083 $0$0$0 $1,083 page
2022-01−$20,748 $0$0$0 −$20,748 page
2022-02$383 $0$0$0 $383 page
2022-04$15,629 $0$0$0 $15,629 page
2022-05−$14,484 $0$0$0 −$14,484 page

Fund page

121 Local Option Sales Tax: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

125 TIF: $1,502,454 not on vendor bills

Transfers to other funds $925,204 Estimate · TIF developer rebates $70,057 Estimate · Unclassified (not on vendor bills) $42,674 Derived · Kept in fund balances $464,519 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$753,079 $0$0$0 $753,079 page
2021-11$49,001 $0$0$0 $49,001 page
2021-12$27,482 $69,000$0$69,000 rebates $69,000 (medium) −$41,518 page
2022-01$28,688 $902,254$0$902,254 transfers $902,254 (medium) −$873,566 page
2022-02$3,314 $43,731$0$43,731 rebates $1,057 (medium); unclassified $42,674 −$40,417 page
2022-04$565,347 $11,450$0$11,450 transfers $11,450 (medium) $553,897 page
2022-05$75,544 $11,500$0$11,500 transfers $11,500 (medium) $64,044 page

Fund page

160 Economic Development: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

168 ARPA - FEDERAL GRANT: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$309,746 $0$0$0 $309,746 page
2021-11−$309,746 $0$0$0 −$309,746 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

170 FEMA: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

200 Debt Service: $1,988,944 not on vendor bills, $308,678 from its balance

Debt service (paying agent) $1,988,944 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$258,307 $2,000$2,000$0 $256,307 page
2021-11$13,849 $240,189$0$240,189 debt service $240,189 (high) −$226,341 page
2021-12$13,730
$13,730 transfers in (est.)		 $550$550$0 $13,180 page
2022-01$1,167,293
$1,167,293 transfers in (est.)		 $0$0$0 $1,167,293 page
2022-02$1,208 $0$0$0 $1,208 page
2022-04$210,523
$210,523 transfers in (est.)		 $0$0$0 $210,523 page
2022-05$17,905
$17,905 transfers in (est.)		 $1,748,755$0$1,748,755 debt service $1,748,755 (high) −$1,730,850 page

Fund page

301 DEVELOPER - ESCROW: $252,582 not on vendor bills

Kept in fund balances $252,582 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$252,582 $0$0$0 $252,582 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

302 CAP Street Projects: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

303 Ireland Ave: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

304 TIFFIN WEST - DEVELOPER REIMBURSEMENT: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

305 Park/Ball Fld Improv Pr: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

306 Cap S Ireland Patch/Mil: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

307 Park Road Paving: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

308 Landswap/Watershed ZE: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

309 US HWY 6 RECONSTRUCTION: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

310 Trail Project: $0 not on vendor bills, $107,627 from its balance
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $97,801$97,801$0 −$97,801 page
2021-11$0 $6,288$6,288$0 $0 page
2021-12$0 $1,300$1,300$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $2,239$2,239$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

311 Comprehensive Park Plng: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

312 Robert's Ferry Road Project: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

313 CIP-Indsl Pk Wtrmain Ex: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

314 Water Tower Press Upgrd: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

315 Cap City Parks Proj: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

316 GO Bonds: $17,164 not on vendor bills

Kept in fund balances $17,164 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$6,724 $0$0$0 $6,724 page
2021-11$1,779 $0$0$0 $1,779 page
2021-12$1,724 $0$0$0 $1,724 page
2022-01$1,724 $0$0$0 $1,724 page
2022-02$1,558 $0$0$0 $1,558 page
2022-04$1,614 $0$0$0 $1,614 page
2022-05$2,041 $0$0$0 $2,041 page

Fund page

317 Village Dr Expansion: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

318 Solar Project-City Hall: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

319 CCA MS/HS Trail Proj: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

320 Roundabout Park Rd: $0 not on vendor bills, $136,468 from its balance
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $1,628$1,628$0 −$1,628 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $230$230$0 −$230 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $134,611$134,611$0 −$134,611 page

Fund page

321 Original Town Urbanization: $0 not on vendor bills, $1,375,498 from its balance
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $657,996$657,996$0 −$657,996 page
2021-11$0 $263,955$263,955$0 −$263,955 page
2021-12$0 $55,779$55,779$0 −$55,779 page
2022-01$0 $270,315$270,315$0 −$270,315 page
2022-02$0 $3,240$3,240$0 −$3,240 page
2022-04$0 $0$0$0 $0 page
2022-05$2,017 $126,231$126,231$0 −$124,213 page

Fund page

322 Traffic Lights: $136,041 not on vendor bills

Kept in fund balances $136,041 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$138,421 $2,380$2,380$0 $136,041 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

323 Timber Ridge Trail: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

324 City Pond Improvmt: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

325 Water Main Relocation for IDOT: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

326 Town Center Land Purch: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

327 State St Reloc/Dry Deten: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

328 San Sewer Ovrsz N Hwy6: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

329 Deerview/HWY6: $0 not on vendor bills, $1,511 from its balance
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $1,354$1,354$0 −$1,354 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $158$158$0 −$158 page

Fund page

330 Tiffin Firetruck: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

331 Trunk Sewer Upsize: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

332 Wtr Quality Sponsored PJT: $398,682 not on vendor bills

Unspent borrowing (still in the fund) $398,682 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $21,869$21,869$0 −$21,869 page
2021-11$0 $36,210$36,210$0 −$36,210 page
2021-12$0 $20,174$20,174$0 −$20,174 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $1,779$1,779$0 −$1,779 page
2022-04$0$407,270 $0$0$0 $407,270 page
2022-05$0$71,444 $0$0$0 $71,444 page

Fund page

333 Soccer Field Exp: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

334 Ballfield Pk Lot: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

335 Forevergreen Rd Pjt: $17,514 not on vendor bills, $104,087 from its balance

Unclassified (not on vendor bills) $17,514 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $13,650$13,650$0 −$13,650 page
2021-11$0 $6,820$6,820$0 −$6,820 page
2021-12$0 $25,430$25,430$0 −$25,430 page
2022-01$0 $8,930$8,930$0 −$8,930 page
2022-02$0 $17,671$17,671$0 −$17,671 page
2022-04$0 $21,984$0$21,984 unclassified $17,514 −$21,984 page
2022-05$0 $9,601$14,071−$4,470 −$9,601 page

Fund page

336 Public Works Building: $1,358,699 not on vendor bills

Transfers to other funds $134,406 Estimate · Kept in fund balances $1,224,293 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $28,510$28,510$0 −$28,510 page
2021-12$0 $19,730$19,730$0 −$19,730 page
2022-01$0 $13,425$13,425$0 −$13,425 page
2022-02$0 $11,944$11,944$0 −$11,944 page
2022-04$0 $136,219$1,812$134,406 transfers $134,406 (low) −$136,219 page
2022-05$1,600,000 $165,879$165,879$0 $1,434,121 page

Fund page

337 Kimberlite Extension: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

338 Frontage Road City Park: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

339 Original Town PH3: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

340 Recreation Center: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

341 RFR Park: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

342 Railroad Replacement: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

343 PERMEABLE PAVERS: $0 not on vendor bills, $370,532 from its balance
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $220,194$220,194$0 −$220,194 page
2021-11$0 $43,292$43,292$0 $0 page
2021-12$0 $100,664$100,664$0 $0 page
2022-01$0 $6,152$6,152$0 $0 page
2022-02$0 $230$230$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

344 PW - EQUIPMENT: $130,750 not on vendor bills

Kept in fund balances $130,750 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$130,750 $0$0$0 $130,750 page

Fund page

345 JOINT PUBLIC SAFETY BUILDING: $700,000 not on vendor bills

Kept in fund balances $700,000 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2022-05$700,000 $0$0$0 $700,000 page

Fund page

346 FIRE EQUIPMENT: $275,000 not on vendor bills

Kept in fund balances $275,000 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2022-05$275,000 $0$0$0 $275,000 page

Fund page

600 Water: $524,284 not on vendor bills

Transfers to other funds $25,168 Estimate · Payroll and benefits (estimate) $169,654 Estimate · TIF developer rebates $21,812 Estimate · Unclassified (not on vendor bills) $45,497 Derived · Kept in fund balances $262,153 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$432,671 $425,812$340,665$85,147 payroll benefits $63,335 (estimate); rebates $21,812 (medium) $6,858 page
2021-11$79,896 $50,215$32,074$18,141 payroll benefits $18,141 (estimate) $29,680 page
2021-12$203,422 $62,576$44,365$18,211 payroll benefits $18,211 (estimate) $140,846 page
2022-01$90,345 $78,958$26,313$52,645 payroll benefits $15,856 (estimate); transfers $25,168 (medium); unclassified $11,620 $11,387 page
2022-02$71,942 $48,995$30,940$18,055 payroll benefits $18,055 (estimate) $22,947 page
2022-04$91,130 $67,343$14,706$52,637 payroll benefits $18,760 (estimate); unclassified $33,877 $23,788 page
2022-05$89,198 $62,551$45,256$17,295 payroll benefits $17,295 (estimate) $26,646 page

Fund page

601 Water Sinking: $33,305 not on vendor bills

Debt service (paying agent) $385 Derived · Kept in fund balances $32,920 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $385$0$385 debt service $385 (high) −$385 page
2022-01$33,305 $0$0$0 $33,305 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

602 CAP WATER MAIN PROJ: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

603 Cap Water Tower Proj: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

604 Cap School Water Extens: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

605 Cap Water Plant Extens: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

606 City Pond Improvement Project: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

607 Second Well: $750 not on vendor bills, $31,176 from its balance

Unclassified (not on vendor bills) $750 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $11,615$11,615$0 −$11,615 page
2021-11$0 $6,700$6,700$0 −$6,700 page
2021-12$0 $582$582$0 −$582 page
2022-01$0 $3,254$3,254$0 −$3,254 page
2022-02$0 $5,236$5,236$0 −$5,236 page
2022-04$0 $3,235$2,485$750 unclassified $750 −$3,235 page
2022-05$0 $554$554$0 −$554 page

Fund page

610 Sewer: $1,260,291 not on vendor bills, $494,849 from its balance

Transfers to other funds $586,365 Estimate · Payroll and benefits (estimate) $159,062 Estimate · Unclassified (not on vendor bills) $514,864 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$381,824 $162,015$95,389$66,626 payroll benefits $66,626 (estimate) $219,809 page
2021-11$128,350 $24,812$10,589$14,223 payroll benefits $14,223 (estimate) $103,539 page
2021-12$106,902 $30,798$16,188$14,610 payroll benefits $14,610 (estimate) $76,104 page
2022-01$94,879 $1,095,125$8,811$1,086,315 payroll benefits $16,055 (estimate); transfers $586,365 (medium); unclassified $483,895 −$1,000,246 page
2022-02$74,802 $36,019$21,612$14,408 payroll benefits $14,408 (estimate) $39,182 page
2022-04$90,988 $84,419$34,492$49,927 payroll benefits $18,958 (estimate); unclassified $30,969 $6,569 page
2022-05$89,351 $28,757$14,574$14,183 payroll benefits $14,183 (estimate) $60,595 page

Fund page

611 Sewer Sinking: $1,070,985 not on vendor bills

Debt service (paying agent) $458,729 Derived · Kept in fund balances $612,255 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $74,030$0$74,030 debt service $74,030 (high) −$74,030 page
2022-01$1,070,985
$646,758 transfers in (est.)		 $384,699$0$384,699 debt service $384,699 (high) $686,285 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

612 Sewer I & I Project: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

613 Schl Sewer Ext/Lift St: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

614 WWTP Expansion Project: $384,489 not on vendor bills

Kept in fund balances $384,489 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $210$210$0 −$210 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$384,699 $0$0$0 $384,699 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

615 Sewer Main Upsz Hwy 6: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

616 City Pond Improvements: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

617 Sanitary Sewer Infrastructure Improvement: $0 not on vendor bills, $5,182 from its balance
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $2,908$2,908$0 −$2,908 page
2021-11$0 $532$532$0 −$532 page
2021-12$0 $1,742$1,742$0 −$1,742 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

618 Sewer Main Upsize Railroad: $0 not on vendor bills
ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$0 $0$0$0 $0 page
2021-11$0 $0$0$0 $0 page
2021-12$0 $0$0$0 $0 page
2022-01$0 $0$0$0 $0 page
2022-02$0 $0$0$0 $0 page
2022-04$0 $0$0$0 $0 page
2022-05$0 $0$0$0 $0 page

Fund page

670 Recycling/Garbage: $34,372 not on vendor bills, $25,709 from its balance

Unclassified (not on vendor bills) $34,372 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$130,460 $157,182$157,382−$200 −$26,722 page
2021-11$32,350 $32,800$32,570$230 unclassified $228 −$450 page
2021-12$34,647 $32,894$32,924−$30 $1,754 page
2022-01$35,454 $33,154$33,154$0 $2,299 page
2022-02$30,643 $33,802$33,802$0 −$3,159 page
2022-04$34,320 $34,372$0$34,372 unclassified $34,143 −$52 page
2022-05$35,023 $34,402$34,402$0 $621 page

Fund page

740 Storm Water: $31,856 not on vendor bills

Kept in fund balances $31,856 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2021-07..2021-10$28,571 $40,831$40,831$0 −$12,261 page
2021-11$7,001 $0$0$0 $7,001 page
2021-12$7,582 $0$0$0 $7,582 page
2022-01$7,788 $0$0$0 $7,788 page
2022-02$6,865 $0$0$0 $6,865 page
2022-04$7,403 $0$0$0 $7,403 page
2022-05$7,477 $0$0$0 $7,477 page

Fund page

What "not on vendor bills" means

Of $12,373,898 not on vendor bills in FY2022 (July 2021 – June 2022), $6,481,950 was spent in ways the payables lists do not show (bond payments, transfers, payroll, developer rebates) and $5,891,948 was not spent: it stayed in the funds, mostly as borrowing not yet used.

The band, part by part, FY2022 (July 2021 – June 2022). The parts add up exactly to $12,373,898.
PartAmountShareBasisHow it is found
Debt service (paying agent) $2,448,05919.8% Derived high confidence Treasurer's expenses of Debt Service (200) and the sinking funds (601, 611) with no vendor payment: bond principal and interest paid through the paying agent, never on a claims list.
Sources: Treasurer's report 2021-11, fund 200; Treasurer's report 2022-05, fund 200; Treasurer's report 2021-12, fund 601; Treasurer's report 2022-01, fund 611
Transfers to other funds $2,125,23117.2% Estimate medium confidence Money moved to another fund (TIF and local option sales tax to Debt Service, sewer to the sewer sinking fund, general fund transfers). The receiving fund counts it again as revenue. the rest is placed by month and fund (see the reconciliation table).
Sources: Treasurer's report 2021-12, fund 001; Treasurer's report 2022-01, fund 001; Treasurer's report 2022-04, fund 001; Treasurer's report 2022-05, fund 001; Treasurer's report 2022-04, fund 336; Treasurer's report 2022-01, fund 600 and 6 more pages (reconciliation table)
Payroll and benefits (estimate) $1,007,7878.1% Estimate medium confidence Modeled from the budget worksheets' wage and benefit accounts (wages, FICA, IPERS, group insurance, workers' compensation) for the months with a report, less those accounts' lines on the claims lists. No payroll register is in the archive. 10 months of the worksheets' wage and benefit accounts for funds 001, 110, 112, 600, 610, less those accounts' lines on the claims lists. A payroll register would replace it.
Sources: Treasurer's report 2021-07..2021-10, fund 001; Treasurer's report 2021-11, fund 001; Treasurer's report 2021-12, fund 001; Treasurer's report 2022-01, fund 001; Treasurer's report 2022-02, fund 001; Treasurer's report 2022-04, fund 001 and 6 more pages (reconciliation table)
TIF developer rebates $228,2021.8% Estimate medium confidence Tax-increment rebates paid to developers under development agreements (fund 125, account 6421). the rest is placed by month and fund (see the reconciliation table).
Sources: Treasurer's report 2021-11, fund 001; Treasurer's report 2022-02, fund 001; Treasurer's report 2021-12, fund 125; Treasurer's report 2021-07..2021-10, fund 600; budget worksheet, fund 001 FY2021 (activity $0); budget worksheet, fund 125 FY2021 (draft budget $144,219) and 4 more pages (reconciliation table)
Unclassified (not on vendor bills) $672,6725.4% Derived Treasurer's expenses with no vendor payment that none of the rules explains. The rest is spending of funds without payroll, transfer or rebate accounts, or beyond the worksheet figures; payables lists that do not reconcile add to it.
Sources: Treasurer's report 2022-04, fund 110; Treasurer's report 2022-02, fund 125; Treasurer's report 2022-04, fund 335; Treasurer's report 2022-01, fund 600; Treasurer's report 2021-11, fund 670
Unspent borrowing (still in the fund) (not spent) $398,6823.2% Derived high confidence Bond or loan proceeds received in the period and not yet spent (they stay in the fund for the project). Bond or loan money received in the period minus what its fund spent (vendor and other).
Kept in fund balances (not spent) $5,493,26644.4% Derived medium confidence Revenue the fund did not spend in the period: its balance went up.
Total not on vendor bills$12,373,898100%Derived$6,481,950 spent without a vendor bill + $5,891,948 kept in the funds

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)": $2,056,210 of the $2,125,231 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 $69,021 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-03, 2022-06; $1,073,601 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

Data last updated October 28, 2026. Built from the archive's documents; see how the data is built.