Cash-flow reconciliation, FY2024 (July 2023 – June 2024)
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.
$15,163,005revenue As printed, 12 of 12 months; ≈ $2,443,463 of it transfers between funds Estimate
$2,319,719borrowing Derived
$15,084,360Treasurer's expenses As printed
$6,722,239vendor payments, same months Derived
$8,505,270spent without a vendor bill Derived
$4,463,645kept in the funds (incl. unspent borrowing) Derived
By fund
| Fund | Revenue | of which transfers in | Borrowing | Treasurer's expenses | Vendor payments | Spent without a vendor bill | Debt service (paying agent) | Transfers to other funds | Payroll and benefits (estimate) | TIF developer rebates | Unclassified (not on vendor bills) | Unspent borrowing (still in the fund) | Kept in fund balances | From balance | Change in balance (printed) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 001 General Fund | $3,439,489 | $3,893,351 | $2,122,900 | $1,770,451 | $323,784 | $795,808 | $650,859 | $453,862 | −$448,322 | ||||||
| 112 Employee Benefit | $243,929 | $303,671 | $122,577 | $181,094 | $18,101 | $162,993 | $59,742 | −$59,742 | |||||||
| 121 Local Option Sales Tax | $344,643 | $55,598 | $0 | $55,598 | $55,598 | $289,045 | $289,045 | ||||||||
| 125 TIF | $1,877,507 | $1,944,706 | $0 | $1,944,706 | $1,646,462 | $52,911 | $245,334 | $67,200 | −$67,200 | ||||||
| 600 Water | $1,411,879 | $1,374,200 | $902,877 | $471,323 | $113,400 | $252,932 | $104,990 | $37,679 | $38,843 | ||||||
| 610 Sewer | $1,328,620 | $1,174,891 | $472,426 | $702,465 | $474,244 | $228,220 | $153,730 | $154,893 | |||||||
| Total (ties to the chart) | $15,163,005 | $2,443,463 | $2,319,719 | $15,084,360 | $6,722,239 | $8,505,270 | $3,144,089 | $2,631,589 | $1,642,087 | $52,911 | $1,034,593 | $2,281,015 | $2,182,630 | $2,208,430 | $2,412,651 |
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,770,451 not on vendor bills, $453,862 from its balance
Transfers to other funds $323,784 Estimate · Payroll and benefits (estimate) $795,808 Estimate · Unclassified (not on vendor bills) $650,859 Derived
| Report | Revenue | Borrowing | Treasurer's expenses | Vendor payments | Difference | Classified as | Change in balance | Source |
|---|---|---|---|---|---|---|---|---|
| 2023-07 | $114,955 | $251,810 | $140,339 | $111,470 | payroll benefits $72,263 (estimate); unclassified $39,208 | −$124,922 | page | |
| 2023-08 | $66,189 | $117,091 | $88,316 | $28,775 | payroll benefits $28,775 (estimate) | −$57,291 | page | |
| 2023-09 | $221,965 | $210,115 | $135,278 | $74,837 | payroll benefits $74,837 (estimate) | $11,850 | page | |
| 2023-10 | $1,135,910 | $233,052 | $144,181 | $88,871 | payroll benefits $88,871 (estimate) | $902,857 | page | |
| 2023-11 | $166,165 | $174,568 | $119,130 | $55,438 | payroll benefits $55,438 (estimate) | −$8,404 | page | |
| 2023-12 | $103,875 | $271,825 | $218,671 | $53,154 | payroll benefits $53,154 (estimate) | −$167,950 | page | |
| 2024-01 | $58,179 | $870,971 | $610,619 | $260,352 | payroll benefits $72,263 (estimate); transfers $188,089 (medium) | −$812,792 | page | |
| 2024-02 | $134,160 | $156,319 | $94,131 | $62,188 | payroll benefits $62,188 (estimate) | −$22,160 | page | |
| 2024-03 | $149,018 | $295,454 | $128,063 | $167,391 | payroll benefits $72,263 (estimate); transfers $95,128 (medium) | −$146,436 | page | |
| 2024-04 | $996,187 | $183,255 | $97,915 | $85,340 | payroll benefits $85,340 (estimate) | $812,932 | page | |
| 2024-05 | $194,876 | $600,494 | $260,120 | $340,374 | payroll benefits $58,154 (estimate); transfers $40,567 (medium); unclassified $241,653 | −$405,618 | page | |
| 2024-06 | $98,009 | $528,397 | $86,137 | $442,261 | payroll benefits $72,263 (estimate); unclassified $369,998 | −$430,388 | page |
112 Employee Benefit: $181,094 not on vendor bills, $59,742 from its balance
Transfers to other funds $18,101 Estimate · Payroll and benefits (estimate) $162,993 Estimate
| Report | Revenue | Borrowing | Treasurer's expenses | Vendor payments | Difference | Classified as | Change in balance | Source |
|---|---|---|---|---|---|---|---|---|
| 2023-07 | $1,419 | $43,407 | $15,758 | $27,649 | payroll benefits $9,548 (estimate); transfers $18,101 (low) | −$41,988 | page | |
| 2023-08 | $0 | $14,996 | $8,983 | $6,013 | payroll benefits $6,013 (estimate) | −$14,996 | page | |
| 2023-09 | $8,738 | $25,937 | $9,549 | $16,389 | payroll benefits $16,389 (estimate) | −$17,199 | page | |
| 2023-10 | $103,710 | $26,510 | $9,855 | $16,655 | payroll benefits $16,655 (estimate) | $77,200 | page | |
| 2023-11 | $10,603 | $22,118 | $9,583 | $12,535 | payroll benefits $12,535 (estimate) | −$11,515 | page | |
| 2023-12 | $3,457 | $21,971 | $9,497 | $12,474 | payroll benefits $12,474 (estimate) | −$18,514 | page | |
| 2024-01 | $1,268 | $25,170 | $9,900 | $15,270 | payroll benefits $15,270 (estimate) | −$23,902 | page | |
| 2024-02 | $791 | $22,805 | $9,802 | $13,004 | payroll benefits $13,004 (estimate) | −$22,014 | page | |
| 2024-03 | $4,055 | $28,136 | $9,802 | $18,334 | payroll benefits $18,334 (estimate) | −$24,081 | page | |
| 2024-04 | $94,602 | $26,141 | $9,802 | $16,340 | payroll benefits $16,340 (estimate) | $68,461 | page | |
| 2024-05 | $13,883 | $22,600 | $9,880 | $12,720 | payroll benefits $12,720 (estimate) | −$8,716 | page | |
| 2024-06 | $1,402 | $23,879 | $10,167 | $13,712 | payroll benefits $13,712 (estimate) | −$22,477 | page |
121 Local Option Sales Tax: $344,643 not on vendor bills
Transfers to other funds $55,598 Derived · Kept in fund balances $289,045 Derived
| Report | Revenue | Borrowing | Treasurer's expenses | Vendor payments | Difference | Classified as | Change in balance | Source |
|---|---|---|---|---|---|---|---|---|
| 2023-07 | $0 | $0 | $0 | $0 | $0 | page | ||
| 2023-08 | $0 | $0 | $0 | $0 | $0 | page | ||
| 2023-09 | $0 | $0 | $0 | $0 | $0 | page | ||
| 2023-10 | $0 | $0 | $0 | $0 | $0 | page | ||
| 2023-11 | $0 | $0 | $0 | $0 | $0 | page | ||
| 2023-12 | $0 | $0 | $0 | $0 | $0 | page | ||
| 2024-01 | $0 | $0 | $0 | $0 | $0 | page | ||
| 2024-02 | $75,632 | $55,598 | $0 | $55,598 | transfers $55,598 (high) = worksheet 121-910-6910 | $20,034 | page | |
| 2024-03 | $57,546 | $0 | $0 | $0 | $57,546 | page | ||
| 2024-04 | $60,359 | $0 | $0 | $0 | $60,359 | page | ||
| 2024-05 | $92,973 | $0 | $0 | $0 | $92,973 | page | ||
| 2024-06 | $58,133 | $0 | $0 | $0 | $58,133 | page |
125 TIF: $1,944,706 not on vendor bills, $67,200 from its balance
Transfers to other funds $1,646,462 Estimate · TIF developer rebates $52,911 Estimate · Unclassified (not on vendor bills) $245,334 Derived
| Report | Revenue | Borrowing | Treasurer's expenses | Vendor payments | Difference | Classified as | Change in balance | Source |
|---|---|---|---|---|---|---|---|---|
| 2023-07 | $18,261 | $0 | $0 | $0 | $18,261 | page | ||
| 2023-08 | $0 | $0 | $0 | $0 | $0 | page | ||
| 2023-09 | $60,510 | $0 | $0 | $0 | $60,510 | page | ||
| 2023-10 | $759,217 | $0 | $0 | $0 | $759,217 | page | ||
| 2023-11 | $136,694 | $36,667 | $0 | $36,667 | transfers $36,667 (medium) | $100,027 | page | |
| 2023-12 | $22,307 | $0 | $0 | $0 | $22,307 | page | ||
| 2024-01 | $58,533 | $923,770 | $0 | $923,770 | transfers $923,770 (medium) | −$865,236 | page | |
| 2024-02 | $4,885 | $0 | $0 | $0 | $4,885 | page | ||
| 2024-03 | $54,109 | $0 | $0 | $0 | $54,109 | page | ||
| 2024-04 | $671,865 | $26,484 | $0 | $26,484 | transfers $26,484 (medium) | $645,381 | page | |
| 2024-05 | $78,635 | $904,876 | $0 | $904,876 | transfers $659,542 (medium); unclassified $245,334 | −$826,241 | page | |
| 2024-06 | $12,488 | $52,911 | $0 | $52,911 | rebates $52,911 (medium) | −$40,422 | page |
600 Water: $509,002 not on vendor bills
Transfers to other funds $113,400 Estimate · Payroll and benefits (estimate) $252,932 Estimate · Unclassified (not on vendor bills) $104,990 Derived · Kept in fund balances $37,679 Derived
| Report | Revenue | Borrowing | Treasurer's expenses | Vendor payments | Difference | Classified as | Change in balance | Source |
|---|---|---|---|---|---|---|---|---|
| 2023-07 | $143,436 | $101,041 | $68,281 | $32,760 | payroll benefits $17,546 (estimate); unclassified $15,214 | $45,824 | page | |
| 2023-08 | $123,224 | $101,531 | $86,238 | $15,293 | payroll benefits $15,293 (estimate) | $19,427 | page | |
| 2023-09 | $142,578 | $109,919 | $77,865 | $32,054 | payroll benefits $21,060 (estimate); transfers $10,995 (medium) | $32,658 | page | |
| 2023-10 | $118,117 | $106,938 | $82,786 | $24,153 | payroll benefits $24,153 (estimate) | $11,178 | page | |
| 2023-11 | $140,989 | $103,977 | $79,832 | $24,145 | payroll benefits $24,145 (estimate) | $37,012 | page | |
| 2023-12 | $101,755 | $80,937 | $57,504 | $23,433 | payroll benefits $23,433 (estimate) | $20,818 | page | |
| 2024-01 | $101,837 | $123,405 | $99,107 | $24,297 | payroll benefits $24,297 (estimate) | −$21,568 | page | |
| 2024-02 | $97,401 | $86,130 | $63,397 | $22,733 | payroll benefits $22,733 (estimate) | $11,271 | page | |
| 2024-03 | $105,066 | $205,631 | $85,578 | $120,052 | payroll benefits $20,961 (estimate); transfers $99,092 (medium) | −$100,565 | page | |
| 2024-04 | $86,189 | $82,891 | $60,538 | $22,353 | payroll benefits $22,353 (estimate) | $3,298 | page | |
| 2024-05 | $155,146 | $191,822 | $84,856 | $106,965 | payroll benefits $13,876 (estimate); transfers $3,314 (medium); unclassified $89,776 | −$36,675 | page | |
| 2024-06 | $96,141 | $79,978 | $56,894 | $23,084 | payroll benefits $23,084 (estimate) | $16,163 | page |
610 Sewer: $856,195 not on vendor bills
Transfers to other funds $474,244 Estimate · Payroll and benefits (estimate) $228,220 Estimate · Kept in fund balances $153,730 Derived
| Report | Revenue | Borrowing | Treasurer's expenses | Vendor payments | Difference | Classified as | Change in balance | Source |
|---|---|---|---|---|---|---|---|---|
| 2023-07 | $126,671 | $118,564 | $91,476 | $27,087 | payroll benefits $17,545 (estimate); transfers $9,543 (medium) | $11,536 | page | |
| 2023-08 | $119,996 | $48,426 | $38,772 | $9,654 | payroll benefits $9,654 (estimate) | $69,305 | page | |
| 2023-09 | $111,066 | $50,468 | $23,281 | $27,187 | payroll benefits $27,187 (estimate) | $60,599 | page | |
| 2023-10 | $120,119 | $37,070 | $18,343 | $18,727 | payroll benefits $18,727 (estimate) | $83,049 | page | |
| 2023-11 | $112,233 | $278,854 | $46,994 | $231,859 | payroll benefits $21,025 (estimate); transfers $210,835 (medium) | −$166,621 | page | |
| 2023-12 | $104,527 | $39,956 | $17,639 | $22,317 | payroll benefits $22,317 (estimate) | $64,571 | page | |
| 2024-01 | $102,742 | $136,973 | $32,139 | $104,834 | payroll benefits $20,910 (estimate); transfers $83,924 (medium) | −$34,231 | page | |
| 2024-02 | $111,312 | $33,545 | $14,968 | $18,578 | payroll benefits $18,578 (estimate) | $77,766 | page | |
| 2024-03 | $105,112 | $68,926 | $40,681 | $28,245 | payroll benefits $20,960 (estimate); transfers $7,286 (medium) | $36,186 | page | |
| 2024-04 | $99,984 | $81,189 | $62,611 | $18,578 | payroll benefits $18,578 (estimate) | $18,795 | page | |
| 2024-05 | $106,836 | $247,935 | $71,402 | $176,532 | payroll benefits $13,874 (estimate); transfers $162,658 (medium) | −$141,099 | page | |
| 2024-06 | $108,023 | $32,986 | $14,119 | $18,867 | payroll benefits $18,867 (estimate) | $75,037 | page |
What "not on vendor bills" means
Of $12,968,915 not on vendor bills in FY2024 (July 2023 – June 2024), $8,505,270 was spent in ways the payables lists do not show (bond payments, transfers, payroll, developer rebates) and $4,463,645 was not spent: it stayed in the funds, mostly as borrowing not yet used.
| Part | Amount | Basis |
|---|---|---|
| Debt service (paying agent) | $3,144,089 | Derived high confidence |
| Transfers to other funds | $2,631,589 | Estimate medium confidence |
| Payroll and benefits (estimate) | $1,642,087 | Estimate medium confidence |
| TIF developer rebates | $52,911 | Estimate medium confidence |
| Unclassified (not on vendor bills) | $1,034,593 | Derived |
| Unspent borrowing (still in the fund) (not spent) | $2,281,015 | Derived high confidence |
| Kept in fund balances (not spent) | $2,182,630 | Derived medium confidence |
| Total not on vendor bills | $12,968,915 | Derived |
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,443,463 of the $2,631,589 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 $188,126 is not identified, so it is still inside the revenue total (counted twice). Estimate
- Every month of the period has a Treasurer's report.
- Fund 340 Recreation Center prints an actual ending balance of 0 in 2 report(s) while its calculated ending balance reaches $-3,340 (2024-06). 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
Data last updated October 28, 2026. Built from the archive's documents; see how the data is built.