What is a bin card?
A bin card is a quantity-only stock record kept at the rack or bin where an item is stored. The standard bin card format has a header: item name and code, unit, store location, minimum, maximum and reorder level. Below it, each movement gets one row. The columns are date, document number, received from or issued to, quantity received, quantity issued, balance and the storekeeper's initials. The balance after each entry is the previous balance plus receipts minus issues, and it should match what is physically on the rack.
The storekeeper writes a line each time goods move and initials it. The stores in-charge checks the card against the rack. The card holds quantities only, no rates or values. Keep one card for each item in each storage location.
Bin card format: what each field and column means
Header fields
| Field | What to write | Example |
|---|---|---|
| Card number | A running number, so cards can be filed and found | BC-114 |
| Item name and size | The name the shop floor uses, with size or grade | Hex bolt M10 x 40 |
| Item code | The code from your item master | FB-M10-40 |
| Unit | One unit for the whole card | Pieces (pcs) |
| Store and bin location | Store, rack and bin | Main store, Rack B2, Bin 4 |
| Minimum level | The level stock should not fall below | 300 pcs |
| Maximum level | The most you want to hold | 2,000 pcs |
| Reorder level | The balance at which you raise an indent | 600 pcs |
Not sure what levels to set? See how to work out the minimum stock level and the maximum stock level.
Movement columns
| Column | What to write | Example |
|---|---|---|
| Date | The day the goods moved | 3 Nov |
| Document no. | GRN, issue slip, return slip, transfer note or adjustment number | IS-221 |
| Received from / Issued to | Supplier, work order, line or store | WO-118, welding line |
| Qty received | Goods in: receipts, returns, transfers in | 30 |
| Qty issued | Goods out: issues, transfers out, approved shortages | 250 |
| Balance | Previous balance + received − issued | 650 |
| Initials | The storekeeper who made the entry | RK |
| Remarks | Anything unusual: indent raised, count difference | Indent IND-047 raised |
Excel works as well as paper. Keep one sheet per item per location and let the balance column calculate itself. Print it or keep a tablet at the rack, so entries still happen when goods move.
How to fill a bin card, step by step
- Open the card. Fill every header field before the first entry.
- Write the opening balance. Count the bin, then write the date and the counted quantity as line one.
- Enter each receipt from its GRN. Write the GRN number, the supplier and the accepted quantity. Use our GRN format if you don't have one.
- Enter each issue from its issue slip. Write the slip number and the work order or line it went to. Issues usually follow the work order's bill of materials.
- Put returns and transfers in the right column. Returns to store go in Received, with the return slip and work order. Transfers to another store go in Issued, with the material transfer note number.
- Work out the balance after every line. Never skip lines and total them later.
- Initial the line. The storekeeper initials each line they write.
- Raise an indent at the reorder level. When the balance touches or drops below it, raise an indent. Note the indent number in Remarks.
- Check against a physical count. Count at least monthly, and more often for fast-moving or high-value items. Write the count and any difference on its own line. Adjust only after the stores in-charge approves. Our stock reconciliation guide covers the full check.
When a paper or Excel bin card stops working
A card works well when one storekeeper looks after one store with a short item list. It starts to slip when:
- You stock a large number of items.
- The same item sits in more than one store or plant.
- Issues happen across shifts, made by different people.
- Cards get updated at day end, from a pile of slips.
- Counts never quite match the cards.
None of this is the storekeeper's fault. Paper and Excel only know what someone writes down, and a busy shift leaves gaps.
[[IMAGE {"type":"compare","title":"Paper bin card vs TranZact","columns":["Paper or Excel card","TranZact"],"rows":[["Reorder warning","Storekeeper checks each balance","AI stock alerts"],["Same item, two stores","Two separate cards","Multi-store stock"],["Reorder to purchase","Separate indent on paper","Indent → RFQ → PO → GRN"],["Stock data to accounts","Typed again into Tally","One-way sync to Tally"]]}]]
Bin card in TranZact (as of October 2026)
TranZact is manufacturing AI software used by 10,000+ manufacturers. Its inventory module includes stock in, bin card, issue, batch tracking, multi-store, reorder and AI stock alerts.
Purchase in TranZact follows the path a reorder starts: MRP report → indent → RFQ → PO → GRN.
Accounting stays in Tally. Operations run in TranZact, with one-way sync and no double entry.
Stock tracking and inventory ageing & valuation come with the Grow plan: ₹8,333/month billed yearly, for 4 users. Batch-wise stock tracking needs Scale+, at ₹16,666/month billed yearly. See pricing for current plans. TranZact goes live in 2–3 weeks.
Worked example: M10 hex bolts in a fabrication unit
All numbers here are illustrative. The unit makes welded steel frames and keeps M10 bolts in its main store. The same example is filled in on the second sheet of the Excel download.
Table 1 (Example): card header
| Field | Entry |
|---|---|
| Card number | BC-114 |
| Item name and code | Hex bolt M10 x 40, FB-M10-40 |
| Unit | Pieces (pcs) |
| Location | Main store, Rack B2, Bin 4 |
| Minimum / maximum | 300 pcs / 2,000 pcs |
| Reorder level | 600 pcs |
Table 2 (Example): movements for November
| Date | Document and from / to | Received / issued | Balance |
|---|---|---|---|
| 1 Nov | Opening balance (counted) | — | 900 |
| 3 Nov | IS-221, to WO-118, welding line | Issued 250 | 650 |
| 4 Nov | IS-226, to WO-121, welding line | Issued 150 | 500 |
| 7 Nov | RS-019, returned from WO-118 | Received 30 | 530 |
| 10 Nov | MTN-012, to Plant 2 store | Issued 100 | 430 |
| 14 Nov | GRN-0342, from bolt supplier | Received 1,200 | 1,630 |
| 17 Nov | IS-240, to WO-125, assembly | Issued 310 | 1,320 |
| 18 Nov | Physical count: 1,280 pcs | Short 40 (noted) | 1,320 |
| 20 Nov | ADJ-07, approved by stores in-charge | Issued 40 | 1,280 |
What the example shows
- 4 Nov: the balance fell to 500, below the reorder level of 600. The storekeeper raised indent IND-047 the same day.
- 10 Nov: 100 bolts moved to the Plant 2 store. They leave this card as an issue and enter Plant 2's own card as a receipt.
- 18 Nov: the count found 1,280 pieces against 1,320 on the card. The difference was written down, not hidden.
- 20 Nov: after approval, a 40-piece adjustment brought the card to 1,280.
Bin card vs stores ledger
| Point | Bin card | Stores ledger |
|---|---|---|
| Kept by | Storekeeper | Stores accounts or costing team |
| Kept where | At the rack or bin | In the stores office or accounts |
| Records | Quantity only | Quantity, rate and value |
| Written | When goods move | From the documents, usually later |
| Used for | Knowing what's in the bin | Valuing stock and costing issues |
The two records should show the same quantity for each item. When they don't, a physical count shows which one is right.
Common bin card mistakes
- Writing at day end from memory. Write the line when the goods move, from the slip in hand.
- Changing the balance to match the rack. Write the count and the difference on a new line. Adjust after approval.
- Lines with no document number. Every entry needs a GRN, issue slip, return slip, transfer note or adjustment number.
- Mixing units. If bolts arrive in boxes of 100, convert to pieces before you write.
- Adding rates and values. The bin card is quantity only. Values belong in the stores ledger.
Want to see the bin card and AI stock alerts on your own items? Bring one of your cards to a demo.
Don't be the bottleneck. Become the AI-Run Factory.