The one-tab dashboard: a spreadsheet that answers five questions

The five rows and what each one answers

A one-tab dashboard answers five questions every month: what came in (gross charges against net collections), how full the schedule actually ran (visits against no-show rate), what's still outstanding (accounts receivable by age), what you can pay yourself and set aside (compensation and retirement headroom), and whether a payer is watching something you aren't (a quality-measure flag). Five rows, refreshed the same day each month, beat a dozen tabs nobody reopens.

Every row pulls from something you already have — your EHR's billing export, your bank statement, your calendar — so the sheet is a summary, not a second data-entry job. This page is the mechanics; the solo dashboard: five numbers, monthly is the companion read for which five numbers to choose if you haven't settled on them yet.

Build it as one tab, one row per month

Structure the sheet as one tab with one row per month and one column per metric, using formulas that pull forward rather than numbers you retype — a running spreadsheet, not a fresh document each month. The first tab you build should be the only tab you maintain; a second tab for extra notes or a third for projections is usually where the habit quietly stops.

Source each column from a place that already exists: net collections and gross charges from your billing software's monthly export, visit counts and no-shows from your scheduling calendar, and accounts-receivable aging from whichever system tracks unpaid claims. If nothing exports cleanly, a five-minute manual tally once a month is still faster than building a system to avoid it.

Protect the formula cells from accidental overwrite — a monthly habit of pasting a new number over a working formula is the single most common way a one-tab dashboard quietly stops telling the truth. Lock the formula columns, or keep manual entries and calculated results in visibly separate columns, so a wrong keystroke breaks obviously instead of silently.

The compensation row: what the sheet tells you about pay

Once net collections is a reliable monthly number, it becomes the input for a compensation row: what you actually took home against what the practice collected, and how much room is left to set aside before year-end. A SEP-IRA allows contributions up to 25% of compensation within the annual limit, though it must cover eligible employees equally once the practice has staff 1Ref 1Internal Revenue Service (2026).Simplified Employee Pension plan (SEP).Supports that a SEP-IRA permits employer contributions up to 25% of compensation within the annual limit, the basis for a dashboard's retirement-contribution row.; a one-participant 401(k) adds an employee-deferral layer on top of employer contributions for an owner with no employees besides a spouse 2Ref 2Internal Revenue Service (2026).One-participant 401(k) plans.Supports that a one-participant 401(k) covers an owner with no employees besides a spouse, adding an employee-deferral layer on top of employer contributions..

Run the retirement-headroom math off trailing-twelve-months collections, not a single strong month — a large insurance payment landing late can make one month look better than the year actually was.

The contractor row: anyone else this sheet pays

Add a row for anything paid to a contractor — a part-time biller, a clinical supervisor, a cleaning service — rather than folding it into a generic expenses line, because the IRS treats a nonemployee paid $600 or more in a year as someone you must issue a 1099-NEC at year-end 3Ref 3Internal Revenue Service (2026).About Form 1099-NEC, Nonemployee Compensation.Supports that paying any nonemployee contractor $600 or more in a year requires a 1099-NEC, the basis for a dashboard's contractor-payment row.. A running row makes that year-end total a lookup, not a scramble through twelve months of bank statements in January.

Track the contractor's name, the running total paid, and the date of the last payment; when the running total crosses $600 partway through the year, that's your signal the relationship now carries a filing obligation, not a one-time favor. This is also the row that keeps a supervision or collaborative-practice arrangement paid by the hour honest, since a running total makes it obvious if a monthly invoice suddenly jumps.

The payer-measures row: quality flags you didn't choose

Add one flag row for any quality measure your payer contracts already reference, since several plans measure outpatient behavioral-health practice patterns directly — antidepressant medication management and follow-up after an emergency-department visit for mental illness are both inside HEDIS, the measure set most commercial and Medicaid plans report against 4Ref 4National Committee for Quality Assurance (2026).HEDIS.Supports that HEDIS measures reach into outpatient behavioral-health practice patterns, the basis for a dashboard's payer-quality-measure flag.. A solo practice doesn't need a quality-reporting system to track this: a single yes-or-no column per patient who trips one of these windows is enough to see the pattern before a payer's report does.

If none of your contracts reference HEDIS or a similar measure set, leave the row blank rather than inventing something to fill it — the point is tracking what actually applies to your payer mix, not padding the sheet.

When one tab stops being enough

One tab usually stops being enough around the same time as the first hire — a biller or a scheduler needs live, shared access that a spreadsheet on your laptop can't grant — or once the questions you're asking outgrow the five you started with. An access metric like third-next-available, or a growing accounts-receivable balance that forks into its own denials-appeals decision, are both natural additions once the core five rows are routine, not replacements for them.

If you are less than three months into the practice, start from the first-90-days dashboard instead of this one — the comparison points are different before you have a full year of seasonal pattern to measure against. And whatever threshold you use for adding software or staff, check it against overhead at micro scale first, since headcount and rent move the math more than any single metric on this sheet. Revisit these thresholds once a year even if none of them have tripped yet — a practice that has quietly grown past its own five rows without noticing usually finds out at tax time, not before.