Attachment C Temp Reporting.xlsm

This is a temporary reporting template for state and local contract opportunities, specifically designed for the STC Cold Laid Asphalt contract in South Carolina. The document provides a standardized Excel-based framework for tracking vendor transaction data across multiple customer segments including state government, K-12 education, higher education, local government, medical, and other entity types. The template captures essential procurement information such as vendor identification, contract numbers, customer billing and shipping details, purchase order data, and invoice records. The spreadsheet includes designated fields for product information, pricing structures, quantities, and administrative fee calculations, with separate tabs for different product categories including Cold Laid Asphalt and High Performance materials across multiple state lots.

The reporting template establishes standardized data collection requirements for all awarded contractors under this NASPO ValuePoint contract framework. Key data fields include list pricing versus NASPO ValuePoint pricing in U.S. currency, extended pricing calculations based on invoiced quantities, administrative fees assessed on total price, and commodity-level classification through UNSPSC coding. The template accommodates various order types including sales orders, credits/returns, and upgrades/downgrades, with date tracking for purchase orders, shipments, and invoice processing. Additional fields capture reseller and distributor information, Energy Star compliance status, and optional supplementary documentation. All financial entries are formatted to standard currency specifications, and the structure allows for 1% administrative fee calculations applied uniformly across the contract for consistent financial tracking and reporting across participating state and local entities.