Skip to main content
All cases

One source of truth across the SaaS stack

A real-time ingestion and reconciliation layer that reads from every system the business runs on. Teams stopped exporting CSVs. Leadership stopped arguing about which dashboard was right.

01

Mid-sized operators rarely run on a single platform. A typical stack mixes a vertical-specific PMS or CRM, a separate telephony system, an accounting tool, a messaging channel, and a handful of point solutions. Each one holds part of the truth about a customer, a transaction, or a day of operations. None of them talks to the others by default.

Reports get rebuilt manually every cycle. Numbers get copied between exports. Strategic questions that should take minutes ("how did response time correlate with revenue last quarter?") arrive late and contested.

The organisation in this engagement had reached the point where the cost of disagreement between systems was more painful than the cost of fixing it.

02

Focus AI built a centralisation layer in front of the existing tools rather than replacing any of them. Webhooks from each source push into a typed ingestion service the moment something changes. A nightly reconciliation job back-fills anything the webhooks missed and flags inconsistencies for human review.

The normalised model lives in a managed PostgreSQL instance with a clear separation between raw landing tables, conformed entities, and analytical views. Sensitive call recordings and free-text notes are summarised by a frontier LLM with explicit prompts and stored alongside the structured fields. Qualitative signal becomes queryable next to revenue and volume.

The stack runs locally on a developer laptop and ships to production without infrastructure rewrites. Every transformation is tested.

03

Operational reporting that used to consume manual export and reconciliation now refreshes continuously. Leadership has a single dashboard to look at, and disagreements about "which number is right" have largely disappeared. The lineage is documented and the reconciliation job is auditable.

The AI summarisation layer surfaced patterns in customer interactions that nobody had read before, including recurring objections and silently churning segments. Those signals are now reviewed by the operations and commercial teams as a recurring artefact.

The architecture is reusable for any business running on three or more SaaS tools that need to act as one.

  • TypeScript
  • Bun
  • Hono
  • PostgreSQL
  • Webhooks
  • Gemini
  • Cron jobs

Tell us where you're stuck.

Every project starts with a focused session discussing your bottlenecks. No slides, no fuss. We listen, understand, and execute on the issue.