Free template · GST credit note

Credit Note Format: Free Excel Template & GST Example

Download a free GST credit note format in Excel: a blank layout and a filled example with CGST and SGST worked out. Every Rule 53(1A) field is explained below, with the deadline and the mistakes to avoid.

Download the Excel template

A credit note is the document a GST-registered seller issues to reduce what a buyer owes on an invoice already raised. Under Rule 53(1A) of the CGST Rules, it must show the supplier's name, address and GSTIN, and the words 'Credit Note'. It needs a serial number of up to 16 characters, unique for the financial year, and the issue date. It must also show the buyer's name, address and GSTIN, and the original invoice number and date. Add the taxable value, tax rate and tax being credited, and sign it. Declare it in your GST return by 30 November after the end of the original invoice's financial year. If you file the annual return before that, its filing date is the limit.

What is a credit note?

When the seller issues one, the buyer's input tax credit goes down by the same tax.

Credit noteDebit note
Who issues itThe supplierThe supplier
Effect on amount owedGoes downGoes up
Typical reasonReturn, rejection, overbilling, discountRate or quantity billed too low
Where it goes in GSTR-1Table 9BTable 9B

When you must issue a credit note under GST

Section 34(1) lets the supplier issue one in three cases:

  • The taxable value or tax charged is more than it should be.
  • The buyer returns the goods.
  • The goods or services supplied are found deficient.

From 1 November 2026, a post-sale discount can also cut taxable value through a credit note (Notification 03/2026-Central Tax). No prior agreement is needed, but the buyer must reverse the matching input tax credit.

In a factory, these cases look like this:

  • Part of a lot is rejected at customer inspection.
  • The invoice rate is above the customer's PO rate.
  • The wrong GST rate was charged on an item.
  • Short supply: 500 pieces billed, 480 delivered.
  • A year-end volume discount goes to a dealer.

Credit note format: every field explained

FieldWhat to writeExample (sample data)Rule 53(1A)
Supplier name, address, GSTINYour registered detailsSample Engineering Works, Pune, 27ABCDE1234F1Z5(a)
Document titleThe words 'Credit Note'Credit Note(b)
Credit note numberOwn series, up to 16 charactersCN/26-27/0007(c)
Date of issueThe day you issue it17-11-2026(d)
Buyer, if registeredName, address and GSTINSample Auto Parts Pvt Ltd, Chakan, 27PQRSX5678K1Z2(e)
Buyer, if unregisteredName, address, delivery address, state name and codeA. Kumar, Nashik, Maharashtra (27)(f)
Original invoice no. and dateEvery invoice this note reducesINV/26-27/0412, 05-11-2026(g)
Taxable value, GST rate, taxValue credited, rate charged, CGST + SGST or IGST₹16,000; 18%; ₹1,440 + ₹1,440(h)
SignatureYours or an authorised person's, by hand or digitalAuthorised signatory(i)
Item, HSN, qty, rateEach line being creditedMS pipe flange 100 mm, 7307, 40 × ₹250Good practice
ReasonReturn, rejection, rate difference, wrong rate, discountRejected at customer inspectionGood practice
Place of supplyThe state on the original invoiceMaharashtra (27)Good practice

The rule fixes the fields, not the layout. Any format works, in Excel or Word, if every field above is on it.

How to fill the credit note format, step by step

Step 1: Pick the next number in your series

Use a separate series, such as CN/26-27/0001, up to 16 characters. Never repeat a number in the same financial year.

Step 2: Link the original invoice

Write the number and date of each invoice the note reduces.

Step 3: Choose the reason

Return, rejection, rate difference, wrong tax rate, short supply or discount. For a discount, get the buyer's written ITC reversal confirmation.

Step 4: Enter qty and rate per line

For a return, enter the pieces and the invoice rate. For a rate difference, enter the billed quantity and the difference per piece.

Step 5: Check CGST + SGST vs IGST

Use the same tax type as the original invoice, as set out below.

[[IMAGE {"type":"compare","title":"CGST + SGST or IGST on a credit note","columns":["Intra-state invoice","Inter-state invoice"],"rows":[["Tax on the note","CGST + SGST","IGST"],["Rate for each tax","Half the GST rate","Full GST rate"],["At 18% GST","9% + 9%","18%"],["Worked example below","Example 1","Example 2"]]}]]

Step 6: Sign and send

Sign by hand or digitally. Send the buyer a copy that quotes the original invoice number.

Step 7: Log it in the register for GSTR-1

Add the note to your credit note register. Your accountant files GSTR-1 from this list.

Where the fields already sit in TranZact

A credit note copies most of its fields from the invoice it reduces. Retyping them from paper or WhatsApp is where errors get in.

In TranZact, they already sit in one place, from the order, the dispatch and the GST e-invoice:

  • Customer name, address and GSTIN
  • Item, HSN, rate and GST rate
  • Original invoice number and date
  • Dispatched quantity

The invoice and its IRN come from the same flow as the e-way bill, on all plans. Your entries reach Tally through the one-way sync, with no double entry. See how the Tally integration works.

TranZact is manufacturing AI software used by 10,000+ manufacturers, and it goes live in 2–3 weeks. Its sales flow covers enquiry, quotation, order timeline, dispatch, e-invoicing and payment.

Book a demo →

Credit note example (filled)

Example 1: rejection + rate difference (intra-state)

Sample Engineering Works, Pune, billed Sample Auto Parts, Chakan, on INV/26-27/0412 dated 5 November 2026. The customer rejected 40 pieces of the 100 mm flange. The 150 mm flange was billed at ₹420 against a PO rate of ₹400. Both are in Maharashtra, so tax is CGST 9% + SGST 9%.

LineQty × rateTaxable value (₹)CGST + SGST (₹)
100 mm flange, rejected40 × ₹25010,000900 + 900
150 mm flange, rate difference300 × ₹206,000540 + 540
Total16,0001,440 + 1,440

Credit note CN/26-27/0007 is for ₹18,880, and the buyer's input tax credit drops by ₹2,880. This is the filled example in the download; all numbers are illustrative.

Example 2: year-end dealer discount (inter-state, IGST)

On 31 March 2027, the same supplier gives a Gujarat dealer a ₹25,000 year-end discount on two invoices. The supply is inter-state, so tax is IGST at 18%.

Original invoiceDiscount, taxable (₹)IGST 18% (₹)Total (₹)
INV/26-27/038815,0002,70017,700
INV/26-27/095110,0001,80011,800
Total25,0004,50029,500

The dealer must reverse ₹4,500 of input tax credit; keep their confirmation.

Credit note format in Excel: what's in the download

The free download has a blank format and a filled copy of Example 1, with every amount worked out.

To do the sums, add three formulas. Taxable value = Qty × Rate. CGST and SGST = Taxable value × GST% ÷ 2 each. IGST = Taxable value × GST%.

For the invoice itself, see our invoice format guide. Building a product structure too? Use the bill of materials format.

Time limit and GST reporting

The deadline

Section 34(2) sets the limit given above. A 5 November 2026 invoice needs its note declared by 30 November 2027, or by the 2026-27 annual return date if sooner.

How to show a credit note in GSTR-1

Credit notes go in Table 9B. Use CDNR for registered buyers, and CDNUR for unregistered buyers on large inter-state (B2CL) or export invoices. Notes against small B2C sales are adjusted in Table 7.

If you issue e-invoices, report credit notes to the IRP too. Our guide to GST e-invoice and IRN compliance covers the flow.

Accounting entry and Tally

For Example 1, the entry is:

AccountDebit (₹)Credit (₹)
Sales returns / Sales16,000
Output CGST1,440
Output SGST1,440
Sample Auto Parts (customer)18,880

In Tally, use the Credit Note voucher type. Pick the customer, the sales and GST ledgers, and refer to the original invoice.

Common credit note mistakes

  1. No invoice reference. Without the invoice number and date, the note is incomplete.
  2. Repeated numbers. Never reuse a credit note number in the same financial year.
  3. Wrong tax type. Mixing up IGST and CGST + SGST won't match the buyer's records.
  4. A different rate. Credit tax at the invoice's rate, unless the rate was the error.
  5. Missing 30 November. A late note can't reduce your GST.
  6. Returns left out of stock. Book them into the store the same day, with rejects kept separately.

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

Book a demo →

Frequently asked questions

Is there a fixed government format for a credit note?

No. GST doesn't prescribe a layout, but the note must carry every particular in Rule 53(1A). Any format, including this Excel, works if those fields are there.

Can one credit note cover several invoices?

Yes. One credit note can cover several invoices to the same customer in a financial year, if you list each invoice number and date.

Is there a time limit to issue a credit note?

Yes. Declare it by 30 November after the original invoice's financial year ends, or by the annual return date if earlier.

Do I need the buyer to reverse ITC?

For a post-sale discount from 1 November 2026, yes. The buyer must reverse the matching input tax credit for the discount to reduce taxable value. Keep their confirmation.

Is a credit note the same as a refund?

No. A credit note lowers what the customer owes. You can adjust it against future invoices or pay it back. The note is the tax document either way.

Should returned goods go back into stock?

Yes. Record the return in your store the same day as the credit note, so stock and accounts agree. Keep rejected pieces in a separate rejection store.

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

Book a demo

Born in India. Building for the world.