Back to case studies

Case study

Automated Billing Correction System

Developed an LLM-powered system to automate the identification and correction of billing errors, reducing manual processing time by 90%.

Client
Aegis Computers Ltd
Industry
Managed IT Services
Location
United Kingdom
Company size
Small Business
Technologies
LangChain · HuggingFace · LangGraph · MS Fabric · Python · MLFlow

01

Challenge

This Managed Service Provider (MSP) with over 30 years in the IT services industry struggled with persistent billing errors in customer support invoices.

Major pain points:

  • Support engineers frequently misclassified billable vs. non-billable hours
  • Missed charges resulted in revenue leakage
  • Manual review process was extremely time-consuming (10 hours/week)
  • Human error in manual corrections compounded issues
  • Delayed and backlogged invoicing frustrated customers
  • Billing cycles extended to three weeks on average

The client sought an automated solution to streamline the billing correction process, improve accuracy, and reduce manual review time whilst leveraging modern data science techniques.

02

Solution

We designed a bespoke agentic workflow powered by Large Language Models (LLMs) to automatically identify and correct billing errors.

Solution architecture:

  • Data Ingestion: Automated extraction of data into data lakehouse (MS Fabric).
  • Multiple Data Sources: Integrated data from helpdesk software, communication tools, and billing systems for comprehensive analysis.
  • Data Preparation: Cleaned and structured data to ensure high-quality inputs for the LLM.
  • Automated Error Detection: LLM-powered analysis of support tickets and time entries to identify billing inconsistencies
  • Semantic Search Integration: Connected with helpdesk software to verify factual accuracy of billing classifications
  • Intelligent Correction: Automated suggestion and application of corrections based on historical patterns
  • Continuous Learning: Feedback loop to refine the model based on user input and corrections

The system reduced manual billing time from 10 hours per week to just 1 hour, whilst accelerating the billing cycle from three weeks to just a few days.

03

Impact

The billing workflow reduced manual review effort and helped the MSP accelerate invoice preparation without relying on repetitive human checks.

Business impact:

  • Reduced billing review time from 10 hours per week to approximately 1 hour per week
  • Shortened customer time-to-bill from around three weeks to a few days
  • Improved consistency in billable and non-billable classifications
  • Freed support and operations staff from repetitive invoice correction work

Working through a similar challenge?

Let's discuss how thoughtful software, data, automation, or cloud engineering could move your project forward.

Discuss your project