Attachment D Reporting Template.xlsm

This is a standardized reporting template for tracking vendor transactions under state and local contracts, designed for use across multiple customer segments including state government, K-12 education, higher education, local government, and medical entities. The template establishes uniform data collection protocols for awarded contractors, requiring comprehensive documentation of all transactional details including vendor identification, contract numbers, customer billing and shipping information, purchase orders, and invoice records. The document specifies fields for order management, product identification using UNSPSC commodity-level coding, and pricing documentation including list prices, NASPO ValuePoint contract prices, quantities invoiced, extended pricing calculations, and administrative fees.

The reporting template mandates detailed product and service tracking with fields for product numbers, descriptions, unit measures, and quantity metrics to ensure accurate billing and administrative fee calculations. The template supports multiple order types including sales orders, credit returns, and upgrade/downgrade transactions, with standardized date formatting requirements for purchase orders, shipment dates, and invoice dates. The document includes optional fields for value-added reseller and distributor identification by state location, as well as Energy Star compliance designation using a coded system. All pricing is denominated in U.S. currency with extended decimal precision, and administrative fees are calculated as percentages of total transaction prices. The template accommodates both detailed product-level reporting and simplified line-item reporting formats to accommodate varying vendor capabilities and contract requirements.