GSTR-7 is the monthly return filed by persons required to deduct Tax Deducted at Source (TDS) under Section 51 of the CGST Act. The GSTR-7 offline tool is an Excel-based utility provided by GSTN that allows TDS deductors to prepare return data offline, validate entries, generate a JSON file, and upload it to the GST portal. This guide covers the entire process, from downloading the tool to resolving common upload errors.
Who Must File GSTR-7?
TDS under GST applies to specific categories of deductors making payments to suppliers for taxable supplies. The following entities are required to deduct TDS and file GSTR-7:
| Deductor Category | Examples |
| Central or state government departments | Ministries, departments, directorates |
| Local authorities | Municipal corporations, panchayats, and cantonment boards |
| Government agencies | Statutory bodies, autonomous bodies |
| Persons or categories notified by the government | Public sector undertakings, societies registered under the Societies Registration Act |
TDS is deducted when the total value of supply under a single contract exceeds Rs. 2.5 lakh. The deduction is made at 2% of the payment (1% CGST + 1% SGST for intra-state supplies, or 2% IGST for inter-state supplies). The deducted amount is deposited with the government and reflected in the supplier’s electronic cash ledger.
GSTR-7 Structure
| Table | Content | Data Source |
| Table 1 | GSTIN of the deductor | Auto-populated |
| Table 2 | Name and trade name | Auto-populated |
| Table 3 | TDS details for the current tax period | Invoice-wise: supplier GSTIN, invoice number, date, taxable value, TDS amount |
| Table 4 | Amendments to TDS details reported in previous periods | Corrections to Table 3 data from earlier months |
| Table 5 | TDS liability and payment | Auto-calculated from Tables 3 and 4 |
| Table 6 | Interest and late fee | Auto-calculated based on filing delay |
Downloading the GSTR-7 Offline Tool
Step 1. Visit the official GST portal.
Step 2. Navigate to Downloads> Offline Tools> GSTR-7 Offline Tool. No login is required for downloading.
Step 3. Download the ZIP file containing the Excel utility. Extract the files to a local folder.
Step 4. Open the Excel file with macros enabled. The utility requires Microsoft Excel with macro support (Windows 7 or later recommended).
Using the Offline Tool: Step-by-Step
Step 1: Enter Basic Details
Open the tool and enter the GSTIN of the deductor, the financial year, and the tax period (month) for which the return is being prepared.
Step 2: Fill Table 3 (TDS Details)
For each TDS deduction made during the month, enter the supplier’s GSTIN, the invoice or contract number, the date of payment, the total taxable value of the supply, the TDS rate (1% CGST + 1% SGST or 2% IGST), and the TDS amount deducted.
Each row represents one deduction transaction. Multiple deductions for the same supplier should be entered as separate rows if they relate to different invoices or contracts.
Step 3: Fill Table 4 (Amendments)
If corrections are needed to the TDS details reported in previous months, enter the amendments in Table 4. Provide the original period, original supplier GSTIN, original invoice reference, and the revised details.
Step 4: Validate Data
Click the Validate button in the tool. The utility checks for missing fields, invalid GSTINs, incorrect rate calculations, and format errors. Any validation errors are displayed with descriptions. Correct all errors before proceeding.
Step 5: Generate JSON File
After successful validation, click Generate File. The tool creates a JSON file in the designated output folder. Note the file location for the upload step.
Step 6: Upload to GST Portal
Log in to the GST portal. Navigate to Services, then Returns, then Returns Dashboard. Select the tax period and click Prepare Offline on the GSTR-7 tile. Click Upload and select the JSON file generated by the offline tool. The portal processes the file and displays the uploaded data for review.
Step 7: Review and Submit
After Upload, review all data on the portal. Make any final corrections online if needed. Submit the return using DSC or EVC. Pay any outstanding TDS liability through the electronic cash ledger. An ARN is generated upon successful filing.
TDS Rates and Thresholds Under GST
| Aspect | Details |
| Applicable threshold | Total contract value exceeding Rs. 2.5 lakh per contract |
| TDS rate (intra-state) | 2% (1% CGST + 1% SGST) |
| TDS rate (inter-state) | 2% IGST |
| Deduction timing | At the time of making payment to the supplier |
| Deposit deadline | By the 10th of the following month (along with GSTR-7 filing) |
| Supplier credit | TDS amount reflects in the supplier’s electronic cash ledger |
| TDS certificate | Form GSTR-7A auto-generated; available to the supplier within 3 days of filing. |
The Rs. 2.5 lakh threshold applies to the total value of the contract, not to individual payments. If a contract is valued at Rs. 3 lakh and payments are made in instalments of Rs. 1 lakh each, TDS must be deducted on each payment, as the total contract value exceeds the threshold.
Common Errors and Resolution
| Error | Cause | Resolution |
| Invalid GSTIN format | Incorrect supplier GSTIN entered | Verify the 15-digit GSTIN from the supplier’s registration certificate |
| TDS amount mismatch | Calculated TDS does not match the rate applied to the taxable value | Recalculate: taxable value x 1% (CGST) + 1% (SGST) or 2% (IGST) |
| JSON upload failure | File corrupted or wrong format | Regenerate the JSON file; ensure macros were enabled during generation |
| Duplicate entry | The same invoice was reported twice in Table 3 | Remove the duplicate row and revalidate |
| Previous period amendment error | Original period or GSTIN does not match the filed data | Verify the original GSTR-7 for the referenced period |
| Portal timeout during Upload | Large file or slow connection | Upload during off-peak hours; split data if the tool supports it |
Impact on Suppliers
When a deductor files GSTR-7, the TDS amount is credited to the supplier’s electronic cash ledger on the GST portal. The supplier can use this credit to pay their output GST liability or claim it as a refund if no liability exists.
The supplier receives Form GSTR-7A (TDS certificate) automatically within 3 days of the deductor filing GSTR-7. This certificate serves as proof of TDS deduction and can be used for reconciliation with the supplier’s own records and GSTR-3B filing.
Key Terms
• GSTR-7: The monthly return filed by TDS deductors under Section 51 of the CGST Act, reporting all TDS deductions and amendments
• Section 51 CGST Act: The provision mandating specific government entities and notified persons to deduct TDS at 2% on payments exceeding Rs. 2.5 lakh
• GSTR-7 Offline Tool: The Excel-based utility provided by GSTN for offline preparation of GSTR-7 data, generating JSON files for portal upload
• Form GSTR-7A: The TDS certificate is auto-generated after GSTR-7 filing, reflecting in the supplier’s account within 3 days
• Electronic Cash Ledger: The GST portal account where TDS is deducted is credited, available to the supplier for tax payment or refund
Filing GSTR-7 for TDS Compliance?
Ensure accurate TDS deduction and timely filing. Use WFYI tools to manage your TDS obligations, generate returns offline, and maintain compliance with Section 51 requirements.
| Disclaimer: This article is for informational purposes only and does not constitute legal or tax advice. Consult a qualified tax professional for advice specific to your situation. |
Ready to Simplify Your Tax Compliance?
WFYI provides comprehensive tools and resources to help you manage GST, income tax, and financial compliance with ease.
Frequently Asked Questions
Q1: Who is required to deduct TDS under GST and file GSTR-7?
Central and state government departments, local authorities, government agencies, and persons notified by the government must deduct TDS at 2% on payments exceeding Rs. 2.5 lakh per contract and file GSTR-7 monthly by the 10th of the following month.
Q2: What is the TDS rate under GST?
TDS is deducted at 2% of the taxable value. For intra-state supplies, it is split as 1% CGST + 1% SGST. For inter-state supplies, 2% IGST is deducted. The Rs. 2.5 lakh threshold applies to the total contract value.
Q3: Can GSTR-7 be filed only through the offline tool?
No. GSTR-7 can be filed either online (direct data entry on the portal) or offline (using the Excel utility to generate JSON for Upload). The offline tool is recommended for deductors with a large number of transactions.
Q4: How does the supplier receive credit for TDS deducted?
The TDS amount is credited to the supplier’s electronic cash ledger on the GST portal within 3 days of the deductor filing GSTR-7. The supplier can use this credit to pay taxes or claim a refund.
Q5: What happens if GSTR-7 is filed late?
Late filing attracts a late fee of Rs. 200 per day (Rs. 100 CGST + Rs. 100 SGST), subject to a maximum. Interest at 18% per annum is charged on the unpaid TDS amount from the due date until payment.
