5.1 KiB
ABANCA – Banking Statement Analysis & Automation Platform
Overview
ABANCA is a Python-based financial automation and banking statement analysis platform developed to process, classify and visualize banking transaction data automatically.
The project focuses on automating financial workflows through:
- Excel data processing
- Banking transaction normalization
- Financial classification
- KPI generation
- Automated reporting
- Data visualization
The notebook combines data science techniques with financial process automation to simplify banking reconciliation and financial monitoring operations. :contentReference[oaicite:0]{index=0}
Main Features
Banking Statement Processing
- Import banking statement files
- Automatic data normalization
- Transaction categorization
- Financial movement processing
- Date formatting automation
Financial Classification
The system automatically classifies:
- Debit transactions
- Credit transactions
- Banking movements
- Financial operations
- Account balances
Data Cleaning & Transformation
- Null value handling
- Currency normalization
- Column standardization
- Duplicate detection
- Invalid entry filtering
Financial Reporting
- Summary generation
- KPI calculations
- Transaction statistics
- Balance analysis
- Aggregated reporting
Technologies Used
| Technology | Purpose |
|---|---|
| Python | Main programming language |
| Pandas | Financial data processing |
| NumPy | Numerical operations |
| Matplotlib | Data visualization |
| OpenPyXL | Excel compatibility |
| Jupyter Notebook | Interactive development environment |
Project Structure
.
├── ABANCA.ipynb
├── Input_Files/
├── Output_Reports/
├── Charts/
└── README.md
Requirements
Python Version
Python 3.10+
Required Libraries
Install dependencies:
pip install pandas numpy matplotlib openpyxl
Running the Application
Launch Jupyter Notebook:
jupyter notebook
Open:
ABANCA.ipynb
Execute all notebook cells sequentially.
Supported Input Formats
| Format | Description |
|---|---|
.xlsx |
Excel banking statements |
.csv |
Transaction exports |
.xls |
Legacy Excel statements |
Main Functionalities
Transaction Analysis
The system processes:
- Transaction dates
- Descriptions
- References
- Debit values
- Credit values
- Running balances
Financial Aggregation
The notebook automatically generates:
- Daily summaries
- Monthly summaries
- Account movement analysis
- Transaction frequency statistics
- Financial totals
Data Visualization
The project supports:
- Financial charts
- Transaction trend analysis
- KPI dashboards
- Summary visualizations
Workflow
Bank Statement Import
↓
Data Cleaning
↓
Normalization
↓
Transaction Classification
↓
Financial Aggregation
↓
KPI Calculation
↓
Report Generation
↓
Visualization
Generated Output
The system can generate:
- Cleaned Excel files
- Financial summaries
- Transaction reports
- KPI analysis
- Graphical dashboards
Data Processing Capabilities
Cleaning Operations
- Empty row removal
- Date parsing
- Numeric conversion
- Currency formatting
- Invalid record filtering
Analysis Operations
- Movement counting
- Total debit calculation
- Total credit calculation
- Net balance computation
- Financial trend analysis
Intended Use Cases
- Banking reconciliation
- Treasury analysis
- Financial auditing
- Banking statement normalization
- Financial KPI reporting
- Accounting support
- Financial automation workflows
Notebook Features
The notebook environment allows:
- Interactive analysis
- Dynamic filtering
- Incremental execution
- Rapid financial experimentation
- Visualization customization
Future Improvements
- PDF report export
- Power BI integration
- Database integration
- Real-time banking synchronization
- AI-assisted financial anomaly detection
- Automated reconciliation engine
- Web dashboard interface
Security Notes
This project may process sensitive financial data.
Users should:
- Protect banking files
- Avoid sharing sensitive exports
- Secure generated reports
- Validate all processed outputs before operational usage
Disclaimer
This project was developed for financial automation and analytical purposes.
Users remain responsible for validating all financial calculations and generated reports before official or accounting usage.
Author
José Garcia
Data Scientist
Process Digitalization & Automation