The missing context
Raw FI$Cal spreadsheets contained row labels whose meaning was not explained in the files. For many labels, the accompanying definitions, crosswalks, metadata, and interpretation guidance were missing. Seeing where dollars were posted did not explain what those postings represented.
Many of the missing explanations existed elsewhere: accounting manuals, budget documents, code lists, crosswalks, and program descriptions published across a wide range of state agencies and organizations.
Bringing the explanations together
Across nearly 200 recorded research and refinement passes, the team connected unexplained labels to that scattered source material. Successive rounds added context, clarified relationships, and preserved the supporting citations.
One discovery often raised a new question. An explanation in one agency’s documents led to a connection in another, which opened another line of inquiry. Layer by layer, the team assembled the context needed to understand the fiscal story behind Open FI$Cal’s consolidated records.
The resulting semantic reference cards are explanations attached to the report’s accounting categories, departments, programs, and other labels. Within each section, those cards connect the figures to sources that help readers understand them. The appendix brings together the broader collection of government sources.
What that context reveals
Internal cost recovery
An accounting label can represent internal charges, recoveries, and offsets rather than one service delivered to the public. The supporting definitions help explain why gross movements and net amounts tell different stories.
Public health funding
A broad departmental label can encompass distinct financing arrangements. The report’s Public Health card identifies context for infant-formula rebates, genetic screening, and tobacco-prevention funding that the label alone does not convey.
Education: a department total includes money flowing to schools
The Department of Education card explains that many large entries represent formula-driven apportionments and payments to local educational agencies. Connecting the department label to school-finance sources reveals how money flows to schools, beyond the cost of running the state department.
Housing: grants, loans, and transfers tell different stories
Housing records encompass grants, loans, disaster recovery, bond financing, and loan repayments. The Housing and Community Development card brings those distinctions together, including transfer pairs that can enlarge accounting activity without representing additional services.
Wildfire response: spending and eventual state cost can differ
The CAL FIRE card distinguishes routine fire protection, emergency suppression, prevention, and other activities. It also explains that later reimbursements and cost sharing can change the state’s net cost across fiscal years. The initial spending entry is only part of that fiscal story.
Water: regulation, infrastructure, and financing share a label
The State Water Resources Control Board card connects the department’s records to drinking-water and water-quality financing, revolving loan funds, federal grants, cleanup accounts, and permit funds. That context separates agency operations from the broader financing of water projects.
A body of work, not just a technology proposal
Herb Morgan’s team has already done the work of connecting raw fiscal records to the public documents needed to interpret them. The report preserves both the explanations established through that research and the ambiguities that remain.
This is the foundation for a concrete approach to financial accountability: make the numbers understandable, connect interpretations to evidence, and make unanswered questions visible.