SOP Template & Training Matrix, Standard Operating Procedure Template, Operations Manual, Training Manual Template | Excel Google Sheets

Seller's description

Get your procedures out of your head and into one system: write each standard operating procedure (SOP), set who must know it, track who signed off on which version, and see exactly who needs retraining when something changes. For owners and managers of small teams: cafes, bakeries, salons, shops, crews and offices. Excel, Google Sheets, Word and Google Docs.

WHAT'S INCLUDED
1. SOP Register & Training Matrix workbook (Excel + Google Sheets), 9 tabs:
- Start Here: setup steps in plain English.
- Setup: review months for High, Medium and Low priority SOPs, due-soon window, new-hire training period, up to 12 departments and 15 job roles. Official sources listed.
- SOP Register (150 SOPs): ID, title, department, owner, approver, priority, status, version, effective date, last review, next review date, review status, people required, people trained, coverage % and a Check column.
- Who Needs It: tick the roles that must be trained on each SOP, once per role instead of once per person.
- People (100): role, start date, active, SOPs required, signed off, on an old version, missing, coverage and status.
- Training Log (1,000 sign-offs): date, person, SOP, version trained, trainer, signed off.
- Training Matrix: people down the side, SOPs across the top. ✓, Old, Missing or New in every cell.
- Change Log (300 changes): what changed in each version and whether retraining is needed.
- Dashboard: SOPs by status, reviews overdue or due soon, training coverage, old-version sign-offs, missing sign-offs, rows to fix and a table by department.
2. Four editable documents (Word + Google Docs): SOP Template (fields match the register); Operations Manual Template (roles, opening and closing, emergency action plan, hazard communication, food safety, training); SOP Writing Guide with 3 worked example SOPs; Training Sign-Off Record.
3. Start Here PDF with 5 Google copy links.

WHY IT'S DIFFERENT
- Version-aware: when you update an SOP, everyone trained on the old version shows "Old" until they sign off again. Most trackers mark people trained forever.
- Set it once per role: add a new hire with their role and their training list fills in. New hires show "New", not "Missing", during the training period you set.
- Review dates by priority, with a per-SOP override, so important procedures don't go stale.
- Catches messy data: duplicate SOP IDs, missing owners, retired SOPs still assigned, sign-offs for people not on the list, SOP ID typos, and missing or future dates.
- The documents match the workbook, and the writing guide shows how to write steps people actually follow.

TESTED
20 automated tests check every calculation against an independent model over 3 rounds, including hand-worked review dates, a version change, a full file of 150 SOPs, 100 people, 1,000 sign-offs and 300 changes, and random setups. Google Sheets matched the Excel/LibreOffice values cell by cell (6,809 cells, 0 differences), and every line of the 4 documents came through in Google Docs.

HOW TO GET IT
1. After you buy, go to your Etsy account > Purchases and download the zip. Etsy also emails you a link.
2. Open SOP-Manual-START-HERE.pdf. Click each link and choose "Make a copy" for Google, or open the .xlsx and .docx files in Excel and Word.
3. Look at the sample, clear it, and add your procedures, roles and team.

GOOD TO KNOW, PLEASE READ
- An organizing tool and templates, not legal or safety compliance advice. Some procedures and training are required by law (for example OSHA and food safety rules); official OSHA and FDA sources are included so you can check what applies to you.
- It's a spreadsheet: no quizzes, reminders or e-signatures. The matrix shows 30 SOPs at a time (change the start number to see the next 30).
- Compatible with Google Sheets and Docs (free Google account), Excel and Word 2010 or newer on Windows or Mac, and LibreOffice. Not designed for Apple Numbers or Pages.
- This is a digital download. Nothing physical will be shipped. Because it's a digital file, returns aren't accepted. If something isn't working, send me a message and I'll help.
- For your own business use. Please don't resell or share the files or links.

HOW THIS WAS MADE
I designed this kit with help from AI tools, which assisted with the formulas, layout, wording and sample data. I chose the features after comparing the SOP trackers, training matrices and SOP kits already available and what they leave out. I tested every calculation against an independent check (20 tests) and checked the documents before listing.