Free template · Excel · Worked example

Material Indent Format: Free Excel Template with a Filled Example

An indent format is the sheet a manufacturer uses to ask for material. Stores or production write the item, quantity, required-by date, job and stock in hand, and a manager approves it. A store indent asks the store to issue stock it holds. A purchase indent asks the purchase team to buy what is short. Once approved, it becomes a purchase order to the supplier.

Download the Excel template

What is an indent?

An indent is an internal request for material. Stores, production or maintenance raise it.

Nothing is issued or bought until someone checks the need.

Store indent vs purchase indent

A store indent asks the store to issue material it already holds.

A purchase indent asks the purchase team to buy what is short, after stock in hand and material on order.

Where the indent sits in the purchase flow

The indent comes after a shortage is found, from a material requirement planning (MRP) report or a reorder level. Our MRP software buying guide explains how that list is worked out.

[[IMAGE {"type":"steps","title":"Where the indent sits in purchase","items":["Shortage found: MRP report or reorder level","Indent raised and approved","RFQ to suppliers, then PO","GRN when material arrives","Payment against the supplier bill"]}]]

What each column in the indent format means

One row per item line, so you can filter by job or status.

ColumnWhat to writeExample
Indent no/dateA running number, never reused, and the date raised.IND-0142 / 18-Nov-2026
TypeStore (issue from stock) or Purchase (buy the shortfall).Purchase
Job/due dateThe work order, and when material must reach the floor.WO-0387 / 25-Nov-2026
ItemBOM item code, name, size and grade.RM-ANG-40 MS angle 40×40×5 mm
UnitThe unit you stock and buy in.m
RequiredTotal the job needs, scrap included. On a store line, the quantity to issue.252
In stockStore stock that no other job has claimed.180
On orderQuantity on open POs, not yet received.0
Net to buyRequired − in stock − on order, never below 0. The sheet works it out.72
Value (₹)Net to buy × last purchase rate.13,680 (72 m × ₹190)
ApproverName of the approver, with the date.Plant head, 18-Nov
Status/PO noOpen, Approved, PO raised, Issued or Closed, plus the PO or issue number.PO raised: PO-0611

How to fill an indent, step by step

  1. Number and date. Take the next number in the series.
  2. Pick the type. Store if the material is in stock, purchase if it is short.
  3. Add the work order and due date.
  4. One line per item. Copy items from the BOM or shortage list, with the same codes.
  5. Work out the net quantity. Required − in stock − on order. If it comes to 0, raise a store indent instead.
  6. Add the value. Net qty × last rate shows the approver the spend.
  7. Approve and close the loop. Stores checks the stock and the manager signs. Purchase writes the PO number back on the line.

Who approves? Usually the head of the team that raised it, or the plant head. Many owners set a value limit above which the indent comes to them.

Where TranZact fills the indent for you

The Excel sheet works for a few indents a month. With ten open orders sharing the same steel and castors, netting by hand gets slow and mistakes slip in.

TranZact is manufacturing AI software used by 10,000+ manufacturers. Its MRP engine runs through your orders and BOMs, then tells you what to buy and when. The indent follows from the MRP report and moves on to RFQ, PO, GRN and payment in one flow.

  • Stock across stores: stock in, issue, bin card and multi-store, in the same system as the indent.
  • Low stock: reorder and AI stock alerts are part of inventory.

One honest limit: TranZact does not raise the PO on its own. Your purchase person reviews the list and raises the PO.

WhatPaper or ExcelTranZact
Quantity to indentWorked out by hand from the BOM and stockMRP runs through orders and BOMs
Indent to POSeparate files and follow-up callsMRP report → indent → RFQ → PO → GRN in one flow
ApprovalSignature on paper or a WhatsApp messageApprovals and alerts
AccountsRe-typed into TallyOne-way sync to Tally, no double entry

See the full flow on the purchase management page.

Book a demo →

TranZact indent and purchase facts (as of 18 Nov 2026)

FactDetailSource
MRPRuns through your orders and BOMs, then tells you what to buy and whenPurchase management page
Purchase flowMRP report → indent → RFQ → PO → GRN → payment, with vendor coordinationPurchase management page
Plans"Planning (MRP + Indent)" listed in Grow (₹8,333/month, billed yearly, 4 users) and Scale+ (₹16,666/month, 8 users). Dominate (₹30,000/month, 12 users) includes everything in Scale+. No Free plan.Pricing page
AccountsAccounts stay in Tally, operations run in TranZact; one-way sync. Busy and Zoho Books too.Pricing page (Tally / Busy / Zoho integration)

Worked example: indent for an order of 50 steel trolleys

This continues the material check on our bill of materials format page. A fabrication unit has work order WO-0387 for 50 MS shop-floor trolleys. All codes, quantities, rates and dates are illustrative.

Table 1 (Example): purchase indent IND-0142 for WO-0387

ItemRequiredIn stock + on orderNet qty to buy
MS angle 40×40×5 mm252 m180 m + 072 m
Castor wheel 100 mm200 nos120 nos + 080 nos
Welding rod 3.15 mm16.5 kg5 kg + 011.5 kg
Enamel paint22 litre8 litre + 10 litre4 litre

At illustrative rates, the estimated value is ₹29,410. The Excel example shows the value for each line.

Table 2 (Example): store indent SI-0088 for the same job

ItemQty to issueStock in handIssue no
MS sheet 2 mm351 kg400 kgISS-0204
MS angle 40×40×5 mm180 m180 mISS-0204
Castor wheel 100 mm120 nos120 nosISS-0204
Welding rod 3.15 mm5 kg5 kgISS-0204
Enamel paint8 litre8 litreISS-0204

Why the lines split this way

MS sheet is on the store indent only. The job needs 351 kg and the store holds 400 kg. Nothing needs to be bought.

Paint nets to 4 litres, not 14. The job needs 22 litres: 8 are in stock and 10 are already on an open PO. Skip the on-order column and you buy those 10 litres twice.

Handle pipe and grips are left out to keep the example short.

Indent vs purchase requisition vs purchase order

A purchase indent and a purchase requisition are the same thing. "Indent" is the shop-floor word in India. "Purchase requisition" is the name in most ERP software.

In procurement, the indent is the first formal step. The purchase order is different: it goes to the supplier.

DocumentWho makes it, who sees itBinding?When
IndentStores, production or maintenance; seen only inside the companyNoWhen a need or shortage is found
Purchase requisitionSame as a purchase indent, under its formal nameNoSame as an indent
Purchase orderPurchase team; sent to the supplierYes, once the supplier accepts itAfter the indent is approved and quotes are compared

For the next document, see our purchase order format. When material arrives, it is checked in on a goods received note (GRN).

Common indent mistakes

  • Ignoring material on order. Open POs are not netted off, so the same item gets bought twice.
  • No work order. When material is late, nobody knows which job is held up.
  • Vague descriptions. "Angle, 20 m" has no size or grade. Use the item code from the BOM.
  • One need split across many indents. Small indents slip under the approval limit and hide the real spend.
  • Late indents, left pending. Review approved indents with no PO every week.

Types of indent, indent books and pending indents

Types of indent: store and purchase are the two main types. Some manufacturers also mark urgent indents, or keep a capital indent for machines and tools.

Indent book: a bound book of numbered indent slips, usually in duplicate. The fields match this sheet.

Pending indent: approved but not yet issued or turned into a PO. Filter the Status/PO no column for "Approved" to see them. In the Excel example, the castor line is pending.

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

Book a demo →

Frequently asked questions

Can I use this indent format in Google Sheets?

Yes. The file is a normal .xlsx, so it opens in Excel and Google Sheets with the formulas working.

Is an indent the same as a purchase requisition?

Yes. 'Indent' is the shop-floor word in India and 'purchase requisition' is the formal name in ERP software. Both are internal requests that are approved before anything is bought.

Do I need GST details on an indent?

No. An indent is an internal request. GST rates and amounts go on the purchase order and the supplier's invoice.

Should one indent cover one job or many?

One work order per indent is easier to trace. If the material is late, you know exactly which order is held up.

Can TranZact work out what to indent from my BOM?

Yes. The MRP engine runs through your orders and BOMs, then tells you what to buy and when. The indent follows from that report and moves on to RFQ, PO and GRN.

Do I have to stop using Tally?

No. Accounting stays in Tally and operations run in TranZact, with a one-way sync and no double entry.

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

Book a demo

Born in India. Building for the world.