# GST Rule 37 180-Day ITC Reversal and Interest Worksheet

> Source: https://netray.co/tools/gst-rule-37-180-day-itc-reversal-worksheet-india
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Editable worksheet that flags supplier invoices unpaid beyond 180 days and computes the ITC to reverse and the interest payable.

## Category

regional

## Region

India

## Audience

- Accounts payable executive
- Tax manager
- Finance controller

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** Rs 

**Columns:**

#### Supplier

**Key:** supplier

**Type:** text

#### Invoice no.

**Key:** inv_no

**Type:** text

#### Invoice date

**Key:** inv_date

**Type:** date

#### ITC availed (Rs)

**Key:** itc

**Type:** number

**Format:** currency

#### Days since invoice date

**Key:** days_inv

**Type:** number

**Unit:** days

**Help:** Days from invoice date to the date of this review (or payment).

#### Days since ITC availed

**Key:** days_avail

**Type:** number

**Unit:** days

**Help:** Days from the date ITC was taken in GSTR-3B to the date of reversal.

#### ITC to reverse (Rs)

**Key:** reverse

**Type:** number

**Expr:** if(gt(days_inv,180), itc, 0)

**Format:** currency

#### Interest at 18% (Rs)

**Key:** interest

**Type:** number

**Expr:** if(gt(days_inv,180), itc * 0.18 * days_avail / 365, 0)

**Format:** currency

#### Status

**Key:** status

**Type:** select

**Options:**

- Unpaid
- Part paid
- Paid, re-avail ITC
- Reversed

**Rows:**

**Supplier:** Alpha Castings

**Inv no:** AC/221

**Inv date:** 2026-02-10

**Itc:** 54000

**Days inv:** 252

**Days avail:** 240

**Status:** Unpaid

**Supplier:** Metro Packaging

**Inv no:** MP/1048

**Inv date:** 2026-05-18

**Itc:** 18000

**Days inv:** 154

**Days avail:** 140

**Status:** Unpaid

**Supplier:** Rajan Tooling

**Inv no:** RT/77

**Inv date:** 2026-01-04

**Itc:** 36000

**Days inv:** 289

**Days avail:** 275

**Status:** Part paid

**Supplier:** Sai Logistics

**Inv no:** SL/905

**Inv date:** 2026-03-01

**Itc:** 9000

**Days inv:** 233

**Days avail:** 220

**Status:** Reversed

**Supplier:** Nova Chemicals

**Inv no:** NC/3310

**Inv date:** 2026-06-02

**Itc:** 27000

**Days inv:** 139

**Days avail:** 125

**Status:** Unpaid

**Totals:**

#### Total ITC availed

**Key:** itc

**Agg:** sum

**Format:** currency

#### Total ITC to reverse

**Key:** reverse

**Agg:** sum

**Format:** currency

#### Total interest

**Key:** interest

**Agg:** sum

**Format:** currency

**Summary:**

#### Total outflow (reversal plus interest)

**Key:** payable

**Expr:** sum_reverse + sum_interest

**Format:** currency

**Primary:** true

#### Share of ITC at risk

**Key:** share

**Expr:** if(gt(sum_itc,0), sum_reverse / sum_itc * 100, 0)

**Format:** percent

**Notes:** Educational worksheet. Rule 37 of the CGST Rules and the proviso to Section 16(2) require reversal of ITC where the supplier is not paid within 180 days of the invoice date, with interest under Section 50(1). Part payments need pro-rata treatment, so adjust the ITC column to the unpaid portion. Confirm with your tax adviser.

## Content

**Intro:** If you do not pay a supplier within 180 days from the date of the invoice, you must reverse the input tax credit and pay interest, and you can claim it again when you pay. This worksheet shows which invoices cross that line and what it costs.

**Sections:**

#### How to use the worksheet

**Body:** List every open supplier invoice where ITC has been availed. Enter the ITC amount and the days since the invoice date. Enter also the days since the ITC was taken, because interest runs from the date of availing credit to the date of reversal. The worksheet flags the reversal and computes interest at 18 percent a year. Export to Excel and share it with accounts payable before the month end cutoff.

**Bullets:**

- Pull open items from your vendor ageing report.
- Work with the unpaid portion if you made a part payment.
- Reverse in GSTR-3B table 4(B)(2) in the month the 180 days lapse.

#### The rule in practice

**Body:** The condition applies to supplies where payment of the value plus tax is not made to the supplier within 180 days of the invoice date. Exceptions exist, for example where the supplier has been paid by a mechanism such as settlement of liability through a contra or where reverse charge applies, since there is no payment of tax to the supplier. Once you pay, the credit can be availed again in the return of that month. The reversal and re-avail cycle is a timing cost, but the interest is real.

#### Mistakes to avoid

**Body:** Teams count from the booking date rather than the invoice date. Others forget to track disputed invoices, advance payments, debit notes, and write-offs. Make sure your ageing report uses invoice date and the GST posting date together. Also confirm that rate and tax were part of the payment, because some vendors are paid only the base amount while a tax balance stays open.

**Bullets:**

- Counting from goods receipt date instead of invoice date.
- Ignoring MSME payment terms that also create interest exposure.
- Not re-availing ITC after later payment.

**Cta:** If vendor ageing and GST credit sit in different reports, we can help you add a 180-day ITC exposure view to your ERP.

**Faq:**

#### Does the 180 days count from the invoice date or the receipt date?

**Answer:** It counts from the date of issue of the invoice. Use the invoice date printed by the supplier, not the date you booked the voucher or received the goods, and keep the ageing report on the same basis.

#### Can I claim the ITC again after I pay?

**Answer:** Yes. When the supplier is paid, the credit that was reversed can be availed again, subject to other conditions. Interest paid on the reversal is not refunded. Track the status column so re-availing is not missed.

#### Does this apply to reverse charge purchases?

**Answer:** The 180-day condition does not apply where tax is paid under reverse charge, because there is no payment of tax to the supplier. Confirm treatment for your case with your adviser.

#### What interest rate applies?

**Answer:** Interest is under Section 50(1) at 18 percent a year, from the date ITC was availed to the date of reversal. The worksheet uses a 365-day year. Check the current notified rate before filing.

## Search terms

rule 37 ITC reversal 180 days, ITC reversal worksheet excel, GST 180 days payment rule, ITC reversal interest calculation, section 16(2) proviso reversal, reverse ITC unpaid invoices, GST ITC reversal format

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json