[ Industry case study — AI & Automation ]

Automated reconciliation saves 14,000+ staff hours a year

STX Next built ReconSync, an Azure-native platform that automatically reconciles 320,000+ bank transactions a year for UK wealth manager Mattioli Woods.

Original project by STX Next ↗Industry reference — not a NexSum Labs engagement.

Client
Mattioli Woods
Industry
Wealth management & financial services
Services
Process automation, Data engineering, Cloud solutions, Agile transformation
Year
2026
Location
United Kingdom
Office worker looking stressed at a laptop, illustrating the burden of manual reconciliation
14,000+
staff hours saved annually
320,000+
bank transactions reconciled automatically per year
<2 hrs
daily processing, down from ~100 person-hours
200 → 4
people needed to run reconciliation

The client

Mattioli Woods is a leading UK wealth management and employee benefits firm founded in 1991, serving more than 20,000 clients with over £16 billion in assets under management, administration and advice. After its 2024 acquisition by private equity firm Pollen Street Capital, the firm launched an ambitious operational transformation programme.

The challenge

Daily bank reconciliation, which underpins the government-mandated Annual Valuation Statement, was done by hand by a 200-person CRM team, costing over 100 hours a day and 14,000+ hours a year. For four of five core banks, someone had to log in each morning and download transaction files manually. The reconciliation logic lived in people's heads with no documented architecture, and internal teams lacked a shared Agile delivery framework.

The solution

01Automated bank data collection

Scheduled Azure Durable Functions pull transaction files from bank APIs and SFTP endpoints and store them securely in Azure Blob Storage, with no morning log-ins required.

02End-to-end ReconSync pipeline

Service Bus-driven functions fetch expected transactions from the internal MWeb platform, send complete batches to the ReconArt reconciliation engine, and sync the matched results back automatically.

03Secure, observable infrastructure

Cosmos DB, Key Vault with Managed Identity, private endpoints, GitHub Actions with modular Bicep, and App Insights give the platform auditable storage, secrets handling and monitoring.

04Embedded Agile coaching

An embedded Scrum Master introduced ceremonies, backlog refinement and estimation across three internal product teams, lifting planned sprint delivery to 50-90%.

The results

A process that consumed a full working day across a 200-person team now runs as an automated pipeline in under two hours, monitored by a team of four. More than 320,000 transactions a year are reconciled across five banking partners without manual touchpoints, saving 14,000+ staff hours annually. Coverage reached 60-70% of transaction volume at soft launch, with a clear path to full automation.

Tools & stack

.NETAzure FunctionsAzure Durable FunctionsAzure Service BusCosmos DBAzure Blob StorageAzure Key VaultGitHub ActionsBicepApp InsightsReconArt

Original project by STX Next ↗ — published by the delivering agency, included here as an industry reference.

Next case study — Zego

InsurTech unicorn rebuilds its employee platform and claims operations