Skip to main content
Alberto Ortiz logo Alberto Ortiz Data · BI · Automation
ES

Sector · Logistics and transport

Data and automation for logistics: reports per customer, cost per kilometre and the operation in plain sight

I spent several years inside a logistics operation with a presence in Spain, Europe and Morocco: internal applications, dashboards and the reports customers expect every week. I know what data a carrier has, where it gets stuck and what the people running the operation want to see.

  • Weekly reports per customer generated and sent on their own
  • Cost per kilometre, per route and per vehicle in a self-updating dashboard
  • Fuel surcharge and rate revisions calculated from official sources

30 minutes · no obligation · reply within 24–48h · or take the guided quick assessment

Illustration of transport routes with cost and delivery indicators

Timeline

1–3 weeks

Price

Fixed

Support

30 days

Does any of this sound familiar?

These are the situations people call me about. If you recognise one, there are hours to be won back.

Every customer’s weekly report is assembled by hand

Export from the TMS or ERP, filter by customer, paste into their template, check, send. Multiplied by the number of customers, every Monday.

The fuel surcharge is revised late or by eye

The revision clause depends on official indices that change every week. If nobody updates it in time, margin leaks away unnoticed until month end.

Nobody sees the cost per kilometre in time

Fuel, tolls, driver and vehicle live in different systems. Profitability per route or per customer is worked out at the close, when it can no longer be corrected.

Delivery notes, CMRs and invoices someone types in

Documents that arrive as PDFs, by email or on paper and are keyed into the system by hand, with the errors and delays that brings.

What you get

No slide decks: concrete deliverables your team uses from day one.

Automated reports per customer or branch

Activity, kilometres, cost per km and deliveries, in the format each customer expects, generated and sent on their own with configurable week windows.

Operations dashboard

On-time deliveries, kilometres, utilisation, costs and profitability per route, customer and vehicle, self-updating and built for whoever runs the operation.

Automatic fuel surcharge

The index is taken from official sources, the revision is calculated according to the contract formula and proposed for approval. No rate changes without someone seeing it.

Documents that process themselves

Reading of delivery notes, CMRs and supplier invoices and their validated upload into the system, with no typing.

Lightweight internal applications

Custom cloud tools (serverless on AWS) for operations tracking, lookups or calculations that currently live in a shared spreadsheet. No servers to manage.

Training and handover

Documentation, a session with the team and 30 days of support. When the project ends, the operation maintains it without depending on me.

A real case

The pattern repeats in almost every project: the process stays the same, it just stops being done by hand.

ESP Solutions · International logistics

Reports per customer and a monitored operation with no servers to manage

Before

Weekly reports per customer assembled by hand from system exports, and an operation across three countries with no shared view of activity and costs.

After

Serverless internal applications on AWS, operational dashboards and automated reports per customer (activity, kilometres, cost per km) exported to Excel ready to send, with configurable rolling week windows.

More cases by sector on the home page.

How I work

No six-figure projects or long commitments: we start small and measurable.

Step 1

Free diagnostic call

A 30-minute video call: you walk me through the process and I tell you whether it makes sense, how I would approach it and what it would cost.

Step 2

Fixed-price pilot

A first, well-scoped project with a fixed price agreed up front and a result you can measure.

Step 3

Delivery, training and support

Everything documented and your team trained to maintain it. 30 days of support for questions and adjustments.

See the full method: phases, timeline and deliverables →

Calculator

What does your customers’ weekly report cost today?

Think of the report someone builds every week for each customer from the TMS or ERP. Move the sliders and see what it costs per year. No sign-up.

4

1 = monthly · 4 = weekly · 20 = every working day

3 h

Include checking, fixing and sending. It is usually more than it seems.

€25

Cost to the company, not net salary. An admin role is around €18–25; a manager, €40–60.

What it costs you today

Hours per month
0 h
Hours per year
0 h
Working days per year
0
Estimated annual cost
€0

Conservative estimate: it leaves out typing errors, delays and review time.

Get the breakdown by email

I’ll send you this detailed calculation plus the checklist “10 signs your Excel has outgrown itself” as a PDF.

No spam. One email with the report and, a few days later, one more. That’s all.

Frequently asked questions

Do you work with our TMS or ERP?
With any system that exports or gives access to its data: files, database or API. There is no need to switch systems; everything is built around what you already use and the Excel your customers already know.
Can you automate the fuel surcharge?
Yes. The index is taken automatically from official sources, the revision formula set in your contract is applied and the result is proposed to whoever approves it. I have done it for a real operation and it is one of the processes with the best ratio of effort to margin recovered.
Does this work for a small fleet?
Yes. The smaller the structure, the more each hour of admin weighs. We start with the report or process that eats the most time, as a fixed-price pilot, and expand only if it works.
What about customer data and rates?
I work on your own systems and access; nothing is copied to external services. Confidentiality terms are agreed in writing before we start, and for the diagnostic call an example with masked figures is enough.
How long does it take and how much does it cost?
A first automated report is usually ready in 1–3 weeks; an operations dashboard in 2–4. The price is fixed and agreed after the free diagnostic call, normally as a pilot on the report that eats the most hours. No hidden hours.

The next step is a conversation

Which report do you send your customers every week?

Tell me on the free 30-minute diagnostic call. I will tell you what can be automated as is, what needs tidying first and what it would cost. No obligation.

Where should I start?Guided quick assessment · 2 min