Start with a current balance, not the project total
A purchase order, packing list, or closeout export can identify what entered a project, but it does not prove what remains available today. Walk the physical inventory and give each reel, carton, or cutoff group one stable reference. Keep the original quantity as history, then add a current-balance field that states whether footage was measured, documented from a current record, or estimated.
Match that reference to the original line only when the manufacturer, part number, and designation actually agree. A current balance is more useful than a polished grand total because it shows which physical cable is present and how the stated quantity was established. If a package cannot be opened or a reel cannot be reached, leave the balance estimated and say why rather than carrying forward an old number as fact.
- Reel or carton ID tied to the inventory row
- Manufacturer, part number, and readable designation
- Current continuous length with measured, documented, or estimated basis
Keep full reels, partial reels, and cutoffs on different lines
A full reel, a partial reel, an unopened carton, and several short cutoffs do not present the same seller decision even when the printed specification matches. Record them separately, including reel count, per-reel length, packaging status, and visible damage. Do not convert separate lengths into one continuous length or mix a carton count with footage without explaining both bases.
This prevents a common inventory mistake: presenting invoice footage as the current available amount while full reels, partial reels, and cutoffs are blended into one project total. Clear lines also let a seller correct one item without changing the evidence for every other item in the offer.
- Condition class for each line
- Per-reel length and reel count
- Packaging status and visible damage noted as observed
Make release status visible before asking for review
Give each line an ownership and release-status field. Identify whether it is available, reserved for another project, pending a return, on consignment, or awaiting owner or manager authorization. An approval-pending reel should stay visible in the inventory, but it should not be represented as cleared surplus.
Where a date is unknown, write unknown rather than inventing a timetable. Include the role or contact responsible for release if that information may be shared, plus the storage area and any access note. This documentation step does not settle commercial terms; it simply keeps a buyer from confusing an inventory record with authority to release the cable.
- Ownership or controlling entity
- Release authority and reserved status
- Approval needed and available date if known
Use New York City context only to organize the record
NYCEDC describes New York as a manufacturing and industrial hub with 21 Industrial Business Zones across Brooklyn, the Bronx, Queens, and Staten Island. That is local context for a contractor, distributor, or facility team organizing a project closeout; it does not identify a particular seller, cable lot, or local purchasing demand.
For a New York City project record, retain the reel reference in both photo filenames and the spreadsheet. Show a label photograph and a jacket-marking photograph when available, then list the storage area beside the current balance. This creates a handoff a reviewer can follow without relying on an unverified citywide count.
- Photo filename matched to the reel or carton ID
- Label and jacket-marking photographs
- Storage area and a contact for follow-up
Correct a stale line with an explicit fictional example
Illustrative inventory example—not a purchased lot: OV-NYC-01 is project-overrun feeder cable with the part number recorded from the tag. One reel has 300 ft documented; a second has 180 ft estimated because its remaining footage is not confirmed. The second reel is marked release pending, so it is not blended into the available balance.
If an export was already sent with the original invoice footage, revise the line instead of trying to reconcile it through a narrative note. Preserve the historical figure, show the new current balance, state the quantity basis, and flag the release gate. The resulting record lets the actual inventory and outstanding unknowns be discussed without implying an accepted purchase.
- Historical quantity retained separately
- Current balance tied to the physical reference
- Reserved or approval-pending status plainly marked
