Free template · GST

Debit Note Format: Free Excel Template with Example

A GST debit note format for Indian manufacturers, with every Rule 53(1A) field, CGST/SGST and IGST columns, and a filled factory example. Download the Excel free, no sign-up.

Download the Excel template

A debit note format is the layout for a document that raises the amount on an invoice already issued. Under GST, the supplier issues it when the taxable value or tax on the invoice was too low. It must show both parties' details and GSTIN, a unique serial number, the date, and the original invoice number and date. It also shows the taxable value, tax rate, tax amount and a signature. Many buyers also send a debit note to a supplier when they return goods. The supplier then issues a GST credit note.

The free Excel has a blank format and both filled examples below. No sign-up.

What is a debit note?

The word has two meanings. The first is the supplier's GST debit note. Under Section 34(3) of the CGST Act, the supplier issues it when the invoice showed too little value or tax. It raises what the customer owes.

The second is the buyer's debit note, sent to a supplier when goods are returned or rejected. It asks the supplier to cut the bill. The GST change then comes through the supplier's credit note.

So why is a debit note prepared? To correct an invoice upward without cancelling it, or to record a return in writing.

When a manufacturer issues a debit note

  • Price revised upward after invoicing. A price clause raised the rate on parts already billed.
  • Quantity short-billed. You shipped 1,000 pieces but billed 950.
  • GST charged lower than due. The invoice used a lower rate by mistake.
  • Goods rejected at inward check and returned. This is the buyer's debit note.

Is a debit note used for purchase return? Yes, as the buyer's document. The supplier answers with a credit note; see our purchase return guide.

What each column in the debit note format means

Rule 53(1A) of the CGST Rules lists what a GST debit note must contain.

FieldWhat to writeRequired under Rule 53(1A)?
Document title"Debit Note"Yes
Supplier name, address, GSTINAs on your GST registrationYes
Recipient name, address, GSTINAs on the original invoiceYes, if registered
State name and codeRecipient's state and delivery addressYes, if unregistered
Debit note number and dateUp to 16 characters, unique in the financial year; the issue dateYes
Original invoice number and dateEach invoice this note correctsYes
Item, HSN, quantity, rate differenceOnly the difference billedNo
Taxable value, GST rate and amountCGST + SGST or IGST, as on the invoiceYes
Line total and reasonValue plus tax; why the note existsNo
SignatureSupplier or authorised person, or digital signatureYes

A buyer's debit note for a return can use the same fields.

How to fill a debit note, step by step

  1. Pick the original invoice. Note its number, date and tax type.
  2. Choose the reason. Price, quantity, tax or return.
  3. Number it. Next in your series, 16 characters or fewer.
  4. Copy party details. Exactly as on the invoice.
  5. Enter only the difference. For a return, returned quantity × invoice rate.
  6. Keep the invoice's tax type. CGST + SGST or IGST, same rate.
  7. Sign and send. Get the IRN first if e-invoicing covers you.

Worked example 1: price revision on supplied flanges

A Rajkot flange maker supplies a customer in Ahmedabad. Both are in Gujarat, so the invoice used CGST + SGST. A price clause raised the 150 NB flange from ₹180 to ₹192, and the 100 NB from ₹140 to ₹148. All names and numbers are illustrative.

Table 1 (Example): debit note header

FieldValue
SupplierExample Flanges Pvt Ltd, Rajkot (24), GSTIN 24AAAAA0000A1Z5
RecipientExample Valves Pvt Ltd, Ahmedabad (24), GSTIN 24BBBBB0000B1Z5
Debit note number and dateDN/26-27/0014, 10 Nov 2026
Original invoiceINV/26-27/0412, 3 Oct 2026
ReasonAgreed price revision on supplied flanges

Table 2 (Example): line items and tax

LineCalculationTaxable value (₹)GST (₹)
150 NB flange, HSN 7307500 nos × ₹126,000CGST 9% 540 + SGST 9% 540
100 NB flange, HSN 7307300 nos × ₹82,400CGST 9% 216 + SGST 9% 216
Total8,4001,512

Total: ₹9,912, on top of the original invoice.

Worked example 2: rejected MS sheet sent back to the supplier

A Pune auto-parts maker buys 2 mm MS sheet from a supplier in Ahmedabad. Gujarat to Maharashtra is inter-state, so the invoice used IGST. At inward check, 250 kg failed the thickness check. The buyer returns it with debit note PR/26-27/0031, quoting invoice XS/2026/1187 of 28 Oct 2026. Numbers are illustrative.

Table 3 (Example): return lines and tax

LineCalculationTaxable value (₹)IGST 18% (₹)
MS sheet, 2 mm250 kg × ₹6215,5002,790
Total15,5002,790

Total: ₹18,290. Reason: rejected at inward check, thickness out of tolerance. Quote the GRN too; see our goods received note format.

What happens next: the supplier's credit note

The supplier answers with a GST credit note for ₹15,500 plus ₹2,790 IGST. That credit note is what changes the GST. Record its number and date, then reduce the input tax credit. See our credit note format.

Book a demo →

[[IMAGE {"type":"steps","title":"A purchase return, from rejection to credit note","items":["Goods fail the inward check","Buyer sends debit note with goods","Supplier issues a GST credit note","Buyer logs the credit note number","Input tax credit comes down"]}]]

Debit note vs credit note vs invoice

A debit note raises an invoice's amount; a credit note lowers it.

DocumentWho issues itWhenEffect on the amount
Tax invoiceSupplierAt the time of supplySets the amount and GST
GST debit noteSupplierValue or tax on the invoice was too lowRaises the amount and GST
GST credit noteSupplierValue or tax was too high, or goods came backLowers the amount and GST
Buyer's debit noteBuyerGoods returned or rejectedAsks the supplier for a credit note

For the invoice side, see our e-invoice format.

How to record a debit note in your books (Tally)

In Tally, record a purchase return as a Debit Note voucher against the original purchase invoice. Stock and tax both come down. Add the supplier's credit note number and date when it arrives.

Common debit note mistakes

  1. Using a credit note when the amount should go up.
  2. A serial number over 16 characters, or repeated in the year.
  3. No original invoice number and date.
  4. Switching from CGST + SGST to IGST, or back.
  5. Billing the full value instead of the difference.
  6. Treating the buyer's debit note as the GST adjustment.
  7. Reporting it in the wrong month's return.
  8. Skipping the IRN when e-invoicing covers you.

Where TranZact keeps the data in one place

A debit note needs the invoice number, items, agreed rate and tax type. These usually sit across Tally, Excel files and WhatsApp chats.

In TranZact, the PO, GRN and invoice for each order sit on one timeline. So the invoice number, items, rates and tax a debit note needs are already in one place. Accounting stays in Tally through one-way sync, with no double entry. See pricing and the purchase management page.

TranZact purchase and returns facts (as of November 2026)

  • Manufacturing AI software, built on 7 years of learning from 10,000+ manufacturers.
  • Purchase flow: MRP report → indent → RFQ → PO → GRN → payment.
  • Quality control (raw material and finished goods): Dominate plan.
  • Works with Tally, Busy, Zoho Books, Gmail and Excel / Google Sheets.
  • E-invoice (IRN) and e-way bill come from the GST invoice, on all plans.
  • Live in 2–3 weeks.

Ask on the demo how debit notes fit your products and returns. For production documents, see our bill of materials format.

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

Use the free Excel for your next price revision or return. To keep the invoice, GRN and PO behind every note in one place, talk to us.

Book a demo →

Frequently asked questions

Can one debit note cover more than one invoice?

Yes. Rule 53(1A) asks for the serial number(s) and date(s) of the corresponding invoice(s), so list each one.

Is a supplementary invoice the same as a debit note?

Under GST, yes. Section 34 says 'debit note' includes a supplementary invoice.

Does a debit note need an IRN?

If your business is covered by e-invoicing, yes. Debit notes are reported on the invoice registration portal like invoices. Use the Excel to prepare the figures first.

When must I report a debit note in GST returns?

In the return for the month you issued it (Section 34(4)). Check older invoices with your CA.

Can I edit this Excel format for my company?

Yes. Add your logo and details, and keep every Rule 53(1A) field. Keep the serial number to 16 characters or fewer.

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

Book a demo

Born in India. Building for the world.