Medical Insurance Changes Pack (Excel)

For each new hire or leaver, HR submits a short form. The flow records the change in an Excel tracker, emails the insurer or broker, and asks HR to confirm the insurer's reply when it comes, chasing the insurer if it is missing.

Steps in this flow

  1. Insurance change form
  2. Excel: add to the tracker
  3. Email the insurer or broker
  4. HR confirms the insurer's reply
  5. Confirmed?
  6. Excel: record the confirmation
  7. Chase the insurer

All templates