Prepare a CCBHC cost report data inventory across finance, staffing, encounters, locations, and partner records with clear reconciliation owners.
A cost report data inventory should identify each source, definition, period, transformation, reconciliation, and responsible owner before the report is assembled. Finding a report with a plausible title is not the same as establishing that its numbers answer the cost report's question.
This guide describes a preparation method for CCBHC organizations. It does not determine allowable costs, allocation methods, prospective payment rates, or submission deadlines for a particular clinic. Use the applicable current instructions and qualified finance and program review for those decisions.
CCBHC cost report data inventory starts with scope
The CMS CCBHC cost reporting page provides report resources and instructions for the demonstration context. Identify the actual program, state process, report version, and reporting period before collecting data.
Record who is responsible for interpreting the instructions and who authorizes the submission. A software administrator can extract information without being the person qualified to decide its financial treatment. Keep those responsibilities distinct.
List the organizational entities, locations, programs, and partner arrangements in scope. An acquisition, site opening, service change, or accounting reorganization can affect which records belong in the period. Document the scope decision rather than assuming current system settings describe the entire historical year.
Identify authoritative sources across departments
Inventory finance, payroll, human-resources, encounter, location, and partner data relevant to the actual instructions. The EHR may supply some activity information while accounting and payroll supply other inputs. Do not assume one system is authoritative for every question.
For each input, identify the source system and the person who can explain it. Record whether the source is a standard report, a saved query, a controlled export, or a manual record. An undocumented spreadsheet copied from a prior year deserves review before reuse.
Use a source dictionary. Include the field meaning, units, date basis, organizational dimensions, and known limitations. Two reports can both be correct while counting different things, such as completed encounters versus posted charges or assigned staff versus paid hours.
Define periods and cutoffs consistently
Name the date used for each input. Service date, payment date, payroll period, posting date, and extraction date answer different questions. A reconciliation can fail simply because one department uses a service period while another uses a posting period.
Record the reporting cutoff and the treatment of later corrections under the applicable process. Preserve the data used for the prepared report and any authorized revision history. A live dashboard may change after submission and should not be assumed to reproduce the submitted result.
For a fictional example, a service occurs near period end, its record is corrected later, and the accounting entry posts in a subsequent period. The finance lead should determine the appropriate treatment using the instructions, while the inventory makes the dates and source events visible.
Map organizational dimensions explicitly
Connect source records to the entities, programs, locations, and other dimensions needed for the report. A current location name may differ from the name used earlier in the period. A staff assignment can also change over time.
Keep a crosswalk with effective dates and an owner. If a department code is renamed or split, record how historical data is interpreted. Avoid using a current label to silently rewrite the organizational history of the reporting period.
The New Jersey CCBHC provider resources illustrate that state program materials sit alongside federal resources. Use the state instructions relevant to the organization rather than importing another state's categories or payment assumptions into the inventory.
Document transformations and allocation decisions separately
Some inputs may be combined, mapped, or otherwise transformed before use. Record the calculation or mapping and the person who reviewed it. A source export and a prepared report cell are different artifacts, and the path between them should be understandable.
Keep financial judgments separate from mechanical transformations. An analyst can apply a mapping without deciding whether a cost is allowable or how it should be allocated. Those decisions need the applicable instructions and authorized specialist review.
| Inventory element | Question to answer |
|---|---|
| Source | Where did the value originate? |
| Definition | What does the value count or measure? |
| Period | Which date and cutoff apply? |
| Transformation | What changed between source and report input? |
| Financial decision | Who approved the treatment and on what basis? |
| Reconciliation | What independent evidence was compared? |
Retain enough detail to reproduce the preparation without exposing sensitive data in a general project document. Detailed payroll and patient-level evidence belong in appropriately restricted locations.
Reconcile inputs before assembling the final report
Choose reconciliations appropriate to each source and the report instructions. Finance totals, payroll extracts, encounter counts, and partner records may need different comparisons. Equal totals can be useful, but unexplained differences should remain visible.
For activity data, inspect individual fictional or authorized sample records as well as totals. A duplicate and a missing event can offset each other. For finance inputs, have qualified staff review the accounting basis and period rather than assuming the EHR's charge total is a substitute.
Record exceptions with an owner, evidence, next action, and decision date. A generic data issue list is less useful than a specific question such as whether a late correction belongs in the prepared period under the applicable process.
Test vendor reporting claims with real definitions
If a vendor says it supports cost reporting, ask which inputs and workflows it actually provides. Request a demonstration using the organization's definitions and fictional cases. Identify what remains in accounting, payroll, partner systems, or manual review.
Ask for export fields, date semantics, location mapping, correction handling, and retained history. Put dependencies and limitations in the written proposal. A report export can be helpful without constituting a complete cost report preparation service.
Ease Health publishes this guide and offers a unified CRM, EHR, and RCM platform for behavioral health. Ask the team to demonstrate the proposed source-data workflow and identify work that remains with finance or external systems. Related material includes the RCM overview, CCBHC evidence matrix, and quality measure lineage guide.
The final artifact is a source inventory the finance team can explain and maintain. It reduces last-minute ambiguity without pretending that software output replaces financial judgment or current program instructions.
Related reading
Frequently Asked Questions
Can an EHR alone produce every input for a CCBHC cost report?
Do not assume that. Relevant information may span finance, payroll, staffing, encounters, locations, and collaborating organizations. Map the actual instructions to the organization's systems and responsible reviewers.
What should a cost report source inventory contain?
List the report input, authoritative source, definition, reporting period, extraction method, transformation, reconciliation, owner, and evidence location. Record unresolved interpretation questions separately.
Should a clinic use a generic cost report template without checking state instructions?
No. Confirm the applicable program, state process, report version, period, and current instructions with the responsible specialists before preparing inputs or making allocation decisions.
Does this checklist determine allowable costs or payment rates?
No. It organizes source data and accountability. Allowability, allocation, rate setting, and submission decisions require the applicable instructions and qualified financial and program review.
