Architecture Overview
System Overview
LostmindAI PropTech Backend v1 is an enterprise-grade PropTech financial automation platform that transforms complex Excel-based property accounting processes into an intelligent, scalable, AI-powered microservices architecture serving the Australian commercial real estate industry.Key Components
- Data Sanitisation Engine: Privacy-safe processing of Knight Frank Excel data
- SQL Schema Generator: Automated database structure creation from Excel analysis
- AI Integration Layer: UnifiedAIClient with TurboRepo ai-compute integration
- Microservices Foundation: AI-enhanced AccrualCalculator and processing services
- Compliance Layer: Australian data sovereignty with Gemma local model support
- Security Framework: Zero hardcoded secrets with comprehensive audit trails
Technical Stack
Core Technologies
- Backend: Python with FastAPI microservices
- Database: PostgreSQL with advanced financial data structures
- AI/ML: Google Generative AI (Gemini), Local Gemma for compliance
- Data Processing: Advanced Excel analysis (20 worksheets, 16,000+ transactions)
- Security: Row Level Security, comprehensive audit logging
Processing Capabilities
- 16,598 General Ledger transactions
- 2,084 Accounts Payable records
- 3,504 Chart of Accounts mappings
- VBA Macro automation integration
- MRI System SQL connectivity
Design Decisions
AI-First Architecture
- UnifiedAIClient: Modern service-oriented AI integration
- Australian Compliance: PropTech-specific AI with data sovereignty
- Intelligent Processing: AI-enhanced variance explanation and validation
- Async Operations: High-performance concurrent AI processing
Enterprise Scalability
- Microservices: Independent scaling of processing components
- Data Privacy: Comprehensive sanitisation for development safety
- Audit Compliance: Complete tracking for financial regulation
- Performance: Process 500+ properties in under 5 minutes
Industry Integration
- Excel Compatibility: Seamless Knight Frank tool integration
- MRI Connectivity: Direct property management system links
- Multi-tenant: Support for 400+ property portfolios
- Automation: 80% reduction in month-end processing time
Architecture reflects enterprise-grade PropTech financial automation with comprehensive AI integration and Australian compliance.