An unused session is a promise, and the new system has to keep it
Jess bought six laser sessions and has had three. On the revenue report the whole package landed the day it was sold; in the chair, three sessions are still owed. A switch is where that promise gets lost, because the count lives in the old system and the new one starts at zero. Whether the open balance is a liability on your books, and when revenue on it is recognized, is for your accountant to confirm; the count itself is yours to protect. Membership credit added and not spent is the same promise.
Reconcile before anything moves
- Export every open package from the old system: patient, series, sessions bought, sessions used, price paid, sale date, last session date.
- Export every active membership: patient, tier, fee, credit added, credit spent, rollover owed, card on file, start date.
- Pull the point-of-sale report of every package and membership sold in the same window, and the bank deposits behind it.
- Match the three. Every package in the point of sale missing from the record, every session used and never charged, and every credit added by hand goes on an exceptions list.
- Resolve each exception with the patient's history open and write the reason beside it. Priya clears the clerical ones; the owner decides anything that changes what a patient is owed.
- Freeze. Pick the date after which no package or membership is sold in the old system, so the list stops moving.
- Hand the reconciled list to the accountant. No balance loads into the new system until it is signed.
| Column | Where it comes from | What a mismatch means | Who signs off |
|---|---|---|---|
| Sessions bought and used | The old record system's package report | A session delivered and not logged, or logged and not delivered | Priya, then the provider for anything clinical |
| Price paid | The point of sale and the bank deposit | A discount at the desk that never reached the record | The owner |
| Credit added and spent | The membership report | Credit added by hand, or a bonus promised and never loaded | The owner |
| Rollover and expiry | The membership terms the member signed | A term applied differently from what was signed; confirm the terms with counsel | Counsel |
| The open balance total | The reconciled list, every row | What the new system shows on day one; its place on the books is the accountant's call | The accountant |
A worked example, labeled illustrative
Say the reconciled list shows forty open packages holding $9,600 of sessions at the per-session price paid, and sixty members holding $4,200 of unspent credit. Say the point of sale shows $13,400 collected against those rows, so the lists differ by $400. The exceptions list explains the gap as two desk discounts never entered in the record. The price-paid column is corrected, and the reconciled list in this example carries $13,400 of sessions and credit. In this illustrative example that $13,400 is what the new system has to show on its first morning, beside the exceptions. How it sits on the books, and how it is recognized as sessions are delivered, is the accountant's call. Replace every figure with your own.
How to carry the balance into the new system
- As sessions, where the new system holds packages: the series, the sessions remaining and the price paid per session, so the report reads the same after the switch.
- As a dollar credit, where it holds packages differently: sessions remaining times the price paid per session, loaded once. Which form keeps the terms the patient signed is for counsel to confirm.
- The proof file: the signed list, the exports and the exceptions, where the accountant and counsel can find them after the old login ends.
- Expiry and rollover carry the terms the member signed, not the new system's defaults. A default that shortens an expiry changes the promise, and counsel reads it first.
The accountant sees the list before the new system does
The accountant gets the reconciled list with the three sources beside it, the exceptions with their reasons, the freeze date, and the balance the new system will show on day one. They decide how prepaid credit sits on the books, and how revenue is recognized as each session is delivered. Ask before the freeze date, in writing, and file the answer with the proof. Confirm with your accountant any accounting statement on this page before acting on it.
Members hear it from the practice before the cutover
Every patient with an open balance hears from their provider by name before the switch. The message says what they hold, that it carries over in full, and the date the new booking link goes live. It goes by text only where texting consent is on record, and by email or a call otherwise. The message carries the count and the date and nothing clinical. What may be said by text, and what counts as consent, is for counsel to confirm. A member who first hears of the switch from the new system's welcome email has a reason to cancel.
How to start this on Monday
- Priya runs the two exports and the point-of-sale report into one sheet, three tabs, by the end of the day.
- The owner sets the freeze date and tells the front desk which system sells packages from that day.
- The accountant gets the sheet on Tuesday with one question: what do you need to see before this loads into the new system?
What to do next
NorthCore's Bring patients back solution carries the open-balance list into the package nurture, so every patient with sessions owed is walked through them on the new system from the first week. Scoped in writing and covered by the promise on this site: results in 90 days, or we keep working until you have them.
