Case study · Transport

From Google Sheets to a TMS built around the business

An international road haulier ran trips, invoices and drivers on Google Sheets and WhatsApp. In 8 weeks I moved everything into one system with GPS tracking, AI checks and automated invoicing.

TMS = Transport Management System. The system where a transport company runs its orders, trips, fleet, documents, invoicing and payments, all in one place.

Client: international road haulier based in RomaniaFleet: own trucks + subcontractorsLive since: September 2026
8 wksfrom kick-off to daily use
380+updates, from the team requests
1×a trip is entered once
The client and the problem

Everything lived in spreadsheets and chats.

An international road haulier with its own fleet and subcontractors. Until September 2026 this is how operations ran:

  • each trip was typed by hand into several sheets (planning, invoicing, driver expenses)
  • the only way to know where a truck was: call the driver
  • client orders and CMRs were checked by reading PDFs one by one
  • invoices were made separately, with the risk of missing a trip or using the wrong price
  • margin per trip was visible only at month end
The solution

A trip is entered once.

I built a dedicated TMS starting from their own spreadsheets: imported the whole trip history, kept the words and the order they worked in, then rolled it out module by module while the team kept working. Today a trip is entered once and flows from there: the subcontractor order, GPS tracking, document checks, the invoice and the margin.

Before

Planning sheetInvoicing sheetDriver expenses sheetSubcontractors sheetPayments sheetWhatsApp with driversOrders by emailHand-made invoices

After · TMS

  1. The trip is entered once
  2. PDF order goes to the subcontractor
  3. GPS updates the status
  4. AI checks the order and the CMR
  5. The invoice is issued from the system
  6. Margin is visible on every trip
Fleet map with each truck's GPS position
Built to measure

A TMS made for your company, not boxed software.

  • Tailored to each client: I start from your real process, the sheets and the words you already use, not from a template.
  • Custom made: each module is built only if you need it, in the order of your priorities.
  • Connected to what you already have: your GPS provider, invoicing software, bank and email, through integrations.
  • Yours: it runs on your server, with your data, and grows with the company.
What the system does

Eight modules, one place.

Click a screenshot to enlarge it. Client data, amounts, addresses and registration numbers are hidden.

Trips and planning

One list of all trips, colour-coded statuses, saved filters per dispatcher.

Planner checklist

A client order becomes a trip in minutes, with a code, stops and a PDF order for the subcontractor.

GPS and monitoring

Statuses update themselves from GPS; alerts when a truck runs late or leaves its route.

AI document checks

AI reads the client order and the CMR, compares them with the trip and proposes fixes in one click.

Invoicing

Invoices issued from the TMS into the accounting software, emailed with the documents attached.

Real km

Real km from the truck's CAN / GPS computed after each delivery and compared with planned km.

Payments and finance

Subcontractor invoices, bank statements matched automatically, margin on every trip.

Tools

3D load planner, tachograph simulator, live fleet map.

Results

What changed, in numbers.

Aggregated figures from the system on 17 Nov 2026. The system has been live since 23 Sep 2026.

8 wksfrom kick-off to daily use
380+updates shipped, from the team requests
1×a trip is entered once
0phone calls to confirm a loading: GPS does it

The team works in one place, with the full trip history imported from the sheets. Loadings and deliveries are confirmed straight from GPS, and client orders and CMRs are read and checked by AI before invoicing.

Every change has an author and a timestamp. Real km from the truck computer are calculated after each delivery and compared with the planned km: a difference nobody could see before.

How we worked

Four steps, without stopping the business.

  1. Discovery

    Started from the existing sheets and how each person works.

  2. Import

    The sheet history moves in, cleaned and checked.

  3. Module rollout

    One module at a time, in parallel with the sheets, until they are no longer needed.

  4. Daily improvements

    Team requests ship the same or next day: 380+ updates in 8 weeks.

I can build this for you

What I can build for your company.

Every module below already runs in production at the client in this case study.

Orders and planning

  • New order / planner checklist
  • Automatic trip code
  • PDF transport order for the subcontractor, sent by email
  • Duplicating regular jobs
  • Quotes and request log

Best for: Any company that receives orders by email or WhatsApp

GPS tracking

  • Live fleet map
  • Statuses updated from GPS (loading, departed, delivered)
  • Monitoring with ETA and delay alerts in the local time of each country
  • Route deviation, breaks and driving hours
  • Real km from CAN / GPS

Best for: Own fleets with GPS (WebEye / Eurowag or any provider with an API)

Documents and AI

  • AI check of the client order against the trip (price, client, addresses, dates), updated in one click
  • CMR checks
  • Automatic document renaming
  • Driver app (CMR photos, confirmations)
  • In-app AI assistant

Best for: Companies with lots of paper or PDF documents

Invoicing and finance

  • Invoices issued from the TMS into your accounting software, PDF emailed to the client
  • Series per user, VAT / reverse charge per client
  • Invoicing blocked when documents or price are missing
  • Subcontractor invoices and payments, bank statement import
  • Statement per client, margin per trip

Best for: Companies invoicing in several countries or currencies

Fleet, drivers and reports

  • Truck and driver documents with expiry dates
  • Driver expenses (per diem, parking)
  • Daily email report, profitability
  • Subcontractor scorecard
  • 3D load planner, tachograph simulator

Best for: Companies with own drivers and subcontractors

You are not buying boxed software: I build on your process, starting from the very spreadsheets you use today.

Contact

Still running on spreadsheets?

Tell me what you use today and in 30 minutes I'll show you what can be automated.

FAQ

Frequently asked questions

What is a TMS?

TMS stands for Transport Management System: the application where a transport company manages its orders, trips, fleet, documents, invoicing and payments. I do not sell a boxed TMS: I build it to measure (tailored, custom made), starting from each client's process.

Do we drop our spreadsheets on day one?

No. Both run in parallel until the system covers them.

Does it connect to our GPS and invoicing tools?

Yes, if the provider has an API (e.g. WebEye / Eurowag, FGO, SmartBill, Xero).

How long does it take?

First modules in 2–4 weeks; this project, everything in 8.

Who owns the system?

Yours: it runs on your server, with your data.

Is it only for transport?

No: the same approach fits any company that has outgrown its spreadsheets.

Case study by Codrin Chicuș · published 17 November 2026