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
ARTICLESHIP 23 October 2026
CA Articleship / Article Assistant

M N Rao & Associates LLP

Vijayawada

CA Inter

View Details
Company
12 October 2026
Finance

I-Genext Consulting Private Limited

New Delhi

CA

View Details
Company
12 October 2026
AUDIT , ACCOUNTS AND TAXATION

KDSS

New Delhi

B.Com

View Details
Company
07 October 2026
Senior Account Manager

Amplio Invest

Mumbai

M.Com

View Details
Company
30 September 2026
Senior Accountant

Codeboard Technology

Chennai

B.Com

View Details
Company
08 October 2026
Accounts and Tax Associate

POOJA R TELI & CO

Pune

CA Inter

View Details
Company
ARTICLESHIP 20 October 2026
CA ARTICLE

AMKN & CO

Noida

CA Inter

View Details
Company
14 October 2026
Accountant

Rize.farm

Bengaluru

B.Com

View Details