Travel agencies · Sales & collections · 2026
Ketzal OS
Our own product: a sales back-office for travel agencies — sales with installment plans, numbered receipts, commissions, collections and a manifest for every departure — plus a public storefront where travelers buy and pay online. Built in Ciudad Juárez with real agencies.
SaaS multi-agenciaLedger de pagosMarketplace
Visit live site ↗
The challenge
A small agency sells from a notebook, tracks installments in a spreadsheet only the owner understands, forgets to collect and writes receipts by hand. Nobody knows for sure how much is owed or how many seats are left on each departure.
How we solved it
A Next.js 16 + Supabase monolith with each agency isolated by RLS. Money is never stored as an editable total: it’s derived from an append-only ledger written only through database functions, with atomic receipt numbers per agency and series. Seats on each departure are resolved in the database, so two reps never sell the same seat. Payments via Mercado Pago Split, SPEI and cash with proof, payment plans and cancellation credit. An AI reader turns a tour flyer (PDF or image) into a service ready to sell, and an MCP server lets you run the system in natural language. The same foundation — capacity per departure, manifests and ledger-based collections — fits routes and trucks in logistics.
Results
- Live at ketzal.tours with two Ciudad Juárez agencies; the back-office is in testing
- Append-only payments ledger: balances are always derived, never edited
- Receipt numbers and seats per departure resolved in the database, no double sales
- 500+ commits and 65 documented architecture decisions since July 2026