Case study · Pediatric cardiology

Six weeks to replace the spreadsheet a whole clinic was running on.

A pediatric cardiology clinic managed every incoming referral in one shared Sheet. Seven people worked in it, anyone could overwrite anyone, and the call history was written in abbreviations only one person could read. We replaced how staff work with that data.

PracticeA pediatric cardiology clinic
Size2 providers, 5 staff
BuiltNorthchart PRM, part one
Timeline6 weeks, first call to live

The situation

Referrals arrived the way they arrive at most specialty practices — by fax, by phone, and by email. Each one was typed into a shared spreadsheet, and from that point on the spreadsheet was the clinic: intake, insurance authorization, call attempts, scheduling status, billing notes. Everyone opened the same tab.

It worked, in the way that spreadsheets work right up until they don't. There was no way to stop a half-finished record being saved. A call attempt was recorded as a string like 4/8/26 JC LVM, which a person can read and a computer cannot count — so the clinic's own rule about attempting five calls before closing a referral could be followed but never verified. And the same referring office was entered four different ways across four months, which meant nobody could total anything by who sent it.

The clinic did not need a bigger spreadsheet. It needed the spreadsheet to stop being the interface.

What nobody could answer

  • Which referrals had gone a week or more without a call attempt
  • Whether the five-call rule had actually been followed on any given referral
  • Who changed a patient's status, when, and what it had been before
  • How many referrals came from a given referring office, when its name was typed differently every time

Everyone who needed to read one row could also edit — or delete — every other row, including the ones holding patient information. That is not a staff discipline problem. It is a permissions problem, and no amount of care fixes it.

What we built

The first part of Northchart PRM — our provider relationship management system: a web portal that every member of staff logs into, and that nobody has to leave. The spreadsheet is still the data store, but it is shared with the physician and one machine account only. Staff never touch it directly again.

Four roles — billing, clinic staff, doctor, administrator — each see the referrals and fields their job requires, and no more. A referral cannot be saved half-entered, because the form validates before it writes. Call attempts are recorded as structured entries with a date, a person, and an outcome, which is what makes the five-call rule countable rather than aspirational. Every change writes to an append-only audit trail: who, what, when, and the previous value.

Before · the shared sheet
Call attempt4/8/26 JC LVM
Referring office4 spellings
Who can editEveryone
Five-call ruleUnverifiable
After · the portal
Call attemptDate · person · outcome
Referring officeOne record
Who can editBy role, audited
Five-call ruleCounted

Illustrative. No practice data shown.

Patient names never appear in a web address or in a browser log; records are addressed by an internal identifier. The clinic's data stays in the clinic's own Google account — Northchart keeps no copy of it. The compliance posture for each deployment, including business associate agreements, is agreed with the practice in writing before any build begins.

How it fits the practice's day

  • Front desk enters a referral once, into a form that will not accept a partial record
  • Every call attempt is logged as a call, not as a note — so the follow-up queue builds itself
  • Billing sees authorization status without interrupting clinical staff to ask
  • The physician sees what is ready to schedule, without reading the whole sheet
  • The spreadsheet is still there. Nobody opens it.

Where it stands

The portal went live and has been the clinic's referral workflow ever since.

6 weeks

from the first conversation to the whole clinic working inside the portal

2 months

in daily use — every referral since go-live has been entered through it, with no fallback to the old sheet

4 roles

billing, clinic staff, doctor, administrator — each with its own permissions and its own view

These are delivery facts, not outcome claims. We have not yet measured staff hours saved or revenue recovered at this practice, and we would rather publish nothing than publish a number we could not defend to a practice administrator. When there are figures the clinic will stand behind, they will appear here.

In build now

What we are building underneath it

The portal answers what happened to this referral. It cannot answer which referring offices are sending us fewer patients than last year — and neither can the EHR. That question needs something the clinic has never had: one clean, current record of the providers and practices who refer to it.

So that is the second part of Northchart PRM, and what we are building next with the same practice: a referring provider and practice directory that becomes the single source of truth for that data across every system the clinic uses.

  • Provider and practice records seeded from the national NPI registry, scoped to the area the practice actually receives referrals from
  • Every field records where it came from, who last verified it, and when — and a scheduled refresh can never overwrite something a human has confirmed
  • The portal reads from the directory and writes nothing to it, so one referral is attributed to one provider rather than to four spellings of a name
  • When staff spot a stale address, phone, or fax, they flag it; an administrator reviews and approves. Two systems never write the same field
  • A provider's affiliation to a practice is dated, so a provider moving between groups does not rewrite last year's referral history

Two deliberate constraints shape it. The directory holds no patient data of any kind — only business information about referring offices, which keeps it outside the reach of the questions that make practices nervous. And it is deployed inside the practice's own hosting account, under the practice's own domain. The practice owns the data and the infrastructure; we build and maintain it.

This page will be updated as that work ships.

What this means for your practice

Every specialty practice we talk to has some version of this. The details differ — an orthopedic group's intake does not look like a pediatric cardiology clinic's — but the shape repeats: the EHR tracks patients, a spreadsheet tracks everything the EHR does not, and nobody tracks the referring relationships at all. The loss shows up later as an unexplained slow quarter that nobody can trace back to a source.

A referral audit is how we find out whether that is happening in your practice. It takes an hour, costs nothing, and you keep the findings either way — including if the answer is that your referrals are healthy and you do not need us.

Free referral audit

See what an audit would find in your practice.

One hour with your practice administrator. Written findings. No obligation.

  1. 1
    You send the formWe reply within one business day to agree a time.
  2. 2
    One hour, on a call or on siteWith whoever handles referrals day to day.
  3. 3
    Written findings within 48 hoursYours to keep, whether or not we go further.

Rather pick a time yourself? See available times →

Request a free referral audit Takes a minute

Please don't include any patient information in this form. We use what you send only to arrange the audit — see our privacy policy.