Reconcile the export to physical stock
A purchase order or warehouse export can identify a product, but it does not prove the current balance on a reel. Walk the inventory and match each listed line to a reel, package, or group of genuinely identical items at the stated storage location. Add a unique inventory reference and capture the manufacturer, part number, condition, and current versus original quantity.
If a spreadsheet line cannot be found, do not carry it into the available total. Mark it discrepant and state why: missing reel, moved storage position, unreadable tag, or unresolved identification. This converts an old report into a usable seller record without pretending that every historical line remains available.
- Inventory reference for each physical item
- Manufacturer and part number
- Actual storage location
- Current balance versus original quantity
Preserve length and quantity by reel
Record continuous footage per reel, reel count, and the basis for every figure: measured, documented, or estimated. A total across several short pieces is not the same as one long reel. State full, partial, and cut-length status separately so the inventory describes what is physically on hand.
When a balance is estimated, say how and keep it distinct from a tag or a measurement. Do not revive the original shipped footage merely because the partial reel has no current reading. The decision here is about the present inventory, not the quantity that was ordered years earlier.
- Reel ID
- Continuous footage per reel
- Reel count
- Measured, documented, or estimated basis
Keep release status visible on every line
Mark available material separately from project-reserved, pending-return, and approval-required stock. Identify the owner, the person or role that can authorize release, and any known reservation or return condition. A reel can appear in a reconciliation list without being described as currently available for sale.
The error to avoid is presenting the original purchase total as released surplus. Resolve it by showing the present balance and its evidence basis, then placing any pending quantity on its own line. This helps the buying conversation stay focused on inventory that has an identified path to release.
- Ownership
- Release authority
- Reservation or return status
- Known release timetable or pending status
Make files match the inventory reference
Use the same reference in the spreadsheet, photo filenames, reel-tag image, jacket-print image, and any matching data sheet. State what each image shows and link a condition note to the precise reel. A document for a similar product should be identified as background, not used to replace a missing record.
The City of Santa Rosa describes Santa Rosa as the economic center of the North Bay and highlights manufacturing, health care, technology, professional services, tourism and creative industries. This is only local context for contractor, distributor, or facility inventory; it does not show that a particular reel exists or is released.
- Photo filenames using the inventory reference
- Complete readable markings
- Matching data sheet when available
- Condition notes and quantity basis
Illustrative reconciliation record
Illustrative inventory example—not a purchased lot: SR-OV-07 records project-overrun cable by the exact reel-tag designation. It lists two reels: 300 feet documented and 180 feet estimated. The second balance is marked release pending, so it is not combined with currently releasable stock.
This fictional record demonstrates the distinction the page addresses. It does not turn an estimate into a measured amount, and it does not imply that a named item, price, or release arrangement exists outside the example.
- Reference: SR-OV-07
- Material: project-overrun cable; exact designation from reel tag
- Quantity: 300 feet documented; 180 feet estimated
- Status: second balance release pending
