Trucking Business Management System in Excel – Profit per Load
See which loads, trucks and lanes really make money after fuel, empty kilometres, repairs and driver pay – and which customers pay late – before you accept the next load or buy another truck. This is a complete back office for a trucking business in Excel: eight connected workbooks that already work with sample data, so you see every alert and dashboard before you type your first load.
Built for owner-operators and small fleets – one truck or a growing fleet of several trucks and drivers – dry van, reefer, flatbed or box truck.
What you get:
- ✓ 8 connected workbooks: loads, rates and dispatch; invoicing, collections and factoring; fuel and fuel tax by region; trucks, trailers and maintenance; drivers, pay and settlements; compliance, safety and documents; costs, cost per km and lane profit; finance, cash flow and growth
- ✓ 550 ready pages: dashboards, calculators, printable forms and documents, checklists and ready WhatsApp messages
- ✓ 15 languages as blank templates, plus filled copies with sample data in English and Spanish
- ✓ Standard xlsx files for Microsoft Excel and LibreOffice – no macros, no subscription
How it works: 1) open the workbook in your language, 2) type your loads, fuel, repairs and pay in the yellow cells, 3) profit per load, cost per km, due dates and cash forecasts update by themselves. One payment, instant download.
- Know the profit of every load after fuel, empty km and driver pay
- Quote rates that cover your true cost per km on every lane
- Invoice every load fast and chase every overdue customer
- Compare factoring with waiting for payment, before you sign
- Track fuel per truck, price swings and fuel tax per region
- Plan services before breakdowns and see repair cost per km
- Pay drivers right: per km, per load or per hour, with settlements
- Never miss an expiry: licences, inspections, permits and insurance
- Find the lanes, customers and trucks that quietly lose money
- See the cash you will have in 13 weeks and plan big payments
- Decide when to add, replace or sell a truck with real numbers
- Send customers and drivers ready messages in one tap
Do I need special software?
No. The files are standard xlsx files that open in Microsoft Excel and in LibreOffice Calc, which is free.
Does it work for one truck and for a small fleet?
Yes. It works for an owner-operator with one truck and for a fleet of several trucks and drivers; the sample data shows eight trucks, eight drivers and twelve customers.
Does it connect to my tracking device or load board?
No. It is a set of workbooks: you paste or type your loads, fuel, repairs and pay, and every profit, alert and report updates from there. Nothing to install and no account to link.
Do I have to enter the same data twice?
No. Each fact is entered once in its table, and every dashboard, alert, tool and report reads it from there.
Can I use kilometres or miles, and my own tax rates?
Yes. Distances, fuel units, tax rates per region, pay rates, thresholds and dates are all on the settings and list sheets, and every formula follows your changes.
Which languages are included?
Fifteen: English, Arabic, French, Spanish, German, Italian, Portuguese, Turkish, Dutch, Russian, Persian, Urdu, Hindi, Chinese and Indonesian, all as blank templates, plus filled copies with sample data in English and Spanish.