A lightweight Windows desktop application that converts bank statement PDFs into structured, standardized Excel workbooks (.xlsx) with balance verification and Excel formulas.

Built with a classic Windows XP Luna-inspired interface (#ECE9D8), the application aims to provide fast startup, clear display on high-DPI screens, and accurate balance checks against the original bank statement.

Development Note: This application was built through vibecoding with AI assistance. AI helped with code generation, parsing logic, debugging, handling different PDF layouts, and designing the desktop interface.

• PDF Balance Comparison: Uses the running balances printed in the bank statement as a reference for checking extracted transactions and identifying discrepancies.
• Excel Formulas: Generates formulas for running balances, verification checks, discrepancy warnings, and debit/credit totals.
• Multiple Date Formats: Attempts to recognize different date formats used in Indian and international bank statements, such as 16 Jun 19, 16 Jun 2019, Jun 16, 2019, 16/06/2019, and 2019-06-16.
• Balancing Figure & Noise Detection: Attempts to identify non-transactional entries such as By Balance c/d, To Balance c/f, TOTAL, and STATEMENT SUMMARY, as well as unrelated text appearing after transactions.
• Amount Recovery: Where supported by the extracted data, uses changes between consecutive balances to help identify missing debit or credit amounts.
• Conversion History: Keeps a history of previous conversions, including timestamps, statuses, and transaction counts. Double-clicking a record can open the workbook or its containing folder.
• Clear Form: Resets the form inputs, logs, and status indicators.
• Windows Installer: Supports packaging the application with PyInstaller and Inno Setup for easier installation on Windows.

1. Select Statement PDF: Choose the bank statement PDF and enter its password if required.
2. Enter First Transaction Date: Provide the first transaction date, such as 16/06/2019 or 16 Jun 19, to help the application locate the transaction table.
3. Enter Balances (Optional): Provide the opening balance or expected closing balance if known. The application may also identify balance information from the statement itself.
4. Convert and Check: The application extracts transaction information, checks the balances using its implemented verification logic, and creates the Excel workbook.
5. Review the Results: Check the verification status in the application or open the generated workbook to inspect the extracted data and formulas.

The exported workbook is designed to use the following structure:

The actual output depends on the data successfully extracted from the source PDF. Always compare the results with the original statement.

• Python 3.10+ — Main application
• Tkinter & ttk — Desktop interface
• pdfplumber — Extracting text and positional information from PDFs
• pandas — Organizing transaction data
• openpyxl — Creating and formatting Excel workbooks
• Pillow (PIL) — Image and icon processing
• PyInstaller — Packaging the application
• Inno Setup — Creating the Windows installer

If a release is available, download it from the Releases page.

1. Download BankStatementConverter_Setup.exe.
2. Run the installer.
3. Choose whether to create a desktop shortcut, if offered.
4. Launch the application.

Note: The installer must be published on the Releases page before it can be downloaded this way.

1. Clone the repository

git clone https://github.com/Batatatab/bank-statement-converter.git
cd bank-statement-converter

2. Create and activate a virtual environment

python -m venv venv
.\venv\Scripts\activate

3. Install dependencies

pip install -r requirements.txt

4. Run the application

python app_gui.py

These steps assume that the required files and tools are present in the repository.

1. Build the application with PyInstaller

pyinstaller --noconsole --onedir --clean --icon=app_icon.ico --add-data "app_icon.ico;." --name "BankStatementConverter" app_gui.py

2. Compile the installer with Inno Setup

& "C:\Program Files (x86)\Inno Setup 6\ISCC.exe" "installer.iss"

The installer output location depends on the configuration in installer.iss. For example, it may be generated at:

dist_installer/BankStatementConverter_Setup.exe

This is an open-source, vibecoded project. AI tools were used extensively to help build the application, write and understand code, troubleshoot errors, and improve the interface.

I'm learning programming while working on this project. The tool is still evolving, and there is more work to do, particularly in handling different bank statement layouts and improving extraction accuracy.

Suggestions, bug reports, and contributions are welcome.

1. Not Professional Advice: This application is an independent utility intended to assist with document processing. It does not provide financial, accounting, legal, tax, or statutory audit advice.
2. Verify the Results: PDF extraction can be affected by document quality, scanned pages, font encoding, and changes in layout. Always cross-check extracted dates, amounts, and balances against the original bank statement before using the results for bookkeeping, tax filings, GST returns, or audits.
3. No Bank Affiliation: This project is not endorsed by, affiliated with, or sponsored by any bank or financial institution. All referenced trademarks belong to their respective owners.
4. Software Provided As-Is: This software is distributed under the MIT License, without warranties or guarantees. The authors and contributors are not responsible for losses or inaccuracies arising from its use.

Distributed under the MIT License. See LICENSE for details.