How we deciphered FI$Cal

Publishing accounting data is only the beginning. Our research connected the state’s raw postings to the sources needed to explain what they mean.

The published warehouse report documents work already performed by Herb Morgan’s team: adding source-backed explanations, interpretation guidance and caveats to Open FI$Cal records. This companion explains that method through examples from the report.

A posting is not a complete explanation

FI$Cal records show where dollars were posted. Understanding those postings requires more: what an account code represents, which program and financing source it belongs to, and whether the movement is a payment, transfer, recovery, offset or correction.

The report identifies a recurring problem: broad labels combine different activities, while the definitions and context needed to separate them sit in other government sources. Even a correctly recorded total can be misread when that context is missing.

How we added the missing context

  1. Start with the recorded accounting context. Examine the account, department, fund, program, budget reference and fiscal period together.
  2. Translate codes using official crosswalks. Use Department of Finance program and accounting crosswalks, account-code lists and Open FI$Cal definitions to connect abbreviated labels and codes to their documented meaning.
  3. Cross-reference the program and financing. Add agency budget documents and other cited government material to determine what the activity represents and how its funding works.
  4. Check the accounting behavior. Separate positive and negative movements, net amounts, transfers and recoveries before interpreting totals as program spending.
  5. Preserve the explanation and its limits. Record the interpretation, sources and caveats in reusable reference cards. Keep unresolved labels and evidence gaps visible for further research.

The report distinguishes four evidence levels: curated interpretation, official-source labels without added context, generated labels still needing support, and missing reference cards. A plausible label is not treated as a verified explanation.

Method and evidence definitions: warehouse executive summary and reference cards.

Three examples of the method at work

“Internal Cost Recovery” is accounting activity, not one public service

The team connected account codes 5700000 and 5710000 to Department of Finance definitions, then examined their positive and negative movements. The report interprets them as internal allocation, recovery and offset mechanisms.

Why it matters: adding gross movements to program spending can double count activity. The research card calls for showing charges, recoveries and net amounts separately.

Report evidence: “Internal Cost Recovery” reference card. Official account-code source linked by the card.

“Other Special Items of Expense” contains different kinds of activity

The report places Medical & Health Care Payments account 5442000 within this broad public category, while noting a different legacy object mapping. It directs readers to examine the underlying account, agency, fund and program rather than interpret the category as one policy program.

Why it matters: a net category total can conceal the different behavior of benefit payments and transfer or offset entries.

Report evidence: “Other Special Items of Expense” reference card. Open FI$Cal definitions linked by the card.

“Local Administration” does not automatically mean administrative overhead

For Public Health, the team combined program-code mapping with fund and budget context. The report identifies WIC infant-formula rebate financing, fee-supported genetic screening and tobacco-prevention funding within the reviewed activity.

Why it matters: those distinct funding mechanisms should be separated before a broad label is described as headquarters cost, overhead or one program.

Report evidence: “California Department of Public Health” reference card. Department of Public Health budget source linked by the card.

All three examples are drawn from the published warehouse’s Health and Human Services reference cards. The companion summarizes those interpretations; it does not update their underlying research.

From completed research to proposed reform

This work demonstrates a practical starting point: make the accounting intelligible, preserve the source trail, and identify what evidence is still missing. It also explains why publishing a ledger alone cannot establish what services were delivered or whether problems were corrected.

The campaign’s other papers apply that approach to specific proposed controls:

These are proposed government controls. The warehouse’s source-backed interpretation work is the completed research that helps explain their design.

Beyond the Top 10: explore additional HHS research leads →

Making the unknowns detectable and fixable →

What Herb would change: three concrete corrections →