← CasesCS-04Internal digital system

Multi-property operations dashboard.

A single screen that replaces three spreadsheets and two weekly ops meetings.

Status

In production

Sector

Real Estate · Multi-property operator

Client

Operator · 47 properties, CDMX

Year

2026

Hook ─ Position

Operators with 20–80 units live in Excel and WhatsApp. Every decision costs a phone call. The opportunity isn't to modernize the spreadsheet — it's to build the command surface they never had.

Demo interactivo · sandbox de operación
Operación47 propiedades
Lun · 09:14Live
Rango
Ocupación
82%
+4 vs trim
Cobranza 30d
94%
+22 vs Q4
Vacantes
8
−6 vs sem
Ingreso operativo · 12 semMXN
S1S12
─ Alerta · accionable

Anzures · 14 con vacancia > 60 días.

Sugerido: revisión de precio.

Filtro
·PropiedadOcupaciónMora
Demo en sandbox · datos sintéticos · roles desactivados para invitados5 propiedades

Theory ─ How we think

An internal system shouldn't feel like software — it should feel like a tool. If the operator has to learn how to use it, we've already lost. If they open it on Monday and understand everything in 30 seconds, we win.

  1. 01

    Single data model

    Property → unit → contract → charge → ticket. One source of truth. Historical spreadsheets are imported, validated, and archived — they don't coexist.

  2. 02

    View by role

    The administrator doesn't see what the owner sees. The owner doesn't see what maintenance sees. Each view is designed for the decision that person makes at 9am.

  3. 03

    Actionable alerts, not notifications

    An alert is worth something if it leads to a concrete action in less than 60 seconds. Otherwise, it's noise. The system only alerts when there's something to decide.

  4. 04

    Zero high-frequency forms

    Capturing a received payment is one click. Capturing a maintenance ticket is a photo. Any flow that happens more than once a day was reduced to 2 taps.

Visual ─ Architecture

Capture · Model · View · Alert.

Cliente · 01

Web dashboard

responsive · roles

Core · 02

API

Server Actions

Servicio · 03

Jobs

alerts + reports

Persistencia · 04

Postgres

single model

─ Flujo del sistema

Every capture enters the single model. Nightly jobs calculate KPIs, generate monthly reports for owners, and trigger actionable alerts. Each role only sees what they need to decide.

Practice ─ Delivery

How it shipped.

Vacancy detection

14 days → 0

real time

Q1 202647 properties CDMX
Collections at 30 days

+22%

vs prior quarter

Q1 2026vs Q4 2025
Operating hours

−11h/wk

reported by team · 6 people

Q1 2026internal survey n=6

─ Deliverables

  • Responsive web operations dashboard
  • Importers from historical Excel with validation
  • Actionable SMS/email alert pipeline
  • Auto-generated monthly reports per owner
  • Maintenance ticket system with photo and geolocation

─ Stack

Frontend
  • Next.js 15
  • Server Components
  • Tremor charts
Backend
  • Postgres + Prisma
  • Server Actions
  • Trigger.dev
Infra
  • Vercel
  • Resend + Twilio
  • Cloudflare R2

─ Timeline

8 weeks · MVP in 4, refinement with feedback in 4

Testimonial ─ Client

By Monday morning I already know exactly which property needs attention that week. That's worth more than the whole system.

Director of operations · 47 properties CDMX

Does your case look like this?

If your operation looks like this, there's a system.