Lost mileage reconciliation automation for bus operations

• Client type: Bus operator managing lost mileage reconciliation in a compliance-sensitive operating environment
• Scope: Centralize source data, apply TfL-aligned validation, and give clerks one controlled workflow for review and approval
• Core result: Lower penalty exposure, lower manual payroll effort, and stronger traceability across reconciliation decisions

Lost mileage reconciliation was being handled through multiple disconnected systems, spreadsheets, emails, and inbox-based communication. That made a specialist workflow slower, harder to trace, and more vulnerable to repeated error.

The operator was not simply dealing with administrative inconvenience. The process also carried compliance risk because submissions had to align with TfL requirements, while the supporting evidence and decision trail were spread across fragmented tools.

The result was a fragile operating model with several practical weaknesses:

• slow reconciliation cycles due to manual handling and cross-checking
• poor traceability across review, discussion, and approval steps
• repeated errors and rework caused by fragmented information
• dependency on a small group of specialist staff
• ongoing exposure to penalty risk in a compliance-heavy process

iQberry approached the work as an operational control problem rather than a simple admin automation exercise.

The first priority was to bring lost mileage data, validation, and communication into one workflow so mileage clerks could work from a shared operational picture. That meant reducing inbox dependence, making decisions traceable at event level, and applying rules aligned to the compliance context.

The implementation focused on:

• integrating source data into one review workspace
• automating validation around reconciliation activity
• capturing communication and decision context inside the workflow
• making review and approval easier to complete without switching between tools

iQberry delivered a centralized lost mileage reconciliation workflow that replaced fragmented spreadsheet and inbox handling with one controlled operational process.

The solution included:

• integrated lost mileage data from multiple source systems
• automated validation aligned with TfL requirements
• event-level reconciliation workflows
• internal communication and notification inside the process
• one workspace for review, validation, and approval

This gave mileage clerks and related teams a more reliable way to manage reconciliation from first review through final approval.

The strongest outcome was a more controlled reconciliation process in a workflow that had previously depended on fragmented data, specialist knowledge, and inbox-driven coordination.

According to the source material, the operator reduced TfL penalties by GBP 150,000 to GBP 300,000 per year and reduced mileage-clerk payroll effort by GBP 50,000 to GBP 100,000 per year. Beyond the direct cost effect, the workflow also improved confidence in how reconciliation decisions were reviewed, evidenced, and approved.

Operationally, the change delivered:

• faster and more accurate reconciliation cycles
• fewer manual errors and less avoidable rework
• better collaboration between controllers, mileage clerks, and finance
• stronger confidence in compliance submissions and supporting evidence
• less dependence on individual expertise and inbox history

In public transport operations, a specialist workflow can still create outsized financial and compliance consequences when it is slow, fragmented, or difficult to evidence.

This case matters because it shows how process control, validation, and integrated data can turn lost mileage reconciliation from a fragile manual routine into a governed operational workflow. That reduces risk in two ways at once: fewer errors inside the process and fewer downstream consequences from weak submissions.

For operators trying to improve control without replacing core systems, that kind of workflow modernization is often one of the highest-leverage places to start.