Keep each shelf balance traceable to real receipts and issues. Use a complete copy-ready record with running quantities, correction rules and a worked example.
A stock request tells a storekeeper what someone wants. A bin card tells them what has actually entered and left a particular stock location. Confusing those records can turn an approval into stock that never arrived—or subtract a planned issue twice.
This bin card template is for small internal stores handling ordinary, noncritical consumables such as envelopes or packaging supplies. Everything needed is inline: copy the setup record and movement table into a document or spreadsheet. There is no separate download to obtain.
What this card records—and what it does not
Use one card for one item, one bin and one stock status. A bin can be a clearly identified shelf compartment, not necessarily a container. Keep different item specifications, units and usable-versus-held stock separate.
The Logistics Cluster’s warehousing documentation guide describes cards kept with stock, recording incoming and outgoing quantities and a running balance. It distinguishes that local record from a central inventory ledger. The operating rules below adapt that basic idea for a small, manually controlled store; they are proposed procedures, not universal legal requirements.
- Card balance: the recorded physical quantity at this item/bin/status boundary.
- Availability: a separate decision that also considers holds, reservations and commitments. Even a USABLE card is not proof that every unit is free to promise.
- Consumption: not established by an issue. Material may remain unused with the recipient.
This is not a costing ledger, purchasing authorization or warehouse system. Do not apply it unchanged to medicines, hazardous materials, expiry-controlled goods, safety-critical parts or serialized equipment. Those need their own approved controls.
Copy the setup record first
Create a spreadsheet sheet named Setup. Put the following labels in column A and their values in column B, using exactly these row numbers if you use the formulas later. For paper use, copy the same fields above the movement table.
| Row | Field | Entry and validation |
|---|---|---|
| 1 | Card ID / page | Unique text, for example BC-N01-ENV01-P01. Never reuse an archived ID. |
| 2 | Item code | One verified internal code; unknown identity blocks routine movement. |
| 3 | Description / specification | Enough detail to distinguish size, grade and pack contents. |
| 4 | Store | Site/store code. |
| 5 | Bin | Exact labeled location; identify a separate compartment for held stock. |
| 6 | Stock status | USABLE or HOLD. Do not change this value to reclassify existing stock. |
| 7 | Stock unit | One unit throughout, such as individual envelopes. State whole-unit or approved decimal precision. |
| 8 | Opening cutoff | Date, time and time zone; movements after this cutoff enter the log. |
| 9 | Opening quantity | Verified nonnegative number. Blank means unknown, not zero. |
| 10 | Opening evidence | Controlled count or preceding card ID, last sequence and closing balance; reviewer and timestamp. |
| 11 | Recording owner | Named storekeeper responsible for this card and reconciliations. |
| 12 | Backup / review owner | Named backup plus person authorized to review discrepancies and approve corrections. |
| 13 | Central stock reference | System/register identity and matching item/location/status record. |
| 14 | Previous / next card | Cross-references for rollover; write “first card” or “not yet assigned” where appropriate. |
| 15 | Reconciliation schedule | For a pilot: after each operating shift, named reviewer and next review due. Change this locally if needed. |
Start with a verified opening quantity and a controlled cutoff. Do not copy an old count and then add receipts that were already included in it. If the opening position cannot be established, mark the card STARTUP HOLD, investigate and begin only after the stores lead signs the baseline.
Copy the movement log
Create a second sheet named Movements. Paste this comma-separated header into row 1 and split it into columns A–M. On paper, extend the record with a linked notes sheet if necessary; keep the card and sequence reference on every note.
Sequence,Event ID,Actual movement at,Recorded at,Type,Source reference,In,Out,Balance,From or to,Recorded by,Evidence and authority,Central posting check- A–B: sequence is a consecutive positive integer within the card. Event ID is unique within your stores record set. Use a suffix for separate physical handovers under one source document.
- C–D: record both actual movement time and entry time, including time zone. For an adjustment with no physical movement, column C is the approved correction’s effective time. A late entry must not pretend it was written earlier.
- E–F: select a movement type below and identify the specific source document, line and handover. A document number alone is insufficient when it covers several events.
- G–H: numeric quantities in the setup unit. Exactly one must be positive and the other must be an explicit zero. Do not enter negatives, both directions or two zeros.
- I: calculated running quantity, never a manually typed replacement for a discrepancy.
- J–L: identify the counterparty/location, recorder, receipt or release evidence and applicable authorization. For a correction, record reviewer, reason and approval reference.
- M: PENDING, MATCHED plus central transaction reference/checker/time, or EXCEPTION plus case ID/owner/due time. This checks the second record; it does not change the card balance.
Require all fields, using an explicit “not applicable” only where no physical counterparty exists, such as an approved count correction. Do not treat a missing receipt signature as not applicable. Preserve the unresolved evidence gap in an exception case.
Choose the direction from what actually happened
| Type | Direction | Required basis |
|---|---|---|
| RECEIPT | In | Goods actually placed in this bin, with receiving reference and condition/status decision. |
| ISSUE | Out | Actual handover, authorized release reference and receiver evidence. Use the material requisition template for that authorization, not this card. |
| RETURN | In | Actual receipt back, linked to earlier issue and condition review. Put questionable goods in a separate HOLD compartment/card. |
| TRANSFER_IN / TRANSFER_OUT | In / Out | Actual arrival/release, paired location and transfer-event reference. A dispatch is not proof of destination receipt. |
| ADJUST_UP / ADJUST_DOWN | In / Out | Approved record correction after investigation. Link evidence; no physical receipt or issue is implied. |
There is no row for a purchase order, request, pick plan or canceled request when no stock moved. A returned unit enters only once; do not also add it as a receipt. A movement between two compartments gets an outward event on the source card and an inward event on the destination card, linked by the same transfer reference.
Add a running balance without hiding invalid entries
For row 2, enter this in Movements!I2 and fill down. It works for a single card per workbook, with the setup locations above:
=IF(AND(G2="",H2=""),"",Setup!$B$9+SUM($G$2:G2)-SUM($H$2:H2))The arithmetic is opening quantity + cumulative In − cumulative Out. The formula does not validate entries, verify authority or detect missing physical events. It can ignore text values, so check that quantities and the opening balance are genuinely numeric before relying on the result. Your spreadsheet locale may require semicolons instead of commas.
Protect the formula column against accidental typing if your tool supports it. Keep rows in recording sequence and never sort only part of the table. Use filtered views for analysis rather than rearranging the authoritative record.
Before an outward movement, check item, bin, status, release authority and current quantity. Block an issue from a HOLD card. If an outward quantity would exceed the known balance, stop the routine release and investigate; never clamp a negative result to zero. If an unrecorded or unauthorized movement has already happened, preserve its actual facts in the log and open an incident—do not omit it to keep the arithmetic looking acceptable.
Worked example: receive, issue, return and correct
Fictional example: card BC-N01-ENV01-P01 tracks individual C5 envelopes in North Stores, bin A-02, status USABLE. Opening quantity is 40 at 08:00 America/Chicago on November 21, 2026, verified under baseline BL-01. All quantities are individual envelopes, not boxes.
| Seq / event | Actual time / type | In | Out | Balance | Evidence |
|---|---|---|---|---|---|
| 1 / EV-201 | 08:20 RECEIPT | 20 | 0 | 60 | GRN-31 line 1; Lee receives from goods-in; checked usable. |
| 2 / EV-202 | 09:00 ISSUE | 0 | 12 | 48 | MR-12 line 1, handover 1; Jo acknowledges; Dana’s release authority linked. |
| 3 / EV-203 | 11:00 RETURN | 3 | 0 | 51 | RT-07 linked to EV-202; Lee verifies usable condition and receipt from Jo. |
| 4 / EV-204 | 14:00 ADJUST_DOWN | 0 | 1 | 50 | CC-09 confirms 50 after controlled recount/investigation; Dana approves delta −1 under ADJ-04. |
For this example, recorded-at time equals actual time on each row and Lee is the recorder. Central posting checks finish MATCHED against ST-201 through ST-204, each checked by reviewer Sam at 14:15. Retain these companion details in columns D, K and M rather than relying on the compact illustration alone.
The arithmetic is 40 + 20 − 12 + 3 − 1 = 50. The adjustment is a correction to the record, not evidence that someone physically issued one more envelope. If investigation instead finds a missing real issue, record that issue with its evidence rather than adding an adjustment for the same difference.
Reconcile the card and manage exceptions
The Logistics Cluster’s recording and supporting-document guidance emphasizes cross-referencing movements to their evidence. For this pilot, the recording owner reviews every PENDING row at shift end against the central stock record and its source event.
If the central record already contains the same event, link it; do not post it again. If a posting response is uncertain, inspect the existing transaction history before any retry. A MATCHED label needs matching item, location, status, direction, quantity and event reference—not merely matching grand totals.
Use a small exception record
Case ID / card ID / affected sequences:
Detected at / detected by:
Expected quantity / observed quantity / evidence cutoff:
Problem: missing document / unit mismatch / late entry /
duplicate record / count difference / posting uncertainty / other
Immediate restriction and affected stock:
Investigation owner / next action / due at / backup:
Evidence reviewed / finding / approved resolution:
Correction events or central transaction references:
Verified resulting balance / verifier / time:
Closure decision / unresolved follow-up:Keep the case OPEN until its resolution and resulting records are verified. If its due time passes, escalate to the stores lead with the affected bin, blocked work and a revised review time. Set real due times before the pilot; an indefinitely “pending” case has no usable follow-up rule.
- Quantity or unit disagreement: stop routine release from the affected bin. Verify the stocking unit and source evidence. Use the controlled cycle count resource if a physical discrepancy remains.
- Late entry: append it with actual and recorded times plus an explanation. The intervening recorded balances were incomplete; retain that fact instead of silently backdating rows.
- Duplicate entry: preserve the erroneous row. Add a reviewer-approved opposite-direction correction linked to it, then retain the correct single physical event. This is a record correction, not a fictitious return.
- Held stock: move questionable units to a labeled HOLD compartment and paired card. Release needs an authorized condition decision and a documented transfer back; changing the header from HOLD to USABLE is not a release procedure.
- Parallel updates: designate one recording owner at a time with a documented backup handover. A shared spreadsheet does not automatically prevent two people issuing against the same old balance.
When the balance and its commitments are reliable, use the reorder point worksheet for a separate replenishment decision. A low card quantity is not permission to buy.
Roll over and test the card before relying on it
When the page fills, reconcile it, record the last sequence and closing quantity, and open a new card/page with that same quantity at the same cutoff. Link both IDs. Do not log the carry-forward as another receipt. This carry-forward and archive rule is part of the proposed local procedure.
- Reproduce the example: balances must be 60, 48, 51 and 50.
- Leave a blank future row: its balance display stays blank. Leave opening quantity unknown: the reviewer must reject setup even if the spreadsheet displays a result.
- Enter In and Out together, text quantity, a negative number or a duplicate Event ID: reject the row at validation.
- Propose an issue of 51 from the final 50: stop release and investigate; never show zero as a substitute for −1.
- Transfer five usable units into hold: source card decreases by five, HOLD card increases by five; total physical stock is unchanged.
- Find EV-202 already posted centrally: link the existing transaction, not a second posting.
- Roll over at 50: a new first issue of two must leave 48, not 98.
Have the backup reproduce the example and follow one real movement from its source document through both records. Review the recording and reconciliation workload before expanding beyond a few bins.
Where Workhint fits in discrepancy review
The card works without Workhint. The Workhint Workflow Engine describes routing approval decisions to defined roles and requiring information before work progresses. Those capabilities are relevant when a stock discrepancy needs a reviewer and evidence before someone authorizes a correction.
The workflow automation software solution describes structured forms, review stages, owners and next actions. A configuration discussion can start with the exception record above. These pages do not establish native bin cards, these spreadsheet calculations, inventory valuation or automatic synchronization with a stock ledger. Confirm any proposed implementation separately and keep the authoritative stock record explicit.
Frequently asked questions
Can one card cover several bins?
Not in this template. Separate cards keep each location’s quantity meaningful. Consolidate them for reporting without treating a balance in another bin as stock physically present here.
Is a bin card the same as a material requisition?
No. A requisition requests and authorizes a release. The bin card records actual movements from many requests and receipts, producing the bin’s running quantity.
Should I erase an incorrect quantity?
No. Preserve the entry and document an approved correction with its reason and cross-reference. Verify the resulting balance and any central-record correction before closing the case.
Does a matching card and ledger prove the shelf is correct?
No. Both records can share the same missing event. Periodic controlled physical counts provide a separate check. Investigate differences before changing quantities merely to make records agree.

Leave a Reply