Create this app:📋 UNIVERSAL ACCOUNTING ANALYZER - COMPREHENSIVE OVERVIEW 🎯 APPLICATION PURPOSE The Universal Accounting Analyzer is a professional desktop application designed specifically for BVA Incorporated and other audit firms to perform sophisticated accounting analysis and audit procedures. 🏢 TARGET USER: BVA Incorporated Audit, tax and advisory firm in Cape Town, South Africa ~20 people in the firm Managing Director: Carel Jordaan (17 years auditing experience, IRBA registered) Standards: IFRS, IFRS for SMEs, International Standards on Auditing Deployment: Local desktop application on each auditor's laptop 🔧 CORE FUNCTIONALITY 1. Client Management Create and manage audit clients Store client information and descriptions Track client data and import history 2. Data Import & Processing Excel files (.xlsx, .xls) - Trial Balance and General Ledger data CSV/TSV files - General Ledger transactions Comprehensive validation - Data integrity checks and error reporting Import logging - Complete audit trail of all data imports 3. Reconciliation Analysis Trial Balance reconciliation using proper accounting logic Balance Sheet accounts: Expected = Opening + GL Movement Income Statement accounts: Expected = GL Movement Equity accounts: Expected = Opening + Sum(Income Opening Balances) Difference identification with detailed explanations Export capabilities for audit documentation 4. Sankey Analysis (Cash Flow Visualization) Interactive account selection with rich context Transaction flow visualization between accounts Configurable parameters (transaction types, flow limits) Visual cash flow diagrams for audit understanding Export functionality for client presentations 5. Correlation Analysis Multi-account correlation for audit risk assessment Statistical analysis (Pearson/Spearman correlations) Time-based analysis (Monthly/Quarterly/Yearly) Source/target account selection with directional flows Exception identification for audit testing focus 6. Advanced Audit Process Flow Analysis Visual business process modeling (BPMN-compliant) Multi-leg transaction analysis (3-way, 4-way correlations) Expected vs Actual analysis with exception scoring Audit-specific templates (Sales cycle, Purchase cycle, etc.) Exception investigation with risk-based prioritization 🎨 DESIGN PHILOSOPHY Minimalistic & Professional (BVA Preference) Clean, uncluttered interface with subtle shadows Muted color palette (whites, grays, professional blues) Typography hierarchy for easy reading Responsive design for various screen sizes User Experience Focus Progress indicators for long operations Rich account context with detailed descriptions Summary data for complex datasets Clear visual feedback during processing Intuitive navigation with tab-based interface 🏗️ TECHNICAL ARCHITECTURE Backend (Python/Flask) Flask web framework with RESTful API design SQLite database (perfect for single-user desktop deployment) SQLAlchemy ORM with proper relationships Service layer architecture for business logic separation Comprehensive logging with structured output Data validation at multiple layers Frontend (HTML/CSS/JavaScript) Single-page application with tab navigation Vanilla JavaScript (no complex frameworks) Responsive CSS Grid/Flexbox layout Professional styling matching BVA preferences Real-time progress indicators and status updates Data Processing Pandas integration for efficient data analysis Excel/CSV/TSV support with robust parsing Statistical calculations for correlation analysis Financial calculations with Decimal precision Export capabilities (Excel, CSV, JSON) 🔒 SECURITY & DEPLOYMENT Local Desktop Application No authentication required (runs on user's secure laptop) No network dependencies (except for installation) Data privacy (all data stays on user's machine) Secure by design (no external data transmission) Windows Deployment Professional installer (.exe) for easy deployment Program Files installation with shortcuts and icons No Python installation required (self-contained) Automatic updates capability for future versions 📊 AUDIT-SPECIFIC FEATURES Business Process Understanding Process templates for common audit cycles Multi-dimensional analysis for complex transactions Exception identification for focused testing Risk-based prioritization for audit efficiency Professional Documentation Comprehensive export options for audit files Detailed analysis reports with explanations Visual presentations for client meetings Audit trail maintenance for regulatory compliance 🎯 VALUE PROPOSITION FOR BVA Efficiency: Automate complex analysis that would take hours manually Accuracy: Eliminate human error in calculations and reconciliations Insight: Identify patterns and exceptions not visible in spreadsheets Professional: Generate client-ready visualizations and reports Compliance: Maintain proper audit documentation and trails Scalability: Handle clients of any size with consistent methodology This application transforms traditional audit procedures into sophisticated, visual, and efficient analysis workflows while maintaining the professional standards required for audit practice. - Initial Deployment
verified 
