How a Freight Forwarder Replaced a 47-Tab Spreadsheet: A Visual Walkthrough

The Freight Forwarding Challenge in Mauritius

Freight forwarding in Mauritius involves complexity that international software often does not handle: local customs procedures, multiple carriers, documentation requirements, and the reality of island logistics.

Most freight forwarders in Mauritius know this reality well. The work is fast-paced, documentation is heavy, and the margin for error is thin.

The 47-Tab Spreadsheet

We worked with a freight forwarder who ran their entire operation on a single Excel workbook with 47 tabs. Each tab tracked a different part of the business: shipments and their status, customer information, carrier details, documentation, billing and payments, customs clearance.

The problem was not that spreadsheets cannot hold this data. The problem is that they cannot connect it. When a shipment status changed, someone had to update multiple tabs manually. Errors crept in. Information fell through the cracks.

One missed update meant a customer did not get their tracking information. One wrong cell reference meant an invoice went out with incorrect charges. One sorted column meant three shipments got lost in the system for a week.

The Before State

Here is what the daily workflow looked like before the custom platform.

Morning started with opening the spreadsheet and checking which tabs needed updating. Someone would call carriers to get shipment status, then manually update each row. Customer inquiries meant searching through multiple tabs to find the right shipment. Generating a customs document meant copying data from five different tabs into a Word template. End-of-day reporting meant exporting data from multiple tabs, pasting it into a summary sheet, and manually calculating totals.

The team spent more time managing the spreadsheet than managing shipments.

The Custom Platform

We built an operations platform that handles the full lifecycle from booking to delivery.

Shipment Tracking

Real-time status updates pulled from carrier systems. No more calling around. The dashboard shows every shipment, its current status, and any exceptions. Automated notifications keep customers informed without manual effort.

Document Generation

Customs documents auto-generated from shipment data. No more copying between tabs. The system pulls the right data, fills the right template, and generates the document in seconds. Digital signatures replace printed forms.

Customer Portal

Customers log in to track their shipments, access documents, view invoice history, and see communication history. No more "where is my shipment" phone calls.

Billing and Reconciliation

Invoices generate automatically from completed shipments. Payment tracking links to each shipment. No more manual reconciliation at month-end.

The After State

After the platform went live, the daily workflow changed completely.

Morning starts with a dashboard review. All shipment statuses visible at a glance. Exceptions highlighted automatically. Document generation takes minutes instead of hours. Customer inquiries resolved in seconds by looking up the shipment in one place. End-of-day reporting runs automatically.

The team stopped managing data and started managing shipments.

Real Results

Document generation time dropped from hours to minutes. Customer inquiries decreased because of self-service tracking. Errors decreased because of automated validation. And visibility increased because of the real-time dashboard.

The freight forwarder now handles 30% more shipments with the same team. Not because they work harder. Because the system works for them.

Implementation Approach

Building freight forwarding software does not happen all at once. The practical approach is to start with the biggest pain point, usually document generation or shipment tracking. Build incrementally. Add features as the team adopts the system. Integrate with existing tools. Connect to accounting, email, and other systems. And train the team. The best software fails if people do not use it.

Next Steps

Running a freight forwarding operation on spreadsheets? WhatsApp us at +230 5458 6879 to discuss how a custom platform could work for your business.

Need help with this?

WhatsApp us for a no-obligation conversation about your specific situation.

Related Reading