Free template · Purchase

Purchase Requisition Format: Free Excel Template + Example

A ready purchase requisition (indent) sheet for Indian factories: a blank format plus a filled example for 50 steel trolleys. Its stock check stops double buying. Free .xlsx, no sign-up.

Download the Excel template

A purchase requisition (many Indian factories call it a purchase indent) is an internal request asking the purchase team to buy material. A good format records the PR number and date, who is asking, item code and description, and unit. It then records quantity needed, stock in hand, quantity already on order and quantity to buy. Last come the required-by date, the reason (work order, reorder or maintenance), estimated rate and the approver. It is never sent to the supplier: once approved, the purchase team turns it into an RFQ or a purchase order.

The free Excel file has a blank sheet and a filled example. It opens in Excel or Google Sheets, with no sign-up.

What is a purchase requisition, and when does a factory raise one?

It is the written request that comes before any buying. It says what is needed, how much, by when and why. The purchase team acts only once it is approved.

The person who feels the shortage prepares it. That is usually the stores in-charge, a production supervisor or the maintenance team. A factory raises one in four common cases:

  • Work-order shortfall: a job needs more material than the store holds.
  • Below reorder level: a regular item drops under its minimum stock.
  • Maintenance and consumables: spares, welding wire, grinding discs, oils.
  • New job or sample: material for a trial or a new customer order.

Purchase requisition vs purchase order

The requisition asks for permission inside the company. The purchase order commits money to a supplier.

PointPurchase requisitionPurchase order
Who sees itInternal onlySent to the supplier
PurposeAsks permission to buyCommits money to a supplier
Price and termsEstimated rate, no GST or termsAgreed rate, GST, delivery and payment terms
Raised byStores, production or maintenancePurchase team
Binding?No, it stays inside the companyYes, once the supplier accepts it

So a requisition is not legally binding outside your company. The binding step is the PO. Our purchase order format picks up where this sheet ends.

What each column in the purchase requisition format means

Header block

PR number (one running series per financial year), PR date, requested by (name and team) and the receiving store or plant.

Line-item columns

ColumnWhat it meansExample
CodeYour internal code for the itemRM-MS-0125
Item specExact grade, size and standardMS square tube 25×25×2 mm, IS 4923
UnitThe unit you buy and store inm, kg, nos, sheet
Qty neededTotal quantity the job or reorder needs300
In stockUsable quantity in the store today80
On orderQuantity on open POs, not yet received100
To buyQty needed minus in stock minus on order120
Need byDate the material must be in the store25-Nov-2026
ReasonWork order, reorder or maintenanceWO/2026-27/0318
Rate (₹)Estimated last purchase rate, before GST95
Value (₹)To buy × rate11,400
PO no.RFQ or PO number, filled by purchasePO/2026-27/0611

Approval and purchase-use block

At the bottom, keep space for the approver's name, signature and date. The buyer fills the PO no. column, so every request can be traced.

[[IMAGE {"type":"steps","title":"From shortage to purchase order","items":["Store spots a shortage","PR raised with a stock check","Approver signs within the value band","Purchase sends the RFQ or PO","PO number written back on the PR"]}]]

Where TranZact fills the requisition for you

In Excel, someone checks the BOM, the store and open POs by hand for every line. That check is where double buying starts.

TranZact AI is manufacturing AI software used by 10,000+ manufacturers. The MRP engine runs through your orders and BOMs, then tells you what to buy and when. In TranZact, the requisition is called an indent. The purchase flow runs MRP report → indent → RFQ → PO → GRN → payment. See the purchase management page for the full flow.

TranZact purchase planning facts (as of 18 Nov 2026)

FeatureWhat it does for the requisitionPlan
Planning (MRP + indent)Tells you what to buy and when, from orders and BOMsGrow and up
Approvals and alertsAn approval step and alerts for your teamGrow and up
Stock trackingStock in hand for the checkGrow and up
Tally / Busy / Zoho integrationAccounting stays in Tally, one-way sync, no double entryGrow and up
Custom document formatsYour own print layout for the indent or PODominate

One honest limit: your own indent or PO print layout needs the Dominate plan. TranZact also works with Excel / Google Sheets and goes live in 2–3 weeks. Plan prices are on the pricing page.

Book a demo →

How to fill a purchase requisition, step by step

  1. Take the next PR number in this year's series.
  2. Fill the header: date, your name and team, and the receiving store.
  3. List each item with its code and exact spec.
  4. Enter qty needed, stock in hand and qty already on order.
  5. Work out qty to buy. If stock covers the need, write 0.
  6. Add the need-by date and the reason for each line.
  7. Send it to the approver. Purchase writes the RFQ or PO number back.

For work-order buys, qty needed comes from the BOM. Our bill of materials format and work order format show where that number starts.

Worked example: material for 50 steel trolleys

A fabrication unit gets work order WO/2026-27/0318 for 50 steel trolleys. The stores in-charge raises PR/2026-27/0142. All numbers below are illustrative, not real prices or norms.

Table 1 (Example): the filled purchase requisition

ItemTo buyRate (₹)Value (₹)
MS square tube 25×25×2 mm120 m9511,400
MS sheet 2 mm, 1250×250010 sheets3,50035,000
Castor wheel 100 mm PU, swivel100 nos18018,000
Hex bolt M8×20 with nut040
MIG wire 0.8 mm, 15 kg spool2 spools2,4004,800
Powder coat, RAL 5015 blue15 kg3505,250
Grinding disc 100 mm40 nos301,200
Total75,650

Table 2 (Example): working out qty to buy

ItemQty neededIn stock + on orderTo buy
Square tube (6 m per trolley)300 m80 + 100120 m
MS sheet (¼ sheet per trolley)13 sheets3 + 010 sheets
Castor wheels (4 per trolley)200 nos60 + 40100 nos
M8 bolts (16 per trolley)800 nos1,200 + 00
Grinding discs (reorder)50 nos10 + 040 nos

The sheet need is 12.5, so it is rounded up to 13 full sheets. The bolt line shows why the stock check matters. The store already holds 1,200 bolts, so nothing is bought.

The 100 m of tube already on order also counts. Skipping that column would have pushed the buy to 220 m.

Who approves a purchase requisition?

The head of the requesting team usually approves routine buys. Above a value limit you set, the plant head or owner approves. Keep one firm rule: no PO goes out without an approved PR.

Common purchase requisition mistakes

  • Vague descriptions. "MS pipe" gets the wrong size. Write the code, grade, size and standard.
  • No stock check. Stock in the store gets bought again. Fill in stock on every line.
  • Ignoring open POs. Material already ordered gets ordered twice. Always fill on order.
  • No reason or reference. Nobody knows why it was bought. Link each line to a work order or reorder.
  • "Urgent" instead of a date. When everything is urgent, nothing is. Give a real need-by date.
  • Approval on WhatsApp or by phone. There is no record later. Get the approver's name and date on the PR.
  • Broken numbering. Skipped numbers hide missing requests. Run one series per financial year.
  • No PO number written back. The request looks open forever. Purchase fills the PO no. column.

After the PO, material arrives against a goods received note. Our GRN format completes the chain. More formats are on the templates page.

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

See how TranZact takes your orders and BOMs to an approved indent and a PO, on a call with our team.

Book a demo →

Frequently asked questions

Is a purchase requisition the same as a purchase indent?

Yes. Most Indian factories say 'indent' for the same internal request to buy material. The format and the approval step are the same.

Should a purchase requisition include GST?

Keep the estimate before GST. Tax rate, GSTIN and final price go on the purchase order once the vendor and rate are fixed. Adding the HSN code early saves the purchase team time.

Can one requisition cover many items?

Yes. One PR can list every item needed for a job or a week, line by line. Give each line its own required-by date and reference.

How should I number purchase requisitions?

Use one running series per financial year, e.g. PR/2026-27/0142. Never reuse or skip numbers, so missing PRs are easy to spot.

Does this Excel format work without accounting software?

Yes. It is a plain .xlsx that opens in Excel or Google Sheets and needs no other software. Your accounts software records the purchase later, when the bill arrives.

When should a factory move requisitions out of Excel?

When requests come from many people, items get bought twice, or nobody can see stock and open POs before approving. Software that works out what to buy from orders, BOMs and stock removes that manual check.

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

Book a demo

Born in India. Building for the world.