Chapter 34: Paper vs. Spreadsheet vs. QMS Software: A Decision Framework for Your Plant Size

Small Operations: When a Well-Built Spreadsheet Is Genuinely Enough

If your plant has fewer than 50 employees, ISO 9001 does not require enterprise software. A properly designed Excel corrective action register—with clear naming conventions, version control, and systematic retention—passes audits regularly. We've seen auditors approve spreadsheet-based systems when they contained all 12 mandatory fields, showed evidence of controlled access (shared drive with backup), and demonstrated consistent closure discipline.

The critical condition: the spreadsheet must be treated as a controlled document. This means:

• A master copy stored on a backed-up network drive (not personal desktops)
• A clear versioning scheme (CAR Register v2026-01, v2026-02, etc.)
• Read-only access for most staff; edit rights limited to your quality lead
• Monthly or quarterly archival of closed CARs to a read-only folder
• A change log row at the top noting who made what change and when

Small manufacturers often use a spreadsheet combined with a shared folder structure: Active CARs in one sheet, Historical/Closed CARs in an archived folder, with a one-page checklist template (printed or digital) that operators fill out when they discover a nonconformance. That checklist becomes the attachment to the CAR number in your register.

The downside: there's no automatic email reminder when a CAR is 30 days past due, no audit trail showing who changed a root cause statement on day 5, and no linked dashboard showing your trending. Your quality lead has to manually chase overdue CARs.

Mid-Size Operations: The Spreadsheet Ceiling

Between 50 and 100 employees, your spreadsheet system begins to strain. Multiple quality team members are touching CARs. Manufacturing sites or shift changes mean different people closing actions. You start losing track of who approved what.

An auditor asks, "Can you show me the audit trail of changes to this CAR's RCA section?" and you can't. This is when organizations typically invest in a dedicated QMS platform. The payoff becomes measurable within 3–6 months.

Large or Multi-Site Operations: eQMS Platforms Are Now Standard

Above 100 employees or across multiple locations, a cloud-based or on-premise QMS platform is the norm in 2026. Leading platforms used by Canadian manufacturers include:

• ETQ Reliance (widely adopted in automotive and heavy equipment)
• MasterControl (strong in medical device and pharma, increasingly in industrial)
• Qualio (cloud-native, strong user experience, growing in mid-market)
• InfinityQS ProFicient (historically SPC-focused, now integrated CAPA modules)
• Intelex (enterprise-scale, full EHS integration)

  These platforms offer capabilities that spreadsheets fundamentally cannot:

• Automated workflow routing: CAR is assigned → RCA must be completed by date X → on date X–5, responsible person gets a reminder → once RCA is approved, verification task auto-creates
• Immutable audit trails: every change (who, what, when, why) is logged and cannot be deleted
• Trending dashboards: real-time visibility into open CARs by source, overdue CARs, recurrence patterns (same root cause appearing in CARs 23, 47, and 61)
• Linked CA-to-document change: when a CAR identifies a control plan flaw, the system can auto-link to the document revision number that corrected it
• Integration with inspection/SPC data: directly pull nonconformance triggers from your inspection system or statistical process control software

Pro Tip: The software doesn't replace discipline; it enforces it. A weak corrective action process with perfect software is still weak. A mature, well-trained team with a spreadsheet system can pass an audit. The software multiplies the effectiveness of a process that's already solid.