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, 2025. Federal expenditures for these entities are separately audited.
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 de minimis cost rate as covered in U.S. Code of Federal Regulations, Title 2 section 200.414 Indirect (F&A) costs.
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.
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).
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 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 below provides the breakdown of expenditures included in the Schedule.
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 following 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 following schedule is presented to comply with these requirements.
The following table summarizes programs funded by various sources or grants whose totals are not shown on the Schedule.
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 following 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 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 following 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 below:
The City manages grants under Assistance Listing No. 97.036 for the Disaster Grants – Public Assistance (Presidentially Declared Disasters) program. Nonfederal entities must record expenditures for this program on the SEFA when (1) FEMA has approved the nonfederal entity’s underlying projects, and (2) the nonfederal entity has incurred the eligible expenditures. FEMA’s approval of a subaward is indicated when FEMA obligates the federal share of the eligible project cost to the recipient. Federal awards expended in years subsequent to the fiscal year in which the projects are approved are to be recorded on the nonfederal entity’s SEFA in those subsequent years. For the year ended June 30, 2025, the City’s SEFA reflects a total of $89,711,470 in federal expenditures under Assistance Listing Number 97.036, of which $88,670,630 represents costs incurred in prior fiscal years.