What is a sales return format?
A sales return happens when a customer sends back goods you sold. The reason may be a wrong size, a defect or damage in transit.
A credit note is the document you issue for it. It reduces what the customer owes you and the GST you owe. Under GST, the credit note is how a sales return gets recorded.
A sales return book lists every credit note in date order. It is also called the return inwards book or sales return day book. Textbook versions show only date, particulars, credit note number, L.F. and amount.
A manufacturer needs more than that: GSTIN, HSN, the original invoice and the GST split. This template is that register.
What a GST credit note must contain
This is the correct format for a sales return invoice under GST. Rule 53(1A) asks for these details:
- Your name, address and GSTIN.
- The document type, written as "Credit Note".
- A serial number of up to 16 characters, unique for the financial year.
- The date of issue.
- The customer's name, address and GSTIN. For an unregistered customer: name and address, delivery address, and state name and code.
- The serial number and date of each original tax invoice.
- The taxable value, GST rate and GST amount credited to the customer.
- Your signature or digital signature, or that of someone you authorise.
If e-invoicing applies to you, the credit note needs an IRN too, just like an invoice. Our guide to e-invoice under GST explains who it applies to.
Every column in the template, explained
This is the credit note format in Excel. Use one row per returned item. A credit note with three items takes three rows with the same credit note number.
| Column | What to write | Where you get it |
|---|---|---|
| CN No. and Date | Your next credit note number, e.g. CN/26-27/014, and today's date | Your credit note series |
| Customer Name and GSTIN | Legal name and 15-character GSTIN; GSTIN blank if unregistered | Original invoice |
| Original Invoice No. and Date | The invoice the goods were billed on | Original invoice |
| Item (HSN) | Item name and HSN code, as invoiced | Original invoice |
| Qty Returned | The quantity actually received back | Stores, after counting |
| Rate | Rate per unit, as invoiced | Original invoice |
| Taxable Value | Qty returned × rate | Calculate |
| GST % | The same rate as the invoice | Original invoice |
| CGST + SGST | Half the GST each, if the place of supply is your state | Calculate |
| IGST | The full GST, if the place of supply is another state | Calculate |
| Total Credit | Taxable value + GST | Calculate |
| Reason, Condition, ITC | Why it came back; restock, rework or scrap; ITC reversed Y, N or Pending | Customer, inspection and stores |
How to record a sales return, step by step
- Receive the goods. Stores count what arrived and note the customer's challan or return note number.
- Check against the invoice. Match item, quantity and rate to the original invoice. Note any shortfall.
- Inspect and decide. Mark each line restock, rework or scrap. Only restocked goods go back into finished-goods stock.
- Raise the credit note. Use the same GST rate and tax type (CGST + SGST, or IGST) as the invoice.
- Enter it in the register. Add one row per item, and get the customer's confirmation that they reversed ITC.
- Pass the accounting entry. Book it in Tally or your accounting software, and show it in GSTR-1.
The receiving check in steps 1 and 2 works like a goods receipt note (GRN), only from a customer.
Worked example: 3 returns in November 2026
Say you make engineering parts in Pune, Maharashtra. Three customers send goods back this month. All names and numbers are illustrative.
| Credit note and goods | Place of supply | Taxable value | GST credited |
|---|---|---|---|
| CN/26-27/014: Customer A, 20 MS flanges × ₹450 | Maharashtra (same state) | ₹9,000 | CGST ₹810 + SGST ₹810 |
| CN/26-27/015: Customer B, 8 MS brackets × ₹1,250 | Gujarat (other state) | ₹10,000 | IGST ₹1,800 |
| CN/26-27/016: Customer C, 5 transmission shafts × ₹600 | Maharashtra (same state) | ₹3,000 | CGST ₹270 + SGST ₹270 |
| Total | ₹22,000 | ₹3,960 |
The total credit is ₹25,960. The flanges pass inspection and go back to stock. The brackets go for rework, and the shafts are scrapped.
Customer C hasn't confirmed the ITC reversal yet. So you can't cut your output GST for CN/26-27/016 until they do.
[[IMAGE {"type":"checklist","title":"Before you approve a credit note","items":["Original invoice number and date quoted","Same GST rate and tax type","Goods inspected: restock, rework or scrap","Customer has reversed ITC","Declared by the Section 34 deadline"]}]]
Where TranZact fills this for you
The hard part of this register isn't the maths. It's re-typing the invoice number, date, items, rates and GST from a printout.
In TranZact, the enquiry, quotation, order, dispatch and e-invoice run in one place. So the invoice details this register needs already sit there. See the sales module.
TranZact generates the e-way bill from the GST invoice, with the e-invoice (IRN) in the same flow. That's on all plans.
For stores, TranZact's inventory features include stock in, bin card, multi-store and AI stock alerts. Accounting stays in Tally, operations run in TranZact, and a one-way sync means no double entry.
Read how the TranZact–Tally integration works. Busy, Zoho Books and Excel / Google Sheets connect too.
10,000+ manufacturers use TranZact, and it goes live in 2–3 weeks. Want to see your own order, dispatch and invoice flow in it? Bring a recent return to the demo.
Sales return journal entry
For row 1 (Customer A, same state), the entry looks like this:
| Account | Debit (₹) | Credit (₹) |
|---|---|---|
| Sales Returns A/c | 9,000 | |
| Output CGST A/c | 810 | |
| Output SGST A/c | 810 | |
| To Customer A A/c | 10,620 |
For an interstate return like Customer B, debit Output IGST instead of CGST and SGST. Separately, the restocked flanges go back into the stock register.
Common mistakes
- No original invoice reference. Without the invoice number and date, the credit note misses a Rule 53(1A) detail. Your customer can't match it either.
- Wrong tax type. Follow the invoice. If you charged IGST, reverse IGST, not CGST and SGST.
- A different GST rate. Use the rate on the original invoice.
- Broken numbering. Keep one credit note series per financial year, up to 16 characters. Don't reuse invoice numbers.
- Restocking without inspection. Defective goods counted as stock make system stock and physical stock drift apart.
- Missing the deadline. After the Section 34 cut-off, a credit note can't reduce your GST.
- Ignoring the customer's ITC. Since 1 October 2025, the customer must reverse their ITC before you reduce your output tax.
GST rules and deadlines for credit notes
When you can issue one. Section 34 allows a credit note when goods are returned or found deficient. It also covers an invoice that overstated the value or tax.
The deadline. Declare it by 30 November after the end of the financial year of supply. If you file your annual return earlier, that date is the cut-off.
For a supply made in FY 2026-27, that means 30 November 2027, or your annual return date if earlier.
The customer must reverse ITC. From 1 October 2025, you can reduce your output tax only if the customer has reversed the ITC on that credit note. This applies where they had claimed it.
Unsure about a case? Check with your CA. For goods you send back to a supplier, see our purchase return guide.
Start with the Excel, then stop re-typing
Download the format and use it for this month's returns. If the same invoice data gets typed in three places, talk to us. Need another format? Get the free bill of materials format.
Don't be the bottleneck. Become the AI-Run Factory.