Enterprise Client Management & Financial Intelligence Platform
The AuxTech Client Management System is a robust enterprise resource planning (ERP) solution built for digital agencies. It centralizes client project tracking, multi-stage payment workflows, monthly expense monitoring, and an advanced log-scaled referral tracking system. By replacing disjointed spreadsheets, it delivers real-time business intelligence and data-driven financial insights.
The Challenge
Agencies struggle with fragmented data. Key issues included inaccurate revenue attribution (mixing project dates with actual payments), manual reconciliation of operational expenses, and 'unfair' referral rewards where single large deals skewed performance metrics.
Technology Stack
PHP 8.2, Laravel 12.x
Blade Templates, Alpine.js 3.x, TailwindCSS v4
Service-Oriented MVC (Thin-Controller Pattern)
Impact & Results
Achieved 100% cashflow accuracy by mapping attribution to actual payment completion timestamps.
Reduced project reporting and payslip generation time from hours to single-click automation.
Normalized referral tracking, fostering greater trust and fairer rewards for affiliate partners.
Centralized all agency operations (hosting, domains, projects, payroll) into a single source of truth.
Core Principles
Architectural Excellence
The platform's architecture prioritizes data correctness and performance, ensuring reliable reporting for enterprise-level operations.
Log-Scaled Referral Algorithm
Engineered a sophisticated mathematical scoring engine that fairly balances quality, impact, and volume using log(1 + value) dampening to eliminate outlier bias in affiliate rewards.
Strict Revenue Attribution
Implemented Business Rule (BR-001) which ties financial reporting strictly to recognized revenue (payment_completed_at), preventing cash flow discrepancies common in traditional project-based systems.
Decoupled Service Layer
Complex logic like payslip generation, profit/loss calculations, and referral weighted-scoring is isolated in dedicated Financial and Referral services, keeping controllers thin and maintainable.
Experience Design
Key Features
Smart Payment Workflows
Multi-stage status transitions (Unpaid → Partially Paid → Paid) with automated due-balance calculations.
Referral Engine (40/40/20)
A mathematically weighted distribution of Project Value, Revenue, and Volume for affiliate tracking.
Real-Time Dashboard
Interactive business intelligence visualizations powered by reactive frontend data-binding with Alpine.js.
Automated Financial Exports
One-click generation of Monthly/Yearly P&L statements and professional payslips in PDF/DOCX formats.