Back to projects

MAUK Reconciliation

“Turning 3 Excel spreadsheets into one source of truth.”

PythonFlaskPandasExcel AutomationData Reconciliation

3

Data Sources

Hours/month

Time Saved

~98%

Match Rate

Live

Status

The Story

MAUK Reconciliation was built for Malca-Amit UK Ltd, a luxury goods freight company at Heathrow. The problem: reconciling three completely different billing systems manually using VLOOKUP in Excel. Every. Single. Month. The app now ingests MAUK internal exports, CASS airline billing statements, and HCH cargo handling invoices, matches them by MAWB number, and spits out a clean reconciliation report in minutes. Saved hours of manual work. Made someone's Monday mornings significantly less painful.

What it does

  • Automated MAWB-based matching across 3 billing systems
  • Exception reporting for unmatched entries
  • Clean web UI for non-technical operations staff
  • Export to formatted Excel reconciliation reports