Skip to main content

Site Quantities & Reporting

Module: ChemIQ

Tellus calculates total chemical quantities at each site by breaking down products into their individual chemical components, converting units to a common standard, and aggregating across your entire inventory. This powers Tier II reporting, fire code compliance, and emergency planning — work that would otherwise take days of manual cross-referencing.

The Site Quantities page has five tabs:

  • Chemical Summary — Every chemical at your site with quantities, threshold status, and regulatory flags
  • Hazard Summary — Chemicals grouped by fire code classification with Maximum Allowable Quantity tracking
  • Inventory Over Time — How your total inventory has changed, with trend charts and top movers
  • Date Comparison — Side-by-side chemical quantity comparison between any two dates
  • Hazard Trends — Per-hazard-class progress toward fire code limits with projections and fire protection adjustments

Why It Matters​

Regulatory Requirements​

RequirementWho Needs ItWhat Is Required
EPCRA Tier II ReportFacilities with hazardous chemicals above 10,000 lbsAnnual report to state/local emergency planning agencies (due March 1)
Fire PermitsFacilities storing flammable/combustible liquidsMaximum Allowable Quantities per International Fire Code
Emergency PlanningFacilities with Extremely Hazardous SubstancesChemical inventory data for Local Emergency Planning Committee (LEPC)
InsuranceMany commercial operationsUnderwriters often require chemical inventory summaries

The Challenge Without Automation​

Your inventory tracks individual products — "5 gallons of Product X" and "10 liters of Product Y." But regulatory reporting needs chemical-level totals — "How many pounds of acetone are on site across all products?"

This requires looking up each product's SDS composition, converting different units to a common standard, multiplying by concentration percentages, summing across all products containing the same chemical, and comparing totals against regulatory thresholds. Tellus does all of this automatically.

How Calculations Work​

Step 1: Inventory Expansion​

Each product in your inventory is broken down into its individual chemical components using SDS composition data. A single cleaning product with 3 chemical ingredients becomes 3 separate entries for aggregation purposes.

Step 2: Unit Conversion​

All quantities are normalized to pounds (lbs) for weight and gallons (gal) for volume. Tellus handles conversions between ounces, kilograms, grams, liters, quarts, pints, fluid ounces, milliliters, and cubic feet.

For converting between weight and volume, Tellus uses chemical-specific densities when available, with water density (8.34 lbs/gal) as the default fallback.

Weight Conversions (to pounds)​

UnitConversion Factor
lbs1.0
oz0.0625
kg2.2046
g0.0022
mg0.0000022
ton2,000.0

Volume Conversions (to gallons)​

UnitConversion Factor
gal1.0
L (liter)0.2642
qt (quart)0.25
pt (pint)0.125
fl oz0.0078
mL0.000264
cu ft7.4805

Step 3: Concentration Adjustment​

Each chemical's contribution is adjusted by its concentration in the product. If a product contains 15% acetone, only 15% of the product's weight counts toward the acetone total.

Example: You have 3 bottles of a cleaner, each 1 gallon, and the SDS shows it contains 15% acetone:

  • Total item quantity = 1 gal x 3 = 3 gallons
  • Acetone contribution = 3 gal x 0.15 = 0.45 gallons
  • Acetone in pounds = 0.45 gal x 6.56 lbs/gal (acetone density) = 2.95 lbs

Step 4: Aggregation by CAS Number​

All contributions for the same CAS number are summed to get the site-level total for each chemical.

Step 5: Threshold Comparison​

Totals are compared against Tier II thresholds and International Fire Code Maximum Allowable Quantities. If you have configured Fire Protection Settings, the adjusted MAQ is used instead of the baseline.

Chemical Summary Tab​

Each row represents one unique chemical (CAS number) at your site:

ColumnWhat It Shows
CAS NumberThe chemical's registry number
Chemical NameCommon name from SDS composition
Quantity (lbs)Total pounds of this chemical at the site
Quantity (gal)Total gallons of this chemical at the site
ContainersNumber of containers holding products with this chemical
ProductsNumber of distinct products containing this chemical
HazardousWhether the chemical has GHS hazard classifications
Tier IIWhether the quantity exceeds the 10,000 lb threshold
Fire CodeWhether the quantity exceeds fire code limits (uses adjusted MAQ when fire protection is configured)

Status Cards​

Four summary cards at the top of the page give you the big picture:

  • Total Chemicals — Unique CAS numbers at this site
  • Hazardous — How many are classified as hazardous
  • Exceeds Tier II — How many exceed the 10,000 lb reporting threshold
  • Exceeds Fire Code — How many exceed fire code Maximum Allowable Quantities

You can narrow the Chemical Summary view using:

  • Search — Find chemicals by name or CAS number
  • Hazardous Only — Show only chemicals with GHS hazard classifications
  • Exceeds Threshold — Show only chemicals that exceed Tier II or fire code limits

Hazard Summary Tab​

Chemicals are grouped by fire code classification (Flammable Liquid, Oxidizer, Corrosive, Toxic) and fire code sub-class:

ColumnWhat It Shows
Hazard CategoryFire code category (for example, "Flammable Liquid")
Hazard ClassSub-class (for example, "IA" — flash point below 73 degrees F, boiling point below 100 degrees F)
Quantity (lbs/gal)Total for all chemicals in this hazard group
ChemicalsNumber of unique CAS numbers in this group
Fire Permit LimitMaximum Allowable Quantity from International Fire Code (adjusted when fire protection is configured)
% of LimitHow close you are to the fire code limit
ExceedsWhether you have exceeded the limit

When you have configured Fire Protection Settings, the Fire Permit Limit column shows your adjusted MAQ rather than the baseline IFC value. This gives you an accurate picture of how much capacity you actually have.

Inventory Over Time Tab​

The Inventory Over Time tab shows how your site's chemical inventory has changed over time. This view is powered by data from your Inventory Reconciliation sessions — each time you complete a reconciliation, a snapshot is captured that feeds into these trends.

Stat Cards​

Four cards at the top summarize your current position and recent changes:

  • Chemicals — Total unique chemicals at the site, with change since the previous period
  • Containers — Total container count, with change indicator
  • Total Weight — Aggregate weight in pounds across all chemicals, with change indicator
  • Reconciled — Number of reconciliation sessions completed this year, with an On track or Behind badge based on your reconciliation frequency

Each card shows the direction and magnitude of change (for example, "up 12 chemicals (+8%)" or "down 150 lbs (-3%)") so you can spot inventory growth or reduction at a glance.

Trend Chart​

Below the stat cards, an area chart shows your inventory over the selected time period. You can toggle between two views:

  • Weight — Total pounds on site over time
  • Containers — Total container count over time

Use the period selector at the top to choose a time range: 3M, 6M, 1Y, 2Y, or All.

Top Chemicals by Change​

A table (on desktop) or card list (on mobile) shows the chemicals with the largest quantity changes during the selected period. Each entry shows:

  • Chemical name and CAS number
  • Previous quantity and current quantity (in pounds)
  • Change amount and percentage, color-coded: red for increases, green for decreases
  • New badge for chemicals added during the period
  • Removed badge for chemicals no longer on site

Per-Chemical Drill-Down​

Click any chemical name in the Top Chemicals by Change list to expand an inline quantity history chart for that specific chemical. This shows you how that chemical's quantity has trended over time, with a quarterly summary table showing maximum daily amount, average daily amount, and days on site — the exact data points required for EPCRA Tier II reporting.

Click Close to collapse the drill-down and return to the overview.

Exporting​

Use the Export CSV and Export PDF buttons to download the Inventory Over Time data for your records or to share with auditors.

Date Comparison Tab​

The Date Comparison tab lets you compare your chemical inventory at any two points in time, side by side. This is useful for audits, Tier II preparation, and understanding how your chemical profile has shifted.

How to Use It​

  1. Set your dates using the two date pickers at the top:
    • As of — The more recent date (defaults to today)
    • Compare to — The earlier date (defaults to 90 days ago)
  2. Review the comparison table, which shows every chemical that was present on either date:
    • Chemical name and CAS number
    • Quantity on each date (in pounds)
    • Change in absolute terms and as a percentage
  3. Look at the color coding for quick scanning:
    • Red — Quantity increased
    • Green — Quantity decreased
    • New badge — Chemical was not present on the earlier date
    • Removed badge — Chemical is no longer present on the later date
  4. A summary row at the bottom shows total chemicals and net weight change across the entire comparison

Exporting​

Click Export PDF or Export CSV to download the comparison. These exports are useful for:

  • Documenting inventory changes for auditors or inspectors
  • Preparing Tier II annual reports (compare January 1 to December 31)
  • Sharing inventory change summaries with management

The Hazard Trends tab shows how each hazard class at your site is tracking relative to Maximum Allowable Quantities (MAQ) from the International Fire Code (IFC). Instead of just telling you where you stand today, this tab shows you the direction things are heading — and projects when you might reach a fire code limit.

What You See​

Each hazard class is displayed as a card with:

  • Hazard category and class — For example, "Flammable Liquid, Class IB"
  • Progress bar showing current quantity as a percentage of MAQ:
    • Green — Below 70% of MAQ (comfortable margin)
    • Amber — Between 70% and 90% of MAQ (approaching the limit)
    • Red — Above 90% of MAQ (at or exceeding the limit)
  • MAQ and current quantity in pounds, displayed side by side
  • Trend indicator showing the direction and rate of change:
    • For example: "Up 15% since Q4 — projected to reach MAQ by Aug 2026"
    • Or: "Down 8% since Q3 — stable"
    • Or: "Unchanged — stable"
  • Warning icon when a hazard class is above 80% of MAQ
  • Projected MAQ crossing date — If the hazard class is trending upward, Tellus estimates when you will reach the Maximum Allowable Quantity at the current rate of change

Use the period selector (3M, 6M, 1Y, 2Y, or All) to control the time window for trend calculations.

Why This Matters​

A fire marshal does not just want to know that you are currently compliant. They want to know that you have a handle on where things are going. The Hazard Trends tab gives you the data to show that you are actively monitoring your quantities against IFC thresholds — and taking action before limits are reached.

Exporting​

Click Export PDF to generate a formatted report of all hazard classes, their MAQ status, trend direction, and projected dates. This is useful for fire permit renewals and inspector walk-throughs.

Fire Protection Settings​

Fire protection measures installed at your facility can increase your Maximum Allowable Quantities under IFC Section 5003.1. The Hazard Trends tab includes a Fire Protection settings panel where you can configure these for each site.

What You Can Configure​

SettingWhat It DoesIFC Basis
Sprinkler systemDoubles your MAQ (2x multiplier)IFC Section 5003.1 — approved automatic sprinkler system
Flammable cabinetsEach approved cabinet adds approximately 120 gallons to your flammable liquid limitIFC Section 5003.1 — approved storage cabinets
Control areasEach control area gets its own MAQ — multiple areas multiply your total allowable quantityIFC Section 5003.1 — separated control areas with fire barriers

How to Configure​

  1. Navigate to the Hazard Trends tab on the Site Quantities page
  2. In the Fire Protection card at the top, click Configure (or Edit if already set)
  3. Check Sprinkler system installed if your facility has an approved automatic sprinkler system
  4. Enter the number of flammable cabinets (approved storage cabinets rated for flammable liquids)
  5. Enter the number of control areas at your site (minimum 1)
  6. Click Save & Recalculate

Tellus recalculates all MAQ values across the site using your fire protection settings. The adjusted MAQ is then used throughout:

  • Hazard Trends tab — Progress bars, percentages, and projected MAQ crossing dates
  • Hazard Summary tab — Fire Permit Limit column
  • Chemical Summary tab — Fire Code threshold status

Understanding Adjusted MAQ​

The baseline MAQ from IFC Table 5003.1.1(1) assumes the most restrictive conditions — no sprinklers, no approved cabinets, a single control area. Most facilities have at least some fire protection in place, which means the baseline numbers are more conservative than your actual limits.

When you configure your fire protection settings, Tellus calculates an Adjusted MAQ that reflects your real-world capacity. For example:

  • A facility with sprinklers storing Class IB flammable liquids has an adjusted MAQ of 240 gallons instead of the baseline 120 gallons
  • Adding 2 flammable cabinets to that facility adds approximately 240 gallons to the limit
  • With 2 control areas, the total MAQ doubles again

The Hazard Trends cards will show both the adjusted MAQ and the base MAQ when fire protection is configured, so you always have full visibility into how your limits were calculated.

Important: Only configure fire protection settings that are actually in place and properly maintained at your facility. Overstating fire protection measures to inflate your MAQ limits creates a compliance risk. Fire marshals verify these measures during inspections.

Tier II Reporting Thresholds​

EPA EPCRA Section 312 requires facilities to file annual Tier II reports for hazardous chemicals stored above these thresholds:

Chemical TypeThreshold
General hazardous chemicals10,000 lbs
Extremely Hazardous Substances (EHS)500 lbs

For Tier II reporting, Tellus tracks:

  • Maximum daily amount — The highest quantity on site during the reporting year
  • Average daily amount — The average quantity across the year
  • Days on site — How many days the chemical was present
  • Exceeds threshold — Whether any of these values trigger reporting requirements

The Date Comparison tab is particularly useful during Tier II preparation — compare your inventory at the start and end of the reporting year to understand annual changes. The Inventory Over Time per-chemical drill-down provides the quarterly quantity snapshots you need for each reportable chemical.

Fire Code Thresholds​

Based on the International Fire Code (IFC) Table 5003.1.1(1) — Maximum Allowable Quantities per control area for indoor storage:

Flammable and Combustible Liquids​

ClassDescriptionMax Quantity (gallons)
IAFlash point below 73 degrees F, boiling point below 100 degrees F30
IBFlash point below 73 degrees F, boiling point at or above 100 degrees F120
ICFlash point 73 to 100 degrees F120
II (Combustible)Flash point 100 to 140 degrees F120
IIIA (Combustible)Flash point 140 to 200 degrees F330
IIIB (Combustible)Flash point at or above 200 degrees F13,200

Oxidizers​

ClassMax Quantity (lbs)
14,000
2250
310
41 (any amount requires a permit)

These are the baseline values. Your actual limits may be higher if you have configured Fire Protection Settings for your site.

The % of Limit shown in the Hazard Summary and Hazard Trends tabs tells you at a glance how close each hazard category is to the fire code maximum. 50% means you are using half your allowable capacity. 100% means you have reached the limit.

Recalculation​

Click the Recalculate button on the Site Quantities page to refresh all aggregations. This reprocesses your entire inventory with the latest SDS composition data, unit conversions, density values, and fire protection settings. Recalculation is also triggered automatically when inventory changes are made or when you complete a reconciliation session.

Who Uses This​

RoleWhat You Can Do
AdminView all tabs for all sites; configure fire protection settings; trigger recalculations; export reports
ManagerView all tabs for managed sites; configure fire protection settings; run recalculations; export reports
Program CoordinatorView all tabs; use data for Tier II and fire marshal submissions; export comparison and trend reports
EmployeeNot available

Availability​

All Site Quantities features listed above — including Inventory Over Time, Date Comparison, Hazard Trends, and Fire Protection Settings — are included on every Tellus EHS account ($99/month).

Common Tasks​