How to Build an Apparel Compliance Matrix in Excel
A compliance matrix is one sheet with one row per SKU and one column per piece of evidence, plus formulas that tell you what is missing. You can build a useful one in under an hour.
Want to skip the build? Use the free template.
Step 1: Choose the row level
Use one row per SKU if materials differ by variant, or one row per style if they never do. Do not mix levels in the same sheet.
Step 2: Set up the columns
| Group | Columns | Why |
|---|---|---|
| Identity | SKU, style, variant, product type | Joins to your Shopify export |
| Material | Fiber 1–3, percentages | Label consistency |
| Labeling | Origin, company name or RN, care label | Core label elements |
| Source | Supplier, factory | Traceability |
| Evidence | Document type, reference, expiry | Proof for what you state |
| Review | Last review, next review, owner | Accountability |
| Result | Open issues, status | Prioritisation |
Step 3: Add data validation
Use Data > Data Validation > List so people select rather than type.
- Put allowed values on a separate Lists sheet.
- Point each dropdown at its list range, for example
=Lists!$A$2:$A$60. - Add a percentage rule (decimal between 0 and 100) on the fiber percentage columns.
Step 4: Add the formulas
Total fiber percentage:
=IF($A2="","",SUM($F2,$H2,$J2,$K2))
Fiber check:
=IF($L2="","",IF(ROUND($L2,1)=100,"OK","Check total"))
Next review date, 180 days after the last review:
=IF($X2="","",$X2+180)
Overdue flag:
=IF($Y2="","",IF($Y2<TODAY(),"Overdue",""))
Open issues, joining messages for blank required cells:
=TRIM(IF($N2="","Origin missing. ","")&IF($O2="","Company ID missing. ","")&IF($M2<>"OK","Fiber total. ",""))
Step 5: Add conditional formatting
- Red fill when the status is not OK.
- Amber fill when the next review date is within 30 days.
- Grey text for the example row so it is not mistaken for data.
Step 6: Summarise
Use COUNTIF on the status column for totals, and a small pivot table by supplier to see which suppliers cause the most gaps.
Keep it usable
- Freeze the header row and the SKU column.
- Turn on filters.
- Protect formula columns so they are not overwritten.
- Keep one owner for the file, with a change log.
When Excel stops being enough
A spreadsheet works for hundreds of rows with one or two editors. Beyond that, shared editing and version drift become the problem. See CSV versus manual audits.
Frequently asked questions
Do I need macros? No. Dropdowns, formulas and conditional formatting are enough.
Can I use Google Sheets? Yes. The same formulas work.
What should a status mean? Define it once: for example OK means every required column is filled and no document has expired.
Related guides
Sources: Microsoft Support, Apply data validation to cells · FTC, Threading Your Way Through the Labeling Requirements
Not legal advice. Check requirements for your products and markets.