BSA (Bank Statement Analysis)

1. Overview

The BSA (Bank Statement Analysis) tool is a comprehensive web-based application designed for analyzing bank statements and financial documents. It provides advanced text extraction, pattern recognition, data visualization, and search capabilities to help investigators and analysts process large volumes of financial documents efficiently.

2. Key Features

3. Getting Started

System Requirements

• Modern web browser (Chrome, Firefox, Safari, Edge)
• JavaScript enabled
• Internet connection (for CDN resources)
• Minimum 4GB RAM recommended
• Sufficient storage for uploaded files

Accessing the Application

1. Open your web browser
2. Navigate to the BSA application URL
3. Wait for the application to load completely
4. Verify that all interface elements are visible
5. Check that the file upload buttons are functional

4. File Upload & Processing

Upload Methods

Method 1: Individual File Upload

1. Click the 📁 Upload Files button in the navigation bar
2. Select one or multiple files from your computer
3. Choose files with supported extensions (.pdf, .csv, .txt, .xlsx, .xls, .doc, .docx, .html, .zip)
4. Click "Open" to start processing
5. Monitor the progress bar for processing status

Method 2: Folder Upload

1. Click the 📂 Upload Folder button
2. Select a folder containing multiple files
3. The system will automatically filter supported file types
4. All compatible files in the folder will be processed
5. Check the sidebar for uploaded file status

Supported File Formats

File Type	Extension	Processing Method	Special Features
PDF Documents	.pdf	Text extraction via PDF.js	Multi-page support, OCR-ready
CSV Files	.csv	Direct text parsing	Structured data extraction
Text Files	.txt	Direct text reading	Plain text processing
Excel Files	.xlsx, .xls	SheetJS library	Multi-sheet support
Word Documents	.doc, .docx	Text extraction	Formatted text processing
HTML Files	.html	DOM parsing	Web content extraction
ZIP Archives	.zip	JSZip library	Nested file processing

Processing Status Indicators

• Processing - File is currently being analyzed
• Completed - File has been successfully processed
• Error - Processing failed, check file format

5. Data Extraction & Analysis

Automatic Pattern Recognition

The BSA tool automatically extracts and categorizes the following patterns from uploaded documents:

IFSC Codes (Indian Financial System Codes)

• Format: 4-letter bank code + 7-digit code
• Example: SBIN0001234
• Used for bank branch identification
• Stored with context information

VPA IDs (Virtual Payment Addresses)

• UPI payment addresses
• Supported suffixes: @paytm, @okaxis, @ybl, etc.
• Example: user@paytm
• Extracted with surrounding context

RRN Numbers (Retrieval Reference Numbers)

• 12-digit unique transaction identifiers
• Format: Numeric sequence
• Used for transaction tracking
• Extracted with transaction details

Mobile Numbers

• Indian mobile number format
• Supports +91, 91, 091 prefixes
• 10-digit mobile numbers
• Validates number format

Data Organization

Extracted data is organized into collapsible sections for easy navigation:

• File-specific sections for each uploaded document
• Count indicators showing number of matches
• Context information for each extracted item
• Expandable/collapsible sections for better organization
• Search functionality within extracted data

Common Data Analysis

The system identifies common patterns across multiple files:

• Cross-file pattern matching
• Frequency analysis of extracted data
• Common IFSC codes across documents
• Shared VPA addresses
• Repeated RRN numbers
• Common mobile numbers

6. Data Visualization

Interactive Network Graphs

The visualization feature creates interactive network graphs showing relationships between files and extracted data:

Graph Types

• IFSC Codes Graph: Shows connections between files and bank branches
• VPA IDs Graph: Displays payment address relationships
• RRN Numbers Graph: Maps transaction reference connections
• Mobile Numbers Graph: Shows phone number associations

Graph Controls

• Mouse Wheel: Zoom in and out of the graph
• Drag: Pan and move around the graph
• Double-click Node: Delete specific nodes
• Hover: Show tooltips with detailed information
• Click: Highlight connected nodes

Visualization Controls

• Data Type Selection: Choose which data to visualize
• Reset Zoom: Return to original view
• Fullscreen Mode: Expand graph to full screen
• Export Graph: Save graph as image

Graph Features

• Dynamic node positioning using D3.js force simulation
• Color-coded nodes for different data types
• Interactive links showing relationships
• Responsive design that adapts to screen size
• Real-time updates when data changes

7. Search Functionality

Advanced Search Features

The search functionality allows you to find specific terms across all uploaded documents:

Search Process

1. Navigate to the "Search Results" tab
2. Enter keywords in the search textarea
3. Separate multiple keywords with commas
4. Click the "Search" button
5. Review results organized by file

Search Capabilities

• Multi-keyword Search: Search for multiple terms simultaneously
• Case-insensitive: Matches regardless of case
• Context Display: Shows surrounding text for each match
• File Organization: Results grouped by source file
• Highlighted Terms: Search terms are highlighted in results

Search Tips

• Use specific terms for better results
• Combine related keywords for comprehensive search
• Search for partial terms to find variations
• Use file-specific search for targeted analysis

Search Results Display

• Results organized by source file
• Context information for each match
• Highlighted search terms
• File name and location information
• Easy navigation between results

8. File Management

File Manager Panel

The File Manager provides comprehensive control over uploaded and analyzed files:

Accessing File Manager

• Click the 📋 File Manager button in the navigation
• Use keyboard shortcut Ctrl+F (or Cmd+F on Mac)
• Panel opens on the right side of the interface

Uploaded Files Section

• File List: Complete list of uploaded files
• Status Indicators: Processing, completed, or error status
• File Information: Name, size, and processing status
• Bulk Operations: Select all or clear all files
• Individual Control: Remove specific files

Analysis Files Section

• Analysis Selection: Choose files for detailed analysis
• Checkbox Control: Select/deselect individual files
• Analysis Status: Track which files are being analyzed
• Remove from Analysis: Exclude files from analysis

File Operations

Bulk Operations

• Select All: Choose all uploaded files
• Clear All: Remove all files from selection
• Batch Processing: Process multiple files simultaneously

Individual File Control

• Remove File: Delete specific files from the list
• View Details: See file information and status
• Re-process: Re-analyze files if needed

Sidebar File List

• Quick Access: View all uploaded files
• Status Overview: See processing status at a glance
• Collapsible: Toggle sidebar visibility
• File Selection: Click to view file details

9. Keyboard Shortcuts

Shortcut	Action	Description
Ctrl+F / Cmd+F	Toggle File Manager	Open or close the file management panel
Mouse Wheel	Graph Zoom	Zoom in/out of visualization graphs
Drag	Graph Pan	Move around in visualization graphs
Double-click Node	Delete Node	Remove specific nodes from graphs
Hover	Show Tooltips	Display detailed information on graph elements

10. Troubleshooting

Common Issues and Solutions

File Upload Issues

• Check File Format: Ensure files are in supported formats
• File Size: Large files may take longer to process
• Browser Compatibility: Use modern browsers (Chrome, Firefox, Safari, Edge)
• Internet Connection: Ensure stable connection for CDN resources
• JavaScript: Enable JavaScript in your browser

Processing Errors

• Password Protection: Remove password protection from PDF files
• File Corruption: Try re-downloading or re-saving the file
• Format Issues: Convert files to standard formats
• Browser Cache: Clear browser cache and try again

Performance Issues

• Close Other Tabs: Reduce browser memory usage
• Restart Browser: Clear memory and cache
• Check System Resources: Ensure sufficient RAM and CPU
• Reduce File Size: Process smaller batches of files

Visualization Issues

• Check Data: Ensure data has been extracted successfully
• Browser Compatibility: Use modern browsers with D3.js support
• Refresh Page: Reload the application
• Clear Cache: Clear browser cache and cookies

Best Practices

• Regular Saves: Export important data regularly
• Batch Processing: Process files in smaller batches for better performance
• File Organization: Use descriptive file names for easier identification
• Backup Data: Keep copies of important files
• Update Browser: Use the latest browser versions

Support Information

Conclusion

The BSA (Bank Statement Analysis) tool provides a comprehensive solution for analyzing financial documents and extracting valuable insights. With its advanced pattern recognition, interactive visualizations, and powerful search capabilities, it serves as an essential tool for financial investigators and analysts.