The Six-Spreadsheet Scramble That Makes Tier II Wrong Every March: EPCRA §312 Reconciliation Failure Modes

February 14, 2:47 PM. Six Tabs Open.

The safety manager has six spreadsheets open and the Tier II form on a seventh tab. Procurement sent a chemical-purchase ledger. The SDS library was exported from SharePoint to Excel. Operations did a plant-floor walk last week. Safety inspections logged “chemicals found in cabinets and on benches” that nobody cross-referenced against the SDS library. Environmental keeps hazwaste manifests in its own tracker. Contractors who came on-site for the September shutdown brought their own materials, and most of those forms never made it past the receiving dock.

Six lists describe the same physical inventory from six different angles. The Tier II form due March 1 pulls from all of them. The lists do not reconcile.

The safety manager files anyway because March 1 is a statutory deadline EPA cannot extend (EPA — Tier II deadline extensions). The form is wrong in ways nobody catches until an enforcement officer pulls it years later.

This post catalogs the six reconciliation failure modes that make Tier II inaccurate when a facility runs on multiple spreadsheets. It is not about whether to leave spreadsheets for an EHS platform — that’s our Three-Trigger Pattern post from May 10. It is not about whether the March 1 deadline applies — that’s Does the March 1 Deadline Apply to Your Facility?. This is for the facility that has been filing for years and keeps producing a form that doesn’t match reality.

What the Form Actually Requires

EPCRA Section 312 (42 U.S.C. § 11022; 40 CFR Part 370 Subpart C) requires the Tier II by March 1 each year for the prior calendar year, sent to the SERC, LEPC, and local fire department.

The form at 40 CFR 370.42 requires, for each reportable chemical: name or common name as on the SDS plus the CAS registry number; maximum amount on any single day (range code per 40 CFR 370.43 or specific weight); average daily amount across the days on-site, and the number of days on-site; physical state and EPCRA hazard categories under 40 CFR 370.66; storage locations, types, and pressure/temperature codes.

Reporting thresholds at 40 CFR 370.10: for EHSs on 40 CFR Part 355 Appendix A, 500 pounds or the TPQ, whichever is lower — TPQs range from 1 to 10,000 pounds. For everything else requiring an OSHA SDS under 29 CFR 1910.1200, 10,000 pounds at any single time during the calendar year. The “any single time” language is load-bearing — not the year-end balance, not the average.

The Penalty Math

EPA adjusts EPCRA penalties annually under the Federal Civil Penalties Inflation Adjustment Act. The 2025 adjustment at 90 FR 1375 (Jan 8, 2025) set the §11045(d)(1) maximum at $71,545 per violation, with headline maximums for the most serious EPCRA provisions running up to $174,985 per day, per violation (Federal Register Vol. 90, No. 5; 40 CFR 19.4).

EPA’s docket shows what those numbers look like in practice. In 2024, EPA filed administrative settlements with three Southeast Region facilities for §312 violations — OFS Fitel in Norcross, Georgia at $38,852 for failure to file; Koch Foods of Gadsden; and Purafil, Inc. for combined §312/§313 violations (EPA — Southeast Region EPCRA settlements, 2024). In December 2025, EPA announced a $262,971 settlement with Delta Packing of Lodi for combined Clean Air Act and EPCRA violations including failure to submit Tier II forms (EPA — Lodi Facility Enforcement Action, Dec 2025).

None of these turn on dramatic events. They turn on forms not filed, filed late, or filed wrong. Reconciliation failure is the bridge between “we tried to file” and “the form is wrong.” Here are the six ways the bridge collapses.

Failure Mode 1 — Chemical-Naming Inconsistency

A Kansas chemical processor has a 5,000-gallon tank of 50% sodium hydroxide solution feeding a neutralization line. Inventory shows up under four names: procurement bought “caustic soda 50% solution”; the SDS library has “sodium hydroxide solution, 50%”; the plant-floor walk recorded “NaOH” on the tank label; the contractor delivery paperwork said “lye.”

All four refer to the same physical material. Section 311 requires SDS submission to the SERC, LEPC, and fire department within three months of first appearance on-site (40 CFR 370.30). Section 312 requires the Tier II to identify the chemical as on that SDS. EPA’s General Reporting Guidance is explicit: the identifier used in §311 and §312 must be consistent (EPA — General Reporting Guidance).

Downstream effect: the form says “sodium hydroxide solution, 50% — 8,000 lb max” with no entry for the 1,500 lb “caustic soda” tote in the warehouse, because that tote was on a different spreadsheet under a different name. The chemical is under-reported by 1,500 lb. Failure Mode 1 directly causes Failure Mode 4.

Failure Mode 2 — CAS Number Missing or Mismatched

The CAS Registry Number is the identifier that crosses naming conventions cleanly. Sodium hydroxide is CAS 1310-73-2 whether the spreadsheet calls it caustic, NaOH, lye, or sodium hydroxide. The Tier II form requires either the CAS as on the SDS or a check in the “Not Available” box (EPA Tier II Inventory Form Instructions, v.17).

Two failures show up. Missing CAS — older SDSs sometimes omit it; procurement spreadsheets have the field blank — so the Tier II line goes out with “Not Available” when the CAS is in fact known. Mismatched CAS for mixtures — a 50% caustic solution can be reported as the mixture or by component, but EPA’s reporting guidance requires the reporting option be consistent between §311 and §312. A facility cannot report the mixture under §311 and break out components under §312, or vice versa.

Downstream effect: state portals validate CAS against 40 CFR Part 355 Appendix A. A mismatched CAS removes the chemical from the right threshold pool and adds it to a wrong one. The fire department receives incorrect hazard data.

Failure Mode 3 — Maximum Quantity vs Average Daily Quantity Confusion

This is the most common single error and the one that produces under-reporting at threshold-crossing levels.

The Tier II form requires two amounts, defined precisely at 40 CFR 370.42(b)(2)–(3): Maximum amount is the largest quantity present on any single day during the calendar year. Average daily amount is averaged over the days the chemical was on-site, not over 365 days.

The safety manager pulls the December 31 inventory snapshot from the plant-floor walk because it’s the most recent count. The form goes out with the year-end balance in the maximum amount field.

Consider a facility that ramped from 6,000 lb of acetone in January to 12,000 lb during an August production push, drew it down to 4,000 lb by November, and held 4,000 lb through year-end. The 10,000 lb threshold under 40 CFR 370.10(a)(2) was crossed in August. File the year-end number and the form either says acetone wasn’t reportable (the chemical disappears entirely) or that acetone peaked at 4,000 lb (misrepresented by a factor of three).

Mirror error: putting the year-end inventory in the average daily field. A chemical present 90 days at an average of 7,000 lb during that window has an average daily of 7,000 lb on the form, not (90/365) × 7,000 = 1,725 lb.

Failure Mode 4 — Threshold Aggregation Gaps (Same Chemical, Different Names)

This failure mode creates non-filings — the most expensive category in the enforcement docket.

A facility has sodium hydroxide solution across three spreadsheets:

Production tank (plant-floor walk): 8,000 lb of “sodium hydroxide solution 50%.”
Warehouse tote (safety inspection): 1,500 lb of “caustic soda 50%.”
Maintenance shop: 800 lb of “NaOH.”

Each entry is below 10,000 lb. The Tier II goes out without sodium hydroxide because nobody added them — three spreadsheets, three names, no aggregation. Total on-site: 10,300 lb. The 40 CFR 370.10(a)(2) threshold was crossed. The form should have reported sodium hydroxide. It did not.

This is the failure mode behind the 2024 OFS Fitel ($38,852), Koch Foods, and Purafil settlements — failures to file Tier II for chemicals that should have been on the form. In most cases it isn’t deliberate avoidance; it’s reconciliation failure. The chemical exists under multiple names on multiple spreadsheets, no source aggregates the same physical material across locations, and the threshold quietly gets crossed.

40 CFR 370.10(a) sets the threshold on “each hazardous chemical present at the facility.” Same chemical = same threshold pool, regardless of internal name or storage location (EPA Chapter 5, January 2022). Failure Mode 1 is the root cause; a reconciliation pass anchored on CAS — not name — eliminates this category of failure.

Failure Mode 5 — Unit-of-Measure Inconsistency

Procurement tracks gallons. The SDS lists density in g/mL. The plant-floor walk records pounds for solids and gallons for liquids. The threshold under 40 CFR 370.10 is pounds, not gallons.

A facility with 2,500 gallons of 93% sulfuric acid — specific gravity around 1.84 — has about 38,400 lb on-site. Procurement shows “2,500” without converting. Pull that onto the form and the Tier II reports 2,500 lb. Sulfuric acid is an EHS with a TPQ of 1,000 lb; actual is 38× the TPQ, reported is 2.5×. The SERC, LEPC, and fire department receive misleading hazard data.

Related error: reporting the solution weight when the basis should be the active ingredient. For EHS components mixed below the de minimis threshold, the reporting basis shifts to the component (EPA — Two Threshold Planning Quantities). A 5,000 lb tank of 12.5% sodium hypochlorite bleach contains 625 lb of sodium hypochlorite. Inconsistent choices across the six feeder spreadsheets produce a Tier II that contradicts itself.

Failure Mode 6 — Physical State and Hazard Category Coding Errors

40 CFR 370.66 defines the physical and health hazard categories on the Tier II form. The list has changed twice in fifteen years: from the original five broad categories to 24 expanded categories after the 2012/2013 rulemaking, and now expanding again to align with the 2024 OSHA HCS under EPA technical amendments published November 17, 2025 (90 FR 51187). The 2025 amendments expand to approximately 112 OSHA-aligned hazard categories with a compliance start of January 16, 2026.

Two patterns emerge. Facilities that built spreadsheet hazard codes in 2014 are using the 24-category set; the rule alignment is moving and the form output is on a clock. Facilities that copy hazard codes from procurement specs, freight classification sheets, or generic chemical references rather than from Section 2 of the actual SDS are coding from the wrong source. The SDS is the authoritative source under 40 CFR 370.42.

Downstream effect: the SERC, LEPC, and fire department receive misleading hazard information — the exact recipient harm EPCRA was written to prevent. Wrong categories produce a wrong first-responder posture.

State Reconciliation Quirks

The six failure modes compound across states. A multi-state filer exports inconsistent names into each portal, and each validator rejects for different reasons. For iSi’s region:

Kansas (KDHE Tier II Online): filing fee of $25 to $300 per facility, capped at $3,000 per owner/operator per year (K.A.R. 28-65-4); LEPC and fire department copies required separately.
Missouri (MERC / DPS): per-chemical and per-facility fees plus a $10 optional distribution charge. Missouri does not accept the federal Tier2 Submit file; only the Missouri Tier II form is accepted, so every chemical is re-keyed. Missouri also requires a 24-hour fire department notice for explosives and blasting agents held over 100 lbs.
Oklahoma (DEQ): Tier2 Submit through DEQ Online Filing. Oil and gas production and ag chemical dealers: $12/facility, $1,000/company cap.
Texas (TCEQ / DSHS STEERS): STEERS portal, fees auto-calculated by facility type, state-specific data fields beyond federal Tier II.
Kentucky (KYEM Tier II Manager): tiered fees — Cat 1 no fee, Cat 2 $40, Cat 3-5 $250; $250 one-time late fee after March 1 under 106 KAR 1:081.
Arkansas (ADEM): Tier2 Submit .t2s upload. $50 first three chemicals, $10 each additional three, $1,000 facility ceiling.

A facility that fixes the six federal failure modes on its master spreadsheet has done most of the multi-state work — the per-state add-ons are then mechanical.

What a Reconciliation Pass Looks Like

A clean reconciliation produces a single master chemical inventory that feeds Tier II, the §311 SDS submissions, the air permit emissions inventory, and the RCRA hazardous waste generator status — one source of truth, multiple downstream reports.

Master chemical list anchored on CAS, not name. “Caustic soda,” “sodium hydroxide solution,” “NaOH,” and “lye” all collapse to one line under CAS 1310-73-2.
Quantity rolled up across all storage locations. Production tanks, warehouse totes, maintenance shops, contractor staging — aggregated against the master line.
Maximum-on-any-day quantity tracked by month or by significant event (production ramps, deliveries, shutdowns) — not by year-end snapshot.
Density and conversion logic in place. Gallons-to-pounds, percent-active-to-total, documented at the master line.
Hazard categories pulled from Section 2 of the current SDS, not procurement specs or legacy spreadsheet codes.
§311 / §312 reporting choice locked. Mixture vs component, decided once, applied consistently across both submissions.

Once in place, this can be maintained quarterly with much smaller effort than the annual February scramble.

The Cost Comparison

A focused Tier II reconciliation engagement at a mid-size facility — 200 to 500 line items across the six feeder spreadsheets, single or two states — runs in the $8,000 to $25,000 range depending on chemical count and complexity. That includes the reconciliation memo, the master inventory in SERC-acceptable format, and a quarterly maintenance protocol.

The comparison number is the enforcement docket. The lowest publicly reported 2024 §312 settlement in EPA’s Southeast Region was $38,852 at OFS Fitel for failure to file. The December 2025 Delta Packing CAA/EPCRA settlement landed at $262,971. The 2025 statutory maximum under 42 U.S.C. 11045(d)(1) sits at $71,545 per violation; the headline maximum for more serious EPCRA provisions reaches $174,985 per day, per violation.

A reconciliation engagement costs less than the lowest publicly reported settlement in the docket. It is not a hedge against worst-case enforcement — it is a hedge against the most common-case enforcement, which is a facility that filed Tier II but filed it wrong.

Where iSi Fits

Fixed-scope reconciliation engagement. A one-time pass through the six feeder spreadsheets, producing one reconciled inventory that feeds Tier II, §311 SDS submissions, and the air permit emissions inventory. Closes with a reconciliation memo, master inventory in SERC-acceptable format, and a quarterly maintenance protocol.

EHS COOP retainer with Tier II built in. Tier II preparation, §311 SDS updates within the three-month rule under 40 CFR 370.30, and quarterly inventory reconciliation absorbed into the broader EHS support footprint — chemical inventory work doesn’t spike once a year.

Our May 10 post on the spreadsheet-to-platform decision frames a different question — whether the data should live somewhere other than spreadsheets at all. This post fixes the data the facility already has. Tier II goes wrong in the same six ways at most facilities. The fix is mechanical once the failure modes are named.

Sources: 40 CFR Part 370; 40 CFR Part 355 Appendix A; 40 CFR 19.4; EPA EPCRA Hazardous Chemical Inventory Reporting General Reporting Guidance; EPA Chapter 5: EPCRA Sections 311 and 312 (Jan 2022); EPA Tier II Form Instructions v.17; 90 FR 1375 (Jan 8 2025); 90 FR 51187 (Nov 17 2025); EPA Southeast Region EPCRA settlements (2024); Lodi/Delta Packing settlement (Dec 2025); state agency resources for KDHE, MERC, OK DEQ, TCEQ, KYEM, ADEM.