×
From 16 hours of manual pension extraction
to 1.5 hours, fully automated
Ellement manually extracted employee pension data from contribution reports into Excel — 16 hours per 100 documents with limited accuracy using Power Automate. A Nanonets agent now ingests reports from OneDrive, extracts all fields with 97% accuracy, and exports structured data to Excel in 1.5 hours.
Ellement is a benefits consulting firm specializing in pension plan administration. Their team processes employee contribution reports from multiple employer clients — each arriving in different formats — requiring accurate extraction of pension data for compliance reporting and member record-keeping.
The Problem
Ellement's team received pension contribution reports from employer clients stored in OneDrive — each in a different format. Extracting employee pension data into Excel required 16 hours per 100 documents. Power Automate had been attempted but delivered limited accuracy and required constant maintenance as formats changed.
- —16 hours per 100 documents of manual pension data extraction into Excel spreadsheets.
- —Power Automate failures — brittle rules broke whenever report formats changed across clients.
- —Compliance risk from manual entry errors in pension member records.
Nanonets replaced a 16-hour manual process with something that runs in under 2 hours — with better accuracy than our previous Power Automate setup.
The solution
One extraction agent. OneDrive to Excel, fully automated.
Nanonets replaced the manual extraction loop with one agentic pipeline. The agent monitors OneDrive for new contribution reports, extracts all pension fields across varied formats, validates completeness, and exports structured data to Excel — with 97% accuracy and no manual intervention required.
Pipeline overview
Impact
AGENT ANATOMY
Nanonets AgentNanonetsSee it run on your process, with your documents.
Start free. No credit card. Or talk to our team about your workflow.