Attachment G Reporting Template.xlsm

The document is a reporting template (Attachment G) for a NASPO ValuePoint contract, designed to capture detailed transaction and reporting information for vendors participating in the contract. The template provides a comprehensive Excel-based structure for recording vendor sales, including fields for vendor name, contract number, customer type, billing details, order information, product specifics, pricing, quantities, and administrative fees. Key data points include capturing vendor contract details, customer segments (such as State Government, Education, Local Government), purchase order information, invoice details, product descriptions, pricing, and a mandatory 1.25% administrative fee calculation.

The template appears to be a standardized reporting mechanism for tracking contract performance, sales volume, and administrative fee calculations across different customer segments and jurisdictions. It includes granular fields for capturing transaction-level data, such as UNSPSC commodity codes, list prices, contract-specific pricing, quantities, and total extended pricing. The template supports detailed financial tracking and reporting, enabling precise monitoring of contract utilization, pricing compliance, and administrative fee generation. The structure suggests a multi-state cooperative purchasing contract with robust reporting requirements to ensure transparency and compliance across different government and educational purchasing entities.