How a regional freight forwarder replaced three spreadsheets with one internal tool — in under a week

Three spreadsheets. Zero visibility. Constant errors.

The operations team at this regional freight forwarder had grown faster than their tooling. Over years, they had accumulated three separate Google Sheets to manage the business: one for active shipments, one for driver and vehicle assignments, and one for client status reports sent out each morning.

The spreadsheets had never been designed to work together. Cross-referencing them was manual, updates were fragile, and when staff left, institutional knowledge walked out with them.

• Morning status reports took 90 minutes to compile manually each day
• Shipment updates had to be entered in multiple places, causing frequent inconsistencies
• New staff required weeks of onboarding before they could use the system reliably
• No real-time view of fleet availability or active deliveries

One call. One clear scope.

The discovery session ran for 90 minutes. We walked through each spreadsheet, mapped how data flowed (and where it broke down), and identified the three workflows that caused the most friction. By the end of the call we had a clear scope and a mutual agreement on what the first version needed to do.

We committed to a single operations dashboard that consolidated all three data sources, with a live shipment board, driver assignment interface, and one-click client report generation. Nothing more, nothing less.

In production by day four.

We built against a clear spec and kept the team in the loop with a shared staging environment throughout. By day two there was a working prototype. By day four the tool was live in production, with real data migrated from the old spreadsheets.

The second sprint — two weeks later — added automated morning report emails and a basic audit log for compliance. Both were classified upfront as new sprints before any work began.

• Unified shipment board with real-time status updates and owner assignment
• Driver and vehicle availability view with conflict detection
• One-click client status report generation (replacing 90 minutes of manual work)
• Role-based access for ops staff, dispatchers, and management
• Full data export at any time — no lock-in

Less time on admin. More time on operations.

Within two weeks of going live, the daily morning report went from 90 minutes to under five. Shipment entry errors dropped to near zero because data was entered once and flowed everywhere. New staff could operate the system after a single 30-minute walkthrough.

The team now manages more shipments with the same headcount — and has a tool that's genuinely built around how they work, not a workaround they've learned to tolerate.