Cross-check your Ministry of Health enrolment roster against your EMR to catch patients who are rostered on one side but not the other. It runs entirely in your browser, so no patient information is ever uploaded or leaves your computer.

Before you start · gather two files

1

Ministry roster

.xml file · from the province

! Use Google Chrome. The Ministry's GO Secure / MC EDT portal does not work reliably in Safari.
  1. Open the Ministry's MC EDT portal and sign in with your GO Secure ID and password.
  2. Go to your reports area and open your patient enrolment roster.
  3. Download it in XML format, not PDF. The tool needs the XML.
  4. Save the file somewhere you can find it.
Open the Ministry portal →
2

EMR roster

.txt file · TELUS PS Suite

  1. Download the ready-made PS Suite Search file below and save it.
  2. In PS Suite, open the Search tool and import this Search.
  3. Run it. It returns Patient #, First Name, Surname, and Health Number for your rostered patients.
  4. Export the results as tab-delimited text and save the .txt file.
Download the PS Suite Search (.srx) →

Run the reconciliation

Load both files into the tool, confirm the Health Card Number field it detects for each side, then click Reconcile. You will get two lists you can export: patients you have rostered in your EMR but who are missing from the Ministry file, and patients the Ministry has rostered to you that your EMR is not tracking.

Download the tool (works offline) → Open the tool in a new tab →

A free tool by Dr. Adam Stewart · Stewart Medicine · built for Ontario family physicians. Questions or ideas? Join the Stewart Medicine Forum →