> ## Documentation Index
> Fetch the complete documentation index at: https://docs.lostmindai.com/llms.txt
> Use this file to discover all available pages before exploring further.

# PropTech X - Your All-in-one PAM Tools - Architecture

> architecture documentation for PropTech X - Your All-in-one PAM Tools

# 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.*