A Caseload Dashboard: Active, Pending, Closed

The Monday morning question nobody's spreadsheet answers

A practice owner opens the shared spreadsheet before the week's first call and starts scrolling. Sixty-some rows, six tabs, a column for "status" that three different counselors fill in three different ways — "active," "Active," "open," "IP" for in progress. She's not looking for a specific case. She's trying to answer one question: which of these files need something from us this week, and which ones are just sitting? By the time she's cross-referenced the report-due column against today's date, the call has started and she still doesn't have an answer. Multiply that by every Monday, every counselor, every referral source, and the practice is running on a list when it needs a dashboard. By the end of this piece you'll know exactly what an active/pending/closed caseload dashboard needs to show — and what it should roll up by counselor and referral source — to replace that scroll with a glance.

What "active," "pending," and "closed" should actually mean

The value of a three-status dashboard collapses fast if the three statuses mean different things to different people. Before building or buying one, a practice needs a shared, written definition of each bucket — not a philosophical one, an operational one tied to what happens next.

• Active means work is currently owed on the file: a report is due, a labor market survey is in progress, a client meeting is scheduled, billing is pending submission. Active is not "the case exists." Active is "someone on this team owes something on this file right now or within the current reporting cycle."
• Pending means the file is open but temporarily blocked on something outside the counselor's control — waiting on medical records, waiting on carrier authorization, waiting on the claimant to schedule, waiting on a fee-schedule decision. Pending is not a dumping ground for cases someone forgot to update. A pending case should always carry a "waiting on" field and a follow-up date, or it isn't pending, it's abandoned.
• Closed means the file is closed to further billable activity, with a closure reason (successful placement, benefit exhaustion, voluntary withdrawal, carrier closure) and a closure date. A caseload dashboard that only shows active and pending is missing half its value — the closed column is where a practice sees its own throughput and outcomes over time.

Every jurisdiction and payer has its own definitions of case status for reporting purposes, and those definitions do not always match a practice's internal operational categories one for one. Treat internal status as an operations tool, not a substitute for whatever status field a carrier, TPA, or workers' comp board requires on its own forms — confirm the terminology those parties expect directly with them rather than assuming the practice's internal labels transfer.

The caseload dashboard: active, pending, closed by counselor

Once statuses are defined consistently, the caseload dashboard's first and most important cut is by counselor. For a practice owner or administrator, the useful question is rarely "how many total cases does the firm have" — it's "is this workload distributed sanely, and is anyone quietly drowning."

A counselor-level roll-up should show, for each counselor: count of active cases, count of pending cases, count of closed cases in the current period, and — critically — how long cases have sat in each status. A counselor with twelve active cases and a two-day average time-in-status is in a different position than a counselor with eight active cases where three have been sitting untouched for three weeks. Raw case counts alone flatten that distinction; a status-aged view doesn't.

This is also where a multi-counselor practice starts to see its own bottlenecks. If pending counts are climbing firm-wide, the blockage is probably external — a slow-turnaround records vendor, a carrier authorization queue — and worth raising as a vendor conversation rather than a counselor performance conversation. If pending counts are uneven across counselors handling similar referral mixes, that's a different, more internal conversation. Either way, the roll-up is what surfaces the pattern; a flat list never will. A closer look at coordinating this across a growing team is worth a separate read on multi-counselor practice coordination.

The same dashboard, cut by referral source

The second essential roll-up is by referral source — the carrier, TPA, attorney, or LTD insurer sending the work. A practice billing against published fee schedules and carrier-specific authorization rules needs to know, source by source, how each relationship is actually performing: average time from referral to first active work, average time cases sit pending on that source's own delays, and closure outcomes by source.

This matters for two reasons that have nothing to do with any single case. First, referral-source performance data is leverage in the panel relationship itself — a practice that can show a TPA its own average authorization delay, sourced from the practice's own tracking, is negotiating from data rather than frustration. Second, it's an early warning system: a referral source whose pending-case count is quietly climbing relative to its historical pattern is a signal worth raising before it becomes a cash-flow problem, not after.

A caseload dashboard that can't be sliced by both counselor and referral source is really just a status list with a coat of paint — the roll-up is the point, not the color-coding.

Overdue and at-risk: the view underneath the view

Active, pending, and closed are status buckets, but the dashboard's real operational teeth come from a fourth, overlapping view: overdue and at-risk. A case can be "active" and still be dangerously close to a jurisdictional reporting deadline or a fee-schedule submission window. Status alone doesn't capture urgency; a date comparison does.

This is where a caseload dashboard needs to do more than categorize — it needs to flag. Any case with a report due within a configurable window, any pending case whose follow-up date has passed without action, any closed case with billing still outstanding, belongs on a distinct overdue/at-risk view that every counselor and the practice owner both see. Because reporting-deadline rules and fee-schedule cadences are set jurisdiction by jurisdiction and payer by payer — never assume one state's or carrier's timeline applies to another — the dashboard's flagging logic has to be configured against the specific rules that apply to each case, not a single practice-wide default. For the mechanics of building that layer specifically, see overdue report alerts for workers' comp caseloads.

Building the view without a dashboard tool — and when to stop

A small solo practice can build a rough version of this in a spreadsheet: three tabs or a status column, a counselor filter, a referral-source filter, a conditional-format rule for approaching due dates. That's a legitimate starting point, and a structured starting template is genuinely useful rather than a stopgap — see the caseload tracker template for a version built around exactly this active/pending/closed structure, and the downloadable Caseload Tracker Workbook if a ready-made version is faster than building one from scratch.

Where the spreadsheet approach breaks down is scale and reliability: past a handful of counselors, someone will forget to update a status field, a filter will get accidentally cleared, and a formula-driven "overdue" flag will quietly stop firing after a template change nobody tested. That's the point at which a caseload dashboard needs to live inside the system that already holds the case data and the deadline rules, rather than as a manual layer on top of it — the difference between a status list and true caseload management for rehabilitation counselors is largely whether the dashboard updates itself or waits for someone to remember it.

If the practice has outgrown the spreadsheet version — if "who owes what this week" takes longer to answer than it should, or an overdue case has already slipped through once — it's worth seeing the roll-up built and maintained automatically. Book a demo to see an active/pending/closed dashboard, sliced by counselor and referral source with overdue flags built in, running against a real caseload.