Rebate_Report_Template.xlsx

This is a Rebate Report Template designed for use by the City of Seattle in tracking rebates related to traffic control products and roadway barricades procurement. The template is structured to record agency information, invoice numbers or credit references, invoice dates, and invoice amounts excluding tax. The format appears standardized across multiple sheets to facilitate consistent reporting and documentation of rebate transactions across departments utilizing the blanket contracts for traffic control products, roadway barricades, safety sign posts, and aluminum sign blanks.

The rebate reporting mechanism supports the City's pool of eligible vendors established through its blanket contract program. The City spent approximately $950,000 on these contracts in 2025, with individual orders averaging $325 and reaching as high as $10,000. Primary users include Seattle Department of Transportation (SDOT), Seattle Public Utilities (SPU), and Seattle City Light (SCL), though any City department may utilize these contracts. The template enables departments to document financial credits or rebates received from vendors, ensuring accurate accounting and budget reconciliation across the multiple active contracts held with National Barricade Co LLC, Traffic Safety Supply Co Inc, Zumar Industries Inc, and Aramsco.