Keeping track of cards and certs - what do you use?

[ChrisW_Midlands]

Just wondering what everyone uses to keep track of expiry dates on things like CSCS cards, first aid, insurance, etc. I've got 4 lads working for me and between them that's about 15 certs to keep tabs on.
Had a close call last month where one of my guys turned up on site with an expired CSCS card. Luckily the principal contractor didn't check that day but it could have been a nightmare.
I was using a spreadsheet but honestly I just forget to check it. Recently started using something called www.amberline.app which sends email reminders before things expire. Does the job so far but I'm only a few weeks in.
Anyone else got a system that works? Even if it's just a calendar reminder or something.

 

[Murdochcat]

Calander entries with reminders

 

[ChrisW_Midlands]

Yeah that's what I was doing before. Works fine when it's just your own stuff but it got messy when I was trying to track the lads' cards as well. Kept ending up with duplicate entries or reminders I'd snoozed and forgotten about. Each to their own though, if it works for you then stick with it.

 

[Harry Bloomfield]

Every couple of months, I need to manually put the caravan's battery on charge for a couple of days. To remind me, I set repeating reminder in MS Outlooks calendar to turn it on, then one a couple of days later to switch off. Would that do it for you?

 

[ChrisW_Midlands]

Ha, love it. Though if I start mixing "renew Dave's CSCS card" with "charge the caravan battery" I'll end up sending one of the lads to Halfords with a hard hat on. Outlook's brilliant for one or two things but 15 certs across 4 blokes and it turns into a graveyard of snoozed reminders.

 

[SimonH2]

I had a similar problem at the day job - keeping track of the mandatory training (you wouldn'tbelive the amount of crap we have to do), site access, clearances, yada, yada, ... I set up a spreadsheet where I tell it how often (some is yearly, some two years, etc.) and when I did it - and it works out when it's next due asd coliur coding - green for in date, lighter green for coming up, amber for close now, and red for overdue.
I've recently added a "days to go" column, with a minimum in the column header, and colour coding for the next due and the next after that.

I've just starting using it to track all the due dates for home & the rental business.

And I back it up with calendar reminders.

If anyone wants to try it, send me a PM