Patient enrolment · MOH roster

Roster Reconciliation

Compare your Ministry roster against your EMR export and surface every patient that appears in one but not the other.

A free tool by Dr. Adam Stewart · Stewart Medicine

Runs entirely in your browser. Nothing you load ever leaves your computer.

MOH Ministry roster

Drop file or click to choose

XML preferred. CSV / TSV also accepted.

Health Card Number field

Name field (optional)

EMR EMR export

Drop file or click to choose

Tab-delimited or CSV. Rostered patients only.

Health Card Number field

Name field (optional)

Matching Ignore version code (digits only) Ignore spaces and dashes Exclude MOH patients with a Roster End date

Load both files to enable.

Action Rostered in EMR, missing from MOH

You carry these as enrolled, but the Ministry does not. You are likely not being paid capitation for them. Investigate: de-enrolled, moved, deceased, or an enrolment that never processed.

Action Rostered in MOH, not flagged in EMR

The Ministry considers these enrolled to you, but your EMR does not show it. Update the EMR roster status so your tracking matches what you are paid for.

Match key is the Health Card Number, normalized per the options above. Rows whose HCN has fewer than 8 digits (for example the MOH ROSTER SUMMARY and totals lines) are treated as non-patient rows and left out of the comparison. The Ministry roster is a snapshot: recent enrolment changes can appear here as differences that are really just timing.