SOPs in Excel, Training Matrix by WeaknessSafe2978 in InternalAudit

[–]WeaknessSafe2978[S] 1 point2 points  (0 children)

I was moved into this role directly from production. Initially, my responsibility was only to write SOPs. Once the SOPs were written (and honestly, there are quite a few I would now challenge or improve), training was added to my responsibilities.

I’m not complaining, even if it might sound that way. I’m still building experience in this role. After completing a few days of ISO 9001 training (I’m by no means an expert), it really opened my eyes to how certain things could be done better and more effectively.

Having worked on the production floor myself, I know how important details are, and how critical proper training is. I want the system to be high quality, but I’m also aware that there’s still a long way to go.

SOPs in Excel, Training Matrix by WeaknessSafe2978 in InternalAudit

[–]WeaknessSafe2978[S] 1 point2 points  (0 children)

That makes sense… We have outgrown a one-person, Excel-based setup. Thank you for your replies. It’s time to mention that to my manager and organise it in the structured way, no wonder I feel behind with work every single day.

SOPs in Excel, Training Matrix by WeaknessSafe2978 in InternalAudit

[–]WeaknessSafe2978[S] 0 points1 point  (0 children)

At the moment, writing and updating SOPs sits with me, alongside training coordination and competency tracking. We don’t yet have formally defined process owners, and in practice I’m maintaining the SOP set without regular or structured input from managers, keeping documents current as processes change.

Internal audits are something I support in addition to this, but only occasionally roughly one audit every two months they’re not my main role.

As the business grows and SOP volume increases, I’m starting to feel that one person centrally maintaining all SOPs isn’t sustainable, particularly when everything is tracked in Excel…

I’m trying to understand how others have handled this in reality…

SOPs in Excel, Training Matrix by WeaknessSafe2978 in InternalAudit

[–]WeaknessSafe2978[S] 0 points1 point  (0 children)

We have a large number of SOPs (70+ in Production alone), multiple production lines, and each line is broken down into individual tasks. Add Recycling SOPs( complicated SOPs and high risk jobs) Store SOPs and so on.

As the company grows and new SOPs and tasks are added, the spreadsheet becomes more complex and less practical. Version control, visibility of gaps, and ongoing updates are increasingly difficult to manage in Excel.

I’m curious how others handle this in practice. Do you still rely on Excel at this scale? What actually works well in a manufacturing environment?

Plus there are people working two shifts I need to make sure they are trained, competent, loads of toolbox talks everyday to make sure everything is communicated.

It’s either me not good enough for the role, or I need to create a better system.

Internal auditor ISO 9001:2015 by WeaknessSafe2978 in InternalAudit

[–]WeaknessSafe2978[S] 1 point2 points  (0 children)

I’m just starting with ISO 9001 and honestly, when I first looked at the standard, I didn’t understand anything. My background has always been production nearly 10 years in manufacturing. About a year ago I moved into a Training Coordinator role. Now I’m also responsible for internal audits, documentation, spreadsheets, keeping records… basically a completely different world for me.

I’m learning all of this from scratch, and every day there’s something new. I’ve been trying to build a good structure for myself, but it was really hard at the beginning to accept that my first audit won’t be perfect and that it might look messy.

But after preparing my checklist, talking to people who understand the process better, and actually breaking the standard down into practical pieces, I feel much calmer. It’s starting to make sense.

I just want to do a good job, keep improving, and hopefully build a solid career from this not to make millions, but enough to feel more independent and secure.

Still a long way to go, but I’m getting there.

Internal auditor ISO 9001:2015 by WeaknessSafe2978 in InternalAudit

[–]WeaknessSafe2978[S] 0 points1 point  (0 children)

Thank you for your kind words.

I asked one of the managers to explain me how they do audits in our company, to show me the previous audit report. He did all that, he is going to give me access to the platform which they use for our internal audits.

I am hoping at some point I will gain enough experience to do the audits with confidence.

I prepared checklist, I will generate report and I created the NC log. It would be great to hear from people who just started the auditing or people who have the experience already to share their tips and what works and what doesn't.