Bank statement to a checked Excel workbook, with Tally and income-tax tools. Fully offline: no AI model, API key or paid service.
StatementIQ · HDFC_Apr.pdf
| Date | Narration | Credit | Debit | Balance | Check |
|---|---|---|---|---|---|
| 01 Apr | Opening balance | 2,50,000 | — | ||
| 02 Apr | NEFT/INFOSYS LTD SALARY | 85,000 | 3,35,000 | VERIFIED | |
| 03 Apr | UPI/ACME TRADERS/RENT | 32,000 | 3,03,000 | VERIFIED | |
| 05 Apr | ACH/HDFC LOAN EMI | 18,450 | 2,84,550 | VERIFIED | |
| 07 Apr | CASH DEPOSIT BRANCHs.269ST | 2,00,000 | 4,84,550 | VERIFIED | |
| 09 Apr | CHQ RETURN 004512 | 4,200 | 4,82,150 | FLAGGED | |
| 12 Apr | GST PAYMENT CBIC | 26,300 | 4,55,850 | VERIFIED |
Latest: v2.3
Reuses your existing Tally ledgers: exact, tidied, alias and same-words matches.
Safer sends to Tally and clearer Tally error messages.
Handles empty companies, guards against sending to a company that isn't open, and adds a light bank-ledger report.
From reading the statement to the Tally voucher, the BRS and the tax review, in one offline tool.
Tag a counterparty as “Rent” or “Supplier Payment” and StatementIQ remembers it for that bank account. It can also learn from your Tally Day Book or live Tally. Every category shows where it came from, so reviewers always know what to trust.
Memory per bank account, never global. One client's choices never leak into another's books.
Export files or send vouchers straight into Tally. Guards on every step keep your books clean.
Review table with Suspense A/c option and a Not-in-Tally guard.
Reuses existing ledgers: exact, tidied, alias and same-words matches.
Bank ledger check, no double booking, only companies open in Tally.
Batches of 500 Payment, Receipt and Contra vouchers, direct or via a secure connector.
| Pattern | Section |
|---|---|
| Cash deposits | s.269ST, s.68, Rule 114B / 114E |
| Cash withdrawals | s.194N |
| Cheque / ECS / NACH returns | s.138 |
| Large & round-figure credits | s.68 |
| Rent, fees, contract, suppliers | s.194-I / 194J / 194C / 194Q |
| Interest credited | s.194A |
A CSV and a 40-page scanned PDF go through exactly the same checks.
| PDF (text layer) | Native text and table extraction |
| PDF (scanned / image) | Built-in OCR, page by page |
| Password-protected PDF | Opens the file only. The password is never stored or logged |
| CSV / TSV / TXT | Delimiter and encoding detected automatically |
| XLSX / XLSM | Formula results are read |
| XLS (legacy) | Supported, including net-banking exports |
Bank detection is a convenience, not a requirement. The parser works out the layout from the table itself.
No per-page or per-transaction charges, and no AI credits to top up. Self-hosted, on your terms.
StatementIQ v2.3
All features₹8,000 / year
StatementIQ converts a bank statement in PDF, scanned PDF, password-protected PDF, CSV, XLSX or XLS format into a checked Excel workbook. Every row is marked VERIFIED or FLAGGED by checking that previous balance + credit − debit equals the stated balance. It also groups counterparties, assigns categories, exports or sends vouchers to Tally, reconciles the statement against the Tally bank ledger (BRS) and highlights income-tax red flags.
No. StatementIQ is fully offline and deterministic. It uses no AI model, no API key and no paid service, and makes no network calls at runtime, so client data never leaves your machine or server.
StatementIQ can export Tally XML, a CSV daybook and a master sheet, or send vouchers directly to Tally in batches of 500 as Payment, Receipt or Contra entries. It reuses your existing ledgers, checks the bank ledger to prevent duplicates, never double-books existing vouchers, and only sends to companies currently open in Tally. It can connect directly or through a secure connector with a hashed token.
Cash deposits (s.269ST, s.68, Rule 114B/114E), cash withdrawals (s.194N), cheque, ECS and NACH returns (s.138), large and round-figure credits (s.68), rent, professional fees, contract and supplier payments (s.194-I, 194J, 194C, 194Q) and interest credited (s.194A).
Version 2.1 added reuse of existing Tally ledgers, 2.2 added safer sends and clearer Tally error messages, and 2.3 makes it reliable with real Tally: it handles empty companies, only sends to the company that is open, and adds a light bank-ledger report.
StatementIQ costs ₹8,000 per year for unlimited statements, banks, counterparties and custom categories, including Excel and Tally exports. There is no per-page or per-transaction charge.
Bring a bank statement to a 30-minute demo and watch it become a checked workbook and Tally vouchers.