A. SUMMARY
This dataset is a cleaned and anonymized version of survey data gathered in FY23 from nonprofits who contract with the City and County of San Francisco. Each row is one organization and data includes general information about the nonprofit's services, finances, and operations, and summary demographic data about each nonprofit's workforce.

B. HOW THE DATASET IS CREATED
This dataset was generated through conducting a two-tiered survey gathering data on organizational characteristics and position-level data from nonprofits who contract with the City and County of San Francisco in FY23. The survey was fielded in October and November of 2022. 152 nonprofits provided organizational-level data and summary data about their workforce. 29 of those organizations (referred to as "Cohort Organizations") provided additional position-level data. This dataset includes organization-level data for the 152 respondent organizations. For further details on survey methodology, please review page 39 of the Nonprofit Wage and Equity Survey report, linked below in "Related Reports."

C. UPDATE PROCESS
Data is a one-time survey and will not update.

D. HOW TO USE THIS DATASET
Review code book, attached in the "About this Dataset" section.

E. RELATED REPORTS
This dataset informs the Nonprofit Wage and Equity Survey Report, released by the Controller's Office in April 2023.
Nonprofit Wage and Equity Survey

F. RELATED DATASETS
This dataset is one of two datasets of survey data from the Nonprofit Wage and Equity Survey (FY23). Position-level data can be viewed on the Open Data Portal. Nonprofit Wage and Equity Survey - Position-Level Cohort Data - FY23

A. SUMMARY
This dataset is a cleaned and anonymized version of survey data gathered in FY23 from nonprofits who contract with the City and County of San Francisco. Each row is one employee (representing one filled position), and data includes wages, position detail, position requirements, and demographic information as supplied by the person's employing organization.

B. HOW THE DATASET IS CREATED
This dataset was generated through conducting a two-tiered survey gathering data on organizational characteristics and position-level data from nonprofits who contract with the City and County of San Francisco in FY23. The survey was fielded in October and November of 2022. 152 nonprofits provided organizational-level data and summary data about their workforce. 29 of those organizations (referred to as "Cohort Organizations") provided additional position-level wage, demographic, and position-requirement data for each worker employed by their organization. This dataset includes position-level data from the cohort organizations. For further details on survey methodology, please review page 39 of the Nonprofit Wage and Equity Survey report, linked below in "Related Reports."

C. UPDATE PROCESS
Data is a one-time survey and will not update.

D. HOW TO USE THIS DATASET
Review code book, attached in the "About this Dataset" section.

E. RELATED REPORTS
This dataset informs the Nonprofit Wage and Equity Survey Report, released by the Controller's Office in April 2023. Nonprofit Wage and Equity Survey

F. RELATED DATASETS
This dataset is one of two datasets of survey data from the Nonprofit Wage and Equity Survey (FY23). Organization-level data can be viewed on the Open Data Portal.
Nonprofit Wage and Equity Survey - Organization-Level Survey Data - FY23

Summary
The City and County of San Francisco contracts with hundreds of nonprofit organizations to provide services for San Franciscans. These services include healthcare, legal aid, shelter, children’s programming, and more. This dataset contains all payments issued to nonprofit organizations by City departments since FY2019. This dataset will be updated at the close of each fiscal year. The underlying data is pulled from Supplier Payments on SF OpenBook. Please use SF OpenBook to find current-year data.

The data in this dataset are presented in easy-to-read dashboards on our website. View the dashboards here: https://www.sf.gov/data/san-francisco-nonprofit-contracts-and-spending.

How the dataset is created
The Controller’s Office performs several significant data cleaning steps before uploading this dataset to the SF Open Data Portal. Please read the cleaning steps below:

Cleaning Steps
1. SF OpenBook provides a filter labeled “Non-Profits Only” (Yes, No), and resulting datasets exported from SF OpenBook include a “Non Profit” column to indicate whether the supplier is a nonprofit (Yes, Blank). However, this field is not always accurate and excludes about 150 known nonprofits that are not labeled as a nonprofit in the City’s financial system. To ensure a complete dataset, we exported a full list of supplier payment data from SF OpenBook with the “Non-Profits Only” field filtered to “No” which provides a list of all supplier payments regardless of nonprofit status. We cleaned this data by adding a new “Nonprofit” column within the dataset and used this column to note a nonprofit status of “Yes” for approximately 150 known nonprofit suppliers without this indicator flagged in the financial system in addition to any nonprofits already accurately flagged in the system. We then filtered the full dataset using the new nonprofit column and used the filtered data for all of the dashboards on this webpage. The list of excluded nonprofits may change over time as information gets updated in the City’s data system. Download the cleaned and updated dataset on the City’s Open Data Portal, which highlights the known nonprofits with a changed nonprofit indicator.

2. While the University of California, San Francisco (UCSF) is technically not-for-profit, a university’s financial management is very different from traditional nonprofit service providers, and the City’s agreement with UCSF includes hospital staffing in addition to contracted services to the public. As such, the Controller's Office created a nonprofit column to be able to exclude payments to UCSF when reporting on overall spending. There are divisions of UCSF that provide more traditional contracted services, but these cannot be clearly identified in the data. Note that filtering out this data may reflect an underrepresentation of overall spending.

3. The Controller's Office also excludes several specific contracts that are predominately “pass through” payments where the nonprofit provider receives funds that they disperse to other agencies, such as for childcare or workforce subsidies. These types of contracts are substantially different from contracts where the nonprofit is providing direct services to San Franciscans.

Update process
This dataset will be manually updated after year-end financial processing is complete, typically in September. There may be a delay between the end of the fiscal year and the publication of this dataset.

A. SUMMARY
Nonprofit organizations receiving more than $100,000 in annual funding from the City must make certain information publicly available. Each year, once nonprofits post their economic statements, they then complete an online form to let us know that they have complied. This dataset contains the responses to this form.

B. HOW THE DATASET IS CREATED
Each year, nonprofit organizations complete the online form. The City stores the results and publishes them here.

C. UPDATE PROCESS
An automated process runs each morning at 8:00am and publishes the form responses submitted during the previous 24 hours.

D. HOW TO USE THIS DATASET
This dataset can be used to track nonprofit compliance with San Francisco Administrative Code Chapter 10.1. Annual Economic Statement -- City-funded Organizations.

E. RELATED DATASETS & LINKS

• Supplier Contracts
• ProPublica's Nonprofit Explorer
• San Francisco Administrative Code Chapter 10.1. Annual Economic Statement -- City-funded Organizations
• Post your nonprofit annual economic statement
• Learn about the nonprofit annual economic statement

A. SUMMARY
This dataset was created to support local nonprofit organizations seeking qualified and available auditors to perform their auditing work timely. Included in this dataset are accounting firm details on:

1. The budget size of nonprofits the firms are interested in working with
2. Whether the firms have prior nonprofit auditing experience
3. The firms' ability to work on-site in San Francisco
4. The firms' ability to perform Single Audits for nonprofits receiving Federal funding
5. Additional types of services the firms provide in addition to auditing

B. HOW THE DATASET IS CREATED
The Controller’s Office surveyed over 400 local, state, and national accounting firms to develop this dataset, asking surveyed firms to provide details on their interest and history with conducting nonprofit financial audits. This dataset reflects verbatim the most recent survey responses; firms may not have answered all questions.

C. UPDATE PROCESS
The Controller's Office provides a live link to allow firms to submit new or updated data at any time. Approximately twice annually, the Controller's Office will refresh the posted dataset with new results submitted in the prior period.

D. HOW TO USE THIS DATASET
Use this dataset to find accounting firms that meet your organization's needs. Please note nonprofit organizations are strongly encouraged to do further outreach and perform additional review of qualifications to confirm firms’ nonprofit auditing expertise and capacity. Nonprofit organizations are also encouraged to do additional research to identify accounting firms best suited for their organization’s needs.

E. RELATED DATASETS
Not applicable.

The Controllers’ Office coordinates the Citywide Nonprofit Monitoring and Capacity Building Program, where City departments conduct annual fiscal and compliance monitoring of nonprofits doing business with the City. Departments submit the results of fiscal and compliance monitoring into the Nonprofit Monitoring Salesforce database. Each year, the Controller’s Office generates this dataset of fiscal monitoring activities and results, then summarizes highlights in the annual Nonprofit Monitoring Annual Report. To read the full Annual Report, please see the Annual Reports section on the Citywide Nonprofit Monitoring and Capacity Building Program website

This dataset includes a list of all nonprofits in the FY24 joint fiscal and compliance monitoring pool, the type of monitoring they received, and their monitoring results including any findings.

Attachment 1 “FY24 Contractor Summary” lists the contractors in the FY24 joint monitoring pool, the type of fiscal monitoring assigned, lead monitoring department for FY24 and participating funding departments for each contractor. Attachment 2 “FY24 Department Key” lists the full name of departments along with their acronym.