The context

An industrial group operating internationally, with field teams producing hundreds of paper timesheets every month, scanned and processed at head office. The IT system rests on the Microsoft ecosystem: SQL Server database, .NET business applications, network folders.

The problem

Two people were tied up full-time re-keying these documents into the system: slow, thankless work and a source of errors — duplicates, half-finished entries, discrepancies discovered weeks later. Business growth mechanically made the load worse.

The solution, step by step

A complete pipeline, built into the core of the existing IT system — without changing the field teams' tools.

  1. Automatic ingestion

    Scans dropped into the network folders are detected and picked up with no manual step: the pipeline's entry point is the gesture the teams already made.

  2. AI extraction

    Azure Document Intelligence and an LLM read each document: fields, hour tables, handwritten entries. The group's business rules validate the consistency of every extracted value.

  3. Human review by batch

    AI proposes, humans decide: a validation interface presents extractions by batch, flags doubtful cases, and learns from corrections — quality improves with use.

  4. Transactional import

    Validated data lands in the business database in a single transaction: zero duplicates, zero half-finished entries, full traceability from document to database record.

The results

Under the hood

Azure Document IntelligenceLLM (extraction + correction).NETSQL ServerBusiness rulesHuman-in-the-loop

Do you have a similar document flow?