Free template · Excel · Worked example

Bin Card Format: Free Excel Template with Worked Example

A ready stock bin card for your stores: header fields, movement columns and a filled November example for M10 hex bolts. Download the Excel, print it or keep it at the rack.

Download the Excel template

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

FieldWhat to writeExample
Card numberA running number, so cards can be filed and foundBC-114
Item name and sizeThe name the shop floor uses, with size or gradeHex bolt M10 x 40
Item codeThe code from your item masterFB-M10-40
UnitOne unit for the whole cardPieces (pcs)
Store and bin locationStore, rack and binMain store, Rack B2, Bin 4
Minimum levelThe level stock should not fall below300 pcs
Maximum levelThe most you want to hold2,000 pcs
Reorder levelThe balance at which you raise an indent600 pcs

Not sure what levels to set? See how to work out the minimum stock level and the maximum stock level.

Movement columns

ColumnWhat to writeExample
DateThe day the goods moved3 Nov
Document no.GRN, issue slip, return slip, transfer note or adjustment numberIS-221
Received from / Issued toSupplier, work order, line or storeWO-118, welding line
Qty receivedGoods in: receipts, returns, transfers in30
Qty issuedGoods out: issues, transfers out, approved shortages250
BalancePrevious balance + received − issued650
InitialsThe storekeeper who made the entryRK
RemarksAnything unusual: indent raised, count differenceIndent 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

  1. Open the card. Fill every header field before the first entry.
  2. Write the opening balance. Count the bin, then write the date and the counted quantity as line one.
  3. 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.
  4. 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.
  5. 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.
  6. Work out the balance after every line. Never skip lines and total them later.
  7. Initial the line. The storekeeper initials each line they write.
  8. Raise an indent at the reorder level. When the balance touches or drops below it, raise an indent. Note the indent number in Remarks.
  9. 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.

Book a demo →

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

FieldEntry
Card numberBC-114
Item name and codeHex bolt M10 x 40, FB-M10-40
UnitPieces (pcs)
LocationMain store, Rack B2, Bin 4
Minimum / maximum300 pcs / 2,000 pcs
Reorder level600 pcs

Table 2 (Example): movements for November

DateDocument and from / toReceived / issuedBalance
1 NovOpening balance (counted)—900
3 NovIS-221, to WO-118, welding lineIssued 250650
4 NovIS-226, to WO-121, welding lineIssued 150500
7 NovRS-019, returned from WO-118Received 30530
10 NovMTN-012, to Plant 2 storeIssued 100430
14 NovGRN-0342, from bolt supplierReceived 1,2001,630
17 NovIS-240, to WO-125, assemblyIssued 3101,320
18 NovPhysical count: 1,280 pcsShort 40 (noted)1,320
20 NovADJ-07, approved by stores in-chargeIssued 401,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

PointBin cardStores ledger
Kept byStorekeeperStores accounts or costing team
Kept whereAt the rack or binIn the stores office or accounts
RecordsQuantity onlyQuantity, rate and value
WrittenWhen goods moveFrom the documents, usually later
Used forKnowing what's in the binValuing 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.

Book a demo →

Frequently asked questions

Who maintains the bin card?

The storekeeper writes and initials every line when goods move. The stores in-charge checks the card against the rack and approves any adjustment.

What is the difference between a bin card and a stores ledger?

The bin card sits at the rack and records quantity only. The stores ledger is kept in the office and records quantity, rate and value.

What is the purpose of a bin card?

It shows how much should be in the bin right now. It warns the store at the reorder level and leaves a document trail when stock goes missing.

What is a stock record card?

Many factories use the name for the same card. Where both exist, the bin card stays at the rack and the stock record card stays in the stores office.

What columns are in a bin card?

Date, document number, received from or issued to, quantity received, quantity issued, balance, initials and remarks. The header holds the item, unit, location and stock levels.

How is the balance on a bin card calculated?

Take the balance on the line above, add what came in and subtract what went out. For example, 500 + 30 − 0 = 530.

Don’t be the bottleneck.
Become the AI-Run Factory.

Book a demo

Born in India. Building for the world.