Title: 1. GENERAL
Accounting Policies: The accompanying Schedule is presented using the modified accrual basis of accounting for program expenditures accounted for in the governmental funds and the accrual basis of accounting for program expenditures accounted for in the proprietary funds as described in Note 2(b) of the City’s basic financial statements, with the exception of the Economic Adjustment Assistance Program described in Note 5.
De Minimis Rate Used: N
Rate Explanation: N/A
The schedule of expenditures of federal awards (Schedule) includes the federal grant activity of the City and County of San Francisco (City). All federal awards received directly from federal agencies as well as federal awards passed through other non-federal agencies are included in this Schedule except for assistance related to Medical Assistance (Medi-Cal) and Medicare Hospital Insurance (Medicare) (see Note 4).
The City’s basic financial statements include the operations of the San Francisco County Transportation Authority (Authority), the San Francisco International Airport (Airport), the Municipal Transportation Agency (MTA), and the Successor Agency to the San Francisco Redevelopment Agency (Successor Agency). The expenditures of the Authority, the Airport, the MTA, and the Successor Agency are not included in the schedule of expenditures of federal awards for the year ended June 30, 2023. Federal expenditures for these entities are separately audited.
Title: 2. BASIS OF ACCOUNTING
Accounting Policies: The accompanying Schedule is presented using the modified accrual basis of accounting for program expenditures accounted for in the governmental funds and the accrual basis of accounting for program expenditures accounted for in the proprietary funds as described in Note 2(b) of the City’s basic financial statements, with the exception of the Economic Adjustment Assistance Program described in Note 5.
De Minimis Rate Used: N
Rate Explanation: N/A
The accompanying Schedule is presented using the modified accrual basis of accounting for program expenditures accounted for in the governmental funds and the accrual basis of accounting for program expenditures accounted for in the proprietary funds as described in Note 2(b) of the City’s basic financial statements, with the exception of the Economic Adjustment Assistance Program described in Note 5. The City did not elect to use the 10% de minimis cost rate as covered in U.S. Code of Federal Regulations, Title 2 section 200.414 Indirect (F&A) costs.
Title: 3. RELATIONSHIP TO FEDERAL FINANCIAL REPORTS AND BASIC FINANCIAL STATEMENTS
Accounting Policies: The accompanying Schedule is presented using the modified accrual basis of accounting for program expenditures accounted for in the governmental funds and the accrual basis of accounting for program expenditures accounted for in the proprietary funds as described in Note 2(b) of the City’s basic financial statements, with the exception of the Economic Adjustment Assistance Program described in Note 5.
De Minimis Rate Used: N
Rate Explanation: N/A
Expenditures of federal awards are reported in the City’s basic financial statements as expenditures in the governmental funds, and as expenses for noncapital expenditures and as additions to capital assets for capital related expenditures in the proprietary funds. Amounts reported in the accompanying Schedule agree or can be reconciled with amounts reported in the related federal award reports and the City’s basic financial statements.
Title: 4. MEDI-CAL AND MEDICARE
Accounting Policies: The accompanying Schedule is presented using the modified accrual basis of accounting for program expenditures accounted for in the governmental funds and the accrual basis of accounting for program expenditures accounted for in the proprietary funds as described in Note 2(b) of the City’s basic financial statements, with the exception of the Economic Adjustment Assistance Program described in Note 5.
De Minimis Rate Used: N
Rate Explanation: N/A
Direct Medi-Cal and Medicare expenditures are excluded from the Schedule. These expenditures represent fees for services and are not included in the Schedule or in determining major programs. The City assists the State in determining eligibility and provides Medi-Cal and Medicare services through City-owned facilities. Administrative costs related to Medi-Cal and Medicare are, however, included in the Schedule under the Medical Assistance Program (Assistance Listing Number 93.778).
Title: 5. ECONOMIC ADJUSTMENT ASSISTANCE PROGRAM
Accounting Policies: The accompanying Schedule is presented using the modified accrual basis of accounting for program expenditures accounted for in the governmental funds and the accrual basis of accounting for program expenditures accounted for in the proprietary funds as described in Note 2(b) of the City’s basic financial statements, with the exception of the Economic Adjustment Assistance Program described in Note 5.
De Minimis Rate Used: N
Rate Explanation: N/A
For the purpose of calculating federal expenditures for the Schedule, the Economic Adjustment Assistance Program (Assistance Listing Number 11.307) reports non-loan expenditures and grants for revolving loan funds (RLF). Federal expenditures for RLF loans are calculated as the federal share of the sum of RLF loans outstanding and cash and investment balance in the RLF at the end of the fiscal year or through or the date of release by the U.S. Department of Commerce of its federal interest in the RLF award, and administrative expenses paid out of RLF income and the unpaid principal of all loans written off during the year. The table provides the breakdown of expenditures included in the Schedule.
Title: 6. CALIFORNIA DEPARTMENT OF AGING (CDA) SINGLE AUDIT
REPORTING REQUIREMENTS
Accounting Policies: The accompanying Schedule is presented using the modified accrual basis of accounting for program expenditures accounted for in the governmental funds and the accrual basis of accounting for program expenditures accounted for in the proprietary funds as described in Note 2(b) of the City’s basic financial statements, with the exception of the Economic Adjustment Assistance Program described in Note 5.
De Minimis Rate Used: N
Rate Explanation: N/A
The terms and conditions of agency contracts with CDA require agencies to display State-funded expenditures discretely along with the related federal expenditures. CDA grant expenditures that involve federal funding have been presented in the Schedule. The schedule is presented using the modified accrual basis of accounting. For State grants not involving federal funding, the amounts are to be displayed separately. The schedule is presented to comply with these requirements.
Title: 7. PROGRAM TOTALS
Accounting Policies: The accompanying Schedule is presented using the modified accrual basis of accounting for program expenditures accounted for in the governmental funds and the accrual basis of accounting for program expenditures accounted for in the proprietary funds as described in Note 2(b) of the City’s basic financial statements, with the exception of the Economic Adjustment Assistance Program described in Note 5.
De Minimis Rate Used: N
Rate Explanation: N/A
The table summarizes programs funded by various sources or grants whose totals are not shown on the Schedule.
Title: 8. CALIFORNIA DEPARTMENT OF EDUCATION (CDE) REPORTING REQUIREMENTS
Accounting Policies: The accompanying Schedule is presented using the modified accrual basis of accounting for program expenditures accounted for in the governmental funds and the accrual basis of accounting for program expenditures accounted for in the proprietary funds as described in Note 2(b) of the City’s basic financial statements, with the exception of the Economic Adjustment Assistance Program described in Note 5.
De Minimis Rate Used: N
Rate Explanation: N/A
The terms and conditions of contracts with CDE require agencies to display State-funded expenditures discretely along with the related federal expenditures. CDE grant expenditures that involve federal funding have been presented in the Schedule. The schedule is presented using the modified accrual basis of accounting. For State grants not involving federal funding, the amounts are to be displayed separately.
Title: 9. CALIFORNIA DEPARTMENT OF SOCIAL SERVICES (CDSS) REPORTING REQUIREMENTS
Accounting Policies: The accompanying Schedule is presented using the modified accrual basis of accounting for program expenditures accounted for in the governmental funds and the accrual basis of accounting for program expenditures accounted for in the proprietary funds as described in Note 2(b) of the City’s basic financial statements, with the exception of the Economic Adjustment Assistance Program described in Note 5.
De Minimis Rate Used: N
Rate Explanation: N/A
The terms and conditions of contracts with CDSS require agencies to display State-funded expenditures discretely along with the related federal expenditures for assistance listing numbers 10.558, 93.575 and 93.596 whose contracts were previously administered by the California Department of Education. CDSS grant expenditures that involve federal funding have been presented in the Schedule. The schedule is presented using the modified accrual basis of accounting. For State grants not involving federal funding, the amounts are to be displayed separately. Additionally, for subawards connected to child care services, entities must report the name of the subawardees and the related contracts, including contract numbers and amounts. This information is reflected in the supplemental table: