The application
A Windows desktop application that reads the returns downloaded from the portal and reconciles them against each other. It is designed for offline working, with the source files staying on the computer.
Built around the work, not a dashboard.
The application starts with the files you already have. It guides you through files, scope, build and output instead of hiding the working behind a generic dashboard.
From downloaded data to a working file.
See the working, not just the brochure.
Use the screenshot, workflow and output descriptions below to understand how the current build handles downloaded GST data.
Ask for the current build
- Email the request to support@gstpragyan.in.
- The current build and release notes are sent after the request is reviewed.
- No taxpayer data is needed for a build request.
What it does
The application opens on five workspaces. Each produces a different workbook, and the mode is chosen from the panel on the left.
- Reconcile Returns, every table of every return you select, arranged tax period wise, in one workbook.
- Return Scrutiny, the scrutiny parameters worked out head by head with the working shown for each, and a draft ASMT-10 prepared. This is the main mode.
- Audit Support, a reconciliation worksheet pre-populated from the returns, against which the sales register, purchase register and electronic ledgers are reconciled. A missing register or ledger is never read as zero; the reconciliation reads NOT TESTED.
- ITC & Purchase Analysis, GSTR-2B matched against a purchase register invoice by invoice, with the invoices unpaid beyond a hundred and eighty days.
- e-Way Bill Analysis, inward and outward bills merged and de-duplicated, with checks for movement patterns that do not fit the supplies declared.
Merges the returns
GSTR-1, GSTR-3B, GSTR-2A, GSTR-2B, GSTR-9, GSTR-9C, IFF and the e-Way Bill report, for as many periods as you have, stacked into one workbook. Every original column is kept.
Runs the scrutiny checks
39 scrutiny parameters. Each runs on its own worksheet, identifies its source data and keeps tax heads separate. The detailed names should be read from the current build because they can evolve with the application release.
Thirty-nine parameters, each on its own worksheet, with every column headed by the source it reads. Each tax head is tested separately, so an excess in one head is never cancelled by a shortfall in another.
Matches the purchases
GSTR-2B against a purchase register, invoice by invoice, with Rule 37 ageing on invoices unpaid beyond a hundred and eighty days.
Drafts an ASMT-10 reference
A Word draft carrying the statutory paragraph, the amount head by head, and the month-wise working. Findings are separated into what is quantified, what needs verification first, and what is only information.
Analyses e-Way Bills
Inward and outward reports merged into one set of transactions and run through automated checks for unusual movement patterns. These are indicators, not proof.
Builds an audit pack
Books against returns, with the electronic cash and credit ledgers where they are available, and register templates to fill in.
What a useful output should tell you
This example is illustrative. It is not an extract from a taxpayer's data or a statutory conclusion.
System requirements
Windows desktop environment. The application is intended for local processing of downloaded GST files. Keep the source files on the working computer and use the current release notes supplied with the build.
How it works
It reads what the portal gives you
Excel, JSON and PDF downloads, as downloaded. ZIP files can be added without unpacking them first. Columns are matched by their heading rather than their position, so a change to the portal export cannot silently cause the wrong column to be read.
Your return data stays on the computer
There is no account, no sign-in and no upload. The returns loaded and the workbooks written stay on the machine it runs on. The application makes no network calls of its own: no update check, no telemetry. Two links hand off to another program when you click them, and neither carries any return data: Website opens your browser, and Feedback opens a blank message in your mail client. See the privacy policy.
Every figure is traceable
Each worksheet states the source of each column and the provision the test rests on. A figure in the draft notice can be followed back to the row it came from.
The statutory position is dated
Late fee, interest and time limits are applied as they stood for the tax period being examined, not as they stand today. The notification behind each is recorded. The demand provision follows the year too: Sections 73 and 74 up to FY 2023-24, and Section 74A from FY 2024-25, which replaces both whether or not fraud is alleged and runs forty-two months to the notice with twelve months from the notice to the order. See limitation.
What it will not do
It does not decide anything. Every figure is a starting point for examination. Nothing produced should be issued without being checked against the record.
It cannot see what is not in the returns. Whether a supply is correctly classified, whether credit was used for business, whether an e-Way Bill represented a taxable supply: none of that is in the data. Where a question cannot be answered from the returns, the output says so instead of guessing.
It is not a substitute for the record. Books, invoices and ledgers settle questions the returns cannot.
Questions
What does it cost?
Nothing. There is no paid version and no licence.
What do I need to run it?
A Windows computer, Windows 10 version 1809 or later. No internet connection is needed for any of the work it does.
Does my data go anywhere?
No. Returns loaded and files written stay on the machine, and the application makes no network calls of its own. The only outbound actions are the Website and Feedback links, which open your browser or mail client when you click them and carry no return data.
Which returns does it read?
GSTR-1, GSTR-3B, GSTR-2A, GSTR-2B, GSTR-9, GSTR-9C, IFF and the e-Way Bill MIS report. GSTR-3B, GSTR-9 and GSTR-9C are read from the PDF; the rest from Excel or JSON.
Does it read GSTR-1A?
It is built to, but the portal presently offers GSTR-1A only as a summary PDF, which carries table totals and no invoice rows. There is therefore nothing to add for it. A GSTR-1A filed for a period is already reflected in that period's GSTR-3B.
Can it handle more than one year?
Yes. Several years can be loaded together, and the workbook carries each year separately as well as a combined view. Years are never set off against one another.
Can it handle more than one GSTIN?
No. One registration per workbook, and a second registration needs its own run. The application does ask whether the PAN holds more than one registration, but that is a disclosure recorded on the dashboard because it bears on aggregate turnover; it does not combine registrations into one working file.
Is the draft notice ready to issue?
No, and it is not meant to be. It is a reference draft. Every figure needs checking against the record, and the internal page of officer notes has to be removed before anything is issued.
Something looks wrong. What should I do?
Please report it, with the version number from the title bar, to support@gstpragyan.in, which is the same address the application's own Feedback link uses. See also Contact. Most of what has been fixed was found this way.
How do I get it?
Ask by email and the current build and release notes will be sent.