Free template · Invoicing
Credit note and debit note format (free Excel download)
One Excel file with a credit note sheet and a debit note sheet. Add the original invoice reference, the items and the GST rate, and the taxable value, GST and note total are calculated for you.
- Free, no sign-up
- GST calculated for you
- Excel, Google Sheets & LibreOffice
Template preview
- Issued to
- Sample Customer Pvt Ltd, Pune · GSTIN 27LMNOP4321Q1Z8
| Description | HSN | Qty | Rate | Taxable value | GST 18% |
|---|---|---|---|---|---|
| MS bracket 40 mm (returned, damaged) | 7326 | 10 | 120 | 1,200 | 216 |
| Total | 10 | 1,200 | 216 |
Preview with sample data
What it includes
- A credit note sheet and a debit note sheet in one file
- Note number and date
- Supplier and recipient names with GSTIN
- Original invoice number and date
- Items with HSN or SAC, quantity, rate and GST percentage
- Taxable value, GST and note total calculated automatically
- Signature line for the authorised signatory
How to use it
- Pick the credit note or debit note sheet and add your details and the original invoice reference.
- List the items affected with quantity, rate and GST percentage.
- Check the total, print or save as PDF, sign it and send it to the customer.
What are a credit note and a debit note?
A tax invoice is not always the last word on a sale. Goods come back, prices get revised, quantities are corrected and mistakes are found after the invoice has gone out. A credit note and a debit note are the two documents you use to fix the amount without cancelling the original invoice.
A credit note reduces the amount the customer owes. A debit note increases it. Both refer back to the original invoice, so anyone reading your records can see what changed and why. This free credit note format in Excel, with a matching debit note sheet, works in Excel, Google Sheets and LibreOffice. You can also copy the table into Word if your team prefers that.
When do you issue a credit note?
A seller usually issues a credit note when the value on the original invoice turns out to be too high. Typical cases are:
- Goods returned: the customer sends back damaged, defective or excess goods.
- Price reduction or discount: you agree a lower rate or a post-sale discount after the invoice is raised.
- Invoice error: the quantity, rate or tax on the invoice was higher than it should have been.
- Short supply: fewer goods were delivered than were billed.
When do you issue a debit note?
A debit note is used when the original invoice undercharged or when something extra has to be billed:
- Price revision upwards: a rate difference agreed after supply, such as a raw material price clause.
- Additional quantity or charges: extra goods, freight or packing that were left off the invoice.
- Invoice error: the taxable value or tax on the invoice was lower than it should have been.
Under GST, the rules for issuing and reporting these notes sit in section 34 of the CGST Act, 2017 and Rule 53 of the CGST Rules. Conditions and time limits apply, especially for credit notes that reduce tax, so check the current text or confirm with your chartered accountant before you rely on a note for your return.
What a credit note or debit note format should contain
Keep the document short and complete. At minimum, include:
- The words “credit note” or “debit note”, clearly shown.
- A note number in a running series, and the date.
- Name, address and GSTIN of the supplier who issues it.
- Name, address and GSTIN of the recipient (and state of supply where it matters).
- The number and date of the original invoice it relates to.
- A description of the items affected, with HSN or SAC code, quantity and rate.
- The taxable value, the tax rate and the tax amount.
- The signature of the authorised signatory.
Credit note vs debit note vs refund
The two notes only change the amount on your books. A credit note does not by itself send money back to the customer. You may adjust it against the next invoice, or pay it out, and that is a separate step. In the same way, a debit note is a request for more money, not a new sale. Keep every note linked to its invoice by writing the invoice number on it. If you need the invoice itself, see our GST invoice format.
Tips for using credit and debit notes without errors
- Number notes in one running series for each financial year, and never reuse a number.
- Always quote the original invoice number and date. A note with no reference is hard to defend.
- Use the same GST rate and HSN code as the original invoice for the items you are adjusting.
- For returns, update your stock on the same day the goods are received back, so stock and books agree.
- Send the note to the customer promptly and ask them to record it, so both sides match at month end.
- Keep a copy with the invoice and any return paperwork, such as a delivery challan for the returned goods.
Stop retyping notes
A spreadsheet works when you issue a handful of notes a month. As volumes grow, retyping party names, GSTINs and item details gets slow and invites mistakes. Mera Udyog handles GST invoicing and stock in one app, so you can raise invoices and keep stock up to date in every warehouse from the same place. See GST billing software and inventory management software to see how it works.
This template is a general format and not legal or tax advice. Rules change, so verify the current requirements with a professional or the latest GST notifications.
Questions
Good to know
What is a credit note?
A credit note is a document a seller issues to reduce the amount a buyer owes, usually because goods were returned, the price was reduced or the original invoice had an error that made the value too high. It refers back to the original invoice.
What is a debit note?
A debit note is a document that increases the amount owed against an earlier invoice, for example when the price is revised upwards, extra quantity is supplied or the original invoice undercharged. Under GST a supplier issues it against the original tax invoice.
What details must a GST credit note or debit note contain?
Rule 53 of the CGST Rules, 2017 lists them: the supplier's name, address and GSTIN, the words credit note or debit note, a serial number and date, the recipient's name, address and GSTIN, the original invoice number and date, the taxable value and tax amount, and a signature. Confirm the latest rule text with your CA.
Is a credit note the same as a refund?
No. A credit note reduces what the customer owes or creates a balance in their favour. Whether you adjust it against the next invoice or pay it out as a refund is a separate business decision.
Can I get this credit note format in Word?
The download is an Excel file with a credit note sheet and a debit note sheet. To use it in Word, copy the table into a Word document, or open the file in Google Sheets or LibreOffice and print it or save it as PDF.
Do I need to report credit and debit notes in my GST return?
Registered businesses generally report them in their GST returns, and time limits apply to credit notes under section 34 of the CGST Act. Check the current rules and notifications or ask your CA.
Done with paperwork?
Mera Udyog handles attendance, salary, quotations, invoices and HR records for you. Try it free for 7 days.
7-day free trial · No credit card needed