Skip to content

About

This Python-based automation tool streamlines the bank reconciliation process by downloading bank statements in CSV format directly from a banking portal using Selenium. It then compares the bank records with internal financial records to highlight unmatched entries and discrepancies.

Resources

Stars

3 stars

Watchers

1 watching

Forks

Repository files navigation

💰 Bank Reconciliation Automation Tool

Python Docker License Build

A powerful automation tool built with Python to perform high-speed, reliable bank transaction reconciliation.
Perfect for accountants, businesses, and devs who are tired of doing it manually.


🚀 Features

  • 🔍 Automatic Reconciliation of bank transactions
  • 📊 Supports Excel (.xlsx) and CSV formats
  • ✅ Detects and highlights mismatches
  • 📁 Outputs easy-to-read reports
  • 🐳 Dockerized for smooth deployment anywhere
  • 🧪 Test coverage via pytest
  • ⚙️ Modular design, easy to extend

📦 Tech Stack

  • Python 3.12
  • pandas, numpy, openpyxl, selenium
  • Docker 🐳
  • Pytest for testing
  • sqlite

⚙️ Installation & Usage

🔧 Local Setup

git clone https://github.com/yourusername/bankAutomation.git
cd bankAutomation
pip install -r requirements.txt
python app/reconciler.py

###🐳 Docker Setup

# Build the Docker image
docker build -t bank-reconciliation-tool .

# Run the container (mounting local data folder)
docker run -v $(pwd)/data:/app/data bank-reconciliation-tool

About

This Python-based automation tool streamlines the bank reconciliation process by downloading bank statements in CSV format directly from a banking portal using Selenium. It then compares the bank records with internal financial records to highlight unmatched entries and discrepancies.

Resources

Stars

3 stars

Watchers

1 watching

Forks

Releases

Packages

Used by

Contributors

Languages