RFP121664 - Attachment E DGS PAYMENT Spreadsheet TEMPLATE .xls

This is a Payment Spreadsheet Template for RFP121664, a surplus property disposal services solicitation issued by the Virginia Department of General Services (DGS). The template is designed to track and document the financial transactions associated with the disposal of surplus vehicles, materials, and equipment through an auction process. The spreadsheet captures comprehensive asset information including vehicle identification details (VIN, year, make, model), property location, condition status, and release dates, along with relevant contact information for agency representatives and haulers. The template accommodates multiple contact points and tracks the complete lifecycle of each asset from dispatch through final sale, including the auction vendor used, titled property state designation, and payment status by lot number.

The payment tracking structure within the template itemizes all financial components of the disposal transaction, including gross sale price, seller commission, mechanical repairs, transport fees, de-identification fees, buyer's premium, and collected funds. The template calculates net proceeds to be paid to DGS by deducting all applicable expenses and fees from the gross sale price. The example entries demonstrate typical transaction flows with line items for hauling expenses, de-identification costs, and wash and vacuum services, providing DGS with detailed financial visibility into each surplus property disposal transaction. This standardized template enables consistent tracking and reconciliation of payments across multiple assets and auction vendors within Virginia's surplus property disposal program.