Start with today’s reel balance, not the purchase order
A purchase order or warehouse export identifies a starting point, but it may describe footage that has already been consumed, reassigned, or split between locations. Walk the actual inventory and create one line for every reel, partial reel, or clearly identified cutoff. The current continuous length is the quantity for the sale record; the original order amount remains background only.
The recurring inventory mistake is submitting the invoice total as though every foot still sits on a full reel. Replace that total with a current balance, identify whether each number is measured, documented, or estimated, and keep estimates visibly different from a count taken from the reel itself.
- Give each offered reel a stable reference before combining totals.
- Record original quantity and current quantity in separate fields.
- Keep full reels, partial reels, and cutoffs on separate lines.
Separate release-ready stock from project reservations
An identified reel is not necessarily available to sell. Add a release status beside every line: available, reserved, or release pending. A line marked reserved should remain in the record, but it should not be included in the balance presented as available. If release is pending, name the role or party that can clear it rather than implying that a warehouse location proves authority.
This is a quantity-provenance task, not a generic large-lot checklist. The useful decision is which physically identified reels can be offered now and which ones need internal clearance. That distinction keeps a buyer from confusing an inventory report with a ready-to-release cable list.
- Use an available-for-release flag for each reel line.
- Record reservation status and a short release note.
- Identify the owner or release authority without publishing personal details.
Make photos prove the inventory line they describe
Use the reel reference in the spreadsheet and the photo filenames. A useful set includes the reel tag, a readable stretch of jacket printing, an overview of the reel, and any visible packaging or condition issue. This is more reliable than attaching a single good photograph to a group with mixed part numbers or mixed remaining footage.
Transcribe the manufacturer, part number, conductor metal, size, marked voltage, and product designation only when shown by the tag, jacket, or matching document. If the label is incomplete, preserve the visible characters and state what is unknown. Do not borrow a specification from a neighboring reel merely to complete a row.
- Match photo references to the exact reel reference.
- Keep cable markings and condition notes on the same inventory line.
- Label an estimated length with its basis rather than false precision.
Use Akron context without inventing a local lot
Massillon Road Industrial Park is a 98-acre industrial park available for light industrial use; the city describes manufacturing employment opportunities and long-term job growth as goals. That is local industrial context only, not evidence that cable is available there or that the buyer has worked with a business at the park.
For an Akron overrun or distributor balance, the practical relevance is simple: inventory may move between project, warehouse, and release records. The seller still needs to show the physical reel, its current balance, its actual storage site, and the authority to release it. City context cannot substitute for those lot-specific facts.
- State the actual storage site for each offered line.
- Do not use a project name as proof of a current balance.
- Keep pending stock visible but outside available totals.
Worked reconciliation record
Use a record that lets another person trace a balance from the physical reel to the release decision. The example below is fictional and is not a purchase record. It shows why an estimate, a documented amount, and a pending release should not be silently added together as one available quantity.
If the tag or current footage cannot be confirmed, retain the reel reference and photo set, mark the uncertain field as unknown, and update that single line when better evidence becomes available. Do not erase the uncertainty by replacing it with the original order quantity.
- Reference: OV-AK-01; product: feeder cable with part number recorded from tag.
- Current balance: two reels, 300 ft documented and 180 ft estimated.
- Status: uninstalled inventory; release pending; illustrative record only.
