Free template · Stores

Material Issue Slip Format: Free Excel Template + Example

A blank material issue slip, a filled example from a trolley manufacturer and an issue register in one free Excel file. Every column explained, how to fill it, and the mistakes that throw store stock and job costs off.

Download the Excel template

A material issue slip is the store document that records material leaving the store for production, a job or a shop-floor section. A standard format has a header (slip number, date, issuing store, receiving section, work order or cost centre, requisition number). It also has an item table (item code, description, unit, quantity requested, quantity issued, batch number, remarks). The requester, approver, storekeeper and receiver sign it. Download our free Excel format below: a blank slip, a filled example and an issue register.

Download the Excel template (free .xlsx, no sign-up).

What is a material issue slip?

A material issue slip is the store's record of every item handed out for production or other internal use. Think of it as the gate pass for material leaving stores.

It keeps store stock right, charges material to the right work order and proves who took what.

Manufacturers also call it a store issue slip, issue voucher or material issue note.

Material requisition vs material issue slip

A material requisition is the request. The shop floor writes what it needs and for which job, and a supervisor approves it. The purpose of a requisition form is simple: nobody pulls stock without a reason and an approval.

To raise one, list the work order and the items its BOM needs. Get a supervisor to sign it and send it to stores.

The issue slip records what stores actually handed over. The quantities often differ when stock runs short or a part is substituted.

PointMaterial requisitionMaterial issue slip
Who writes itShop floor or supervisorStorekeeper
QuantityQty requestedQty issued and pending qty
WhenBefore the job needs itWhen material leaves the store

Many manufacturers combine both on one "requisition cum issue slip". Our template does this.

What each field in the material issue slip format means

Header fields

FieldWhat to write
Slip numberA running number, never reused. A gap shows a missing slip.
DateThe day the material left the store.
Issuing storeThe store or godown that issued it.
Issued toThe section or line receiving it.
Work order / cost centreThe job or cost head charged.
Requisition numberThe approved request this slip fills.

Item columns

ColumnWhat to write
Sr. no.Line number.
Item codeThe code from your item master.
Item descriptionName, size and grade, for example "MS sheet 1.2 mm".
UnitThe same unit as the stock register.
Qty requestedThe quantity on the approved requisition.
Qty issuedWhat actually left the store.
Pending qtyRequested minus issued. The Excel works it out.
Batch / lot no.So a bad lot can be traced.
Rate and value (₹)Optional. Value is Qty issued × rate.
RemarksShort stock, a substitute item or other notes.

Sign-off

SignatureWho signs
Requested byThe person who needs the material.
Approved byThe supervisor or production head.
Issued byThe storekeeper.
Received byThe person who took it. This is your proof of handover.

How to fill a material issue slip, step by step

  1. Take the approved requisition. No approval, no issue.
  2. Check that the work order is open and the stock is on the shelf.
  3. Issue the oldest stock first (first in, first out) and write its batch number.
  4. Write the quantity actually issued, not the quantity asked for. Note any pending quantity.
  5. Get the receiver and the storekeeper to sign.
  6. Update the bin card or stock register the same day.
  7. File copies for stores, accounts and the receiving section.

Where TranZact fills it for you

A slip book and an Excel register work until the shop floor gets busy. Then slips get written late and the register drifts from the shelf. The fault is in the patchwork, not the storekeeper.

In TranZact, issue, bin card, batch tracking and multi-store are part of inventory. Work orders and multi-level BOMs are part of production. So stores stops keeping a separate slip book and Excel register.

Accounting stays in Tally, with one-way sync and no double entry. TranZact is manufacturing AI software used by 10,000+ manufacturers, and it goes live in 2–3 weeks.

TranZact inventory and production facts (as of 22 Oct 2026)

Need on the slipWhere it lives in TranZactPlan
Recording the issue and the bin cardInventory: issue, bin cardGrow and up
Work order and BOM the material is forProduction: work orders, multi-level BOMGrow and up
Material cost per jobProduction: production costingGrow and up
Batch number on each lineInventory: batch trackingScale+ and up
Who may issue from which storeStore-level permissionsDominate
Sending it to accountsTally, Busy or Zoho Books syncGrow and up

The honest limit: batch-wise stock tracking starts on Scale+, and store-level permissions are on Dominate. See pricing for what each plan includes.

Book a demo →

[[IMAGE {"type":"steps","title":"From request to register","items":["Supervisor approves the requisition","Stores writes the issue slip","Bin card goes down the same day","Unused material returns on a return note","Register shows net consumption"]}]]

Worked example: issuing material for 50 steel trolleys

This example uses the same steel trolley as our bill of materials template. All numbers are illustrative.

Table 1 (Example): slip header

FieldExample
Slip numberMIS-0147
Date18 Nov 2026
Issuing storeMain store
Issued toFabrication line
Work orderWO-2411-022 (50 steel trolleys)
Requisition numberMR-0389

Table 2 (Example): item lines with pending qty and value

Item (unit)Requested → issuedBatchValue (₹)
RM-101 MS square tube 25×25 mm (m)300 → 300B-2410-0728,500 (at ₹95)
RM-205 MS sheet 1.2 mm (kg)400 → 350 (50 pending)B-2410-1225,200 (at ₹72)
BO-310 Castor wheel 100 mm (nos)200 → 200B-2411-0317,000 (at ₹85)
BO-412 Nut-bolt set M8 (set)50 → 50B-2409-212,000 (at ₹40)
CN-501 Powder coat, black (kg)25 → 25B-2411-018,000 (at ₹320)
Total issued80,700

The MS sheet line shows 50 kg pending. Stores was short, so the balance goes out on a new slip after the next delivery. Our goods received note format covers that side.

Table 3 (Example): next day's return and net consumption

ItemIssuedReturnedNet used
MS square tube (m)30012288 (₹27,360)
Powder coat (kg)25322 (₹7,040)
Value, all five items (₹)80,7002,10078,600

The job's material cost is ₹78,600, not ₹80,700. Without the return entry, the work order looks ₹2,100 costlier. The shelf will also show 12 m of tube and 3 kg of powder coat more than the register.

What happens to material that is not used?

Unused material goes back to the store on a material return note. Write it against the same work order and the original slip number.

Stores adds it back to the bin card. The register then shows net consumption, as in Table 3.

Moving material between stores, not to production? Use a material transfer note instead.

Common material issue slip mistakes

  • No work order or cost centre. The material can't be charged to a job, so costing becomes a guess.
  • Loose, unnumbered slips. A missing slip means unreconciled material, and nobody notices the gap.
  • No receiver signature. When stock is short, there is no proof of who took it.
  • Returns taken back without a note. Consumption is overstated and the store count goes wrong.
  • Issuing on a WhatsApp message. The slip never gets written, so the stock never goes down.
  • One slip for several work orders. Costs and returns can't be split by job.

If the store count and the register keep disagreeing, our material reconciliation guide shows how to find the gap.

Material issue register: one line per issue

The material issue register is the running list of every issue slip. Each slip line becomes one row, so you can total consumption by item, work order or month.

The register sheet in our Excel has these columns:

  • Date and slip number
  • Work order or cost centre
  • Item code, item and unit
  • Qty issued, qty returned and net qty
  • Value (₹) and issued to

Filter by work order to see a job's total material, or by month to see total consumption. Check net quantities against the bin cards every week.

Bring last month's slip book and register to the call. We'll show you where each entry lives in TranZact.

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

Book a demo →

Frequently asked questions

Who should sign a material issue slip?

The person asking for the material, the person approving it, the storekeeper who issues it and the person who receives it. The receiver's signature is your proof of who took the material.

Should the issue slip show rate and value?

It's optional. Adding a rate lets you see the material cost of each work order. Our Excel works out the value as quantity issued × rate.

How many copies of an issue slip should I keep?

Many stores use a numbered three-copy book: one for stores, one for accounts and one for the receiving section. In Excel, keep the register as your master copy.

Can one slip cover more than one work order?

Better not. Use one slip per work order so each job's material cost stays clear and returns match the right job.

Can I keep my accounts in Tally if I move stores to software?

Yes. With TranZact, accounting stays in Tally and operations run in TranZact, with one-way sync and no double entry.

What file format is the template?

A free .xlsx file with three sheets: blank slip, filled example and issue register. It opens in Excel and Google Sheets, with no sign-up.

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

Book a demo

Born in India. Building for the world.