Separate Spending from Transfers and Reversals

A large transaction total can include internal charges, recoveries and corrections. Reconciliation comes before conclusions.

What is broken, and why?

Adding positive and negative accounting movements without understanding their relationship can misstate the spending story. Gross movement measures activity; net amounts account for offsets. Neither, by itself, establishes what public service was delivered.

The warehouse’s Internal Cost Recovery card explains that some entries allocate or recover costs already recorded elsewhere. Combining those internal flows with program spending can double count activity.

A concrete example the team documented

The report distinguishes account 5700000, Internal Cost Recovery, from account 5710000, Estimated Distributed Indirect and Recovery Cost. In the loaded FY23–FY25 rows described by that reference card, account 5710000 has about $27.51 billion in gross movement but nets to roughly zero.

That is evidence of substantial offsetting accounting activity to investigate, not $27.51 billion of additional service spending or proven waste. The card connects these accounts to official Department of Finance definitions and explains the allocation, recovery and reversal mechanisms researchers must separate.

The concrete correction

  1. Display charges, recoveries and net amounts separately. Make the relationship between gross activity and net spending visible.
  2. Separate the mechanisms. Distinguish internal allocations, chargebacks, transfers, reversals and external purchases.
  3. Reconcile within the right scope. Compare account, department, fund, program, budget reference and fiscal period before adding totals.
  4. Investigate the remaining differences. Use the report’s mechanism queues to identify the records and explanations needed.

The report applies the same principle to IT service billing: an internal-service charge should not automatically be added to the customer agency’s IT spending without checking the relationship.

Why this goes beyond AI

The team has already published the account distinctions, source guidance and gross-versus-net interpretation. Applying this discipline to oversight means requiring a reconciled explanation before presenting a total as spending on a service. An automated alert can identify a pattern; accounting evidence determines what it means.

These examples come from the report’s historical loaded data. They are not a current statewide expenditure total or a calculation of recoverable funds.

Sources: Warehouse: Internal Cost Recovery reference card · DOF: AC Codes Available in Hyperion · Warehouse: mechanism investigation queue

See the three concrete corrections →