Free Excel template · GST credit note

Sales Return Format (Excel): Free GST Template & Example

A sales return format records goods a customer sends back and the credit note you issue for them. It needs the credit note number and date, customer name and GSTIN, and original invoice number and date. List items, quantity, rate, taxable value and GST reversed (CGST + SGST or IGST). Declare the credit note by 30 November after the end of the financial year, or the annual return date if earlier.

Download the Excel template

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.

ColumnWhat to writeWhere you get it
CN No. and DateYour next credit note number, e.g. CN/26-27/014, and today's dateYour credit note series
Customer Name and GSTINLegal name and 15-character GSTIN; GSTIN blank if unregisteredOriginal invoice
Original Invoice No. and DateThe invoice the goods were billed onOriginal invoice
Item (HSN)Item name and HSN code, as invoicedOriginal invoice
Qty ReturnedThe quantity actually received backStores, after counting
RateRate per unit, as invoicedOriginal invoice
Taxable ValueQty returned × rateCalculate
GST %The same rate as the invoiceOriginal invoice
CGST + SGSTHalf the GST each, if the place of supply is your stateCalculate
IGSTThe full GST, if the place of supply is another stateCalculate
Total CreditTaxable value + GSTCalculate
Reason, Condition, ITCWhy it came back; restock, rework or scrap; ITC reversed Y, N or PendingCustomer, inspection and stores

How to record a sales return, step by step

  1. Receive the goods. Stores count what arrived and note the customer's challan or return note number.
  2. Check against the invoice. Match item, quantity and rate to the original invoice. Note any shortfall.
  3. Inspect and decide. Mark each line restock, rework or scrap. Only restocked goods go back into finished-goods stock.
  4. Raise the credit note. Use the same GST rate and tax type (CGST + SGST, or IGST) as the invoice.
  5. Enter it in the register. Add one row per item, and get the customer's confirmation that they reversed ITC.
  6. 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 goodsPlace of supplyTaxable valueGST credited
CN/26-27/014: Customer A, 20 MS flanges × ₹450Maharashtra (same state)₹9,000CGST ₹810 + SGST ₹810
CN/26-27/015: Customer B, 8 MS brackets × ₹1,250Gujarat (other state)₹10,000IGST ₹1,800
CN/26-27/016: Customer C, 5 transmission shafts × ₹600Maharashtra (same state)₹3,000CGST ₹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.

Book a demo →

Sales return journal entry

For row 1 (Customer A, same state), the entry looks like this:

AccountDebit (₹)Credit (₹)
Sales Returns A/c9,000
Output CGST A/c810
Output SGST A/c810
To Customer A A/c10,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

  1. 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.
  2. Wrong tax type. Follow the invoice. If you charged IGST, reverse IGST, not CGST and SGST.
  3. A different GST rate. Use the rate on the original invoice.
  4. Broken numbering. Keep one credit note series per financial year, up to 16 characters. Don't reuse invoice numbers.
  5. Restocking without inspection. Defective goods counted as stock make system stock and physical stock drift apart.
  6. Missing the deadline. After the Section 34 cut-off, a credit note can't reduce your GST.
  7. 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.

Book a demo →

Frequently asked questions

Is a sales return the same as a credit note?

No. The sales return is the goods coming back. The credit note is the document that reduces what the customer owes. Every GST sales return needs a credit note, but a credit note can also be for a rate difference with no goods returned.

Can I issue one credit note for several invoices?

Yes. Section 34 allows one or more credit notes for supplies made in a financial year. Rule 53(1A) asks for the serial numbers and dates of the corresponding invoices, so list every invoice it covers.

What if the customer returns goods after 30 November of the next year?

You can't reduce your GST through a credit note after the Section 34 deadline. That is 30 November after the FY of supply, or the annual return date if earlier. Ask your CA how to treat it.

Should returned goods go back into finished-goods stock?

Only if they pass inspection. Record the condition (restock, rework or scrap) on each line so your stock register matches what is actually usable.

Is this Excel enough for a growing factory?

It works for a few returns a month. When returns, rework and re-dispatch start crossing between sales, stores and accounts, people re-type the same invoice data in three places. That's where software that holds the order, dispatch and invoice in one place helps.

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

Book a demo

Born in India. Building for the world.