Back to Blog
Smart Factory

Still Managing Plant Chemicals in Spreadsheets? Digitalizing MSDS, GHS Labels, and Handling Records

Chemical inventories maintained separately by purchasing, production, and EHS become liabilities the moment an inspection or incident occurs. This guide covers a three-layer data model for digitalizing SDS version control, GHS labels, and handling records—and how to phase in MES integration.

POLYGLOTSOFT Tech Team2026-09-078 min read0
MSDSChemical ManagementOccupational SafetyManufacturing ComplianceSmart Factory

The Reality of Plants Where Chemical Management Is Still Paperwork

When we visit a manufacturing site and ask for the chemical inventory, we rarely receive a single file. Purchasing has a spreadsheet of purchase orders, production has a line-by-line material list, and the EHS officer keeps a folder of scanned SDS documents. Cross-checking the three often reveals a 20-30% discrepancy in the number of substances.

The causes of these mismatches are fairly predictable.

  • Substitute purchases: A discontinued cleaning agent is replaced with a similar product, but the SDS on file still refers to the old one.
  • Small trial quantities: A few kilograms brought in for R&D or pilot production bypass the formal registration process.
  • Contractor-supplied materials: Thinners, rust preventives, and sealants brought in by painting or maintenance contractors never appear on the site inventory.
  • The gap usually surfaces during an incident or an inspection. When an inspector asks which process used the substance, when, and in what quantity, spreadsheet-based management takes days to answer—because the usage history was never recorded in the first place.

    What Regulations Actually Require: Submission, Posting, Training, Records

    Under Korea's Occupational Safety and Health Act framework, chemical management obligations fall into four categories.

    SDS preparation and submission applies to manufacturers and importers, who must file with the Minister of Employment and Labor — in practice through the submission system operated by KOSHA. Sites that merely *use* chemicals are not subject to submission but must keep, post, and provide training on SDS. This distinction is a frequent source of confusion.

    The trade secret alternative disclosure system requires prior approval when a company wants to withhold component identity or concentration. Approvals carry an expiration date and require renewal tracking—a deadline easily missed in spreadsheet management.

    GHS labels must be affixed to containers and packaging, and inspections frequently cite the omission of *decanted* containers. A 20L transfer can drawn from a 200L drum without a label is a finding.

    Training records must be traceable by substance and by worker. Inspectors typically ask when a specific operator handling a specific substance received training; a department-level group training log alone is difficult to defend.

    Without a pre-review process for newly introduced substances, risk accumulates. If hazard classification, required PPE, storage conditions, and incompatibility with existing substances are not verified at the point of purchase, they get discovered only after an incident.

    The Data Model to Design Before You Digitalize

    The most common reason chemical digitalization projects fail is scoping them as an "SDS file upload system." Building a document repository alone leaves the inventory consistency problem untouched.

    We recommend a three-layer separation.

  • Substance master: Product name, manufacturer, components, CAS number, GHS hazard classification, physical hazards. Even when the same product is used across multiple sites, there is exactly one master record.
  • Site inventory: How many kilograms sit in which warehouse or storage area. This is the basis for storage limit management.
  • Process-level usage history: Which work order, which equipment, when, and how much was consumed. This is the evidentiary basis for incident investigation and emission estimates.
  • Connecting these three layers to purchase orders structurally reduces inventory gaps. When a new item is ordered, the system checks whether a substance master record exists and routes unregistered items through EHS approval. The key principle is that anything purchased is automatically brought under management.

    SDS should be managed as versions, not files. Revision history, revision date, and reason for revision belong in dedicated fields, and when a manufacturer issues a revision, the departments handling that substance should be notified. Setting automatic alerts 90 and 30 days before trade secret approval expiry prevents missed renewals.

    Tangible Gains from MES and EHS Integration

    Once chemical data connects to MES, compliance work becomes operational data.

  • Work order integration: Work orders display hazard information and required PPE alongside the input materials, so operators no longer need to hunt for separate documents.
  • Storage limit alerts: Current storage volume is calculated in real time against designated quantity thresholds, triggering alerts as limits approach. Receiving approval can block excess intake up front.
  • Emission and waste tallies: Emissions are estimated from the difference between input volume and product content, then reconciled against waste disposal records. The effort required for chemical release inventory reporting drops sharply.
  • Automated evidence generation: Usage history, training completion status, and label compliance status are generated on demand when inspectors request them.
  • In real deployments, the two to three weeks typically spent preparing the annual release inventory report can be reduced to a matter of days.

    A Phased Rollout for Small and Mid-Sized Manufacturers

    Many projects stall because they attempt everything at once. We recommend three phases.

    Phase 1 — Inventory reconciliation (1-2 months): Consolidate purchasing, production, and EHS records into a confirmed list of substances actually in use. This phase requires no system, and it is where missing SDS documents surface.

    Phase 2 — Document digitalization (2-3 months): Build the substance master, SDS version control, label printing, and training record management.

    Phase 3 — Usage history integration (3-6 months): Connect to MES work order and equipment data to automatically collect process-level consumption records.

    There is no need to replace an existing MES or ERP. In most cases, building a separate compliance module and integrating BOM, purchase order, and work order data through APIs is the better path in terms of both cost and risk.

    Work with POLYGLOTSOFT

    Drawing on our MES and smart factory implementation experience, POLYGLOTSOFT helps manufacturers digitalize chemical management on the plant floor. We advise on everything from designing a compliance module that attaches to your existing systems in stages, to work order integration and automated evidence generation—tailored to your site conditions. If you would like an assessment of your current management maturity and a rollout roadmap, please reach out through our [contact page](https://polyglotsoft.dev/en/support/contact).

    Need Technical Consultation?

    Our expert consultants in smart factory, AI, and logistics automation will analyze your requirements.

    Request Free Consultation