To make GST return working, ITC reconciliation, compliance tracking, and monthly GST reporting easier, we have prepared a practical GST Utilities Pack 10-in-1 Excel Workbook. This utility is useful for Chartered Accountants, GST Practitioners, Accountants, Tax Consultants, Business Owners, and Finance Teams.
GST Utilities Pack 10-in-1 is an Excel-based workbook designed to help users prepare GST working papers, reconcile input tax credit, track vendor compliance, calculate interest and late fees, monitor GST notices, and prepare GST annual return or audit-related data.
| S. No. | GST Utility | Purpose |
|---|---|---|
| 1 | GSTR-2B vs Books ITC Reconciliation | To compare ITC as per books with ITC available in GSTR-2B. |
| 2 | GSTR-1 Sales Working | To organize outward supply and sales data before filing GSTR-1. |
| 3 | GSTR-3B Monthly Working | To prepare monthly GST liability, ITC, tax payable, and cash payment working. |
| 4 | RCM Liability & ITC Tracker | To track reverse charge liability and eligible ITC on RCM payments. |
| 5 | E-Invoice / E-Way Bill Applicability Checker | To check invoice-wise e-Invoice and e-Way Bill applicability. |
| 6 | GST Interest & Late Fee Calculator | To calculate interest and late fee for delayed GST filing or payment. |
| 7 | Vendor GST Compliance Tracker | To track vendor-wise GST compliance and ITC follow-up status. |
| 8 | GST Notice / DRC-01 / ASMT-10 Reply Tracker | To monitor GST notices, due dates, replies, and pending actions. |
| 9 | ITC Reversal Rule 42/43 Working | To prepare ITC reversal working for common credit and exempt supplies. |
| 10 | GST Audit / Annual Return Checklist | To support GSTR-9, annual return review, and GST audit preparation. |
This GST Utility is prepared only for working, reconciliation, and compliance support purposes. Before final GST return filing, tax payment, ITC claim, interest calculation, late fee calculation, or legal compliance, users should verify the data with the GST Act, GST Rules, notifications, circulars, and the official GST portal. Professional advice should be taken in case of any mismatch, legal interpretation, or complex GST matter.
Click the button below to download the GST Utilities Pack 10-in-1 Excel Workbook.
Click Here to Download Excel Utility
Yes, this GST Utilities Pack is available for download and working purposes.
Yes, CA firms, GST practitioners, accountants, and tax consultants can use this utility for client GST working.
No, this is not an official GST portal utility. It is an Excel-based working and reconciliation support tool.
This utility can support GST return preparation, but final figures must be verified with the GST portal before filing.
It includes GSTR-2B reconciliation, GSTR-1 working, GSTR-3B working, RCM tracker, e-Invoice/e-Way Bill checker, GST interest calculator, vendor compliance tracker, GST notice tracker, Rule 42/43 ITC reversal working, and GST audit checklist.