CoCM minutes tracking: spreadsheet vs registry software
Last updated
Quick answer
A spreadsheet can run a small Collaborative Care pilot if one person logs every contact, the file is HIPAA-safe, and the formulas for 99492 (36 minutes), 99493 (31), 99494 (the 30-minute add-on) and G2214 (16) are right. Registry software adds minute totals, due lists, scores and a billing packet as the caseload grows.
Spreadsheet vs registry software
| Spreadsheet | Registry software | |
|---|---|---|
| Cost | Free (you already have it) | $199 a month or $2,000 a year per clinic (Asendar); other vendors quote on request |
| Minute totals | You add them up; easy to miss a contact | Each logged contact adds to the patient's month |
| Code thresholds | Formulas you maintain (36, 31, 16 and the 30-minute add-on) | Shown as you log (99492, 99493, 99494, G2214) |
| Who is due | Filter and sort by hand | A list of who is due and who is short of minutes |
| PHQ-9 and GAD-7 | Typed in from paper or another system | Scores and their trend kept with each patient |
| Psychiatric caseload review | Print or share the sheet | Review requests and notes in the record |
| Audit trail | Whoever edits last wins | Who logged what, and when |
| Privacy | Only safe if the file lives in a HIPAA-compliant place and uses patient IDs | HIPAA-compliant service with a BAA |
| Billing packet | Build it each month | CSV and PDF at month end |
When a spreadsheet is enough
- You are piloting CoCM with a handful of patients.
- One care manager logs every contact the same day.
- The file lives in a HIPAA-compliant place and uses patient IDs, not names.
- Someone owns the formulas and checks the month's totals before billing.
Start with our free CoCM registry template (XLSX or CSV, no sign-up). It already has the code-suggestion formulas.
When to move to software
- The caseload passes what one person can sort by eye, often around 25 to 50 active patients.
- More than one person logs minutes.
- You are missing billable months because minutes were not added up in time.
- Your psychiatric consultant wants to see scores and trends, not a printed sheet.
Compare options in the CoCM software buyer's guide.
The thresholds your sheet must get right
| Code | When | Time block | Reportable from |
|---|---|---|---|
| 99492 | First month of Collaborative Care | First 70 minutes | 36 minutes |
| 99493 | Each later month | First 60 minutes | 31 minutes |
| 99494 | Add-on to 99492 or 99493 | Each additional 30 minutes | 86 minutes in a first month, 76 in a later month (16 into each extra block) |
| G2214 | First or later month (Medicare) | First 30 minutes | 16 minutes; not with 99492, 99493 or 99494 in the same month |
Source: CMS MLN909432, Behavioral Health Integration Services. Try any month in the free CoCM billing calculator.
Common questions
Can I use Excel as a CoCM registry?
Yes. CMS asks for a registry, not for specific software. Use patient IDs, keep the file in a HIPAA-compliant place, and check the formulas.
How do I track CoCM minutes in a spreadsheet?
One row per patient per calendar month, with the care-manager minutes for that month and whether it is the first month. The free template suggests the code from those two cells.
What is the CoCM time tracking threshold?
99492 from 36 minutes in the first month, 99493 from 31 minutes in later months, 99494 for each further 30 minutes (from 86 or 76 minutes), and G2214 from 16 minutes for Medicare.
When should a clinic move from a spreadsheet to software?
When more than one person logs minutes, when the caseload outgrows sorting by eye, or when billable months slip because totals were late.
Published by Asendar™ (Ignite Synergy™). Education only, not medical, legal or billing advice. Payers set their own rules: verify with your payer and your Medicare Administrative Contractor before you bill.
Run Collaborative Care in Asendar™
A registry, care-manager minutes per patient per month, PHQ-9 and GAD-7 follow-ups and a monthly billing packet, in one place. $199 a month or $2,000 a year per clinic, with a 15-day free trial, no card needed.
Start 15-day free trial