01
Instructions
How to use every sheet, the credit-versus-debit rule, the 30-November deadline, the IMS accept and reject mechanism, numbering rules, and a colour guide. Read this first.
Credit Note and Debit Note Management Template for Indian Businesses
Log every credit and debit note you issue under Section 34. The sheet auto-calculates CGST, SGST, and IGST, flags the 30-November declaration deadline, and tracks each note's IMS status. Updated FY 2026-27 for the new IMS rules.
- Enter the taxable value and rate, get CGST, SGST, IGST, and the note total automatically
- Every credit note shows its 30-November declaration deadline so you never miss the cut-off
- Live dashboard of the output-tax impact plus an IMS status summary showing GST at risk
No spam. Instant download link to your
email.
Petpooja presents
Credit Note & Debit Note Management Template
GST-ready Excel for Indian Businesses
5
Sheets · Excel template
FY 2026-27
What's Inside
Five sheets covering every part of note management
02
Credit Note Register
Log every credit note you issue. Enter the note, invoice, customer, reason, and taxable value. CGST, SGST, IGST, the total, and the declaration deadline fill in automatically.
03
Debit Note Register
Log every debit note that increases your output tax. Same simple entry, with the GST calculated for you and a column to track whether you have declared it in GSTR-1.
04
Summary Dashboard
The output-tax impact at a glance: GST reduced by credit notes, GST added by debit notes, the net adjustment, a breakdown by reason, and an IMS status summary showing the GST at risk.
05
How It Works
A walkthrough of the sample data: how the GST is split intra versus inter-state, how a rejected note adds tax back, why a financial note carries no GST, and how the deadline is worked out.
Why This Matters
A Credit Note Is Not Just a Refund Slip
A customer returns goods, so you raise a credit note and assume your GST goes down. Under the new rules, that reduction is no longer automatic. It now depends on what your customer does next.
Since 1 October 2025, a GST credit note reduces your output tax only if the registered customer accepts it and reverses the matching input tax credit in the Invoice Management System (IMS), the facility added on the GST portal. If they reject it, the GST goes straight back onto your liability.
This trips up a lot of Indian businesses. They issue the credit note, cut the tax in their books, and only find out months later that the customer rejected it or never reversed the credit. The gap then shows up as a demand with interest.
The deadline catches people too. A credit note must be declared in your GST return by 30 November following the end of the financial year of the original supply. Miss that date and the note still exists on paper, but it can no longer reduce your GST.
Then there is the credit note that should never have carried GST at all. A later volume or target discount, not agreed before the sale, belongs on a financial credit note with no tax. Put GST on it by mistake and you wrongly reduce your liability, which is exactly what a scrutiny notice looks for.
This template keeps all of it straight. Enter the note, and the GST calculates itself. Every credit note shows its deadline. An IMS column tracks who has accepted, rejected, or not yet acted, and the dashboard totals the GST you can safely reduce against the GST still at risk. Verified against Section 34 and the current CGST rules.
Sample Preview
What the sheet shows for a ₹8,000 credit note
Here's a preview of what you'll get inside:
Note details: CN/26-27/001 dated 06-Jun-2026 against invoice
INV-2027, issued to Haldiram Retail for goods returned
Taxable value ₹8,000 at 18% intra-state: the sheet fills CGST
₹720 and SGST ₹720 automatically, IGST stays zero
Total note value: ₹9,440, calculated as taxable value plus the
two tax components
Declaration deadline: 30-Nov-2027, auto-filled from the FY of
the original invoice, so you know the last date to declare it
IMS status Accepted: the customer reversed the ITC, so the ₹1,440 reduction stands. A Rejected note would add the GST back
... plus the debit note register, a live dashboard of the net output-tax impact, and
a How It Works walkthrough across 5 sheets.
Key Stats
The rules that decide your tax reduction
30 Nov
The deadline to declare a credit note in your GST return: 30 November following the end of the financial year of the supply, or the annual return date, whichever is earlier. After that, no tax reduction.
Source: Section 34(2), CGST Act (deadline moved from 30 Sep to 30 Nov w.e.f. 01-Oct-2022)01 Oct 2025
From this date, a credit note reduces your liability only if the customer accepts it and reverses ITC through the Invoice Management System. A rejected note adds the GST back to what you owe.
Source: Section 34(2) proviso, Notification 16/2025-Central Tax, dated 17-Sep-202516 characters
The maximum length of a credit or debit note serial number. It must be a consecutive series, unique for the financial year, using only hyphen and slash as special characters.
Source: Rule 53, CGST Rules, 2017
Common Mistakes
6 Credit and Debit Note Mistakes Businesses Make
01
Assuming the credit note reduces your GST on its own
Since 1 October 2025, the reduction holds only if the customer accepts the note in IMS and reverses the ITC, per the CBIC amendment. Track every note's IMS status, because a rejected one adds the tax straight back.
02
Missing the 30-November declaration deadline
A credit note must be declared in your return by 30 November after the financial year of the supply. Issue it late in your books but declare it after the cut-off, and you lose the tax reduction.
03
Putting GST on a financial or discount credit note
A later volume or target discount not agreed before the sale should be a financial credit note with no GST. Charging tax on it wrongly reduces your liability and invites a scrutiny notice.
04
Thinking the buyer can issue a GST debit note
Under GST, both credit and debit notes are supplier-issued. A buyer's accounting debit note has no GST effect. Only the supplier can raise a note that adjusts the tax.
05
Mixing note numbers with your invoice series
Credit and debit notes each need their own consecutive series, unique for the year and separate from invoices. Reusing invoice numbers causes duplicates and reconciliation errors.
06
Forgetting the IRN on notes under e-invoicing
If your turnover is ₹5 crore or more, credit and debit notes need an IRN from the e-invoice portal too, not just tax invoices. A note without an IRN is not a valid document.
Comparison
Note Tracking: Manual vs This Template
| Aspect | Manual Tracking | With This Template |
|---|---|---|
| GST calculation | Worked out by hand per note | CGST, SGST, IGST auto-split from value and rate |
| Declaration deadline | Easy to forget, no reminder | 30-November deadline shown for every credit note |
| IMS status | Tracked nowhere, discovered late | Accept / Reject / Pending column with GST at risk |
| GST vs financial note | Often confused, tax charged wrongly | Note Type field keeps financial notes tax-free |
| Output-tax impact | Added up manually at return time | Live dashboard: reduced, added, and net adjustment |
| Numbering control | Prone to duplicates and gaps | Separate credit and debit series in one place |
| Audit readiness | Scattered across files | One register with original invoice links and reasons |
Stop losing GST to missed deadlines
Download the free Credit and Debit Note template and track every note, deadline, and IMS status in one sheet.
FAQ
Frequently asked questions
What is the difference between a credit note and a debit note under GST?
Both are issued by the supplier under Section 34 of the CGST Act. A credit note is issued when
the invoice value or tax was too high, goods are returned, or the supply is deficient, and it reduces the
supplier's output tax. A debit note is issued when the invoice value or tax was too low, or extra goods or
services were supplied, and it increases the supplier's output tax. A debit note includes a supplementary
invoice. A buyer cannot issue a GST debit note to reduce the supplier's tax.
What is the time limit to issue a credit note under GST?
A credit note must be declared in your GST return by 30 November following the end of the
financial year in which the original supply was made, or the date of filing the annual return, whichever is
earlier (Section 34(2)). For a supply made in FY 2025-26, the deadline is 30 November 2026. After this date
the credit note can still be issued commercially, but it can no longer reduce your GST liability. Debit notes
have no issue deadline, though the customer's ITC on them is capped by Section 16(4).
Does a credit note automatically reduce my GST liability?
Not any more. From 1 October 2025, a GST credit note reduces your output tax only if the
registered customer accepts it and reverses the corresponding input tax credit through the Invoice Management
System (IMS). If the customer rejects the note, the GST is added back to your liability in your next GSTR-3B.
This template has an IMS status column so you can track which notes are accepted, rejected, or pending, and
the dashboard shows the GST still at risk. You can cross-check figures with a free GST calculator.
What is the difference between a GST credit note and a financial credit note?
A GST credit note is issued under Section 34, carries tax, and reduces the supplier's output
liability, but only if the customer reverses the matching ITC. A financial or commercial credit note carries
no GST, needs no ITC reversal, and does not change your GST. Financial notes are used for post-sale discounts
that were not agreed before the supply, such as later volume or target discounts. A post-sale discount can be
taken out of the taxable value only if it was agreed at or before the supply and the customer reverses the
proportionate ITC (Section 15(3)(b)). This template lets you mark each note as GST or Financial so the tax is
handled correctly. To reconcile the ITC side, use the GST ITC reconciliation template.
Where are credit and debit notes reported in GST returns?
Credit and debit notes are reported in Table 9B of GSTR-1, separately for registered
customers (CDNR) and unregistered customers (CDNUR). From there the values flow into your GSTR-3B, where a
credit note reduces and a debit note increases the net taxable value and tax. If your turnover is ₹5 crore
or more, credit and debit notes also need an IRN generated from the e-invoice portal. Keep your GST invoices
and notes numbered in separate consecutive series to keep filing clean.
About Petpooja
Petpooja is India's leading SME business software suite, trusted by 1,50,000+ businesses across restaurants, retail, healthcare, manufacturing, and more. From billing and payroll to task management and procurement, Petpooja helps Indian businesses run better, every day.
Raise credit and debit notes without the spreadsheet
Petpooja Invoice creates GST credit and debit notes against any invoice, generates the IRN for e-invoicing, and files them into your GSTR-1, so the numbers, deadlines, and IMS entries take care of themselves.
Book a Free Demo
Call: +91-92279 80766