After making required and optional filter and output column selections, click View Report to proceed.

• * Titled filters indicate mandatory selections.
• To reduce run time, narrow your results by selecting Fiscal Year(s), Department(s), or Supplier(s).
• Replace the text 'All Supplier Values' with the required supplier value in Supplier filter and click outside the prompt or enter button. The matching supplier results will be displayed in the 'Results' filter
• City Department Spending occurs in three ways:
  1. Department and Supplier agree to a written contract and then Purchase Order is created for all or a discrete set of work. The Purchase Order creates the encumbrance.
  2. Department goes directly to a Purchase Order to establish both terms of agreement and encumbrance.
  3. As an exception to general rule, Department does a direct payment without a contract or purchase order, for non-recurring, one-time expenditures.
• "Prime Contractors Only" displays each contract with only prime suppliers indicated, whereas "Primes and Subcontractors" lists all known and reported subcontractors participating in the contract with their respective award allocations.
• Please note that some procurement transactions are structured as direct purchase orders and do not utilize a supplier contract. To review these purchase orders, please use the "Encumbrance Level" view of the Supplier Payments report.
• Revenue Contracts, including concessions and rental income contracts, are not included in this data set; they are tracked in departmental subsystems and currently are not available in SFOpenBook. For more information about Revenue Contracts, please contact the City department that awards the contract, e.g. for Airport Concession Contracts, contact the San Francisco Airport Commission which maintains these records.
• Supplier Contracts shown here include new expenditure contracts executed since July 1, 2017, when the City implemented the new SF Procurement (PeopleSoft) system, and previously executed expenditure contracts where the Contract End Date extended past July 1, 2017. Departments periodically update contract information, such as process contract amendments, update project team subcontractors, liquidate purchase orders to make payment for completed work and do contract reconciliation. For information regarding contracts executed prior to July 1, 2017, please contact the awarding department.
• Download the full dataset from DataSF.
• Use browser ← and → to see previous results.