Case Studies | Healthcare & Life Sciences

A traceable financial modelling engine, built on AWS

Financial Engine

About

A Healthcare & Life Sciences business working with Cloud Combinator on AWS. The client is anonymised at their request.

Challenge

The challenge had four focus areas, each of which had to be solved for the engine to be trusted by a pilot fund.

Extraction from messy inputs

Financial documents arrive in whatever form they were created, from clean spreadsheets to graph-heavy PDFs. Getting a number off a page or out of a

Trust and traceability

Every calculated output value must trace back to the source document, page or cell and the calculation chain that produced it. This is measured against an audit and lineage layer rather than asserted, and it admits no exceptions, because a fund cannot act on a number it cannot defend.

Deterministic calculation with AI kept in its place

The model has to be reliable, which rules out an AI that performs arithmetic. Circular dependencies that exist in every three-statement model, where interest affects debt, which affects cash, which affects interest, must resolve predictably or be flagged rather than published silently.

Parallel delivery

The client's own interface team could not afford to wait for a finished backend. The API contract had to be frozen early so frontend work could proceed in parallel, de-risking the overall delivery.

Solution

Cloud Combinator designed and built the backend engine as four separated concerns: how raw documents become atoms, how atoms are mapped to a canonical chart of accounts, how the numbers are proven internally consistent, and how the model is calculated and changed. The phased plan below keeps each concern independently testable.

10-12 wks

From-scratch build to first pilot fund live (projected)

109

Entry canonical chart of accounts seeded at deploy

Week 6

API contract frozen so frontend runs in parallel

By the numbers:

  • 10-12 wks - From-scratch build to first pilot fund live (projected)
  • 109 - Entry canonical chart of accounts seeded at deploy
  • Week 6 - API contract frozen so frontend runs in parallel
Changes

Acceptance mirrors the success criteria one for one: extraction and lineage, mapping and review, reconciliation, modelling, the frozen API contract, the architecture, and handover each carry an explicit sign-off condition. The build is scoped at 10 to 12 weeks (projected) and delivers a system engineered for regulated-fund data sensitivity from day one, with encryption via KMS, VPC isolation and per-workspace tenant isolation in place.

  • Extraction and lineageReal documents convert to atom rows with full source lineage (document, page, cell range, snippet, bounding box) and a confidence score per line item.
  • Mapping and reviewExtracted atoms map to the canonical chart with three-tier routing, auto-map at 0.90 and above, flag for review between 0.70 and 0.89, hold below, with a human-override queue usable end to end.
  • ReconciliationFive default integrity rules run per period, alongside any plain-language custom rule added through the API, and results are reported whether they pass or fail without blocking modelling.
  • ModellingThe SaaS three-statement template runs end to end on extracted data, with circular dependencies converging within 50 iterations or being flagged for human review rather than published silently.
  • HandoverMonitoring dashboards, runbooks and handover sessions are delivered, with the first pilot fund live on the engine as the closing milestone.

The engine is built to grow beyond its first template without re-architecture. A Google Sheets and Excel live-sync bridge and a template scale-out track are scoped as parallel add-ons, while QuickBooks, Xero and Plaid integrations, SSO, and agent-generated custom models are reserved in the schema for later releases. The result is not just a pilot-ready modelling engine but a foundation the client can extend as it moves from its first fund to many.

AWS Stack

Amazon S3

For raw document storage on upload via pre-signed URLs.

Amazon Textract

For automated extraction of figures from PDF financial statements.

Amazon Bedrock

(Claude) for closed-set mapping to the canonical chart of accounts and vision fallback, never arithmetic.

AWS Lambda

For stateless per-stage extraction, mapping and reconciliation compute.

Amazon ECS Fargate

For the persistent modelling engine that runs the iterative convergence loop.

Amazon RDS

For PostgreSQL for the atom store, model graph, change logs and reconciliation results.

Amazon SQS

For decoupling the processing stages so one slow extraction does not hold up the others.

AWS Secrets

Manager, Amazon API Gateway and Amazon CloudWatch for secrets, the API layer and monitoring.

YOU MIGHT LIKE

Related success stories

View all case studies

Case Studies | Insights

Utilising Language Recognition, Speed, and Enhanced Security to Make Social Media a Force for Good

  • Here, we take a detailed look at how the Cloud Combinator team collaborated with another cutting-edge AI service provider that provides intelligent systems to “make social media more social” for brands and users alike.
  • Arwen AI is a UK-based startup specialising in AI solutions to manage and enhance brands’ social media interactions. Founded in 2020 by Matt McGrory, Dr. David Cole, and Joel Bailey, Arwen. AI focuses on using AI to automatically detect and remove spam, toxic comments, and other unwanted content from social media platforms.
  • The team at Arwen have three core products. ‘Moderate’ is focused on identifying and removing toxic content from social media channels. ‘Engage’ helps brands identify and engage with meaningful conversations on social media, and ‘Customize’ allows brands to apply bespoke algorithms to their channels - creating an even more effective moderation and engagement.
Read more
CONTACT US

Ready to turn AI into impact?

We'll help you spot the highest-value opportunities, reduce risk around your first AI initiative, and define a clear path to results from day one.

Why talk to us:

Outcome-driven recommendations

AWS-recognised delivery expertise

Risk-aware AI adoption

Clear next step, not a sales pitch

Start with a focused 20-minute conversation about your goals — no pressure, no commitment.

This website uses cookies to enhance user experience and to analyze performance and traffic on our website.

See our Privacy Policy for details.