City spending: the payables lists

From the city's published payables lists, not official accounting. How these figures are built

Every bill the council approved on its payables list ("Expense Approval Report"), 2021 to today plus one 2018 claims report, read line by line from the published lists. Pick a year, a payee, a fund or a department to filter. From revenue to payee: cash-flow chart.

The lists in the archive add up to $66,857,922, a lower bound, in 19,909 line items paid to 818 payees. 130 of the 135 lists add up to their printed total.

Spending by year

No payables lists in the archive for 2019, 2020: those years are blank, not zero. 2018 is partial (2 lists). Coverage below 100% (parsed lines ÷ printed totals): 2021 93%. Some scanned lists are missing pages or have OCR misreadings.

Table: spending by year
Payables total by year
YearPaidLinesListsCoverage
2026 (so far)$24,389,2954,15421100%
2025$18,620,0854,22025100%
2024$8,828,0013,69324100%
2023$5,947,9803,37023100%
2022$4,008,4961,69415100%
2021$4,828,4482,6642593% lower bound
2020No lists in the archive
2019No lists in the archive
2018 (partial: 2 lists)$235,6171142100%
Reset

Payee: AUTOMATIC SYSTEMS

AUTOMATIC SYSTEMS business

$73,478 in 38 lines, Jan 19, 2021 to Oct 6, 2026, the payee's page

By year: 2021 $6,124; 2022 $2,140; 2023 $1,838; 2024 $31,131; 2025 $8,030; 2026 $24,216

Projects: Water Treatment Plant Upgrades (paid on project)

Top descriptions: PROCESSOR & POWER SUPPLY REPLACEMENT $7.9k; PANELVIEW REPLACEMENT $6.7k; WATER TOWER RTU, AIR TEMP TRANSMITTER $6.4k; LEVEL TRANSMITTER WELL 4 $4k; WWTP HARD DRIVE REPLACEMENT $3.7k; WELL 3 ANALOG OUTPUT CARD $3.3k; PROCESSOR BATTERIES $3k; DOT LIFT STATION TRANSDUC $2.9k

Top payees (matching lines)

Top payees
PayeePaidBar, to scale
AUTOMATIC SYSTEMS$51,695

All payees (JSON)

By fund

Paid by fund
FundPaidBar, to scale
610 Sewer$2,387,308

By department

Paid by department
DepartmentPaidBar, to scale
815 Sewer utility$3,159,760

Line items 30 lines, $51,695

Line items, filtered
DatePayeeDescription AccountAmountSource
Oct 6, 2026AUTOMATIC SYSTEMS LIFT STATION REPAIRS 610-815-6419 $350.00 p. 5: AUTOMATIC SYSTEMS, 2026-10-06 (PDF, opens in a new tab)
Oct 6, 2026AUTOMATIC SYSTEMS KELLER LEVEL RAT 610-815-6350 $15.31 p. 5: AUTOMATIC SYSTEMS, 2026-10-06 (PDF, opens in a new tab)
Jul 7, 2026AUTOMATIC SYSTEMS MAIN LIFT STATION FLOAT REPAIR 610-815-6490 $350.00 p. 3: AUTOMATIC SYSTEMS, 2026-07-07 (PDF, opens in a new tab)
Jul 7, 2026AUTOMATIC SYSTEMS MAIN LIFT STATION SERVICE 610-815-6490 $175.00 p. 3: AUTOMATIC SYSTEMS, 2026-07-07 (PDF, opens in a new tab)
May 19, 2026AUTOMATIC SYSTEMS PARK RD LIFT STATION INPUT… 610-815-6350 $2,437.57 p. 5: AUTOMATIC SYSTEMS, 2026-05-19 (PDF, opens in a new tab)
May 5, 2026AUTOMATIC SYSTEMS DOT LIFT STATION TRANSDUC 610-815-6350 $2,885.80 p. 3: AUTOMATIC SYSTEMS, 2026-05-05 (PDF, opens in a new tab)
May 5, 2026AUTOMATIC SYSTEMS PARK RD LIFT STATION 610-815-6490 $1,715.00 p. 3: AUTOMATIC SYSTEMS, 2026-05-05 (PDF, opens in a new tab)
May 5, 2026AUTOMATIC SYSTEMS WIN911 DOWN 610-815-6490 $756.25 p. 3: AUTOMATIC SYSTEMS, 2026-05-05 (PDF, opens in a new tab)
Mar 17, 2026AUTOMATIC SYSTEMS MOTHERBOARD BATTERY REPLACEMENT 610-815-6490 $1,358.18 p. 6: AUTOMATIC SYSTEMS, 2026-03-17 (PDF, opens in a new tab)
Mar 17, 2026AUTOMATIC SYSTEMS OUTPUT MODULE REPLACEMENT 610-815-6350 $2,485.65 p. 6: AUTOMATIC SYSTEMS, 2026-03-17 (PDF, opens in a new tab)
Mar 17, 2026AUTOMATIC SYSTEMS COMPUTER FAILURE REPAIR 610-815-6490 $2,255.00 p. 6: AUTOMATIC SYSTEMS, 2026-03-17 (PDF, opens in a new tab)
Jul 1, 2025AUTOMATIC SYSTEMS SEWER TREAT. PLANT LIFT STATION PROCESSOR REPAIR 610-815-6490 $1,580.00 p. 3: AUTOMATIC SYSTEMS, 2025-07-01 (PDF, opens in a new tab)
Sep 3, 2024AUTOMATIC SYSTEMS PROCESSOR & POWER SUPPLY REPLACEMENT 610-815-6350 $7,907.21 p. 3: AUTOMATIC SYSTEMS, 2024-09-03 (PDF, opens in a new tab)
Sep 3, 2024AUTOMATIC SYSTEMS FLOW METER ADJUSTMENTS 610-815-6350 $2,222.50 p. 3: AUTOMATIC SYSTEMS, 2024-09-03 (PDF, opens in a new tab)
Aug 6, 2024AUTOMATIC SYSTEMS PARK RD LIFT STATION VPN 610-815-6350 $350.00 p. 5: AUTOMATIC SYSTEMS, 2024-08-06 (PDF, opens in a new tab)
Jul 2, 2024AUTOMATIC SYSTEMS LIFT STATION HARD DRIVE 610-815-6350 $262.50 p. 4: AUTOMATIC SYSTEMS, 2024-07-02 (PDF, opens in a new tab)
Jul 2, 2024AUTOMATIC SYSTEMS WWTP HARD DRIVE REPLACEMENT 610-815-6350 $3,662.00 p. 4: AUTOMATIC SYSTEMS, 2024-07-02 (PDF, opens in a new tab)
Mar 5, 2024AUTOMATIC SYSTEMS WELL 3 ANALOG OUTPUT CARD 610-815-6350 $3,291.40 p. 2: AUTOMATIC SYSTEMS, 2024-03-05 (PDF, opens in a new tab)
Mar 5, 2024AUTOMATIC SYSTEMS PANELVIEW REPLACEMENT 610-815-6350 $6,706.71 p. 2: AUTOMATIC SYSTEMS, 2024-03-05 (PDF, opens in a new tab)
Mar 5, 2024AUTOMATIC SYSTEMS LEVEL TRANSMITTER WELL 4 610-815-6350 $3,991.00 p. 2: AUTOMATIC SYSTEMS, 2024-03-05 (PDF, opens in a new tab)
Jan 9, 2024AUTOMATIC SYSTEMS WWTP PROGRAM REPAIR 610-815-6350 $938.75 p. 4: AUTOMATIC SYSTEMS, 2024-01-09 (PDF, opens in a new tab)
Aug 8, 2023AUTOMATIC SYSTEMS WWTP PROGRAM SERVICE 610-815-6350 $175.00 p. 4: AUTOMATIC SYSTEMS, 2023-08-08 (PDF, opens in a new tab)
Jul 11, 2023AUTOMATIC SYSTEMS WWTP PROGRAM REPAIR 610-815-6350 $175.00 p. 5: AUTOMATIC SYSTEMS, 2023-07-11 (PDF, opens in a new tab)
Mar 15, 2022AUTOMATIC SYSTEMS WET WELL REPAIR 610-815-6350 $1,497.00 p. 4: AUTOMATIC SYSTEMS, 2022-03-15 (PDF, opens in a new tab)
Mar 15, 2022AUTOMATIC SYSTEMS WATEWATER PANEL PROGRAMING 610-815-6350 $561.00 p. 4: AUTOMATIC SYSTEMS, 2022-03-15 (PDF, opens in a new tab)
Mar 15, 2022AUTOMATIC SYSTEMS PRINTER CONTRACT 610-815-6350 $81.64 p. 4: AUTOMATIC SYSTEMS, 2022-03-15 (PDF, opens in a new tab)
Jul 6, 2021AUTOMATIC SYSTEMS WWTP PROGRAM REPAIR 610-815-6350 $1,030.75 p. 3: AUTOMATIC SYSTEMS, 2021-07-06 (PDF, opens in a new tab)
Jul 6, 2021AUTOMATIC SYSTEMS WWTP PROGRAM REPROGRA 610-815-6350 $990.00 p. 3: AUTOMATIC SYSTEMS, 2021-07-06 (PDF, opens in a new tab)
May 4, 2021AUTOMATIC SYSTEMS WWTP PUMP SUPPORT 610-815-6350 $165.00 p. 2: AUTOMATIC SYSTEMS, 2021-05-04 (PDF, opens in a new tab)
Apr 20, 2021AUTOMATIC SYSTEMS INSTALL OF OUTPUT CARD 610-815-6519 $1,323.50 p. 3: AUTOMATIC SYSTEMS, 2021-04-20 (PDF, opens in a new tab)

City staff and official reimbursements

Reimbursements the council approved on the payables lists for city employees and officials: mileage, travel and conferences, training and licenses, uniforms and gear, phones and supplies they paid for. Names are not shown; each line gives its purpose and links to the published list. Wages and payroll are not on the payables lists. $57,291.14 on 220 lines. Shown as one payee, City employee (reimbursement).

By year

Reimbursements by year
YearPaidLines
2018$13.661
2021$3,548.6225
2022$2,978.4012
2023$5,898.8830
2024$8,906.5647
2025$23,480.0255
2026$12,465.0050

By purpose

Reimbursements by purpose
PurposePaid
Training, tuition, certification and licenses$28,480.96
Mileage$19,552.18
Travel, meals and conferences$3,300.85
Other expense reimbursement$2,640.58
Uniforms, boots and safety gear$1,579.34
Supplies and purchases$1,102.96
Medical or wellness (details withheld)$634.27

By department

Reimbursements by department
DepartmentPaid
151 Fire department (training and gear)$26,514.22
650 City hall and general government$18,416.67
150 Fire department$4,582.67
160 Emergency medical services$3,742.01
810 Water utility$1,040.94
431 Recreation$720.25
610 Mayor$680.68
520 Economic development$406.20
410 Library$404.00
430 Parks$354.27
815 Sewer utility$317.10
210 Streets (road use tax)$82.49
170 Building and inspections$15.98
(no account)$13.66

JSON

Resident programs and rebates

Rebates and incentives the city paid residents under its own programs, from the payables lists. Residents' names are never shown: each payment is listed as "Individual (refund/reimbursement)" with its program. Refunds and deposits are not programs and are not counted here.

Resident programs and rebates
ProgramPaymentsPaidBy yearLines
SQR rebates
City of Tiffin Soil Quality Restoration rebate (SRF sponsored project); fund 332
92$102,298.17 2021: 88; $96,709.31
2022: 4; $5,588.86
every line

JSON

Account numbers are fund-department-object. Fund names come from the Treasurer's reports and the lists; department names are read from the lists' account summaries. Data-quality report (JSON).

About these figures
Figures are parsed from the payables lists, Treasurer's reports, receipts, pay applications and change orders the City of Tiffin published with its council agendas. They are not official accounting records. Every number links to the page it was read from; where a document's parsed lines do not add up to its printed total (coverage below 100%), the parsed amounts are a lower bound.
Payments to private individuals (refunds, deposits, reimbursements, coaches and officials) are shown as one payee, "Individual (refund/reimbursement)", without names; reimbursements to city staff and officials (mileage, travel, training, uniforms …) are shown as "City employee (reimbursement)" with their purpose; the source page is still linked.

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