v1.1.0 Bank Statement Converter — First Stable Release

Bank Statement Converter v1.1.0 (Official Release)

This marks the first stable release of Bank Statement to Excel Converter.This release brings a brand-new conversion history tracker, a universal multi-format date parser, and native dynamic Excel audit formulas.

---

What's New in the Stable Release

1. Interactive Conversion History & Quick Launch

• Recent Conversions Panel: Tracks past statements directly in the UI with status verdicts, converted row counts, and timestamps.
• Direct File & Folder Launch: Double-click any record (or use the action buttons) to open the generated workbook directly in Microsoft Excel or jump to its output directory in Windows File Explorer.
• Dedicated Form Reset: Added a Clear Form button to instantly reset file paths, balances, logs, and verdict cards between runs.

2. Universal Sliding-Window Date Engine

• Multi-Token Textual Dates: Dynamically parses space- and hyphen-separated dates across all Indian and international formats (e.g., 16 Jun 19, 16 Jun 2019, Jun 16, 2019, 16/06/2019, 2019-06-16).
• Narration Isolation: Isolates Value Date and Transaction Date tokens from table columns so dates never bleed into the particulars/narration fields.
• Flexible Column Alignments: Adaptively detects reversed column layouts where Deposit / Credit precedes Withdrawal / Debit.

3. Audit-Grade Reconciliation & Native Excel Formulas

• Strict PDF Balance Precedence: Locks the bank's printed running balance 1:1 across every row, preventing artificial rounding or calculation drift.
• Dynamic Formula Injection: Generates live =SUM() grand totals and interactive running balance formulas (=PrevBal - Debit + Credit or Overdraft =PrevBal + Debit - Credit).
• Live Discrepancy Warnings: Employs dynamic =IF() comparison formulas to flag any math variance against the source PDF in real time.
• Delta-Derived Amount Recovery: Populates missing Debit or Credit entries directly from balance movements ($\Delta \text{Balance}$) when physical column grids shift.
• Statement Cutoff Guard: Automatically suppresses trailing statutory annexures, tax disclaimers (Form 15G/15H), and web-converter watermarks.

4. Packaging & Desktop Performance

• Sub-Second Cold Launch: Packaged via pre-extracted runtime architecture, opening in under one second on modern Windows 64-bit systems.
• Dedicated Windows Installer: Includes BankStatementConverter_Setup.exe with optional desktop shortcut toggle, Start Menu integration, and clean uninstallation support.
• High-DPI Awareness: Native Per-Monitor DPI scaling with crisp classic Windows XP Luna styling.

---

Installation & Usage

1. Download BankStatementConverter_Setup.exe under Assets below.
2. Run the installer and choose whether to create a desktop shortcut.
3. Open the app, select your bank statement PDF, enter the First Transaction Date, and click Convert and Reconcile.

---

Verified against major Indian banking formats, including ICICI Bank, State Bank of India (SBI), HDFC Bank, Kotak Mahindra Bank, Standard Chartered, Bank of Baroda, IDFC Bank.

v1.0.1(Beta) Bank Statement Converter

What's New in v1.0.1 (Beta)

Packaging & Performance

• Standalone Setup Wizard: Available as a standard Windows installer (BankStatementConverter_Setup.exe) with an optional desktop shortcut toggle and Start Menu registration.
• Fast Startup: Switched to a pre-extracted runtime architecture, cutting application cold launch times from 10–15 seconds down to under 1 second.
• Optimized UI & High-DPI: Lightweight Windows XP layout with high-DPI scaling support, proper taskbar grouping, and high-resolution multi-layer icon rendering.

Core Extraction Engine & Reconciliation

• Strict PDF Balance Precedence: Printed bank statement running balances now take absolute priority across every transaction row, eliminating theoretical calculation drift.
• Auto-Detection of Closing Markers: Intelligently identifies ledger balancing figures (Balance c/d, TOTAL, Bal c/f) to anchor expected closing balances without duplicating them as live transactions.
• Noise & Annexure Suppression: Cleanly cuts off multi-page legal legends, terms, and web-converter watermarks at statement boundaries to prevent text bleeding into transaction narrations.
• Thread-Safe Processing: Isolated background worker threads with synchronized UI dispatching to ensure smooth operation during large, multi-page statement conversions.

---

Installation

1. Download BankStatementConverter_Setup.exe below.
2. Run the installer and check "Create a desktop shortcut" if desired.
3. Launch and select your statement PDF to convert.

v1.0.0(beta) Bank Statement Converter

Bank Statement Converter v1.0.0

A standalone desktop application designed to standardize, reconcile, and convert complex Indian bank statement PDFs into audit-ready Excel ledgers with automated running balance verification.

---

Highlights & Core Features

• Multi-Format Extraction Engine:

  • Hybrid parsing pipeline combining line-geometry grid extraction and horizontal coordinate-interval binning for borderless statements.
  • Tested across diverse Indian banking formats (including SBI, IDFC FIRST, Bank of Baroda, Kotak Mahindra, IndusInd, and HDFC).

• Layout & Data Normalization:

  • Reverse Chronology Handling: Automatically detects statements ordered newest-to-oldest and realigns them chronologically forward for double-entry calculation.
  • Dynamic Column Alignment: Correctly resolves non-standard layouts (e.g., statements with reference numbers in column 1, credit before debit, or narrations in the final column).
  • Resilient Header Matching: Recognizes past-tense and variant headers (Credited Amount, Debited Amount, Cheque/Reference#) without text collisions.
  • Multi-Page Layout Persistence: Maintains locked column intervals across pages where tables lack repeated header rows.
  • Noise Suppression: Discards summary boxes (Total Debit, Total Credit), reward points sections, table totals, and dummy reference placeholders (000000).

• Ledger Reconciliation & Verification:

  • Automatic Opening Balance Deduction: Automatically computes opening balance from initial transaction movement if omitted or unlisted on the statement.
  • Strict Mutual Exclusivity: Properly isolates Dr/Cr movements and prevents merged amount columns from misbalancing.
  • Reconciliation Verdict Card: Real-time visual feedback within the GUI comparing the final computed balance against the bank statement's reported closing balance down to the paisa.

• Audit-Ready Excel Export:

  • Exports formatted .xlsx files with standard columns: Date, Ref No, Cheque No, Particulars, Dr, Cr, Bal, PDF Bal, Status, Warning.
  • Formatted with readable column widths and enabled text wrapping.
  • Includes optional header metadata (Account Holder Name, Account Number).

---

Installation & Usage

Option 1: Standalone Application (Windows)

1. Download BankStatementConverter.exe from the Assets section below.
2. Double-click to launch (no Python installation required).

Option 2: Run from Source

git clone https://github.com/Batatatab/bank-statement-converter.git
cd bank-statement-converter
pip install -r requirements.txt
python app_gui.py

Full Changelog: https://github.com/Batatatab/bank-statement-converter/commits/v1.0.0(Beta)