180 DAYS ITC REVERSAL WITH INTEREST EXCEL UTILITY

Please provide me excel format of 180 DAYS ITC REVERSAL WITH INTEREST EXCEL UTILITY

Read more at: https://www.caclubindia.com/forum/create_message.asp#

Replies (3)
Quick Summary
This discussion seeks an Excel utility to manage the 180-day Input Tax Credit (ITC) reversal requirement under Rule 37, including interest calculations. A community member has developed a specialised MS Excel-VBA tool, the MSB Forensic Suite, to identify ITC reversals, automate interest calculations, and generate reclaim certificates. The 'Community Edition' of this utility is offered to help streamline GST compliance.

Youtube.com
https://m.youtube.com › watch
1 Calculation of ITC Reversal and Interest of GST in Ms-Excel

Dear Sir/Madam,

Please provide us excel utility for 180days Input Reversal (rule_37) with interest calculation,

 

Dear Ashok Ji,

I noticed your request for a Rule 37 compliance utility. This is a common challenge many of us face regarding the mechanical tracking of the 180-day limit and interest calculations.

To assist the community, I have developed a specialized tool called the MSB Forensic Suite (V16.0 GOLD). It is a native Excel-VBA utility designed specifically to:

  • Identify ITC reversals based on the 180-day payment deadline.

  • Automate interest calculations with forensic precision.

  • Generate audit-ready reclaim certificates.

I am happy to share the "Community Edition" of this tool with you. Please find the utility attached [if the forum allows attachments] or feel free to connect if you need the direct file.

I hope this helps streamline your compliance workflow.

Best Regards,

Mohamed A Proprietor | M S Tax Consultant Indirect Tax Expert

Contact us : md71076 @ gmail.com 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
13 August 2026
Chartered Accountant (FP&A)

Client of Trellis Consulting

Gurgaon

CA

View Details
Company
08 September 2026
Semi-Qualified Assitant

Subrahmanyam & Sivudu CA Firm

Hyderabad

CA Inter

View Details
Company
08 September 2026
Audit Executive

Thammana & Associates

Srikakulam

B.Com

View Details
Company
25 August 2026
Senior Accountant

MG Associates

New Delhi

CA Inter

View Details
Company
18 August 2026
CA Semi Qualifies

Goyanka and Associates

New Delhi

CA Inter

View Details
Company
21 August 2026
Finance Manager

Resollect Technologies Pvt Ltd

Mumbai

CA

View Details
Company
ARTICLESHIP 07 September 2026
CA Articles

Kothari Jain Patil & Chartered Accountants

Pune

CA Inter

View Details
Company
ARTICLESHIP 24 August 2026
Chartered Accountant Articles

Rohit KC Jain & Co

New Delhi

CA Inter

View Details