What is a purchase return format?
A purchase return format is the document a buyer fills in when sending goods back to a supplier after they were accepted into stock. It lists the supplier and GSTIN, plus the original invoice, PO and GRN numbers. It also shows each returned item with quantity, rate and GST, and the reason for the return. The buyer usually records it as a debit note against the original invoice. The supplier then issues a GST credit note for the same quantity and value.
Use it when material has already passed the GRN and entered stock. If you refuse material at the gate, that is a rejection at GRN, not a purchase return. Our purchase return guide explains the full process and both cases.
Download the free purchase return format (Excel)
The download has two sheets: a blank format and the filled example from this page, with the GST worked out. To chase credit notes, copy the tracker row from the example below into a third tab.
What each column in the purchase return format means
Header fields
| Field | What to enter | Why it matters |
|---|---|---|
| Return no. and date | Your running number and the date goods leave | The supplier quotes it on the credit note |
| Supplier name, address, GSTIN | Exactly as on the original invoice | A wrong GSTIN breaks the match |
| Your company name and GSTIN | Your registered details for that factory | Shows which registration it belongs to |
| Original invoice no. and date | The invoice the goods came on | The credit note must point to it |
| PO no. | Your purchase order for the goods | Links the return to what you ordered |
| GRN no. and date | The GRN that took the goods into stock | Proves how many were accepted |
| Place of supply | State name and code from the invoice | Decides IGST or CGST + SGST |
| Transport and e-way bill no. | Vehicle, transporter, e-way bill if needed | Lets the goods move back legally |
Item lines
| Column | What to enter | Why it matters |
|---|---|---|
| Item description (unit) | Item name and unit (kg, nos, m), as on the invoice | Both sides find the same item fast |
| HSN | The HSN code from the invoice | The credit note uses the same HSN |
| Qty received (GRN) | The quantity accepted on the GRN | Stops you returning more than you got |
| Qty returned | Only what is going back | Drives the value, tax and stock entry |
| Rate (₹) | The original invoice rate | Today's price won't match the credit note |
| Taxable value (₹) | Qty returned × rate | The base for GST |
| GST %, CGST, SGST, IGST | The invoice GST rate and split | A different split causes a mismatch |
| Line total (₹) | Taxable value + GST | What the supplier owes back for the line |
| Reason code | One code per line | Settles disputes and shows repeat problems |
The sheet uses five reason codes:
- R1: defect found after acceptance
- R2: wrong item, size or grade
- R3: excess over PO quantity
- R4: order cancelled with the supplier's agreement
- R5: other (write it in remarks)
Footer and sign-off
Add totals for taxable value, each tax and the grand total, with the amount in words. Add remarks such as test report numbers. Leave space for three sign-offs and the supplier's acknowledgement (see the FAQ).
How to fill a purchase return format, step by step
- Pull the papers: supplier invoice, PO and GRN.
- Fill the header: supplier and GSTIN exactly as on the invoice, plus the invoice, PO and GRN numbers.
- List only the returned lines, with the GRN quantity beside each.
- Use the invoice rate and GST rate, split the same way as the invoice.
- Pick a reason code for each line.
- Check the totals: qty × rate equals taxable value, and the GST adds up.
- Sign, send and log: send a copy with the goods and track it until the credit note arrives.
Once it is approved, record it as a debit note against the original invoice. Reduce stock by the returned quantity when the goods leave.
Worked example: returning steel bars and bearings to a supplier
An auto-parts maker in Maharashtra returns material to a supplier in the same state. Some bars were the wrong grade, and some bearings failed at assembly. All names and numbers below are illustrative.
Table 1 (Example): header
| Field | Example |
|---|---|
| Return no. and date | PR/26-27/014, 09-Nov-2026 |
| Supplier and GSTIN | Example Steel Traders, 27ABCDE1234F1Z5 |
| Original invoice | INV-2210, 12-Oct-2026 |
| PO no. | PO/26-27/0318 |
| GRN no. and date | GRN/26-27/0452, 14-Oct-2026 |
| Place of supply | Maharashtra (27), so CGST + SGST |
Table 2 (Example): returned lines and GST
| Item (HSN) | Qty returned × rate | Taxable value | CGST 9% + SGST 9% |
|---|---|---|---|
| MS round bar 25 mm (7214), R2 | 150 kg × ₹62.00 | ₹9,300.00 | ₹837.00 + ₹837.00 |
| Ball bearing 6205 (8482), R1 | 40 nos × ₹145.00 | ₹5,800.00 | ₹522.00 + ₹522.00 |
| Total | 2 lines | ₹15,100.00 | ₹1,359.00 + ₹1,359.00 |
Return value = ₹15,100.00 + ₹2,718.00 GST = ₹17,818.00. The GRN showed 2,000 kg of bars and 500 bearings, so both returns stay within what was received.
Table 3 (Example): tracker row
| Return no. | Supplier | Value (₹) | Credit note status |
|---|---|---|---|
| PR/26-27/014 | Example Steel Traders | 17,818.00 | Pending. Chase well before 30-Nov-2027. |
Purchase return vs debit note vs credit note
| Document | Who issues it | What it does | Changes GST? |
|---|---|---|---|
| Purchase return format | Buyer | Lists what goes back and why | No, it is your internal and supplier record |
| Debit note (for a return) | Buyer | Records the amount the supplier owes you in your books | No, it is a commercial document |
| GST credit note | Supplier | Reduces the original invoice value and tax | Yes, under Section 34 of the CGST Act |
See our debit note format and credit note format for both documents.
[[IMAGE {"type":"steps","title":"How a purchase return moves, start to finish","items":["Goods go back with the return format","Buyer books a debit note","Supplier issues a GST credit note","Credit note shows in your GSTR-2B","Buyer reduces ITC and closes the tracker"]}]]
GST points to check on a purchase return
- Credit note deadline. Under Section 34, the supplier must declare the credit note by 30 November after the year of supply. If the annual return is filed earlier, that date applies.
- Same tax split. Match the invoice: CGST + SGST, or IGST.
- Input tax credit. When the supplier's credit note shows in your GSTR-2B, reduce your input tax credit by its GST.
- E-way bill. Goods going back need an e-way bill when the value crosses the limit (₹50,000 in most cases). A delivery challan can be the base document.
Common purchase return mistakes
- Using today's rate, not the invoice rate.
- Charging IGST when the invoice had CGST + SGST, or the reverse.
- Missing the invoice or GRN number, so the supplier cannot match it.
- Returning more than the GRN accepted, or mixing two invoices on one line.
- No reason code on the line.
- Not reducing stock, so system stock and physical stock drift apart.
- Not chasing the credit note before the Section 34 deadline.
Before the return, check the original purchase invoice format and goods received note format. Most mistakes start with a wrong reference there.
Where TranZact already holds this data
Most of this sheet is copying. The supplier, PO and GRN details already sit in your purchase records. When those records live in WhatsApp and Excel, someone retypes them, and errors creep in.
TranZact's manufacturing AI software runs the purchase flow in one place. Supplier, PO and GRN details are recorded as part of that flow. See how it works on our purchase management page.
| Fact | Detail | Source |
|---|---|---|
| Purchase flow | MRP report → indent → RFQ → PO → GRN → payment, with vendor coordination | letstranzact.ai/solutions, as of 18-Nov-2026 |
| Inventory | Stock in, issue, bin card and multi-store | letstranzact.ai/solutions, as of 18-Nov-2026 |
| Quality | Quality control (raw material and finished goods) and Batch Tracking & QC are on the Dominate plan | letstranzact.ai/pricing, as of 18-Nov-2026 |
| Accounting | Accounting stays in Tally, with one-way sync and no double entry. Also syncs with Busy and Zoho Books, and works with Excel / Google Sheets | TranZact |
| Go-live | Live in 2–3 weeks. Used by 10,000+ manufacturers | TranZact |
TranZact does not replace Tally. Ask on a demo how purchase returns are handled for your setup.
Don't be the bottleneck. Become the AI-Run Factory.
Use the free format for your next return. If your team retypes the same supplier, PO and GRN details every time, let us show you the purchase flow.