HousingBrixx Rebuild — Technical Architecture & Build Estimate¶
Date: 2026-02-18
Author: AI Software Architecture Estimate (based on OYN codebase + prior Brixx/HousingBrixx research)
Executive Summary¶
Reproducing MRI HousingBrixx as a modern, advisor-led SaaS is feasible, but this is a domain-complex financial platform, not a typical CRUD SaaS. The highest-risk and highest-value areas are:
- 30-year integrated 3-way engine correctness (P&L ↔ BS ↔ CF with monthly/annual granularity)
- Regulatory compliance outputs (FFR + SORP/FRS 102 conventions + RSH viability/stress expectations)
- Treasury/covenant logic under stress scenarios
- Data migration + trust parity vs incumbent models/Excel
A realistic path is a phased delivery: - Phase 1 (MVP/pilots): 9–12 months, targeted feature set for first 5 pilots - Phase 2 (Production): +9–12 months to support 50 clients reliably - Phase 3 (Scale/leadership): +12–18 months to reach 200+ with strong moat
Total build investment (3 phases): ~£3.3m–£8.3m depending on team size, pace, and compliance depth.
OYN Baseline Assessment (What was reviewed)¶
I reviewed:
- /root/clawd/repos/oyn/README.md
- OYN backend architecture and pipeline files (notably):
- oyn/backend/api/main.py
- oyn/backend/processing/pipeline_v2.py
- oyn/backend/processing/calculations.py
- oyn/backend/core/schema.py
- settings, db/session, user/xero models
- Prior research:
- brixx-deep-research-2026-02-18.md
- brixx-technical-spec.md
- housing-brixx-deep-research.md
Key finding on OYN¶
OYN is a financial data ingestion/analysis platform (Excel/Xero parsing, snapshotting, AI commentary), not a full 30-year deterministic planning engine. It provides reusable platform foundations, but the core HousingBrixx-equivalent planning engine is largely net-new.
1) Architecture Design¶
1.1 Text-based System Architecture Diagram¶
┌─────────────────────────────────────────────────────────────────────┐
│ Client Applications │
│ React/Next.js SPA | Advisor Portal | Board/Read-only Portal │
└───────────────┬───────────────────────────────────────┬─────────────┘
│ │
▼ ▼
┌──────────────────┐ ┌──────────────────────┐
│ API Gateway/BFF │ │ AuthN/AuthZ Service │
│ (REST/GraphQL) │ │ (SSO, RBAC, Audit) │
└───────┬──────────┘ └──────────┬───────────┘
│ │
├──────────────────────────────┬──────────┘
▼ ▼
┌──────────────────────┐ ┌───────────────────────────────┐
│ Plan Orchestration │ │ Scenario & Version Service │
│ (workflows, jobs) │ │ (branching, compare, stress) │
└──────────┬───────────┘ └──────────────┬────────────────┘
│ │
▼ ▼
┌────────────────────────────────────────────────────────────────┐
│ Core Financial Engine Service │
│ - Component compiler │
│ - Time-series calc graph (360 months/30 years) │
│ - 3-way linkage (P&L, BS, CF) │
│ - Covenants, treasury, dev appraisal hooks │
└───────┬──────────────────────────────┬────────────────────────┘
│ │
▼ ▼
┌───────────────────────────┐ ┌──────────────────────────────────┐
│ Reporting & Reg Service │ │ Asset & Development Engines │
│ FFR, SORP/FRS102 maps, │ │ stock lifecycle + scheme models │
│ board packs, exports │ │ │
└────────────┬──────────────┘ └──────────────┬───────────────────┘
│ │
└──────────────┬──────────────────┘
▼
┌──────────────────────────────────────┐
│ Data Integration Layer │
│ CSV/Excel, GL systems, HMS, APIs, │
│ migration tools, validation pipeline │
└─────────────────┬────────────────────┘
▼
┌────────────────────────────────────────────────────────┐
│ Data Platform │
│ PostgreSQL (OLTP) | Object Storage | Redis/Queue │
│ + optional warehouse for analytics/benchmarking │
└────────────────────────────────────────────────────────┘
│
▼
┌───────────────────────────┐
│ AI Layer (optional first) │
│ anomaly, narratives, NLP │
└───────────────────────────┘
1.2 Core modules & relationships¶
- Core Financial Engine is the system of record for projections.
- Component System feeds the engine with locked formula objects.
- Scenario Manager clones/overrides assumptions and runs differential recalc.
- Loan & Treasury, Development, and Asset modules are specialized sub-engines writing cashflow/P&L/BS entries.
- Regulatory Reporting maps engine outputs to formal templates (FFR, SORP/FRS narrative structures, VfM packs).
- Consolidation aggregates intercompany-adjusted outputs across entities.
- Dashboard/Reporting reads curated output marts.
- Import/Export handles onboarding and periodic sync.
- User Management secures tenant/entity/scenario access.
- AI Layer consumes curated data, never source-of-truth for calculations.
1.3 Proposed Data Model (high level)¶
Core entities¶
Tenant(advisor firm or HA organization)Organization(group)LegalEntity(subsidiary/SPV/RP)Portfolio/AssetBlock/UnitClassPlan(30-year model)PlanVersion(immutable snapshot)Scenario(branch + overrides)ComponentDefinition(formula-locked template)ComponentInstance(parameterized in plan)AssumptionSet(inflation, rent, voids, arrears, capex, rates)Period(month index 1..360 + FY buckets)JournalLine(engine postings, typed by statement)LoanFacility,CovenantDefinition,CovenantResultDevelopmentScheme,Phase,GrantAssumption,TenureMixLifecycleRule,StockConditionRecord,CapexProgramConsolidationRule,IntercompanyBalanceReportTemplate,ReportRun,RegulatorySubmissionImportJob,MappingRule,ValidationIssueUser,Role,Permission,AuditEvent
Key relationships¶
- Tenant 1:N Organizations; Organization 1:N LegalEntities
- Plan belongs to LegalEntity or Group scope
- Plan 1:N Scenarios; Scenario 1:N ComponentInstances/Overrides
- ComponentInstances produce many JournalLines over Periods
- JournalLines aggregate to statement marts (P&L/BS/CF)
- LoanFacility + CovenantDefinition produce CovenantResults by period/scenario
- Consolidation consumes entity outputs + intercompany eliminations
1.4 How this differs from OYN; reuse potential¶
OYN strengths reusable¶
- FastAPI service scaffolding, settings discipline, env-driven configuration
- File ingestion and validation pipeline patterns (Excel-first pragmatism)
- Snapshot construction and schema validation approach
- Basic multi-model AI orchestration and guardrails
- Auth/session patterns, observability hooks, retention controls
Major gaps vs HousingBrixx-class platform¶
- No 30-year deterministic planning graph
- No native component-based planning model with locked formulas
- No loan covenant engine / refinancing optimizer
- No development appraisal engine for HA pipelines
- No asset lifecycle/Decent Homes/building safety model
- No FFR-compliant output engine
- No group consolidation engine
Net: OYN accelerates platform plumbing, not domain core.
2) Module-by-Module Estimate¶
Estimates assume experienced team, parallel workstreams, and that regulatory design is available from domain SMEs. “Dev weeks” are elapsed feature-delivery weeks with a focused squad (not person-weeks).
| Module | Complexity | Dev Weeks (elapsed) | Typical Team Composition |
|---|---|---|---|
| a) Core Financial Engine | Very High | 24–36 | 2 backend staff/principal + 1 quant/financial engineer + 1 QA automation |
| b) Component System | High | 14–22 | 1 backend + 1 frontend + 1 financial modeller |
| c) Scenario Manager | High | 10–16 | 1 backend + 1 frontend + 0.5 QA |
| d) Loan & Treasury | Very High | 14–24 | 1 backend + 1 treasury SME + 1 QA |
| e) Development Appraisal | High | 12–20 | 1 backend + 1 frontend + 1 housing dev SME |
| f) Asset Management | Very High | 16–28 | 1 backend + 1 data engineer + 1 asset SME + 1 frontend |
| g) Regulatory Reporting | Very High | 12–20 | 1 backend/reporting + 1 finance/reg SME + 1 QA |
| h) Consolidation | High | 10–18 | 1 backend + 1 finance SME |
| i) Dashboard & Reporting | Medium-High | 10–18 | 1 frontend + 1 backend + 0.5 designer |
| j) Data Import/Export | High | 12–22 | 1 data/backend + 1 integration engineer + 0.5 QA |
| k) User Management | Medium | 6–10 | 1 backend + 0.5 frontend |
| l) AI Layer | Medium (non-core) | 8–14 | 1 ML/backend + 1 prompt/app engineer |
| m) Frontend (Next.js app shell + planner UX) | Very High | 20–36 | 2 frontend + 1 product designer + 1 backend support |
Notes by module (critical nuances)¶
- Core Engine: must support deterministic recompute, dependency graph ordering, circular dependency prevention, audit trace per number.
- Component System: formula locking is key to replacing spreadsheet risk.
- Scenario Manager: copy-on-write + override inheritance prevents data bloat.
- Loan/Treasury: covenant breach early-warning and refinancing actions are must-have for treasurers.
- Regulatory: needs rigorous test packs against known FFR examples and multiple accounting edge cases.
- Consolidation: intercompany elimination UX can be a hidden complexity sink.
- AI Layer: should be assistive only; never authoritative for compliant numbers.
3) Build Phases¶
Phase 1 — MVP (first 5 pilot clients)¶
Goal: deliver a credible, auditable alternative for pilot HAs with advisor support.
Include: - Core 3-way engine (monthly + annual rollups, 30 years) - Initial component library (income, opex, capex, asset, loan, equity, tax basics) - Scenario manager (base + 3–5 stress scenarios) - Loan/covenant essentials (ICR, gearing, liquidity headroom) - Basic development appraisal (scheme pipeline + grant + tenure split) - FFR export v1 + board report pack basics - Import/export via Excel/CSV templates - Tenant/user roles + full audit trail
Defer: deep connectors, advanced consolidation, advanced AI, broad benchmarking.
Phase 2 — Production (to 50 clients)¶
Goal: harden operations, broaden coverage, reduce advisor implementation effort.
Add: - Asset lifecycle module depth (decent homes, safety programs, EPC-style drivers) - Consolidation v1 (multi-entity, eliminations) - richer dashboards/custom reports - stronger integration layer (Xero + selected housing/GL imports) - migration toolkit from HousingBrixx/Excel patterns - compliance hardening + regression test harness - SRE maturity (SLAs, DR, monitoring, support workflows)
Phase 3 — Scale (200+ clients, category leadership)¶
Goal: enterprise depth + moat.
Add: - Full connector marketplace + API ecosystem - AI copilot for scenario design, anomaly detection, board narrative drafting - benchmarking network data products (opt-in, anonymized) - advanced treasury (hedging, refinancing optimization) - performance scaling (large portfolios, concurrent scenario runs) - partner/advisor operating layer (multi-client command center)
4) Team & Timeline¶
4.1 Recommended team composition (full program)¶
- 1 Product Lead (HA finance domain)
- 1 Tech Lead / Architect
- 4–6 Backend Engineers
- 2–3 Frontend Engineers
- 1 Data/Integration Engineer
- 1 ML/App Engineer (Phase 2+)
- 2 QA/Automation Engineers
- 1 DevOps/SRE
- 1 UX/Product Designer
- 1–2 Domain SMEs (treasury/regulatory/asset)
Core delivery team: ~10–15 FTE during peak build.
4.2 Timeline by phase (realistic)¶
- Phase 1 MVP: 9–12 months
- Phase 2 Production: +9–12 months
- Phase 3 Scale: +12–18 months
Total: ~30–42 months to robust market-leading position.
4.3 What 1–2 senior devs can do vs needs a team¶
With 1–2 senior devs (6–12 months)¶
- Build proof-of-concept 3-way engine core
- Deliver limited component framework
- Basic single-entity scenario analysis
- Prototype UI and import templates
What requires a full team¶
- Production-grade compliance, auditability, and UAT across HA edge cases
- Loan covenant + development + asset lifecycle depth
- Consolidation and reporting at enterprise scale
- Reliable onboarding/migration pipeline for multiple clients
- 24/7 operations, support, and security posture expected by larger RPs
5) Cost Estimates (GBP)¶
Assumes UK-based blended loaded rates and mixed seniority.
5.1 Phase 1 MVP (9–12 months)¶
- Lean (6–8 FTE): £700k–£1.3m
- Stronger (9–11 FTE): £1.2m–£2.0m
5.2 Phase 2 Production (+9–12 months)¶
- Incremental: £1.0m–£2.0m
5.3 Phase 3 Scale (+12–18 months)¶
- Incremental: £1.6m–£4.3m
5.4 Ongoing monthly run costs (post-Phase 2)¶
- Cloud/SaaS infra: £15k–£60k/month (depends on tenant scale, data workloads, environments)
- Support + success + QA + SRE staffing: £60k–£180k/month
- Continuous product/compliance dev: £80k–£250k/month
Typical mature burn: £155k–£490k/month.
6) OYN Reuse Analysis¶
6.1 Directly reusable (high confidence)¶
- FastAPI project skeleton, API conventions
- Config/settings and environment patterning
- Logging/observability foundations
- File ingestion workflow patterns and schema validation style
- Authentication/session baseline
- AI integration scaffolding (for narrative/anomaly assistants)
6.2 Reusable with modification¶
- Data pipeline orchestration (adapt for planning data instead of extracted actuals)
- Snapshot concepts (extend to plan/version/scenario snapshots)
- User and connection models (extend for multi-tenant enterprise RBAC and advisor hierarchy)
- Reporting pipeline approach (must be redesigned for compliance output templates)
6.3 Net-new build required¶
- Calculation graph engine for 360-period integrated forecasts
- Formula-locked component compiler/runtime
- Loan/treasury covenant simulation engine
- Development appraisal engine
- Asset lifecycle + stock condition logic
- Consolidation/elimination engine
- Regulatory mapper for FFR + SORP/FRS aligned outputs
- Large new planner UX (drag-drop model builder, compare, diagnostics)
6.4 Acceleration impact from OYN¶
Estimated acceleration vs greenfield: - Engineering platform acceleration: 15–25% - Domain engine acceleration: 0–10% - Overall program acceleration: ~10–20%
Reason: OYN’s reusable value is mainly in platform plumbing and data discipline, not HousingBrixx-equivalent modelling semantics.
7) Key Risks & Decisions¶
7.1 Build vs extend decisions¶
- Decision: whether to architect a bespoke deterministic engine or embed external modelling tech.
- Recommendation: bespoke core engine (domain moat + auditability), modularized so select pieces can be swapped.
7.2 Regulatory compliance risk¶
- Risk: failing edge-case compliance/format expectations can block adoption.
- Mitigation:
- Regulatory SME embedded in product loop
- Golden test packs from real anonymized HA models
- Formal model validation harness and sign-off process
7.3 Data migration from HousingBrixx/Excel¶
- Risk: migration friction is a primary switching blocker.
- Mitigation:
- Import adapters for common workbook shapes
- Assisted reconciliation (difference checker by statement/period)
- Dual-run period tooling for confidence with board/lenders
7.4 Go-to-market timing risk¶
- Risk: long sales cycles (6–12+ months) and incumbent inertia.
- Mitigation:
- Advisor-led distribution (already trusted channel)
- Start with 3–5 lighthouse pilots and publish quantified outcomes
- Win on speed, transparency, scenario power, and service quality
7.5 Technical risk hotspots¶
- Engine performance at scale with many scenarios/entities
- Formula governance/versioning and backward compatibility
- Explainability: every number must be traceable to assumptions and formulas
- Security expectations for social housing sector procurement
Suggested Delivery Blueprint (practical)¶
- First 8 weeks: domain blueprint + canonical chart-of-accounts mapping + engine contract tests
- Months 3–6: core engine + component runtime + first UI planner
- Months 6–9: scenarios + loan/covenant + FFR v1 + pilot onboarding tooling
- Months 9–12: pilot hardening, reconciliation tooling, production readiness
- Year 2: asset/development depth, consolidation, connectors, enterprise operations
- Year 3: AI differentiation, benchmarking, ecosystem play
Final Recommendation¶
This is a strong opportunity because the market is concentrated, sticky, and underserved by modern UX and AI-native workflows. Success depends less on generic SaaS execution and more on financial model trust. The winning strategy is:
- Build deterministic, auditable modelling core first
- Pair with advisor-led implementation and migration support
- Use AI as leverage around planning productivity and narrative, not core arithmetic
- Treat compliance and reconciliation as product features, not afterthoughts