What an AIS actually is
The Annual Information Statement is the tax department’s account of you. Every bank, exchange, registrar and buyer that reported a payment during the year is gathered into one PDF — not what you told them, but what everybody else told them about you.
It is also written for machines. Sections are labelled with information codes like TDS-194S, SFT-016(SB) and EXC-GSTR3B, and the document nests summaries over detail rows several levels deep. Most people opening it want three things: what have they been told I earned, how much tax has already been taken, and does any of it look wrong. This tool answers those in words rather than codes, and gives you the whole thing as a workbook.
The check that makes the numbers worth anything
An AIS contains its own arithmetic, and that is the lever this tool pulls. Every summary line states a total, and the individual payments printed beneath it must add up to that total.
So which column holds the money is never guessed from its heading. The column that sums to the printed figure is the money column.If no column adds up, the section says so rather than reporting a total nobody has verified. A tax figure that is confidently wrong is far more expensive than one clearly marked as unverified — you act on the first and check the second.
Sections it has not seen are shown, not dropped
This is the design decision that governs everything else. An AIS has no fixed shape: a TDS block gives quarter and deduction, a savings block gives account number and interest, a GST block gives return period and turnover. Three shapes, and no promise there are only three. Different taxpayers get different sections entirely.
A parser fitted to one example that silently discards the parts of a second one it does not recognise is worse than useless, because the total still looks plausible. So anything unrecognised is carried through and shown— with its own column names and its rows intact — rather than dropped. You may see a section the tool cannot label neatly. You will not silently lose one.
What to do with the output
- Compare against your own records. The AIS is what third parties reported. Where it disagrees with what you know, one of the two is wrong, and finding which is the entire point of reading it.
- Check the tax already deducted. TDS entries are money already paid on your behalf; missing them means paying twice.
- Look for entries you do not recognise at all. A reported transaction from a party you have never dealt with is worth raising, and the AIS has a feedback mechanism for exactly that.
This is not tax advice
Worth saying directly: this tool reads a document and adds up what it says. It does not compute your liability, does not decide what is taxable, and does not know your circumstances. It is a faster way to read your AIS and spot what needs attention — the return itself needs somebody qualified, working from the original statement.
Related
The AIS says what others reported. Your bank statement says what actually moved — the statement analyser reads that side, with a reconciliation check of its own, and PDF to Excel gives you the raw transactions if you would rather work with the rows. For slicing either one, the pivot table tool summarises a sheet without opening Excel.
Your statement
An AIS is a tax document with your PAN on it. The file is sent over an encrypted connection, read to produce your result, and discarded — not written to a database, not kept after your download, not used to train anything, not shared. Nothing about its contents is logged, and no account is required. Our privacy policy states it in full.