Case Study: One Town's Check Register, 15 Public Company Tickers

Geneva, Illinois publishes bi-weekly check registers listing every payment the city makes. Municipal Alpha resolves vendor names to stock tickers automatically. A single check register contains payments to 10-15 publicly traded companies. Across 9 years of bi-weekly reports, that builds a continuous revenue signal for companies like Grainger, Tyler Technologies, Comcast, Waste Management, and others. Nobody else is reading 2,500 municipal check registers bi-weekly.

9years of check registers
15+public company tickers
~200bi-weekly registers
2,500+municipalities at scale

What you're about to read

Every entry is a real document from the City of Geneva, Illinois. Population: 22,000. The links go to geneva.il.us. Each check register is a snapshot of municipal spending. Bi-weekly snapshots over 9 years build a time series. For any company that sells to municipalities, this is micro-revenue data below the threshold of any SEC filing, updated every two weeks.

The Signal Chain

January 3, 2017
Check Register
First register in the chain. Payments to Comcast, Grainger, AT&T, Home Depot, Staples, Dell. GWW is a recurring municipal customer for industrial supplies. This is the baseline. Grainger appears in nearly every register, bi-weekly payments for maintenance and operations.
Source: geneva.il.us →
August 7, 2017
Check Register
Tyler Technologies, American Water Works, Stantec, Verizon, Grainger, AT&T. TYL appears in the context of GIS-related services. Different signal type than Grainger. Tyler payments indicate a software contract, sticky, multi-year, high-margin revenue. One town is noise. The same pattern across 50 towns reveals TYL's government segment pipeline.
Source: geneva.il.us →
August 9, 2017
Check Register
Dedicated line item for "Household Hazardous Waste Collection Services." Waste Management (WM). Municipal contracts are long-cycle and geographically sticky. Contract renewals or losses are visible in the payment stream months before they hit quarterly earnings.
Source: geneva.il.us →
November 27, 2017
Check Register
"Electric Utility Geographic Information System" contract. Tyler Technologies and Microsoft both appear. This is the highest-value signal type: a named contract for a specific system. Geneva's electric utility is committing to Tyler's platform for years. Microsoft appears as the infrastructure layer (Azure/SQL licensing). Both represent committed recurring revenue.
Source: geneva.il.us →
8 years of bi-weekly registers
January 5, 2026
Budget
FY 2026-27 Proposed Budget. Waste Management listed among continuing vendors, confirming contract continuity into FY27. Budget documents are forward-looking. When a vendor appears in a proposed budget, it signals the municipality expects to continue the relationship. This is pre-earnings intelligence: the contract renewal that won't show up in WM's next quarterly filing is already visible here.
Source: geneva.il.us →
February 17, 2026
Check Register
13 tickers resolved in a single bi-weekly cycle. TYL, CMCSA, GWW, AIQUY, NEE, AMZN, HD, UPS, USB, and more. Nine years after the first register, Grainger is still there. Tyler Technologies is still there. For any of these companies, an analyst watching municipal payment data would have seen 200+ data points from Geneva alone before the next 10-K is filed.
Source: geneva.il.us →

Why this matters

Municipal check registers publish weeks to months before vendor revenue appears in quarterly earnings. An equity analyst watching GWW payments across 100 municipalities would see geographic expansion or contraction before the earnings call.

A new town appearing in GWW's payment stream is a new customer. A town dropping out is a lost account. Neither event is visible in any filing until the quarter closes.

Three signal types:

Recurring supply payments (GWW, HD, AMZN) confirm ongoing customer relationships. Aggregated across municipalities, this reveals geographic footprint and seasonal patterns.

Contract awards (TYL, WM, STN) represent multi-year commitments. One contract in Geneva is noise. The same pattern across 50 towns is pipeline.

Utility and infrastructure payments (NEE, AWK, VZ, CMCSA) show which utility serves which municipality, and whether that changes, before it appears anywhere else.

What One Register Produces

Vendor Name (as printed)TickerSector
W.W. GraingerGWWIndustrial distribution
Tyler TechnologiesTYLGovernment software
ComcastCMCSATelecom / broadband
StantecSTNEngineering / consulting
VerizonVZTelecom
NextEra EnergyNEEUtilities
Airgas (Air Liquide)AIQUYIndustrial gases
Home DepotHDRetail / supplies
AmazonAMZNGeneral procurement
American Water WorksAWKWater utilities
Waste ManagementWMEnvironmental services
AT&TTTelecom
UPSUPSLogistics
U.S. BancorpUSBBanking / treasury
MicrosoftMSFTSoftware licensing

This is not insider information. Every check register cited above is a public document, published on a municipal website, available to anyone. The edge is not access. It's aggregation. No single check register moves a stock. 2,500 check registers, resolved to tickers, updated bi-weekly, with 9 years of history, is a dataset that doesn't exist anywhere else.

See what your tickers look like.

Pick a ticker. I'll pull the municipal payment history across every town in the network and show you what the signal looks like before it hits the 10-K.

Book a 15-Minute Data Review
Methodology note: All documents cited in this case study are public records published by the City of Geneva, Illinois. Every link above goes to the original source document on geneva.il.us. No proprietary data sources were used. Vendor-to-ticker resolution runs automatically on every accounts payable document ingested. The documents have always been public. They were just sitting on a city website, unread.