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
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
Featured ARTICLESHIP 17 November 2026
Associate/ Article Trainee

M/s. A V C & Co.

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 23 October 2026
CA Articleship / Article Assistant

M N Rao & Associates LLP

Vijayawada

CA Inter

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details