Behavioral health billing census automation · Two to twelve locations

Less census retyping. A clearer view of every center.

We connect attendance records, billing workbooks and available EMR data so your team can review discrepancies and see performance across locations.

Billing census automation prepares the work for review. Daily census, executive and clinical dashboards make the available numbers easier to use. Your team keeps responsibility for clinical and billing decisions.

Works alongside your EMR and billing company. It replaces neither, and it never submits claims. A BAA is signed before any patient data is touched.

From source records to a decisionIllustrative
Fig. 1 Inputs vary by client. The implementation is scoped around the records your team actually maintains.
01Two jobs

Two jobs, one connected foundation.

One foundation, two jobsIllustrative
Fig. 2 APIs are used where suitable access exists. Nothing is written back to your EMR.

Running on Kipu? See custom Kipu reporting.

02The checks

What the checks look for.

  1. Attendance without a corresponding census entry
  2. Entries that need documentation review
  3. Short sessions under the agreed billing rules
  4. Level-of-care disagreements
  5. Identity and episode mismatches

A flag is a question to investigate, not a verdict. Thresholds and payment rules depend on your contracts and operation; they are not universal reimbursement rules.

The detail, with the arithmetic: the five billing census checks. Or print the one-page checklist and run it on last month.

Review listSample
DateRecordLogCensusFlag
3/8R-44173.0h IOPblankAttended, not in census
3/8R-22982.0h IOPIOPShort session
3/9R-7741noneIOPNeeds documentation review
3/10R-50935.0h PHPPHPMatches
Fig. 3 Patient-level, so it never reaches a leadership board. Invented record codes. See a full worked example
03Leadership view

The questions leadership should be able to answer.

Which programs are below their operating targets? How current is each center's data? Which figures are comparable? What needs review before the next billing handoff?

Centers this morningSample data
CenterEnrolled vs targetVs break-evenSource data as of
Fairmont42 of 38 · 111%112%Today, 7:55
Northgate36 of 35 · 103%104%Today, 7:55
Lakeview30 of 31 · 97%Not availableToday, 7:55
Cedar Park26 of 32 · 81%88%2 days ago
TargetThe enrollment target leadership set for each program.
Break-evenShown only where finance confirmed the cost assumptions. Otherwise it says not available.
FreshnessWhen the source was last read. A new report can still carry old data.
Fig. 4 Invented centers and numbers. Aggregates only: no names, no record codes.

Where confirmed cost assumptions are available, the dashboard can also show position against break-even. Estimated care value, submitted claims, collected cash and profit are different measures. Missing inputs are shown as missing.

04Revenue intelligence

Revenue intelligence: which plans pay, which push back, and where your mix is lopsided.

A census shows who attended. Charges show what was billed. Neither tells leadership which insurance plans pay well, which deny or delay, or which fill the most days for the least money. Revenue intelligence sets attendance, charges, your billing company's reports and payment files side by side, by plan and by center.

  • Which plans pay the most?Paid per program day and per level of care, by plan. Billed, allowed and paid stay three separate numbers.NeedsClaim-level payment files
  • Which plans push back the most?Denials on first submission, days to payment and resubmissions, by plan.NeedsDenial and payment dates
  • Where is the payer mix lopsided?Each plan's share of days beside its share of money, for every center over the same weeks. How to calculate payer mixNeedsCharges and expected-value reports
  • Which attended days never became a charge?Attendance against charges, line by line. Each difference is held for a person to decide.NeedsAttendance logs and charges
  • How late are charges going out?Charge lag: days from the service to the charge, by center, and charges that repeat.NeedsCharges with service dates
  • How much rides on one plan or a few clients?Concentration: how much expected money depends on a single payer or a small number of episodes.NeedsCharges and expected-value reports
Payer scorecardSample data
PlanShare of days against share of paidPaid per program dayDenied first timeDays to paymentReading
Plan group A
34%
22%
6522%61Most days, least per day
Plan group B
27%
38%
1406%24Highest paid per day
Plan group C
22%
26%
1209%31In line
All other
17%
14%
8214%45Slow to pay
Share of billed daysShare of paid dollars
Paid per program dayAn index. 100 is the average across all plans.
Denied first timeThe share of claims denied the first time they were sent.
Days to paymentThe middle value, from submission to payment.
Fig. 5 Invented plan groups and numbers. It reads your own claims. It is not a ranking of insurers in general.

It starts with what your billing company already sends. The first month reads attendance, charges and expected-value reports. The payer scorecard is added when claim-level payment and denial files are available.

The first month, before payment files arriveSample data

Report coverage

13 of 16weekly reports on file
W1W2W3W4 Fairmont Northgate Lakeview Cedar Park

Days against expected value

Plan group A
34%
19%
Plan group B
27%
35%
Plan group C
22%
31%
All other
17%
15%
Share of billed daysShare of expected value

To review this week

3421 open · 13 decided
  • Attended, no matching charge14
  • Late charge9
  • Charge, no matching attendance6
  • Amount not as expected4
  • Repeated charge1
CoverageA week with no report shows as not covered, never as zero. Centers are only compared over the same weeks.
Expected valueThe billing company's estimate of what a charge will pay. It is not a payment.
To reviewEach difference is a question for a person, not a verdict. Client-level rows stay with the operations team.
Fig. 6 Invented centers, plan groups and numbers. Totals only: no names, no record codes.

Leadership sees totals by plan and center. Client-level rows stay with the operations team. The system never submits, changes or holds a claim, and it is scoped separately from the Ops Engine.

  • In buildThe first-month view. A first draft exists for one five-center network and is not yet in weekly use.
  • DesignedThe payer scorecard and the work queue for differences. Built when a client's payment and denial files are available.

Not claimed: an underpayment finding, recovered revenue or a measured result for any client. Expected value, submitted claims, collected cash and profit are different measures. A denial rate is a count, not a judgment about a plan.

05Evidence

Evidence from a five-center network.

~10 secOne measured run: a facility-month of 27 tabs and 943 client-days.Excludes collecting the source files and human review.
1 weekParallel run against the manual census. The operations lead signed off with corrections, which were incorporated.Reviewed corrections are logged as rules where they apply.
5 centersDaily census and clinical reporting implemented; executive reporting published.Read from the EMR's API each morning, read-only.
  • RunningCensus automation at 3 of 4 outpatient sites. The fourth is moving onto the shared template first.
  • RunningDaily census, executive and clinical dashboards for all five centers.
  • Not claimedRecovered revenue. That needs a financial reconciliation over a full billing cycle, which has not been done.

Status as of October 1, 2026. The case study records the dated rollout and what remains open.

06Prove it

Prove it against your existing work.

Before anyone relies on the output, it has to match the work your team already trusts.

  1. Map one periodTake one completed month and document the rules your team applies.
  2. GenerateDraft the census for that month from the same source records.
  3. CompareSet it beside the census your team built by hand and investigate every difference.
  4. Agree the lineCorrect the rules, and agree what must remain a human decision.
07Engagement

How an engagement works.

Start with a free call about one problem. Timing and price follow the scope, and if the existing workflow already meets your needs, the audit says so.

A fit

  • Two to twelve locations
  • Founder-led
  • One operations person and a spreadsheet between the work and the money

Not a fit

  • Fifty-site groups
  • Hospital systems
  • Anyone already live end to end on a modern revenue-cycle platform
08Questions

What operators ask first.

What is billing census reconciliation?

Comparing the attendance your sites record with the billing census your biller works from, line by line, so that services delivered, documented and billed agree before claims are built. Each disagreement is held for a person to review.

Does this replace our EMR or billing company?

No. It works with agreed inputs and outputs around the systems you keep. We first check whether your existing tools already solve the problem.

Does it submit claims?

No. Census preparation and discrepancy review are separate from claims submission.

Are all dashboards real time?

No. Each view should show the source observation date and refresh status. A newly generated report can still contain older source data.

Can it tell us our profit?

Only with suitable, reconciled financial inputs. Census targets and estimated billed-rate value do not establish profit.

Show us where the week gets copied by hand.

Start with a walkthrough of one center's workflow. No patient files are needed for the introductory call.