California Agency Chart of Accounts (CACOA)
A Standards-Aligned, Flexible Framework for Public Agency Accounting and Reporting
Prospectus
Executive Summary
California public agencies operate in an increasingly complex financial environment. Agencies must meet statutory reporting requirements, maintain GAAP compliance, support audits, respond to transparency demands, and manage operations with limited staffing and aging systems.
The California Agency Chart of Accounts (CACOA) is a voluntary, standards-aligned accounting framework designed to address these challenges by providing a shared structural foundation for public-sector accounting—without requiring agencies to abandon local practices, systems, or professional judgment.
CACOA is not a mandate, not a software product, and not a replacement for GAAP.
It is a reference framework that enables:
- consistent classification of financial activity across agencies,
- scalable adoption for agencies of varying size and complexity,
- explicit alignment with California Financial Transaction Report (FTR) requirements for municipalities, and
- compatibility with a broad range of special districts and public agencies not governed by the California Department of Education (CDE).
CACOA is published under the MIT License, permitting free use, modification, and redistribution of the framework materials. The license does not apply to agency financial data or proprietary systems.
Purpose and Scope
The purpose of CACOA is to reduce fragmentation in public-sector accounting structures by providing a shared structural vocabulary that supports statutory reporting, budgeting, financial statements, management analysis, and public transparency. CACOA is designed as infrastructure rather than mandate.
CACOA is intended for use by:
- Cities and municipalities
- Special districts (enterprise, governmental, fiduciary, and hybrid)
- Joint powers authorities (JPAs)
- Public agencies and authorities not subject to CDE/SACS requirements
While CACOA is designed to be broadly applicable, its explicit reporting alignment is limited as follows:
- FTR mapping and validation are targeted specifically to municipalities
- Non-municipal agencies may adopt CACOA structures without FTR mapping requirements
This distinction is intentional and reflects the differing statutory reporting obligations across California public agencies.
Relationship to GASB and GAAP
CACOA is designed to support, not define, accounting standards issued by the Governmental Accounting Standards Board.
Key Principles
- CACOA does not establish recognition, measurement, or disclosure rules
- CACOA does not supersede professional judgment
- CACOA provides structural consistency to help agencies apply GASB standards more effectively
In other words:
- GASB defines what must be reported.
- CACOA provides a consistent way to organize and report it.
CACOA’s design reflects:
- fund accounting principles,
- measurement focus distinctions,
- legal and budgetary compliance realities, and
- common public-sector reporting structures.
CACOA Is:
- A multi-dimensional chart of accounts framework
- Object-centric and reporting-first
- Designed for partial or full adoption
- Compatible with existing ERPs and local charts
- Extensible through reserved local ranges
- Transparent about unmapped or exceptional items
CACOA Is Not:
- A mandated statewide chart
- A replacement for GASB or GAAP
- An ERP system
- A prescriptive posting manual
- A one-size-fits-all solution
Core Design Philosophy
1. Reporting-First, Not Posting-First
CACOA recognizes that agencies post transactions differently due to:
- legacy systems,
- historical practice,
- operational needs, and
- staffing constraints.
Rather than forcing uniform posting behavior, CACOA prioritizes: - consistent reporting outcomes
- transparent mapping
- diagnostic visibility
- consistent reporting outcomes
- transparent mapping
- diagnostic visibility
This allows agencies to achieve comparability without disrupting operations.
2. Object-Centric Structure
CACOA emphasizes standardized object classifications (assets, liabilities, equity, revenue, expenditures) as the primary driver of comparability.
This approach:
- mirrors successful elements of SACS object discipline,
- supports FTR line mapping for municipalities,
- allows flexibility in funds, departments, and functions.
Objects provide the strongest anchor for statewide comparability while remaining intuitive to finance professionals.
3. Multi-Dimensional and Extensible
CACOA separates accounting dimensions into:
- Funds
- Objects
- Functions
- Departments
- Reporting relationships
This separation:
- prevents overloading single codes with multiple meanings,
- allows local extensions without breaking rollups,
- supports future analytics and automation.
Reserved ranges are intentionally included to accommodate:
- agency-specific programs,
- enterprise complexity,
- regulatory nuance.
4. Support for Reporting Profiles
CACOA implements flexible reporting profiles: - Municipal FTR - Budget Development - ACFR/CAFR - Custom Management/Operational Dashboarding.
Profiles define how accounts are grouped and presented for specific reporting purposes and are reusable and transferable across agencies.Each profile emphasizes unique group-level analytics, dashboarding, cost center analysis, and benchmarking.
5. Transferability and Shared Reporting
Reporting profiles, rollups, custom SQL may be shared across agencies without requiring identical charts of accounts. This enables peer benchmarking, shared dashboards, and reusable reporting logic while preserving local control.
Implementation Options
CACOA is designed to be adopted incrementally.
1. Minimal Adoption (Rollup-Only)
Description
- Retain existing chart of accounts
- Map local accounts to CACOA objects and categories
- Produce standardized reports without changing posting practices
Best For
- Small agencies
- Agencies in audit backlog
- Initial pilots
Benefits
- No operational disruption
- Immediate reporting improvements
- Low implementation cost
2. Mapped (Hybrid) Adoption
Description
- Existing chart remains active
- New accounts follow CACOA where practical
- Legacy accounts mapped via rules
- Validation highlights unmapped or ambiguous items
Best For
- Mid-sized agencies
- Agencies preparing for system changes
- Agencies seeking gradual standardization
3. Full Structural Adoption
Description
- CACOA becomes the primary chart
- Local detail implemented within reserved ranges
- Validation rules enforce consistency
- FTR reporting largely automated for municipalities
Best For
- Large cities
- New agencies
- ERP implementations
Handling Real-World and Non-Standard Practices
CACOA explicitly acknowledges that many legitimate practices do not fit neatly into textbook examples.
Event-Based Accounting
Some agencies track events (festivals, emergencies, special programs) as unique objects.
CACOA approach:
- Treats events as management or program dimensions, not object classes
- Recommends retaining standard expenditure objects
- Allows mapping and exception documentation where event-specific objects exist
Development and Balance-Sheet-Driven Activity
Common examples include:
- developer deposits recorded as liabilities,
- reimbursements drawn down from balance sheet accounts,
- trust-like or pass-through arrangements.
CACOA approach:
- Recognizes these practices as potentially GAAP-compliant
- Supports explicit balance sheet object classes
- Uses documented exception handling rather than forced reclassification
- Preserves transparency for audit and reporting review
FTR Alignment (Municipalities Only)
For cities and municipalities, CACOA includes:
- explicit object-to-FTR line mappings,
- validation rules for coverage,
- draft vs finalized reporting states,
- diagnostic views identifying unmapped activity.
For non-municipal agencies:
- CACOA structures remain valid
- FTR mapping is optional and not enforced
This distinction ensures relevance without overextension.
Ancillary Benefits
Beyond compliance, CACOA provides significant organizational value.
Workforce Mobility and Training
- Familiar structures across agencies
- Reduced onboarding time
- Transferable skills for staff
Recruitment and Retention
- Clear, professional accounting frameworks
- Reduced dependence on institutional memory
- Improved succession planning
Transparency and Public Trust
- Comparable reporting across agencies
- Improved interpretability for policymakers and the public
- Stronger foundation for open data initiatives
Conclusion
The California Agency Chart of Accounts is designed to be:
- Practical for agencies of all sizes
- Aligned with GASB principles
- Explicit where statutory reporting applies
- Flexible where professional judgment is required
CACOA does not seek to eliminate local nuance.
It seeks to make that nuance visible, understandable, and reportable within a shared framework.
Adoption can begin at any level and mature over time, allowing California public agencies to move toward greater consistency without sacrificing clarity or control.
SCO Alignment
This part of the CACOA Manual provides comprehensive, textbook-level guidance on alignment with the California State Controller’s Office (SCO) Financial Transactions Report (FTR). Each chapter mirrors the FTR structure and explains statutory intent, accounting rationale, CACOA implementation guidance, common pitfalls, and audit considerations.
1 – Overview of the Financial Transactions Report (FTR)
This chapter provides comprehensive, textbook-level guidance on the California State Controller’s Office (SCO) Financial Transactions Report (FTR). It establishes the statutory purpose of the FTR, explains how the report is used by state agencies and the public, and describes how the California Agency Chart of Accounts (CACOA) is intentionally designed to align with — but not replace — FTR reporting.
1.1 Statutory Authority and Purpose of the FTR
The Financial Transactions Report (FTR) is authorized under California law and administered by the State Controller’s Office as the primary mechanism for collecting standardized financial data from California municipalities. The FTR is designed to support statewide fiscal monitoring, legislative analysis, intergovernmental comparisons, and public transparency.
Unlike audited financial statements, which focus on fair presentation in accordance with GAAP, the FTR emphasizes uniform classification and comparability. Its objective is not to replicate local financial statements, but to normalize financial activity across diverse accounting systems into a common analytical framework.
1.2 Intended Users and Uses of the FTR
FTR data is used by a broad range of stakeholders, including the Legislature, Department of Finance, bond analysts, researchers, journalists, and the general public. These users rely on consistent classification to evaluate fiscal trends, compare municipalities, and assess financial condition.
Because users do not have access to local charts of accounts or internal accounting policies, clarity and consistency in FTR classification are critical. CACOA is designed to preserve this consistency while allowing agencies to retain local flexibility.
1.3 Relationship to GASB and Audited Financial Statements
The FTR does not supersede GASB standards or replace audited financial statements. GASB standards govern recognition, measurement, and presentation for financial reporting, while the FTR governs classification for statewide data collection.
Differences between audited financial statements and FTR totals may arise due to timing, reclassification, or consolidation differences. CACOA explicitly supports reconciliation between local ledgers, audited statements, and FTR submissions by maintaining traceable mappings.
1.4 Structural Organization of the FTR
The FTR is organized around a small number of core dimensions: fund, revenue classification, expenditure function, expenditure object, other financing sources and uses, and balance sheet elements. Each dimension serves a distinct analytical purpose.
The FTR structure intentionally limits dimensional complexity to promote comparability. CACOA respects these constraints by applying additional analytical dimensions only at the reporting and management layers.
1.5 CACOA’s Alignment Philosophy
CACOA is designed as a translation and alignment framework rather than a prescriptive accounting system. Agencies are not required to abandon their existing charts of accounts to achieve FTR compliance.
Instead, CACOA provides standardized object definitions, fund structures, functional guidance, and rollup logic that can be applied to existing data. This approach lowers adoption barriers and supports incremental implementation.
1.6 Common Misconceptions About the FTR
A common misconception is that the FTR represents a full financial statement or audit substitute. In reality, the FTR is a statistical and analytical report that complements, but does not replace, audited financial reporting.
Another misconception is that agencies must restructure their accounting systems to match the FTR. CACOA demonstrates that alignment can be achieved through mapping and rollups without disrupting local operations.
1.7 Role of CACOA in Statewide Standardization
CACOA provides a consistent reference structure that can be adopted voluntarily across agencies. By aligning CACOA structures with the FTR, agencies gain a shared vocabulary for financial reporting, training, benchmarking, and system design.
Over time, consistent CACOA adoption can reduce the cost of onboarding staff, improve data quality, and enable more advanced statewide analysis without imposing mandates.
1.8 Citations and References
• California State Controller’s Office – Financial Transactions Report Instructions
• California Government Code Sections governing municipal reporting
• GASB Concepts Statement No. 1 – Objectives of Financial Reporting
2 – Fund Structure and Fund Reporting in the FTR
This chapter provides comprehensive guidance on fund structure and fund reporting under the California State Controller’s Office (SCO) Financial Transactions Report (FTR). It explains the central role of funds in statutory reporting, the relationship between funds and other accounting dimensions, and how the California Agency Chart of Accounts (CACOA) supports compliant, flexible, and auditable fund reporting.
2.1 The Fund as the Primary Accountability Unit
In governmental accounting, the fund is the primary unit of fiscal accountability. Each fund represents a self-balancing set of accounts established to demonstrate legal compliance, financial stewardship, and operational accountability.
The FTR is explicitly fund-centric. All revenues, expenditures, assets, liabilities, other financing sources and uses, and fund balances are reported within a fund context. There is no concept of cross-fund netting or functional fund balances in statutory reporting.
2.2 Statutory and Reporting Expectations in the FTR
The SCO’s FTR instructions require agencies to report financial activity by individual fund, using standardized fund groupings for statewide analysis. These groupings distinguish among governmental, proprietary, fiduciary, and other fund types.
The FTR does not prescribe how agencies must structure their internal fund numbering systems. Instead, it requires that reported data be classified consistently for comparability across jurisdictions.
2.3 CACOA Fund Coding Structure
CACOA adopts a three-digit base fund coding structure to balance simplicity with scalability. This structure accommodates common municipal fund types while allowing larger agencies to extend fund codes for additional granularity without breaking rollup logic.
CACOA fund codes are intentionally neutral with respect to internal system design. Agencies may retain legacy fund numbers while mapping them to CACOA fund identifiers for reporting.
2.4 Fund Rollups and Reporting Views
Fund rollups are a core CACOA concept. A rollup is a defined aggregation of multiple funds for a specific reporting purpose. Rollups do not alter legal fund accounting and do not replace individual fund reporting.
CACOA supports multiple concurrent rollups, such as governmental funds for FTR reporting, enterprise fund groupings for rate analysis, or management-defined groupings for budgeting.
2.5 When to Create a Separate Fund
A separate fund should be established when required by law, regulation, bond covenant, or when necessary to demonstrate accountability for restricted or committed resources.
Common triggers for separate funds include legally restricted revenues, voter-approved taxes, grant requirements, rate-based activities, or material fiduciary responsibilities.
2.6 Fund vs Function vs Department
Confusion among funds, functions, and departments is a common source of reporting error. Funds represent accountability for resources, functions represent the purpose of spending, and departments represent organizational responsibility.
CACOA explicitly discourages using functions or departments to simulate fund restrictions or fund balance segregation. Separate funds should be used when accountability requires it.
2.7 Real-World Examples
Example 1 – General Fund vs Special Revenue Fund:
A city receiving a voter-approved public safety sales tax should establish a special revenue fund if the proceeds are legally restricted. Recording the revenue in the General Fund with a public safety function does not provide adequate accountability for statutory reporting.
Example 2 – Enterprise Utility Funds:
Water and sewer operations are typically reported in separate enterprise funds. CACOA allows these funds to be grouped for FTR reporting while preserving individual fund integrity for rate-setting and bond compliance.
2.8 Common Errors and CACOA Diagnostics
Common errors include excessive fund proliferation, using departments to mimic funds, and inconsistent fund definitions across reporting periods. CACOA diagnostics identify unmapped funds, incomplete rollups, and inconsistencies prior to FTR submission.
2.9 Audit and Reconciliation Considerations
Auditors evaluate fund structure for consistency, legal compliance, and clarity. CACOA supports audit review by preserving traceability from individual fund activity to FTR rollups and audited financial statements.
2.10 Citations and References
• California State Controller’s Office – Financial Transactions Report Instructions
• GASB Statement No. 34 – Basic Financial Statements
• GASB Concepts Statement No. 1 – Objectives of Financial Reporting
3 – Revenue Reporting in the Financial Transactions Report (FTR)
This chapter provides comprehensive, textbook-level guidance on revenue reporting under the California State Controller’s Office (SCO) Financial Transactions Report (FTR). It explains statutory expectations, GASB alignment, CACOA revenue object structure, and appropriate analytical treatment of revenues for both statutory and management reporting.
3.1 Purpose and Scope of Revenue Reporting in the FTR
Revenue reporting in the FTR is designed to identify the source, legal character, and economic nature of inflows to a governmental entity. The FTR emphasizes comparability across jurisdictions by standardizing revenue classifications while allowing agencies to retain local detail internally.
Revenues are reported by fund and revenue classification. Functional classification is not applied to revenues in the FTR, reflecting the principle that revenues describe sources of financing rather than purposes of spending.
3.2 Relationship to GASB Revenue Recognition Standards
GASB standards govern when and how revenues are recognized, while the FTR governs how recognized revenues are classified for statewide reporting. GASB Statement No. 33 establishes the framework for recognizing nonexchange revenues, including taxes and intergovernmental revenues.
CACOA respects GASB recognition principles by separating recognition and measurement from classification. Revenue objects and rollups are applied at the reporting layer and do not alter GAAP-based accounting.
3.3 CACOA Revenue Object Structure and FTR Alignment
CACOA revenue objects are organized within the 3000–3999 range and mapped directly to FTR revenue lines. Objects distinguish among major categories such as taxes, licenses and permits, intergovernmental revenues, charges for services, fines and forfeitures, use of money and property, and other revenues.
This structure ensures deterministic rollups to FTR categories while allowing agencies to define additional local detail beneath standardized object classes.
3.4 General Revenues vs Program Revenues
GASB Statement No. 34 distinguishes between general revenues and program revenues for government-wide financial reporting. While the FTR does not require explicit identification of program revenues, understanding this distinction is critical for consistent reporting.
CACOA supports program revenue analysis through analytical linkages rather than functional revenue posting, preserving statutory compliance while enabling meaningful internal reporting.
3.5 Functional Revenue: Prohibition and Management Alternatives
Functional classification describes the purpose of expenditures and is not a statutory dimension for revenue reporting. Assigning revenues to functions can obscure legal restrictions and distort fund-level accountability.
CACOA prohibits functional revenue classification in the FTR profile. Agencies seeking functional revenue analysis for management purposes should use program codes, grant identifiers, or reporting views rather than ledger postings.
3.6 When to Use Separate Funds for Revenue Accountability
Separate funds should be used when revenues are legally restricted, voter-approved, rate-based, or otherwise require discrete accountability. Using functional revenue coding as a substitute for separate funds is discouraged.
CACOA provides guidance for identifying when fund segregation is appropriate and supports rollups to maintain comparability without sacrificing accountability.
3.7 Real-World Examples
Example 1 – Property Tax Revenue (General Fund):
Property tax revenues are recorded in the General Fund using the appropriate revenue object. No functional classification is applied. Expenditures funded by property taxes are later reported by function in the expenditure section of the FTR.
Example 2 – Grant-Funded Program:
Grant revenues are recorded in the applicable fund using intergovernmental revenue objects. Expenditures are charged to the appropriate functions and objects. Program-level analysis links revenues and expenditures analytically.
Example 3 – Enterprise Utility Charges:
Charges for water or sewer services are recorded in enterprise funds using charges-for-services objects. No functional revenue classification is applied. Functional analysis may occur at the expenditure level for management purposes.
3.8 Common Errors and CACOA Diagnostics
Common revenue reporting errors include misclassifying transfers as revenues, embedding functional meaning in revenue objects, and using revenue classification to simulate fund restrictions. CACOA diagnostics identify these issues prior to FTR submission.
3.9 Audit and Reconciliation Considerations
Auditors evaluate revenue classification for consistency, legal compliance, and reconciliation to audited financial statements. CACOA preserves traceability from detailed revenue objects to FTR rollups and GASB-based disclosures.
3.10 Citations and References
• California State Controller’s Office – Financial Transactions Report Instructions
• GASB Statement No. 33 – Accounting and Financial Reporting for Nonexchange Transactions
• GASB Statement No. 34 – Basic Financial Statements and Management’s Discussion and Analysis
4 – Expenditure Reporting in the Financial Transactions Report (FTR)
This chapter provides comprehensive, textbook-level guidance on expenditure reporting under the California State Controller’s Office (SCO) Financial Transactions Report (FTR). It explains the statutory role of functional and object classification, how expenditures differ from revenues and balance sheet activity, and how the California Agency Chart of Accounts (CACOA) supports compliant, flexible, and auditable expenditure reporting.
4.1 Purpose and Scope of Expenditure Reporting in the FTR
Expenditure reporting in the FTR is designed to answer two fundamental questions: why resources were spent and what was acquired. These questions are addressed through the combined use of functional and object classifications.
Unlike revenue reporting, functional classification is mandatory for expenditures in the FTR. This requirement reflects the central role of expenditure data in evaluating service delivery, policy priorities, and cost structures across municipalities.
4.2 Functional Classification: Purpose of Spending
Functions describe the purpose or objective of an expenditure, such as public safety, public works, community development, or general government. Functional classification enables statewide comparisons of how resources are allocated among services.
CACOA adopts a four-digit function structure modeled on widely recognized governmental reporting standards. Function 0000 is reserved as a silent or non-applicable value and should not be used for expenditure reporting in the FTR profile.
4.3 Object Classification: Nature of Spending
Object classification describes the nature of what was purchased or paid, such as salaries, benefits, supplies, services, or capital assets. Object codes provide insight into cost drivers and spending behavior.
CACOA expenditure objects are organized within the 4000–4999 range and grouped into standardized object classes that roll up deterministically to FTR expenditure categories.
4.4 Relationship Between Function and Object
Function and object classifications are complementary, not interchangeable. Functions answer why money was spent; objects answer what the money was spent on. Both dimensions are required to fully describe an expenditure in statutory reporting.
CACOA enforces this separation to prevent misuse of objects to simulate functional reporting or functions to simulate spending categories.
4.5 Departments and Cost Centers
Departments represent organizational responsibility and are optional for FTR reporting. While not required by the FTR, departments are critical for internal management, budgeting, and cost control.
CACOA supports department coding as a parallel analytical dimension that does not interfere with statutory classification. Department rollups enable dashboarding and performance analysis.
4.6 Shared Costs and Cost Allocation
Many municipal costs support multiple functions or programs. Shared costs may include information technology, fleet services, human resources, or administrative overhead.
CACOA supports cost allocation methodologies while preserving FTR integrity. Allocations should be documented, applied consistently, and reviewed periodically. Allocated costs must retain appropriate functional and object classifications.
4.7 Capital Outlay vs Operating Expenditures
Capital outlay expenditures represent the acquisition or construction of capital assets and are distinct from operating expenditures. Proper classification is essential for meaningful financial analysis.
CACOA distinguishes capital outlay objects from operating objects while recognizing that capital assets are later reported on the balance sheet in accordance with capitalization policies.
4.8 Real-World Examples
Example 1 – Police Department Salaries:
Police salaries are recorded in the appropriate fund using a public safety function and salary-related expenditure objects. Department codes may be used for management analysis but do not affect FTR classification.
Example 2 – Shared IT Services Allocation:
Information technology costs incurred centrally may be allocated to multiple functions using a documented allocation methodology. Each allocated expenditure retains its functional and object classification for FTR reporting.
Example 3 – Capital Project Expenditures:
Expenditures for infrastructure construction are recorded using capital outlay objects and the appropriate function. The resulting asset is capitalized and reported separately on the balance sheet.
4.9 Common Errors and CACOA Diagnostics
Common errors include using departments in place of functions, misclassifying capital outlay as operating expense, and inconsistent allocation practices. CACOA diagnostics identify these issues prior to FTR submission.
4.10 Audit and Reconciliation Considerations
Auditors assess expenditure classification for consistency, appropriateness, and compliance with GASB and statutory requirements. CACOA preserves traceability from detailed postings to FTR rollups and audited financial statements.
4.11 Citations and References
• California State Controller’s Office – Financial Transactions Report Instructions
• GASB Statement No. 34 – Basic Financial Statements
• GASB Concepts Statement No. 1 – Objectives of Financial Reporting
5 – Other Financing Sources and Uses (OFS/OFU) in the Financial Transactions Report (FTR)
This chapter provides comprehensive, textbook-level guidance on Other Financing Sources and Uses (OFS/OFU) as reported in the California State Controller’s Office (SCO) Financial Transactions Report (FTR). It explains the conceptual distinction between operating activity and financing activity, the statutory treatment of transfers and debt proceeds, and how the California Agency Chart of Accounts (CACOA) supports accurate classification, diagnostics, and reconciliation.
5.1 Purpose and Conceptual Framework of OFS/OFU
Other Financing Sources and Uses represent inflows and outflows that are not revenues or expenditures. They reflect changes in financial resources arising from financing decisions rather than operations.
5.2 Relationship to GASB Standards
GASB standards distinguish operating activity from financing activity across governmental and proprietary fund reporting. GASB Statement No. 34 establishes the framework for reporting other financing sources and uses in governmental funds.
5.3 CACOA Object Structure for OFS/OFU
CACOA reserves dedicated object ranges for Other Financing Sources and Uses, distinct from revenue and expenditure object ranges.
5.4 Interfund Transfers
Interfund transfers represent flows of financial resources between funds without expectation of repayment.
5.5 Debt Proceeds
Proceeds from issuing bonds or notes are reported as Other Financing Sources in governmental funds.
5.6 Capital Contributions
Capital contributions may be reported as Other Financing Sources depending on legal structure.
5.7 Real-World Examples
Examples include General Fund transfers to Capital Projects Funds and bond issuance proceeds.
5.8 Common Errors and Diagnostics
Common errors include misclassifying transfers as revenues and failing to record symmetrical entries.
5.9 Audit and Reconciliation
Auditors closely review OFS/OFU because misclassification can materially affect reported results.
5.10 Citations
• SCO Financial Transactions Report Instructions
• GASB Statement No. 34
6 – Balance Sheet and Fund Balance Reporting in the FTR
This chapter provides comprehensive, textbook-level guidance on balance sheet and fund balance reporting under the California State Controller’s Office (SCO) Financial Transactions Report (FTR). It explains how assets, liabilities, and equity/fund balance are reported at the fund level, how these concepts align with GASB requirements, and how CACOA supports compliant classification, rollups, and diagnostics without compromising local accounting needs.
6.1 Purpose and Scope of Balance Sheet Reporting in the FTR
Balance sheet reporting in the FTR is designed to provide statewide visibility into the financial position of municipalities. While the FTR is not a substitute for audited financial statements, its balance sheet categories allow comparability across agencies by applying standardized classification at the fund level.
Unlike expenditure reporting, balance sheet reporting does not use functional classification. Assets and liabilities are reported solely by fund and object classification.
6.2 Relationship to GASB: Governmental vs Proprietary Reporting
GASB Statement No. 34 requires governments to present both governmental fund financial statements and government-wide statements. Governmental funds use the modified accrual basis and generally focus on short-term financial resources, while proprietary funds use full accrual and focus on economic resources.
The FTR balance sheet consolidates key balance sheet categories by fund but does not replicate all GAAP presentation nuances. CACOA supports both bases by maintaining consistent object definitions while allowing reporting profiles to tailor presentation.
6.3 CACOA Asset Classification and FTR Alignment
CACOA asset objects are organized within the 1000–1999 range and mapped to FTR balance sheet lines. Asset classes are structured to distinguish current assets (cash, receivables, inventories, prepaid items) from noncurrent assets (capital assets, restricted assets, long-term receivables).
CACOA supports additional detail beneath standardized asset categories, provided that rollups remain deterministic and traceable.
6.4 CACOA Liability Classification and FTR Alignment
CACOA liability objects are organized within the 2000–2899 range and mapped to FTR balance sheet lines. Liabilities are structured to distinguish current liabilities (accounts payable, accrued liabilities, current portions of long-term debt) from long-term liabilities (bonds, leases, pensions, OPEB).
Proper liability classification is critical for comparability and audit review, particularly for pension and OPEB obligations, lease liabilities, and debt-related balances.
6.5 Equity and Fund Balance: Governmental and Proprietary Concepts
In governmental funds, equity is typically reported as fund balance, which GASB Statement No. 54 requires to be classified into nonspendable, restricted, committed, assigned, and unassigned categories. In proprietary funds, equity is reported as net position, classified into net investment in capital assets, restricted, and unrestricted categories.
The FTR reports equity/fund balance at the fund level, focusing on standardized categories that support statewide analysis. CACOA provides equity objects within the 2900–2999 range and supports GASB-aligned subclassification through reference tables and rollups.
6.6 Prohibition on Functional Balances and Improper Segmentation
A common structural error is attempting to track fund balance by function or department. Fund balance represents the residual of assets and liabilities within a fund and must be maintained at the fund level. Functions describe the purpose of expenditures and do not apply to balance sheet accounts.
CACOA explicitly prohibits functional classification of balance sheet accounts in the FTR profile and provides diagnostics to identify improper postings.
6.7 Special Situations and Real-World Examples
Example 1 – Developer Deposits and Drawdowns:
A city may receive deposits from developers for plan review or inspection services. These deposits are not revenue at receipt; they represent a liability (deposit payable). As services are provided, the city recognizes revenue or reduces the liability depending on the policy and legal structure. CACOA supports this by providing distinct liability objects for deposits and appropriate revenue objects for earned amounts.
Example 2 – Advances Between Funds:
Interfund advances differ from transfers. Advances are balance sheet receivables/payables expected to be repaid. Transfers are other financing sources/uses and do not create receivables. CACOA distinguishes advances using asset and liability objects, while transfers are recorded in OFS/OFU ranges.
Example 3 – Restricted Cash in Enterprise Funds:
Enterprise funds may hold restricted cash for bond covenants or capital reserves. CACOA supports restricted asset objects that roll up to FTR categories while preserving detail for covenant compliance.
6.8 Common Errors and CACOA Diagnostics
Common balance sheet reporting errors include treating deposits as revenue, misclassifying advances as transfers, failing to separate current and long-term portions of liabilities, and mixing restricted and unrestricted assets without adequate detail. CACOA diagnostics identify these issues through mapping completeness checks and classification validation rules.
6.9 Audit and Reconciliation Considerations
Balance sheet accounts are frequently subject to audit emphasis because they affect financial position and long-term obligations. CACOA supports audit review by providing consistent definitions, GASB-aligned descriptions, and traceable rollups from detailed objects to FTR categories.
Reconciliation between local ledgers, audited statements, and FTR reporting should be performed at the fund level. CACOA’s reporting views are designed to facilitate this reconciliation by preserving fund integrity and deterministic rollups.
6.10 Citations and References
• California State Controller’s Office – Financial Transactions Report Instructions
• GASB Statement No. 34 – Basic Financial Statements and Management’s Discussion and Analysis
• GASB Statement No. 54 – Fund Balance Reporting and Governmental Fund Type Definitions
• GASB Statement No. 68 – Accounting and Financial Reporting for Pensions
• GASB Statement No. 75 – Accounting and Financial Reporting for Postemployment Benefits Other Than Pensions
• GASB Statement No. 87 – Leases
7 – Functional Rules, Exceptions, and Special Cases in FTR Reporting
This chapter provides authoritative guidance on the application of functional classification in the California State Controller’s Office (SCO) Financial Transactions Report (FTR). It addresses when functional classification is required, when it is prohibited, common exceptions encountered in municipal accounting, and how the California Agency Chart of Accounts (CACOA) enforces consistent, auditable treatment while allowing operational flexibility.
7.1 Purpose of Functional Classification
Functional classification exists to describe the purpose of expenditures. It allows statewide comparison of how resources are allocated among services such as public safety, public works, community development, and general government.
7.2 When Functional Classification Is Required
Functional classification is required for all operating and capital expenditures reported in the FTR.
7.3 When Functional Classification Is Prohibited
Functional classification must not be applied to revenues, balance sheet accounts, or other financing sources and uses.
7.4 Primary Function Selection
Agencies must assign a primary function or allocate costs across functions using documented methodologies.
7.5 Cost Allocation and Shared Services
Shared services may be allocated to benefiting functions using rational, consistent methodologies.
7.6 Departments vs Functions
Departments represent organizational responsibility and must not be used as substitutes for functions.
7.7 Special Cases
Certain expenditures may require documented exceptions while preserving standardized rollups.
7.8 Real-World Examples
Examples include election costs, emergency operations, and improper functional revenue use.
7.9 Common Errors and Diagnostics
CACOA diagnostics identify missing or improper functional classification.
7.10 Audit Considerations
Auditors evaluate functional classification for consistency and appropriateness.
7.11 Citations
• SCO Financial Transactions Report Instructions
• GASB Statement No. 34
8 – Diagnostics, Validation, and Error Resolution in CACOA and FTR Reporting
This chapter provides comprehensive, textbook-level guidance on diagnostics, validation, and error resolution within the California Agency Chart of Accounts (CACOA) framework as it relates to Financial Transactions Report (FTR) reporting. It explains how structured validation rules, diagnostic reporting, and controlled exception handling improve data quality, audit readiness, and statewide comparability without preventing agencies from previewing results or submitting draft reports.
8.1 Purpose of Diagnostics and Validation
Diagnostics and validation exist to ensure that financial data is structurally sound, internally consistent, and compliant with statutory reporting requirements. Unlike transactional controls that prevent posting, CACOA diagnostics are designed to identify issues early while preserving the ability to analyze and review data.
This approach supports iterative improvement, transparency, and informed decision-making prior to final FTR submission.
8.2 Validation Philosophy: Prevent vs Detect
CACOA distinguishes between preventative controls and detective controls. Preventative controls block structurally invalid combinations, such as applying functional codes to balance sheet accounts. Detective controls identify issues that require judgment or correction.
This distinction allows agencies to preview results, understand unmapped items, and address exceptions without suppressing meaningful information.
8.3 Core Validation Rules
Core validation rules enforce non-negotiable statutory requirements. Examples include requiring function codes on expenditures, prohibiting function codes on revenues and balance sheet objects, and enforcing fund-level integrity for equity balances.
8.4 Mapping Completeness and Draft States
CACOA supports explicit mapping states that indicate whether a chart element is fully mapped, partially mapped, or unmapped for FTR reporting. Draft states allow agencies to review preliminary rollups while clearly identifying gaps.
This design avoids the false choice between blocking reports and submitting incomplete data.
8.5 Unmapped and Exception Handling
Unmapped items may arise from locally defined codes, newly introduced activity, or unusual transactions. CACOA provides exception tables and diagnostic views to capture these items without forcing premature classification.
8.6 Symmetry and Cross-Fund Validation
Certain transactions require symmetrical treatment across funds, such as interfund transfers and advances. CACOA diagnostics identify unmatched pairs and imbalances prior to FTR submission.
8.7 Rollup Integrity and Range Validation
CACOA relies on deterministic rollups based on code ranges and class definitions. Validation rules ensure that all detail codes fall within defined ranges and that rollups do not overlap in ways that compromise comparability.
8.8 Diagnostic Reporting and Review Workflow
Diagnostic reports present validation results in a structured, review-friendly format. Agencies should review diagnostics iteratively, resolve high-risk issues, and document exceptions prior to finalizing FTR submissions.
8.9 Audit Readiness and Documentation
Well-documented diagnostics and exception handling support audit review by demonstrating intentional classification decisions, consistent application of rules, and continuous improvement.
8.10 Citations and References
• California State Controller’s Office – Financial Transactions Report Instructions
• GASB Concepts Statement No. 1 – Objectives of Financial Reporting
• GASB Statement No. 34 – Basic Financial Statements
9 – Reconciliation, Submission, and Review Process for CACOA and FTR Reporting
This chapter provides comprehensive, textbook-level guidance on the final stages of Financial Transactions Report (FTR) preparation: reconciliation, submission, and review. It explains how the California Agency Chart of Accounts (CACOA) supports reconciliation to audited financial statements, structured internal review, and compliant submission to the California State Controller’s Office (SCO).
9.1 Purpose of Reconciliation and Review
Reconciliation ensures that data reported in the FTR is complete, accurate, and consistent with the agency’s accounting records and audited financial statements. Review processes provide assurance that classification decisions are intentional, documented, and compliant.
9.2 Relationship Between FTR and Audited Financial Statements
The FTR is not a replacement for audited financial statements. Rather, it is a standardized statutory report derived from those statements and the underlying accounting records.
CACOA facilitates reconciliation by maintaining deterministic rollups from detailed chart elements to FTR categories, allowing agencies to trace reported amounts back to source data.
9.3 Reconciliation at the Fund Level
Reconciliation should be performed at the fund level, consistent with the unit of accountability used in the FTR. Agencies should reconcile fund revenues, expenditures, other financing sources and uses, and ending fund balances to audited figures.
9.4 Timing and Sequencing of Reconciliation Activities
Reconciliation is an iterative process. Preliminary reconciliation may occur prior to audit completion, with final reconciliation performed after audited balances are available.
9.5 Use of Diagnostics in Final Review
Diagnostics developed under CACOA play a critical role in final review. Agencies should resolve high-severity issues, review remaining exceptions, and document rationale for any unresolved items prior to submission.
9.6 Internal Review and Approval Workflow
Agencies should establish a formal internal review process that includes accounting staff, finance leadership, and, where appropriate, external advisors. Documentation of review and approval supports accountability and audit readiness.
9.7 Submission to the State Controller’s Office
The SCO establishes deadlines and submission formats for the FTR. Agencies are responsible for ensuring timely submission and responding to follow-up inquiries or correction requests.
9.8 Responding to SCO Review and Inquiries
SCO staff may request clarification or correction of reported data. CACOA supports efficient response by preserving traceability and providing documentation of classification and mapping decisions.
9.9 Post-Submission Review and Continuous Improvement
Following submission, agencies should review diagnostic results, SCO feedback, and audit findings to identify opportunities for improvement. CACOA supports continuous refinement of mappings and validation rules without disrupting historical comparability.
9.10 Citations and References
• California State Controller’s Office – Financial Transactions Report Instructions
• GASB Concepts Statement No. 1 – Objectives of Financial Reporting
• GASB Statement No. 34 – Basic Financial Statements and Management’s Discussion and Analysis
Funds
General Governmental
100 General Fund — Operating
110 Impact Fees / Development Fees — Governmental
130 Grants — Governmental (general)
190 Other Governmental — Reserved
200 Special Revenue — General (restricted programs)
250 Special Revenue — Public Safety Programs (template)
260 Special Revenue — Transportation Programs (template)
270 Special Revenue — Community Services Programs (template)
280 Special Revenue — Community Development Programs (template)
290 General Governmental — Reserved/Overflow
Capital Projects
300 Capital Projects — General CIP
330 Capital Projects — Streets/Transportation
360 Capital Projects — Parks/Facilities
380 Capital Projects — Public Safety Facilities
390 Capital Projects — Utility-Related Governmental CIP
399 Capital Projects — Reserved/Overflow
Debt Service
400 Debt Service — General
410 Debt Service — GO Bonds (template)
420 Debt Service — Lease/Subscrip. (GASB 87/96) (template)
430 Debt Service — Assessment/Other (template)
499 Debt Service — Reserved/Overflow
Enterprise
510 Water Enterprise — Operating
511 Water Enterprise — Impact Fees
512 Water Enterprise — Grants
513 Water Enterprise — Capital Projects
514 Water Enterprise — Debt / Financing
515 Water Enterprise — Reserved Local
516 Water Enterprise — Reserved Local
517 Water Enterprise — Reserved Local
518 Water Enterprise — Reserved Local
519 Water Enterprise — Reserved Local
520 Sewer Enterprise — Operating
521 Sewer Enterprise — Impact Fees
522 Sewer Enterprise — Grants
523 Sewer Enterprise — Capital Projects
524 Sewer Enterprise — Debt / Financing
525 Sewer Enterprise — Reserved Local
526 Sewer Enterprise — Reserved Local
527 Sewer Enterprise — Reserved Local
528 Sewer Enterprise — Reserved Local
529 Sewer Enterprise — Reserved Local
530 Solid Waste Enterprise — Operating
531 Solid Waste Enterprise — Impact Fees
532 Solid Waste Enterprise — Grants
533 Solid Waste Enterprise — Capital Projects
534 Solid Waste Enterprise — Debt / Financing
535 Solid Waste Enterprise — Reserved Local
536 Solid Waste Enterprise — Reserved Local
537 Solid Waste Enterprise — Reserved Local
538 Solid Waste Enterprise — Reserved Local
539 Solid Waste Enterprise — Reserved Local
540 Electric Enterprise — Operating
541 Electric Enterprise — Impact Fees
542 Electric Enterprise — Grants
543 Electric Enterprise — Capital Projects
544 Electric Enterprise — Debt / Financing
545 Electric Enterprise — Reserved Local
546 Electric Enterprise — Reserved Local
547 Electric Enterprise — Reserved Local
548 Electric Enterprise — Reserved Local
549 Electric Enterprise — Reserved Local
550 Gas Enterprise — Operating
551 Gas Enterprise — Impact Fees
552 Gas Enterprise — Grants
553 Gas Enterprise — Capital Projects
554 Gas Enterprise — Debt / Financing
555 Gas Enterprise — Reserved Local
556 Gas Enterprise — Reserved Local
557 Gas Enterprise — Reserved Local
558 Gas Enterprise — Reserved Local
559 Gas Enterprise — Reserved Local
560 Airport Enterprise — Operating
561 Airport Enterprise — Impact Fees
562 Airport Enterprise — Grants
563 Airport Enterprise — Capital Projects
564 Airport Enterprise — Debt / Financing
565 Airport Enterprise — Reserved Local
566 Airport Enterprise — Reserved Local
567 Airport Enterprise — Reserved Local
568 Airport Enterprise — Reserved Local
569 Airport Enterprise — Reserved Local
570 Transit Enterprise — Operating
571 Transit Enterprise — Impact Fees
572 Transit Enterprise — Grants
573 Transit Enterprise — Capital Projects
574 Transit Enterprise — Debt / Financing
575 Transit Enterprise — Reserved Local
576 Transit Enterprise — Reserved Local
577 Transit Enterprise — Reserved Local
578 Transit Enterprise — Reserved Local
579 Transit Enterprise — Reserved Local
580 Parking Enterprise — Operating
581 Parking Enterprise — Impact Fees
582 Parking Enterprise — Grants
583 Parking Enterprise — Capital Projects
584 Parking Enterprise — Debt / Financing
585 Parking Enterprise — Reserved Local
586 Parking Enterprise — Reserved Local
587 Parking Enterprise — Reserved Local
588 Parking Enterprise — Reserved Local
589 Parking Enterprise — Reserved Local
590 Other Enterprise System Enterprise — Operating
591 Other Enterprise System Enterprise — Impact Fees
592 Other Enterprise System Enterprise — Grants
593 Other Enterprise System Enterprise — Capital Projects
594 Other Enterprise System Enterprise — Debt / Financing
595 Other Enterprise System Enterprise — Reserved Local
596 Other Enterprise System Enterprise — Reserved Local
597 Other Enterprise System Enterprise — Reserved Local
598 Other Enterprise System Enterprise — Reserved Local
599 Other Enterprise System Enterprise — Reserved Local
Enterprise Reserved
600 Enterprise System 60 — Operating (Local)
601 Enterprise System 60 — Sub-fund (Local)
602 Enterprise System 60 — Sub-fund (Local)
603 Enterprise System 60 — Sub-fund (Local)
604 Enterprise System 60 — Sub-fund (Local)
605 Enterprise System 60 — Sub-fund (Local)
606 Enterprise System 60 — Sub-fund (Local)
607 Enterprise System 60 — Sub-fund (Local)
608 Enterprise System 60 — Sub-fund (Local)
609 Enterprise System 60 — Sub-fund (Local)
Internal Service
700 Internal Service — General
710 Internal Service — Fleet
720 Internal Service — IT
730 Internal Service — Risk / Insurance
799 Internal Service — Reserved/Overflow
Agency / Fiduciary / Trust
800 Fiduciary/Agency/Trust — General (Combined Block)
810 Agency/Custodial — General
820 Pass-through / Clearing — General
849 Agency/Custodial — Reserved/Overflow
850 Trust — General
860 Pension/OPEB Trust — General
870 Private-purpose Trust — General
899 Trust — Reserved/Overflow
Reserved
900 Reserved / Future Use
999 Cash & Investment Clearing Fund
Objects
Assets
Current Assets
1000 Cash & Cash Equivalents
1001-1049 Cash & Cash Equivalents – Local Detail
1050 Investments
1051-1079 Investments – Local Detail
1080 Cash / Asset Suspense – Unidentified Receipts
1081-1089 Asset Suspense – Local Detail
1090 Cash Allocated to Funds
1091-1099 Cash Allocated to Funds - Local Detail
1100 Taxes Receivable
1101-1119 Taxes Receivable – Local Detail
1120 Accounts Receivable
1121-1139 Accounts Receivable – Local Detail
1140 Intergovernmental Receivable
1141-1149 Intergovernmental Receivable – Local Detail
1150 Due From Other Funds
1151-1159 Due From Other Funds – Local Detail
1160 Inventory
1161-1169 Inventory – Local Detail
1170 Prepaid Items
1171-1179 Prepaid Items – Local Detail
1180-1199 Current Assets – Local Detail
Capital Assets
1200 Capital Assets – Land
1210 Capital Assets – Buildings
1220 Capital Assets – Improvements
1230 Capital Assets – Infrastructure
1240 Capital Assets – Equipment/Vehicles
1250 Accumulated Depreciation (Contra)
1260-1299 Capital Assets – Local Detail
Other Assets
1900-1999 Other Assets – Local Detail
Liabilities
Current Liabilities
2000 Accounts Payable
2001-2009 Accounts Payable – Local Detail
2010 Accrued Payroll & Benefits
2011-2019 Accrued Payroll & Benefits – Local Detail
2020 Unearned / Deferred Revenue
2021-2029 Unearned / Deferred Revenue – Local Detail
2030 Due To Other Funds
2031-2039 Due To Other Funds – Local Detail
2040-2099 Current Liabilities – Local Detail
2180 Suspense / Clearing
2181-2189 Suspense / Clearing - Local Detail
Long-Term Liabilities
2200 Long-Term Debt – Bonds/COPs
2201-2209 Long-Term Debt – Bonds/COPs – Local Detail
2210 Lease / SBITA Liability (GASB 87/96)
2211-2219 Lease / SBITA Liability (GASB 87/96) – Local Detail
2220 Compensated Absences
2230 Net Pension/OPEB Liability
2240-2899 Long-Term Liabilities – Local Detail
Equity
Net Position
2900 Fund Balance / Net Position – Unassigned
2910 Fund Balance – Restricted
2920 Fund Balance – Assigned/Committed
2930-2999 Equity – Local Detail
Revenues
Taxes
3000 Property Taxes
3010 Sales & Use Taxes
3020 Utility User Taxes
3030 Transient Occupancy Taxes
3040 Business License Taxes
3050 Franchise Taxes
3060 Property Transfer Taxes
3070 Parcel Taxes / Special Taxes
3080 Other Taxes
3090-3099 Taxes – Local Detail
Licenses & Permits
3100 Licenses & Permits
3101-3109 Licenses & Permits – Local Detail
3110 Development & Impact Fees
3111-3119 Development & Impact Fees – Local Detail
3120 Fines & Forfeitures
3121-3129 Fines & Forfeitures – Local Detail
3130 Special Benefit Assessments
3131-3139 Special Benefit Assessments – Local Detail
3140-3199 Other Fees – Local Detail
Intergovernmental — Federal
3200 Intergovernmental — Federal
Intergovernmental — State
3210 Intergovernmental — State
Intergovernmental — Local
3220 Intergovernmental — Local/County/Other
Intergovernmental
3230-3299 Intergovernmental – Local Detail
Charges for Services
3300 Charges for Services
3301-3309 Charges for Services – Local Detail
3310 Utility Service Charges
3311-3319 Utility Service Charges – Local Detail
3320-3399 Charges for Services – Local Detail
Use of Money & Property
3400 Use of Money & Property
Miscellaneous
3410 Contributions & Donations
3411-3419 Contributions & Donations – Local Detail
3420 Miscellaneous / Other Revenues
3421-3429 Miscellaneous / Other Revenues – Local Detail
3430-3999 Other Revenues – Local Detail
Expenses
Payroll
4000 Salaries & Wages – Regular
4010 Salaries & Wages – Part-Time/Seasonal
4020 Salaries & Wages – Overtime
4030 Extra Help / Temporary Wages
4040 Premium / Special / Supplemental Pay
4050-4099 Payroll – Local Detail
Employee Benefits
4100 Retirement Contributions
4110 Health Insurance
4120 Dental/Vision Insurance
4130 FICA / Medicare
4140 Workers’ Compensation
4150 Other Employee Benefits
4160-4199 Employee Benefits – Local Detail
4980 Payroll Suspense / Clearing
4981-4989 Payroll Suspense / Clearing - Local Detail
Materials & Supplies
5000 Materials & Supplies
5010 Fuel & Utilities (Supplies)
5020 Maintenance Supplies
5030-5099 Materials & Supplies – Local Detail
Contracts & Services
5100 Professional & Contract Services
5110 Legal / Audit / Consulting
5120 IT / Communications Services
5130 Repairs & Maintenance (Contracted)
5140-5199 Contract Services – Local Detail
Other Operating
5200 Other Operating Expenditures
5210 Utilities (Operating)
5220 Insurance
5230 Claims & Judgments
5240 Travel / Training / Conferences
5250 Memberships / Dues / Subscriptions
5260 Bank / Trustee / Paying Agent Fees
5270 Rentals & Leases
5280 Miscellaneous Operating
5290-5299 Other Operating – Local Detail
5980 Expenditure Suspense / Clearing
5981-5989 Expenditure Suspense / Clearing
Capital Outlay
6000 Capital Outlay – Land
6010 Capital Outlay – Buildings
6020 Capital Outlay – Infrastructure
6030 Capital Outlay – Equipment/Vehicles
6040-6999 Capital Outlay – Local Detail
Debt Service
7000 Debt Service – Principal
7001-7009 Debt Service – Principal – Local Detail
7010 Debt Service – Interest
7011-7019 Debt Service – Interest – Local Detail
7020 Debt Issuance Costs
7021-7029 Debt Issuance Costs – Local Detail
7030-7999 Debt Service – Local Detail
Other Financing
Transfers
8000 Transfers In
8001-8009 Transfers In – Local Detail
8010 Transfers Out
8011-8019 Transfers Out – Local Detail
Other Financing
8020 Proceeds of Debt
8021-8029 Proceeds of Debt – Local Detail
8030 Sale of Capital Assets
8031-8499 Sale of Capital Assets – Local Detail
8500-8999 Other Financing – Local Detail
Meta
Control
9000 Non-Posting / Control
9001-9999 Control / Local System Codes
Functions
Default
0000 All Functions / Unspecified (Silent Default)
General Government
1100 Legislative
1200 Executive / City Manager
1300 Clerk / Elections
1400 Legal
1500 Finance
1600 Human Resources
1700 Information Technology
1800 General Admin — Other
1900 General Government — Local Detail
Public Safety
2100 Police
2200 Fire
2300 Emergency Medical Services
2400 Emergency Management / Disaster Prep
2500 Animal Regulation
2600 Code Enforcement
2900 Public Safety — Local Detail
Transportation
3100 Streets
3200 Street Lighting
3300 Storm Drains / Stormwater
3400 Transit
3500 Parking
3900 Transportation — Local Detail
Community Development
4100 Planning
4200 Building & Safety
4300 Housing / Neighborhood Services
4400 Economic Development
4500 Redevelopment / Successor
4900 Community Development — Local Detail
Culture and Leisure
5100 Parks
5200 Recreation
5300 Libraries
5400 Community Centers / Auditoriums
5500 Museums
5600 Golf Courses
5700 Marinas / Wharfs
5800 Cemeteries
5900 Culture & Leisure — Local Detail
Health
6100 Physical & Mental Health
6200 Hospitals & Sanitariums
6900 Health — Local Detail
Public Utilities
7100 Water
7200 Sewers
7300 Solid Waste
7400 Electric
7500 Gas
7900 Utilities — Local Detail
Capital Outlay
8100 Capital — General Government
8200 Capital — Public Safety
8300 Capital — Transportation
8400 Capital — Community Development
8500 Capital — Culture & Leisure
8600 Capital — Public Utilities
8900 Capital — Local Detail
Debt Service
9100 Operating Expenditures (Nonfunctional)
9200 Other Expenditures (Nonfunctional)
9300 Debt Service (Nonfunctional)
9900 Other / Local Detail
Departments
Default
00 Nondepartmental / Default
Governing Body & Executive
10 City Council / Mayor
11 City Manager / Executive
12 City Clerk / Elections
13 City Attorney / Legal
14 Citywide Boards & Commissions
19 Executive — Other / Reserved
Administrative Services
20 Finance / Accounting
21 Budget / Treasury
22 Human Resources
23 Information Technology
24 Purchasing / Contracting
25 Risk Management
26 Citywide Administrative Services
29 Admin Svcs — Other / Reserved
Public Safety — Police
30 Police
31 Dispatch / Communications
32 Animal Services
33 Code Enforcement
39 Police — Other / Reserved
Public Safety — Fire/EMS
40 Fire
41 Emergency Medical Services
42 Emergency Management / Disaster Prep
49 Fire/EMS — Other / Reserved
Public Works & Engineering
50 Public Works Administration
51 Streets
52 Stormwater / Drainage
53 Engineering
54 Facilities / Buildings
55 Fleet / Equipment Maintenance
56 Street Lighting
59 PW/Eng — Other / Reserved
Community Services
60 Parks
61 Recreation
62 Library
63 Community Centers
64 Senior / Youth Programs
65 Cemetery
69 Comm Services — Other / Reserved
Community Development
70 Planning
71 Building & Safety
72 Housing / Neighborhood Services
73 Economic Development
74 Redevelopment / Successor
79 Comm Dev — Other / Reserved
Utilities
80 Water
81 Wastewater / Sewer
82 Solid Waste
83 Electric Utility
84 Gas Utility
85 Utility Billing / Customer Service
86 Utility Administration
89 Utilities — Other / Reserved
Capital & CIP
90 Capital Projects / CIP Admin
91 Capital Design / Construction
92 Impact Fees / Development Fees
94 Capital — Other / Reserved
Debt & Financing
95 Debt Administration
96 Grants Administration (Citywide)
97 Financing / Special Programs
Other / Internal Service / Allocations
98 Internal Service / Support Ops
99 Allocations / Nondepartmental Charges / Reserved
Data Dictionary
Reference for CACOA tables and fields from the published dataset.
Tables
COA_DEPT
CACOA base table for codes, structures, or mappings.
COA_DEPT_BLOCK
CACOA base table for codes, structures, or mappings.
COA_DEPT_FUNC_XREF
CACOA base table for codes, structures, or mappings.
COA_ENTITY
CACOA base table for codes, structures, or mappings.
COA_FTR
CACOA base table for codes, structures, or mappings.
COA_FTR_MAP
CACOA base table for codes, structures, or mappings.
COA_FTR_MAP_FUNC
CACOA base table for codes, structures, or mappings.
COA_FTR_MAP_FUND
CACOA base table for codes, structures, or mappings.
COA_FTR_MAP_OBJ
CACOA base table for codes, structures, or mappings.
COA_FTR_RELATE_LEGACY
CACOA base table for codes, structures, or mappings.
COA_FUNC
CACOA base table for codes, structures, or mappings.
COA_FUNC_GROUP
CACOA base table for codes, structures, or mappings.
COA_FUND
CACOA base table for codes, structures, or mappings.
COA_FUND_BLOCK
CACOA base table for codes, structures, or mappings.
COA_FUND_LOCAL
CACOA base table for codes, structures, or mappings.
COA_FUND_ROLLUP
CACOA base table for codes, structures, or mappings.
COA_FUND_ROLLUP_FUND
CACOA base table for codes, structures, or mappings.
COA_FUND_ROLLUP_RANGE
CACOA base table for codes, structures, or mappings.
COA_OBJ
CACOA base table for codes, structures, or mappings.
COA_OBJ_CLASS
CACOA base table for codes, structures, or mappings.
COA_OBJ_EXPORT
CACOA base table for codes, structures, or mappings.
COA_OBJ_LOCAL
CACOA base table for codes, structures, or mappings.
COA_REPORT_RUN
CACOA base table for codes, structures, or mappings.
COA_TXN_DIM
CACOA base table for codes, structures, or mappings.
COA_TXN_DIM_VALUE
CACOA base table for codes, structures, or mappings.
COA_VALID_RULE
CACOA base table for codes, structures, or mappings.
COA_VALID_RULE_COND
CACOA base table for codes, structures, or mappings.
COA_VALID_RULE_MSG
CACOA base table for codes, structures, or mappings.
COA_VALID_RULE_REQDIM
CACOA base table for codes, structures, or mappings.
DATA_DICTIONARY
Supporting table.
README
Workbook readme, assumptions, and usage notes.
REF_DEPT_NOTES
Reference/lookup table supporting rollups, profiles, or reporting.
REF_ENTITY_TYPE
Reference/lookup table supporting rollups, profiles, or reporting.
REF_FTR_KIND
Reference/lookup table supporting rollups, profiles, or reporting.
REF_FTR_SCHEMA_VERSION
Reference/lookup table supporting rollups, profiles, or reporting.
REF_FUNC_MATCH_TYPE
Reference/lookup table supporting rollups, profiles, or reporting.
REF_FUND_TYPE
Reference/lookup table supporting rollups, profiles, or reporting.
REF_INCL_EXCL
Reference/lookup table supporting rollups, profiles, or reporting.
REF_MAP_STATUS
Reference/lookup table supporting rollups, profiles, or reporting.
REF_MATCH_METHOD
Reference/lookup table supporting rollups, profiles, or reporting.
REF_OBJ_CLASS
Reference/lookup table supporting rollups, profiles, or reporting.
REF_OBJ_GROUP
Reference/lookup table supporting rollups, profiles, or reporting.
REF_OBJ_MATCH_TYPE
Reference/lookup table supporting rollups, profiles, or reporting.
REF_OBJ_REPORT_CLASS
Reference/lookup table supporting rollups, profiles, or reporting.
REF_OBJ_REPORT_CLASS_MAP
Reference/lookup table supporting rollups, profiles, or reporting.
REF_OBJ_SUBCLASS
Reference/lookup table supporting rollups, profiles, or reporting.
REF_OBJ_SUBGROUP
Reference/lookup table supporting rollups, profiles, or reporting.
REF_REPORT_MAP_STATE
Reference/lookup table supporting rollups, profiles, or reporting.
REF_REPORTING_PROFILE
Reference/lookup table supporting rollups, profiles, or reporting.
REF_VALID_DIM
Reference/lookup table supporting rollups, profiles, or reporting.
REF_VALID_OPERATOR
Reference/lookup table supporting rollups, profiles, or reporting.
REF_VALID_RULE_TYPE
Reference/lookup table supporting rollups, profiles, or reporting.
REF_VALID_SEVERITY
Reference/lookup table supporting rollups, profiles, or reporting.
REF_YN
Reference/lookup table supporting rollups, profiles, or reporting.
VIEW_DEFS
Supporting table.
VIEW_FTR_COA_SPEC
Supporting table.
Downloads
Export the current release as Excel or DOCX from the system of record.