
StatementIQ – Bank Statement Parser & Tally XML Transformer
StatementIQ is an enterprise document intelligence platform engineered for chartered accountants, tax auditors, and corporate finance departments. It converts complex bank statement PDFs—including password-encrypted files and low-resolution physical scans—into mathematically validated Excel workbooks and native Tally ERP XML vouchers.
Backed by a hybrid extraction engine combining pdfplumber, pikepdf, Tesseract OCR, and Claude Vision AI, StatementIQ validates opening and closing balances, detects transaction categories automatically, and enforces bank-grade zero-retention privacy with automated 7-day file purges.
- Services:PDF Statement Parsing, OCR Extraction, Tally XML Generation
- Client:Chartered Accountants, Tax Firms & Credit Teams
- Industry:FinTech / Accounting Automation
Project Requirement
Accounting firms and financial auditors manually type thousands of transaction lines from bank statements into Tally and accounting software every month. Scanned PDFs, skewed camera photos, and encrypted statement files cause immense delays and high entry error rates during quarterly audits.
The goal was to build a high-throughput, multi-bank parsing pipeline capable of decrypting password-protected statements, reading tabular transaction columns from scanned images, auto-verifying running ledger balances, and generating native Tally XML files for one-click import.
Multi-Bank PDF & Scanned Image Extraction
Password-Protected PDF Unlocking via pikepdf
Running Balance & Ledger Verification Engine
Native Tally ERP XML & Excel Voucher Exports
Optical Character Recognition via Tesseract OCR
7-Day Auto-Purge Zero-Retention Security
Solution & Result
Skylink engineered a microservices pipeline utilizing Python 3.12, FastAPI, and Redis task queues. Digital PDFs are parsed via pdfplumber with table coordinate boundary detection, while scanned and physical statement photos route through an image pre-processing pipeline and Tesseract OCR / Claude Vision for extraction.
Every extracted ledger row undergoes checksum verification where each transaction debit/credit must reconcile with previous and next balances before export. Validated records are converted into Tally XML format ready for instant import. StatementIQ slashed monthly reconciliation time from days to seconds while eliminating manual typing errors.


