Free template · Purchase

Purchase Return Format: Free Excel Template with Example

A ready purchase return format in Excel for Indian manufacturers. It carries the invoice, PO and GRN references, GRN vs returned quantity, a reason per line and the right GST split. Download the blank sheet and a filled example. No sign-up.

Download the Excel template

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

FieldWhat to enterWhy it matters
Return no. and dateYour running number and the date goods leaveThe supplier quotes it on the credit note
Supplier name, address, GSTINExactly as on the original invoiceA wrong GSTIN breaks the match
Your company name and GSTINYour registered details for that factoryShows which registration it belongs to
Original invoice no. and dateThe invoice the goods came onThe credit note must point to it
PO no.Your purchase order for the goodsLinks the return to what you ordered
GRN no. and dateThe GRN that took the goods into stockProves how many were accepted
Place of supplyState name and code from the invoiceDecides IGST or CGST + SGST
Transport and e-way bill no.Vehicle, transporter, e-way bill if neededLets the goods move back legally

Item lines

ColumnWhat to enterWhy it matters
Item description (unit)Item name and unit (kg, nos, m), as on the invoiceBoth sides find the same item fast
HSNThe HSN code from the invoiceThe credit note uses the same HSN
Qty received (GRN)The quantity accepted on the GRNStops you returning more than you got
Qty returnedOnly what is going backDrives the value, tax and stock entry
Rate (₹)The original invoice rateToday's price won't match the credit note
Taxable value (₹)Qty returned × rateThe base for GST
GST %, CGST, SGST, IGSTThe invoice GST rate and splitA different split causes a mismatch
Line total (₹)Taxable value + GSTWhat the supplier owes back for the line
Reason codeOne code per lineSettles 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

  1. Pull the papers: supplier invoice, PO and GRN.
  2. Fill the header: supplier and GSTIN exactly as on the invoice, plus the invoice, PO and GRN numbers.
  3. List only the returned lines, with the GRN quantity beside each.
  4. Use the invoice rate and GST rate, split the same way as the invoice.
  5. Pick a reason code for each line.
  6. Check the totals: qty × rate equals taxable value, and the GST adds up.
  7. 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

FieldExample
Return no. and datePR/26-27/014, 09-Nov-2026
Supplier and GSTINExample Steel Traders, 27ABCDE1234F1Z5
Original invoiceINV-2210, 12-Oct-2026
PO no.PO/26-27/0318
GRN no. and dateGRN/26-27/0452, 14-Oct-2026
Place of supplyMaharashtra (27), so CGST + SGST

Table 2 (Example): returned lines and GST

Item (HSN)Qty returned × rateTaxable valueCGST 9% + SGST 9%
MS round bar 25 mm (7214), R2150 kg × ₹62.00₹9,300.00₹837.00 + ₹837.00
Ball bearing 6205 (8482), R140 nos × ₹145.00₹5,800.00₹522.00 + ₹522.00
Total2 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.SupplierValue (₹)Credit note status
PR/26-27/014Example Steel Traders17,818.00Pending. Chase well before 30-Nov-2027.

Book a demo →

Purchase return vs debit note vs credit note

DocumentWho issues itWhat it doesChanges GST?
Purchase return formatBuyerLists what goes back and whyNo, it is your internal and supplier record
Debit note (for a return)BuyerRecords the amount the supplier owes you in your booksNo, it is a commercial document
GST credit noteSupplierReduces the original invoice value and taxYes, 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

  1. Using today's rate, not the invoice rate.
  2. Charging IGST when the invoice had CGST + SGST, or the reverse.
  3. Missing the invoice or GRN number, so the supplier cannot match it.
  4. Returning more than the GRN accepted, or mixing two invoices on one line.
  5. No reason code on the line.
  6. Not reducing stock, so system stock and physical stock drift apart.
  7. 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.

FactDetailSource
Purchase flowMRP report → indent → RFQ → PO → GRN → payment, with vendor coordinationletstranzact.ai/solutions, as of 18-Nov-2026
InventoryStock in, issue, bin card and multi-storeletstranzact.ai/solutions, as of 18-Nov-2026
QualityQuality control (raw material and finished goods) and Batch Tracking & QC are on the Dominate planletstranzact.ai/pricing, as of 18-Nov-2026
AccountingAccounting stays in Tally, with one-way sync and no double entry. Also syncs with Busy and Zoho Books, and works with Excel / Google SheetsTranZact
Go-liveLive in 2–3 weeks. Used by 10,000+ manufacturersTranZact

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.

Book a demo →

Frequently asked questions

Is there a government-prescribed Excel format for a purchase return?

No. The CGST Act says a credit or debit note must contain 'such particulars as may be prescribed', but it sets no Excel layout. Use a format that carries the invoice, GRN, GSTIN, item, quantity, rate and tax details.

Can I return only part of an invoice?

Yes. Put only the returned quantity on the format. The debit note, the supplier's credit note and the stock reversal should all show that same quantity and value.

Which rate should I use on the purchase return?

Use the rate and GST rate from the original invoice, not today's price, so the supplier's credit note matches.

Does a purchase return reduce my stock?

Yes. Remove the returned quantity from your stock records when the goods leave, or your books will show material you no longer have.

Who should sign the purchase return?

Stores prepares it, QC or purchase checks the reason, and an authorised person approves it. Ask the supplier to acknowledge it on receipt.

Does TranZact replace Tally for purchase returns?

No. Accounting stays in Tally. TranZact runs the purchase flow (indent, PO, GRN, payment) and syncs to Tally one way, with no double entry.

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

Book a demo

Born in India. Building for the world.