Tiffin Civic Chronicletiffin.cc

Cash-flow reconciliation, FY2024 (July 2023 – June 2024)

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
$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

Per fund, FY2024. 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. Filtered: Payroll and benefits (estimate) (show every fund); the total row is every fund's.
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 $3,439,489 $3,893,351$2,122,900$1,770,451 $323,784$795,808$650,859$453,862 −$448,322
110 Road Use Tax $792,414 $793,930$570,414$223,515 $202,133$21,382$1,516 −$135
112 Employee Benefit $243,929 $303,671$122,577$181,094 $18,101$162,993$59,742 −$59,742
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

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
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

Fund page

110 Road Use Tax: $223,515 not on vendor bills, $1,516 from its balance

Payroll and benefits (estimate) $202,133 Estimate · Unclassified (not on vendor bills) $21,382 Derived

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
2023-07$50,708 $220,234$192,027$28,206 payroll benefits $18,620 (estimate); unclassified $9,586 −$165,117 page
2023-08$50,317 $34,908$26,960$7,949 payroll benefits $7,949 (estimate) $12,382 page
2023-09$70,494 $65,122$41,667$23,454 payroll benefits $18,620 (estimate); unclassified $4,834 $5,372 page
2023-10$50,657 $64,319$46,707$17,612 payroll benefits $17,612 (estimate) −$13,662 page
2023-11$49,944 $74,168$56,666$17,502 payroll benefits $17,502 (estimate) −$24,224 page
2023-12$54,415 $81,912$64,586$17,326 payroll benefits $17,326 (estimate) −$27,498 page
2024-01$52,820 $66,770$49,022$17,748 payroll benefits $17,748 (estimate) −$13,950 page
2024-02$88,233 $40,075$22,477$17,598 payroll benefits $17,598 (estimate) $48,159 page
2024-03$121,565 $34,144$8,563$25,581 payroll benefits $18,620 (estimate); unclassified $6,961 $87,421 page
2024-04$51,680 $34,896$17,588$17,309 payroll benefits $17,309 (estimate) $16,784 page
2024-05$79,642 $47,320$30,172$17,147 payroll benefits $17,147 (estimate) $32,322 page
2024-06$71,940 $30,063$13,980$16,082 payroll benefits $16,082 (estimate) $41,878 page

Fund 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

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
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

Fund 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

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
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

Fund 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

ReportRevenueBorrowingTreasurer's expensesVendor paymentsDifferenceClassified asChange in balanceSource
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

Fund 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.

The band, part by part, FY2024 (July 2023 – June 2024). The parts add up exactly to $12,968,915.
PartAmountShareBasisHow it is found
Debt service (paying agent) $3,144,08924.2% 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 2023-11, fund 200; Treasurer's report 2024-05, fund 200; Treasurer's report 2023-12, fund 611; Treasurer's report 2024-06, fund 611
Transfers to other funds $2,631,58920.3% 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. $55,598 matches a worksheet figure to the dollar; the rest is placed by month and fund (see the reconciliation table).
Sources: Treasurer's report 2024-01, fund 001; Treasurer's report 2024-03, fund 001; Treasurer's report 2024-05, fund 001; Treasurer's report 2023-07, fund 112; Treasurer's report 2024-02, fund 121; Treasurer's report 2023-11, fund 125 and 6 more pages (reconciliation table)
Payroll and benefits (estimate) $1,642,08712.7% 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. 12 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 2023-07, fund 001; Treasurer's report 2023-08, fund 001; Treasurer's report 2023-09, fund 001; Treasurer's report 2023-10, fund 001; Treasurer's report 2023-11, fund 001; Treasurer's report 2023-12, fund 001 and 6 more pages (reconciliation table)
TIF developer rebates $52,9110.4% 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). The TIF register's state report prints $239,294 of rebates for FY2024.
Sources: Treasurer's report 2024-06, fund 125; budget worksheet, fund 125 FY2023 (activity $78,426); budget worksheet, fund 125 FY2024 (activity $79,394); budget worksheet, fund 125 FY2025 (activity $462,493); TIF register, FY2024 state rebate report
Unclassified (not on vendor bills) $1,034,5938.0% 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 2023-07, fund 001; Treasurer's report 2024-05, fund 001; Treasurer's report 2024-06, fund 001; Treasurer's report 2023-09, fund 110; Treasurer's report 2024-03, fund 110; Treasurer's report 2023-12, fund 340 and 3 more pages (reconciliation table)
Unspent borrowing (still in the fund) (not spent) $2,281,01517.6% 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) $2,182,63016.8% Derived medium confidence Revenue the fund did not spend in the period: its balance went up.
Total not on vendor bills$12,968,915100%Derived$8,505,270 spent without a vendor bill + $4,463,645 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,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.