GST tax deducted at source: Table 3 and Table 4, row-by-row checks and the JSON file for the GST portal. Version 1.0.0. Your data stays in your browser.
Free GSTR-7 offline return preparation for tax deductors
GSTR-7 is the monthly return that a person who deducts tax at source under GST files on the GST portal. This free tool helps you prepare Table 3 (tax deducted) and Table 4 (amendments), check every row, and create the JSON file for upload, without installing a spreadsheet macro. It runs in your browser and your data stays on your device.
Who it is for
Government departments, local bodies, public sector undertakings and others who deduct tax at source, and the accountants who prepare their returns.
Guide and release notes
GSTR-7 Return Preparer, Version 1.0.0, released 27 October 2026.
What is new in Version 1.0.0
First release. Prepare the GSTR-7 return (tax deducted at source under GST) in your browser and create the JSON file to upload on the GST portal.
Table 3 (tax deducted at source) and Table 4 (amendments to earlier periods), with a Suppliers master that fills the deductee names. Follows the layout and checks of the GST offline utility version 4.1, including the document-level details required from September 2025 and the earlier GSTIN-wise format for older periods.
Financial years 2018-19 to 2026-27 are available.
Checks every row: GSTIN format, deductee not the same as the deductor, document number, date and value, amounts and digits, CGST equal to SGST, tax not above the amount paid, duplicates, the amended period, and the State rules for older periods. Cells with errors are marked in red with the message and its error code.
Opens the JSON file downloaded from the GST portal, and the error report from the portal, with the portal message shown against each row. Imports the Table 3, Table 4 and Suppliers master sheets from the official Excel utility, or from CSV.
Creates the upload JSON, split into several files when there are more than 5,000 records.
Tabs are now named TDS and Amendments. When a TDS or Amendments file is imported (Excel, CSV or JSON), blank amount cells and cells showing a dash are filled with 0 for the amount paid, integrated, central and state tax, and the tool says how many were filled.
Save: a Save button (and Ctrl+S) at the top, and a save location. In Chrome or Edge you choose a data file once; every change is then saved to it automatically, and the file loads again next time (reconnect once per session if the browser asks). Other browsers save a backup file when you choose Save. Data is also kept in the browser.
Suppliers master: a search box (GSTIN, legal name or trade name) and a duplicate GSTIN warning [G7-E402] that marks every row sharing a GSTIN, with a button to show only those rows. Suppliers master Excel template in the official layout (S.No., GSTIN, Legal name, Trade name) that you fill and import. Section-wise summary, printable summary, backup and restore, CSV and Excel export.
Error codes with solutions on the Error codes tab and in this guide. Footer on exported and printed files: Generated using GSTR-7 Return Preparer v1.0.0 by Techmin Wealth Partners. No logo is printed.
Security: Content Security Policy, clickjacking guard, referrer policy, 20 MB limit on files, 10,000 rows per table, safe reading of JSON and backup files, and spreadsheet formula characters neutralised in exports.
1. Purpose
This tool helps a tax deductor (a person who deducts tax at source under section 51 of the CGST Act) prepare the monthly GSTR-7 return offline. It checks the data and creates the JSON file that is uploaded on the GST portal. It does not file the return. You must upload the file on the portal, preview the form and file it there.
2. Before you start
Keep the GSTIN of the deductor (the 14th character is D), and the list of deductees with the amount paid and the tax deducted for the month. From September 2025 the portal asks for the invoice or document number, date and value of every payment.
3. Steps
Home: enter the GSTIN, the financial year and the tax period. Choose Save at the top (or press Ctrl+S) and pick a save location in Chrome or Edge, so that every change is saved to your own file.
Suppliers master (optional): add the GSTIN, legal name and trade name of your regular deductees (use the Excel template to upload many at once, and the search box to find a supplier). A GSTIN entered twice gives a warning [G7-E402]; keep one row for it. The names then fill in by themselves.
Table 3: add one row for each document (or, for periods before September 2025, one row for each deductee). Type, paste from Excel, or import a CSV or Excel file.
Table 4: add rows only for amendments to earlier periods. The amended month must be earlier than the return period.
Validate each table. Cells in red show the problem and its error code. Fix them and validate again.
Home: choose Validate all and get summary, then Generate JSON file to upload.
On the GST portal open Returns Dashboard, choose the period, GSTR-7, Prepare Offline, and upload the JSON file. Preview, then file.
4. How the main checks work
Action: Add creates or revises a record; Delete removes a record already on the portal.
Tax: enter either Integrated tax, or CGST and SGST (which must be equal). Total tax cannot exceed the amount paid. As in the official utility, the tax is typed by you; the tool does not work it out.
Dates are typed as DD/MM/YYYY and cannot be before 1 July 2017 or after the end of the period.
Periods before September 2025 use the earlier format: no document details, one row for each GSTIN and action, IGST only for another State, CGST and SGST only within the State.
In Table 4, for September 2025 either fill all six document fields or leave all six blank. For periods before September 2025 the document fields are not needed. From October 2025 they are required.
Records rejected by deductee: choose Yes when the deductee rejected the record on the portal.
5. If the portal shows errors
Download the error report (returns__R7__errorReport.json). Choose Open downloaded error JSON file on the Home screen. Correct the rows, using the portal message in the last column, then generate and upload the JSON again.
6. Limits
Up to 10,000 rows in each table. Up to 5,000 records in each upload file; larger returns are split automatically.
The tool is based on the offline utility version 4.1 as published for FY 2026-27. The portal may change its rules; the portal is always the final check.
The Excel import and export need an internet connection to load the spreadsheet reader once. CSV works offline.
Your data is stored only in this browser. Download a backup regularly.
Disclaimer
Not a GST Network or Government product
GSTR-7 Return Preparer is provided by Techmin Wealth Partners and Techmin HR Solutions (A Subsidiary of Techmin Wealth Partners) as a working aid. It is not provided, endorsed or approved by the Goods and Services Tax Network, the GST Council or any tax authority. The offline utility published on the GST portal remains the official tool.
Check before you file
The software checks data against the rules of the GST offline utility as published, but those rules can change and the checks are not exhaustive. You are responsible for the data, the rates and the return. Upload the file on the portal, preview it, and compare it with your records before you file. This is not tax or legal advice.
No warranty and limit of liability
The software is provided as is, without warranty of any kind. Techmin Wealth Partners and Techmin HR Solutions accept no liability for any loss, penalty, interest, late fee or other consequence of using it.
Your data
Data is processed and stored in your browser and is not sent to a server by this software. Browser data can be lost and can be read by anyone using the same browser profile. Keep backups. The spreadsheet reader for Excel files is loaded once from a public content network when you use Excel import or export.
Donations
The tool is free. A voluntary donation does not create any warranty, support or service obligation.
