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.
| Point | Purchase requisition | Purchase order |
|---|---|---|
| Who sees it | Internal only | Sent to the supplier |
| Purpose | Asks permission to buy | Commits money to a supplier |
| Price and terms | Estimated rate, no GST or terms | Agreed rate, GST, delivery and payment terms |
| Raised by | Stores, production or maintenance | Purchase team |
| Binding? | No, it stays inside the company | Yes, 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
| Column | What it means | Example |
|---|---|---|
| Code | Your internal code for the item | RM-MS-0125 |
| Item spec | Exact grade, size and standard | MS square tube 25×25×2 mm, IS 4923 |
| Unit | The unit you buy and store in | m, kg, nos, sheet |
| Qty needed | Total quantity the job or reorder needs | 300 |
| In stock | Usable quantity in the store today | 80 |
| On order | Quantity on open POs, not yet received | 100 |
| To buy | Qty needed minus in stock minus on order | 120 |
| Need by | Date the material must be in the store | 25-Nov-2026 |
| Reason | Work order, reorder or maintenance | WO/2026-27/0318 |
| Rate (₹) | Estimated last purchase rate, before GST | 95 |
| Value (₹) | To buy × rate | 11,400 |
| PO no. | RFQ or PO number, filled by purchase | PO/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)
| Feature | What it does for the requisition | Plan |
|---|---|---|
| Planning (MRP + indent) | Tells you what to buy and when, from orders and BOMs | Grow and up |
| Approvals and alerts | An approval step and alerts for your team | Grow and up |
| Stock tracking | Stock in hand for the check | Grow and up |
| Tally / Busy / Zoho integration | Accounting stays in Tally, one-way sync, no double entry | Grow and up |
| Custom document formats | Your own print layout for the indent or PO | Dominate |
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.
How to fill a purchase requisition, step by step
- Take the next PR number in this year's series.
- Fill the header: date, your name and team, and the receiving store.
- List each item with its code and exact spec.
- Enter qty needed, stock in hand and qty already on order.
- Work out qty to buy. If stock covers the need, write 0.
- Add the need-by date and the reason for each line.
- 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
| Item | To buy | Rate (₹) | Value (₹) |
|---|---|---|---|
| MS square tube 25×25×2 mm | 120 m | 95 | 11,400 |
| MS sheet 2 mm, 1250×2500 | 10 sheets | 3,500 | 35,000 |
| Castor wheel 100 mm PU, swivel | 100 nos | 180 | 18,000 |
| Hex bolt M8×20 with nut | 0 | 4 | 0 |
| MIG wire 0.8 mm, 15 kg spool | 2 spools | 2,400 | 4,800 |
| Powder coat, RAL 5015 blue | 15 kg | 350 | 5,250 |
| Grinding disc 100 mm | 40 nos | 30 | 1,200 |
| Total | 75,650 |
Table 2 (Example): working out qty to buy
| Item | Qty needed | In stock + on order | To buy |
|---|---|---|---|
| Square tube (6 m per trolley) | 300 m | 80 + 100 | 120 m |
| MS sheet (¼ sheet per trolley) | 13 sheets | 3 + 0 | 10 sheets |
| Castor wheels (4 per trolley) | 200 nos | 60 + 40 | 100 nos |
| M8 bolts (16 per trolley) | 800 nos | 1,200 + 0 | 0 |
| Grinding discs (reorder) | 50 nos | 10 + 0 | 40 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.