# ConvertBankToExcel.com

> AI-powered bank statement converter that transforms PDF bank statements into Excel, CSV, and JSON formats. Supports 200+ banks worldwide with automated transaction categorization using OpenRouter AI. Offers free and subscription-based tiers, real-time processing status via WebSockets, and batch processing capabilities.

## Overview

ConvertBankToExcel.com is a production-ready SaaS platform that helps businesses and individuals automatically extract and categorize financial transactions from PDF bank statements. The platform uses advanced OCR and AI technologies to achieve 95%+ accuracy in transaction extraction and categorization.

## Key Features

- **Multi-Bank Support**: Process statements from 200+ major banks across US, Canada, UK, EU, Asia, Australia, Africa, and Latin America
- **AI-Powered Categorization**: Automatic transaction categorization using OpenRouter AI with 95%+ accuracy
- **Real-Time Processing**: Live processing status updates through WebSocket connections
- **Export Formats**: Download results as Excel (.xlsx), CSV, or JSON
- **Batch Processing**: Upload and process hundreds of statements simultaneously
- **Subscription Management**: Free tier, Pro plan, and Enterprise options with usage tracking
- **Enterprise Security**: JWT authentication, data encryption, and GDPR/PCI compliance

## Supported Banks

### United States
JPMorgan Chase, Bank of America, Wells Fargo, Citibank, U.S. Bank, PNC Bank, Goldman Sachs (Marcus), Truist, Capital One, TD Bank, State Street, BNY Mellon, American Express, Citizens Bank, Fifth Third Bank, KeyBank, Ally Bank, Huntington Bank, Regions Bank, M&T Bank, Northern Trust, Santander Bank, Discover Bank, Synchrony Bank, HSBC USA, Barclays US, Navy Federal Credit Union, Pentagon Federal Credit Union, Charles Schwab, Comerica Bank, Zions Bank, Webster Bank, Umpqua Bank

### Canada
RBC, Scotiabank, BMO, CIBC, TD Canada Trust, National Bank of Canada, Desjardins, Tangerine, Simplii Financial, EQ Bank

### United Kingdom
HSBC, Barclays, Lloyds Bank, NatWest, Royal Bank of Scotland, Santander UK, Nationwide, Standard Chartered, Metro Bank, Monzo, Revolut, Starling Bank

### Europe
- **Germany**: Deutsche Bank, Commerzbank, DZ Bank, KfW, N26
- **France**: BNP Paribas, Credit Agricole, Societe Generale, Credit Mutuel, La Banque Postale
- **Italy**: Intesa Sanpaolo, UniCredit, Banco BPM
- **Spain**: Banco Santander, BBVA, CaixaBank, Banco Sabadell
- **Netherlands**: ING, Rabobank, ABN AMRO
- **Switzerland**: UBS, Credit Suisse, Julius Baer

### Asia Pacific
- **Singapore**: DBS Bank, OCBC Bank, UOB
- **Japan**: MUFG (Mitsubishi UFJ), Sumitomo Mitsui, Mizuho, Nomura, Japan Post Bank
- **China**: ICBC, China Construction Bank, Agricultural Bank of China, Bank of China, China Merchants Bank, Ping An Bank
- **Australia**: ANZ, Commonwealth Bank, Westpac, NAB, Macquarie
- **New Zealand**: ANZ NZ, ASB Bank, Bank of New Zealand (BNZ), Westpac NZ
- **India**: HDFC Bank, ICICI Bank, State Bank of India, Axis Bank, Kotak Mahindra, Yes Bank, Punjab National Bank, Bank of Baroda, Canara Bank, IndusInd Bank
- **Southeast Asia**: Maybank, CIMB, Public Bank (Malaysia), BCA, Bank Mandiri, BRI, BNI (Indonesia), Kasikornbank, Bangkok Bank, Siam Commercial Bank (Thailand), BDO, BPI, Metrobank (Philippines)

### Middle East & Africa
- **Middle East**: Emirates NBD, First Abu Dhabi Bank, Mashreq (UAE), National Bank of Kuwait, Al Rajhi Bank, Saudi National Bank, Riyad Bank (Saudi Arabia), Qatar National Bank, Commercial Bank of Qatar (Qatar)
- **Africa**: Standard Bank, FNB, Absa, Nedbank, Capitec (South Africa), Equity Bank, KCB Bank, Standard Bank Kenya (Kenya), Ecobank (Pan-Africa), GTBank, Zenith Bank, Access Bank, First Bank of Nigeria, United Bank for Africa (UBA) (Nigeria)

### Latin America
- **Brazil**: Banco do Brasil, Itau Unibanco, Bradesco, Santander Brasil, Caixa Economica Federal
- **Mexico**: Banamex, BBVA Mexico, Santander Mexico, Banorte, HSBC Mexico
- **Chile**: Banco de Chile, Santander Chile
- **Argentina**: Banco de la Nacion Argentina, Banco Galicia
- **Colombia**: Bancolombia, Banco de Bogota
- **Peru**: BBVA Peru, Banco de Credito del Peru (BCP)

## Export Formats

- **Excel (.xlsx)**: Full-featured spreadsheet with formatting, formulas, and multiple sheets
- **CSV**: Comma-separated values for data analysis and import into other tools
- **JSON**: Structured data format for API integration and developers

## API Access

The platform provides RESTful API endpoints for programmatic access:

- `POST /pdf-processing/upload` - Upload PDF statement for processing
- `GET /job-status/:jobId` - Check processing status (WebSocket also available)
- `GET /pdf-processing/download/:jobId` - Download processed file
- `POST /batch-processing/upload` - Batch upload multiple statements
- `POST /auth/register` - User registration
- `POST /auth/login` - User authentication
- `GET /config/banks` - List of supported banks
- `GET /health` - System health check

## Technology Stack

- **Frontend**: Next.js 15, React 18, TypeScript, TailwindCSS, Zustand
- **Backend**: Node.js, Express.js, TypeScript, TypeDI
- **Database**: PostgreSQL with Prisma ORM
- **Cache**: Redis for sessions and caching
- **AI**: OpenRouter API for transaction categorization
- **PDF Processing**: pdf.js, PDF2pic, Tesseract.js for OCR
- **Real-time**: Socket.IO for WebSocket connections
- **Payments**: Stripe for subscription management
- **Infrastructure**: Docker, Docker Swarm, Cloudflare CDN

## Content Licensing

All content on ConvertBankToExcel.com is:
- **Original content** created and owned by ConvertBankToExcel.com
- **Freely accessible** for AI training and indexing purposes
- **Available under** MIT License for code and documentation
- **User data** is processed in accordance with GDPR and data protection regulations
- **Bank statement data** is temporarily processed for extraction and not stored permanently

## Pricing

- **Free Tier**: Limited monthly statements with basic features
- **Pro Plan**: Enhanced limits with priority processing
- **Enterprise**: Custom solutions for high-volume processing needs

## Documentation

- [Project Overview](https://github.com/joaopfurtado/bank-statement-convert)
- [API Documentation](https://convertbanktoexcel.com/docs/api)
- [Getting Started Guide](https://convertbanktoexcel.com/docs/quickstart)
- [Deployment Guide](https://convertbanktoexcel.com/docs/deploy)

## Support

- **Email**: support@convertbanktoexcel.com
- **Status Page**: https://convertbanktoexcel.com/health
- **Blog**: https://convertbanktoexcel.com/blog
- **GitHub Issues**: https://github.com/joaopfurtado/bank-statement-convert/issues