Cities FTR crosswalk

The State Controller's Cities Financial Transactions Report, form by form and line by line, with the CACOA codes that feed each line. Field IDs are the identifiers LGRS uses for each input box.

CACOA 2027.03: 2,294 rules across 41 forms and 2,503 fields. How the crosswalk works

Report

Form 01

General Information

Descriptive

Form 03

Internal Service Fund

From the trial balance25 of 27 lines fed by universal codes

Enterprise

Form 04

Airport Enterprise Fund

From the trial balance50 of 54 lines fed by universal codes

Form 05

Electric Enterprise Fund

From the trial balance47 of 51 lines fed by universal codes

Form 06

Gas Enterprise Fund

From the trial balance41 of 45 lines fed by universal codes

Form 07

Harbor and Port Enterprise Fund

From the trial balance47 of 51 lines fed by universal codes

Form 08

Hospital Enterprise Fund

From the trial balance73 of 77 lines fed by universal codes

Form 09

Sewer Enterprise Fund

From the trial balance42 of 46 lines fed by universal codes

Form 10

Solid Waste Enterprise Fund

From the trial balance41 of 45 lines fed by universal codes

Form 11

Transit Enterprise Fund

From the trial balance41 of 45 lines fed by universal codes

Form 12

Water Enterprise Fund

From the trial balance59 of 63 lines fed by universal codes

Form 13

Other Enterprise Fund

From the trial balance33 of 37 lines fed by universal codes

Conduit Financing

Form 14

Conduit Financing

From schedules

Revenues

Form 15

Functional Revenue Details

Calculated

Form 16

Taxes

From the trial balance24 of 24 lines fed by universal codes

Form 17

Special Benefit Assessments

From the trial balance5 of 5 lines fed by universal codes

Form 18

Licenses and Permits

From the trial balance5 of 5 lines fed by universal codes

Form 19

Fines, Forfeitures, Penalties, and Use of Money and Property

From the trial balance7 of 7 lines fed by universal codes

Form 20

Intergovernmental - State

From the trial balance9 of 9 lines fed by universal codes

Form 21

Intergovernmental - Federal, County, and Other Taxes In-Lieu

From the trial balance6 of 6 lines fed by universal codes

Form 22

Charges for Current Services

From the trial balance30 of 30 lines fed by universal codes

Form 23

Miscellaneous Revenues and Grand Totals

From the trial balance3 of 3 lines fed by universal codes

Expenditures

Form 24

General Government and Public Safety

From the trial balance11 of 13 lines fed by universal codes

Form 25

Transportation and Community Development

From the trial balance14 of 16 lines fed by universal codes

Form 26

Health and Culture and Leisure

From the trial balance14 of 16 lines fed by universal codes

Form 27

Public Utilities and Other Expenditures

From the trial balance6 of 7 lines fed by universal codes

Form 28

Debt Service, Capital Outlay, and Grand Totals

From the trial balance15 of 15 lines fed by universal codes

Form 29

Major Object Classification

From the trial balance18 of 20 lines fed by universal codes

Operating Summary

Form 30

Other Financing Sources (Uses) and Changes in Fund Balance

From the trial balance17 of 21 lines fed by universal codes

Form 30.5

Changes in Fiduciary Net Position

From the trial balance21 of 24 lines fed by universal codes

Debt

Form 31

Long-Term Debt - Bonds and COPs

From schedules

Form 32

Other Long-Term Debt - Loans, Notes, and Other

From schedules

Form 33

Construction Financing - Federal and State

From schedules

Form 34

Lease Obligations

From schedules

Form 35

Debt Service Reconciliation

Calculated

Net Position

Form 36

Check List of Services Provided

Descriptive

Form 37

Balance Sheet - Governmental Funds

From the trial balance31 of 33 lines fed by universal codes

Form 38

Statement of Net Position - Proprietary Funds

From the trial balance73 of 74 lines fed by universal codes

Form 39

Statement of Fiduciary Net Position

From the trial balance39 of 39 lines fed by universal codes

Form 40

Noncurrent Assets and Liabilities, Deferred Out/Inflows

From the trial balance42 of 43 lines fed by universal codes

Summary

Form 41

Summary and Statistics

Calculated