ER1 Issues Actions Register
You do not need a separate log for complaints, audit findings and improvement ideas. Put them all in one register, give each one an owner and a due date, and check the action worked before you close i..
ER2 Staff Training Competency Matrix
First aid certificates, licence checks and training tickets all run out, and it usually comes to light when someone needs one. Put every renewal date on the matrix and it turns orange well before the ..
ER3 Key Supplier Contractor Register
Your key suppliers are the ones who could let your own customers down, so that is the list worth keeping. Note what each one is approved to supply, how they are doing and when their insurance runs out..
ER4 Equipment Vehicles Register
Anything that needs a service, a calibration or an inspection goes on the list once, with how often it is due. After that the register does the remembering. Dates go orange as they come up and red whe..
ER5 Customer Feedback Analysis Register
Log each completed customer questionnaire here and the analysis sheet averages the scores by question and by year, ready to take into management review. Effective Excel Registers Part of the a..
ER6 Purchase Order Register
Raise each purchase order on the order sheet and log it on the register, with suppliers and categories picked from your own lists to keep the record tidy. Effective Excel Registers Part of the..
ER7 Enquiry Quote Register
Every enquiry gets a row, a priority and an outcome, and the analysis sheet shows how many turned into quotes and how many were won. Effective Excel Registers Part of the alphaZ ER series of E..
ER8 Job Register
A simple numbered list of jobs, with the customer picked from your own list and columns for due date, completion date and invoice number. Effective Excel Registers Part of the alphaZ ER series..
ER9 Legal Register
This is a simple to complete and maintain legal register. The easy to select relevance column automatically formats the entry based on relevance, and you can then filter to only show pertinent legisla..
ER10 IT Equipment Logins Register
ISO 27001 expects you to know what information assets you have and to control who can get at them. Recording every laptop, login, key and card against the person it was issued to covers both, and when..
ER11 Audit Schedule
An audit programme does not need to be complicated. Rate each area, set how often it gets looked at, and the yearly schedule picks it up for you. The clause checker then shows straight away whether yo..
ER12 Breakdown Register
List your plant once, then log each breakdown against its fleet number. The analysis sheet shows which fault codes and item types come up most. Effective Excel Registers Part of the alphaZ ER ..
ER14 Hazard Risk Assessment Register
The register is where you find out whether your risk assessments actually cover what people do. Every activity, the hazards it carries and who is exposed, then the assessment that deals with it. A haz..
ER15 Information Security Risks
ISO 27001 asks for a risk assessment, a treatment decision on every risk and a Statement of Applicability that follows from them. Keep those as one chain in one file and the controls you select come f..
ER16 Business Continuity Risk Register
Business continuity starts with deciding which activities matter most and how long you could manage without each one. Get that right on the critical functions sheet and the impact analysis, the contin..
ER17 Vehicles Register
Every vehicle with its service, MOT and other due dates in one list, highlighted as each date approaches, and a service history sheet to log the work done. Effective Excel Registers Part of th..
ER18 Accident Statistics
Enter a short summary of each accident or near miss and the register works out the yearly totals, days lost and frequency rates, with charts over six years. Effective Excel Registers Part of t..
ER19 Staff Competency Training Development Planner
Rate each person against your key activities, current and target, and the planner flags the gaps and shows each person on a radar chart. Effective Excel Registers Part of the alphaZ ER series ..
ER20 FORS Vehicles Register
Built for FORS operators, this register holds the vehicle details the standard asks for, plus fuel, tyre and tax logs and a fleet summary by operating centre. Effective Excel Registers Part of..
ER21 Personal Data Register
Special category and criminal offence data needs more than a basic record of processing. This workbook has room for it, with sheets for transfers, requests, breaches and deletions. Effective Exce..
ER22 Hospitality and Gifts Register
Record every significant gift or hospitality offered, accepted or not, who approved the decision, and keep donations your company gives on a separate sheet. Effective Excel Registers Part of t..
ER23 Fuel Emissions Register
Every fuel receipt is emissions data if you log it. Put the litres and the mileage against each vehicle and the register works out the miles per gallon, the CO2, NOx and particulates, vehicle by vehic..
ER24 Consumer Vulnerability Register
ISO 22458 does not ask you to keep a list of vulnerable customers. It asks that your people can recognise the signs, respond in a way that suits the person and learn from what happened. The case studi..
ER33 Key Supplier Bribery Risk Register
Score each key supplier on how often you trade, how much and a general bribery risk rating, then record the review and the controls in place. Effective Excel Registers Part of the alphaZ ER se..
ER34 Environmental Performance Register
This register turns meter readings, fuel receipts and mileage into carbon figures, and keeps one continuous picture of progress against your baseline. The report dashboard slots straight into the Carb..
ER42 AI Risks and Controls Register
At audit, the AI risk register needs to show every AI system in use, what could go wrong with each one, what is being done about it and which Annex A controls it maps to. With those four things in one..