Truck stock, consignment, and supplier material — one place
📦 What this page is
Every dollar of material that goes on a truck should land on a job. This page tracks supplier inventory — starting with the Winsupply consignment stock (they own it until we use it; we get billed as it's pulled). Next up: receipts from the Winsupply portal matched against HCP jobs, then Trane, then full truck-stock tracking.
🧭 What's going on with Winsupply
Loading…
Consignment stock on the shelf
Consignment master list — Winsupply order 173422-01 (PO: CONSIGNMENT · salesman Clay Carroll · NET 10TH PROX). This is the stock placed on consignment with unit pricing — the cost baseline for job-costing every Winsupply receipt.
Stock value by category
Top 10 items by stocked value
Consignment items
Item #
Description
Category
UOM
Stock Qty
Unit Cost
Extended
Loading consignment list…
Receipts → Jobs: every Winsupply order since Jan 2025, classified. Orders with a CI-8XXXXXX P.O. are tied to the HCP job and verified against the live job list.
Shop stock is material bought for the shop (consignment restock) — expected, and tracked on its own line. The leak is the rest — date-coded counter buys, names instead of job numbers, truck stock — material with no job attached.
Spend by classification
Monthly spend — job-attached vs unattached
Winsupply orders
Date
P.O. / Reference
Class
HCP Job
Placed by
Status
Subtotal
Loading receipts…
Home Depot purchases already have a full dashboard.
It will fold into this page once all suppliers are connected.
Every Trane / ComfortSite order back to 2019, classified. Pulled live from the ComfortSite portal. Trane is mostly equipment — orders carry the CI-job# P.O. plus the customer's name, so attach discipline is far better than counter material. Verification is against the 2026 HCP job list (older jobs show unverified ?).
Spend by classification
Monthly spend — job-attached vs unattached
Trane orders
Date
P.O. / Customer
Class
HCP Job
Placed by
Status
Total
Loading Trane orders…
Every Robert Madden order back to 2000, classified. Pulled live from rmadden.com (customer 596959). RM runs equipment consignment — "EQUIPMENT CONSIGNMENT - [customer]" POs carry the homeowner's name, not a job #. Old orders predate the CI-job# convention, so most history lands in OTHER; 2025+ is the actionable window.
Spend by classification (2025+)
Monthly spend — job/consignment vs unattached (2025+)
Robert Madden orders
Date
P.O. / Customer
Class
HCP Job
Location
Status
Subtotal
Loading RM orders…
Cowboy's Air Conditioning & Heating · Consignment source: Winsupply San Antonio order 173422-01 (printed 6/09/26)
Generated by Michael Scott Lopez for Cowboy's Air Conditioning & Heating
