San Francisco Supplier Contracts from Fiscal Year 2018

San Francisco's Controller's Office maintains a database of fully executed, expenditure-only contracts with suppliers from fiscal year 2018 forward. The data includes departmental and citywide contracts for commodities, professional services, general services, and construction, updated weekly on the SF Open Book platform. Revenue contracts are not included in this dataset.

Use Cases

• Analyze contract award amounts and remaining authority by contracting department to track budget utilization.
• Identify spending patterns by supplier or vendor across different contract types (e.g., commodities, professional services, construction).
• Monitor contract status and associated purchase order balances for active supplier expenditure agreements.
• Cross-reference contract data with payment reports to understand the full procurement lifecycle from encumbrance to voucher.

Strengths

• Data is updated on a weekly basis, providing regular refresh cycles.
• Includes contracts from fiscal year 2018 onward, offering multi-year coverage.
• Covers both departmental and citywide supplier expenditure contracts, providing a consolidated view.

Limitations

• Revenue contracts, including concessions and rental income, are explicitly excluded from the dataset.
• Sensitive contracts related to legal proceedings have been removed, potentially omitting significant expenditures.
• Contract award amounts for balances converted from pre-July 2017 systems may only reflect the unutilized portion as of that date.

Provenance

Source

San Francisco Controller's Office via the SF Open Book platform.

Collection Method

Maintained database of contracts and payments based on contracting departments' inputs to the PeopleSoft Financial & Procurement System.

Time Range

From fiscal year 2018 forward, with some active pre-July 2017 contract balances included.

Freshness

Updated weekly.

Geography

City and County of San Francisco, California, USA.