CERTIFICATE OF INSURANCE (COI) TRACKING PROCESS

Created by ChecklistGuro (https://checklistguro.com)

[ ] Retrieve Vendor Records: Fetch existing vendor entries from the Vendor Data Model to check for existing COI history.
[ ] Create COI Request Entry: Create a new entry in the COI Tracking Data Model to initiate the tracking of a new certificate.
[ ] Update COI Expiry Date: Update the specific COI entry with the new expiration date once the certificate is verified.
[ ] Calculate Days to Expiration: Calculate the difference between the current date and the COI expiration date to determine urgency.
[ ] Assign Verification Task: Create a task for the Risk Management Officer to review the uploaded document for compliance.
[ ] Notify Vendor of Missing Info: Create a task for the Procurement Agent to follow up with the vendor regarding incomplete documentation.
[ ] Send COI Request to Vendor: Send an automated email to the vendor contact requesting the updated Certificate of Insurance.
[ ] Send Expiry Alert to Stakeholders: Send an email notification to internal project managers when a vendor's COI is approaching expiration.
[ ] Summarize Expired Certificates: Aggregate the count of COI entries where the expiration date is in the past to identify high-risk vendors.
[ ] Update Vendor Compliance Status: Update the Vendor Data Model to change the 'Compliance Status' to 'Active' or 'Non-Compliant' based on COI validity.
[ ] Generate Monthly Compliance Report: Create a report summarizing all COI renewals processed and all expired certificates during the month.
[ ] Remove Duplicate COI Entries: Delete erroneous or duplicate COI entries identified during the verification process.

--- END OF TEMPLATE ---
Transform this text into a digital, automated, and trackable mobile app!
Visit: https://checklistguro.com/workflow-templates/facility-management/certificate-of-insurance-coi-tracking-process
(Click "Install Template" to launch your digital inspection tool immediately)