Bank Statement Analysis
Flask-based application that analyses bank statements to generate interactive visualizations and analytical reports. Features include OCR-based data extraction, machine learning for transaction categorization, Azure SQL database integration, and PowerBI dashboards for expense tracking.
Overview
The Bank Statement Analyzer is an innovative application designed to help individuals gain insight into their spending habits. Utilizing modern technologies, it analyzes bank statements and delivers analytical reports on account expenses. This personal project not only enhances the user’s understanding of their financial habits but also serves as a practical exercise in several cutting-edge technologies, making it incredibly useful for anyone looking to take control of their finances.
With the help of Python's Flask framework, machine learning algorithms, and interactive data visualizations, this application simplifies the process of understanding financial data. Users can effortlessly navigate through transaction details, view dashboard selections, and upload their statements, thereby transforming complex data into actionable insights.
Features
-
Transaction Analysis: Automatically extracts and categorizes transaction details from uploaded bank statements using advanced OCR technology.
-
User-friendly Dashboard: Offers an intuitive dashboard view, allowing users to track their total spending and filter expenses by year or category.
-
Interactive Visualizations: Leverages PowerBI to create dynamic visualizations that provide a clear picture of spending habits based on approximately 3000 transaction samples.
-
SQL Database Integration: Utilizes an Azure SQL Database to securely store transaction data and user login credentials, ensuring data integrity and privacy.
-
Machine Learning Integration: Employs Scikit Learn to predict transaction categories, improving the accuracy of expense reports over time.
-
Local Run Capabilities: Easily run the application locally with a simple setup, using Docker to streamline the installation process.
-
Customizable SQL Database Setup: Provides a template for users to create their own SQL database, enabling the easy integration of personal financial data for tailored insights.
This combination of features makes the Bank Statement Analyzer an empowering tool for anyone aiming to gain a clearer understanding of their financial landscape.
- Docker
A website that uses Docker for containerization to streamline development, testing, and deployment workflows. This includes features such as containerization of dependencies, automated builds and deployments, and container orchestration to ensure scalability and availability.