Odoo How Odoo Is Transforming Supermarkets in Uzbekistan: A Real Case Study
If you run a supermarket or grocery store in Uzbekistan, and you want transparency, control, and growth — Odoo is the sy...
Measuring fleet profitability in liters is a mistake. Odoo ERP connects each trip’s revenue to its full cost and reveals which routes are losing money.
The month has closed at a transport company in Tashkent. The trucks ran nonstop, orders were plentiful, and money came into the bank account. Yet profit was 80 million soums below plan. The drivers are the first suspects: where did all the diesel go?
The question should be asked differently: which trip cost more than it earned? Odoo ERP assigns a separate analytical account to each run and reveals that gap. The system connects order revenue with diesel, driver pay, repairs, depreciation, and empty-return costs. The manager can then see that the Tashkent–Samarkand route is profitable, while the rate for the Tashkent–Karshi route needs to be recalculated.
We often see the same mistake in fleet operations: liters and kilometers are monitored, but trip margins are not calculated. The margin of every trip must be calculated. Otherwise, a small increase in diesel prices can turn into a substantial loss within just a few months.
The Problem Is Not in the Fuel Tank, but in the Accounting Model
Many companies have a fuel spreadsheet listing the vehicle, date, liters, and driver. The spreadsheet records consumption, but it does not tell you whether that consumption was justified. The same 300 liters of diesel may generate a profit on an urgent, high-value order. On a low-rate trip followed by an empty return, however, that same consumption can push the company into the red.
Golden Pages listings show that filling station prices vary across Tashkent. That is why the system should record not a standard estimate, but the actual price paid per liter and the specific trip on which the fuel was used.
What Goes into the Full Cost of a Trip?
If you count only fuel, the report may show a profit. But the money will not remain in the account.
01
Diesel Costs
The liters purchased, the price paid, and actual consumption on the route.
02
Empty Mileage
Kilometers traveled without cargo on the return journey are also included in the order’s cost.
03
Driver Pay
Trip pay, daily allowances, and additional payments are allocated to the relevant run.
04
Share of Repair Costs
The cost of tires, oil, and spare parts is assigned to the relevant vehicle.
05
Depreciation
The vehicle’s depreciation cost is allocated by mileage or accounting period.
06
Cost of Delays
Penalties and downtime are deducted from the trip margin.
How Can a Trip Look Profitable but Still Lose Money?
Let’s look at a hypothetical calculation. A customer paid 5.2 million soums for a Tashkent–Karshi trip. Diesel cost 2.15 million soums, driver expenses were 750 thousand soums, the share of repair costs was 520 thousand soums, and depreciation came to 680 thousand soums. If the calculation stops there, the trip appears to have generated a profit of 1.1 million soums.
But the truck returned empty from Karshi. The return journey alone cost another 1.35 million soums. The trip’s actual result was a loss of 250 thousand soums. If the same run is repeated eight times a month, the company loses two million soums even though its trucks remain busy.
Warning
GPS shows where a vehicle traveled and how much distance it covered. If that data is not connected to financial accounting, you cannot tell whether the trip made or lost money for the company.
Full trip cost includes diesel, driver pay, repairs, depreciation and the empty return.
How Does Odoo Connect the Data?
According to the Odoo 19 documentation, the Fleet module tracks vehicles, contracts, and service costs. Analytic Accounting makes it possible to separate these costs by route or trip. We recommend structuring each run as a separate analytical object. This makes fleet accounting traceable and verifiable.
Revenue comes from the sales order. Data from a fuel card or GPS system is assigned to the relevant trip through an API. Purchase and accounting entries then add repair costs. The final report breaks down the trip margin by vehicle, driver, customer, or route.
Five Steps to Implementation
Do not rush to build a large dashboard. First, calculate the economics of a single trip correctly.
- Identify the Trip Give each order a unique number, then link it to the route, vehicle, and driver.
- Connect the Costs Assign fuel, repairs, and driver payments directly to that trip.
- Define Allocation Rules Agree on whether depreciation and overhead costs will be allocated by mileage or by working day.
- Verify the Margin Test the calculation first using dozens of actual trips on a single route.
- Set Up an Alert If the margin falls below the defined threshold, notify the responsible manager via Telegram.
Unified analytics connects order revenue with every expense of the specific trip.
The Report Should Force a Decision
A beautiful chart does not save money. A useful report clearly separates the causes of a loss: is the rate too low, is diesel consumption above the standard, or did the truck return without cargo? If the cause is unclear, the manager is likely to make the wrong decision.
If the rate is too low, pricing is renegotiated with the customer. If there is too much empty mileage, return loads are planned in advance. If the problem keeps recurring with one vehicle, the company can consider a technical inspection or replacement. An Odoo report should show not only the problem, but also the next task and the person responsible for it.
A busy truck is not always a profitable truck.
Celion engineering team
The Most Common Mistake: Automating Too Early
Some companies start connecting GPS, fuel cards, accounting, and a mobile app in the very first week. The volume of data grows, but no useful report comes out of it. The reason is simple: the same trip number is recorded differently across different systems.
Agree on the economic model first. When does a trip begin and end? Which order should absorb the cost of an empty return? How should overhead costs be allocated? Without one clear answer to each of these questions, automation will only multiply accounting errors faster.
An empty return leg can turn strong trip revenue into an actual loss.
The Results Every Manager Should See
A fleet report should clearly show the following results:
- Liters Are Not Enough. Compare fuel consumption with revenue and the full cost of the trip.
- Treat Every Trip Separately. An average result for the route may conceal an individual loss-making run.
- Do Not Forget the Empty Return. Kilometers traveled without cargo are often omitted from trip accounting, distorting the margin.
- Model First, API Second. Approve the rules for connecting costs to trips before starting the integration.
- Make the Report Drive Action. When a loss is identified, assign someone to make the necessary decision about the rate, route, or vehicle.
Frequently Asked Questions
Does Odoo replace a GPS tracking system?
No. GPS collects location, distance, speed, and, on some devices, fuel readings. Odoo connects this data with orders, invoices, and expenses. When the two systems are connected through an API, GPS shows vehicle movement, while Odoo shows the financial result of that movement.
Does a small fleet of 10 to 20 vehicles need Odoo?
Yes, if the company works with multiple routes, customers, and rates. The issue is not the number of vehicles, but which trip each cost is assigned to. A small fleet can start with a compact accounting model covering the trip, revenue, diesel, driver pay, and repair costs. That information alone can reveal where losses are emerging.
Can fuel data be entered manually?
Yes, during the initial stage. An operator can enter the liters, price, and vehicle from a receipt or fuel card report. Once the calculation has been tested on several actual trips, data entry can be automated through an API or file import. Testing the model manually first is cheaper than automating an incorrect model.
Should a loss-making route be closed?
Not immediately. First, identify the source of the loss. The cause may be a low rate, an empty return, excessive fuel consumption, or a vehicle that requires frequent repairs. Sometimes increasing the rate by 5% to 7% is enough. In other cases, finding a return load or replacing the vehicle may be more profitable.
How Much Profit Are Your Trips Really Generating?
The Celion team connects Odoo ERP, GPS, and accounting systems to calculate the true profitability of every trip. We begin with actual data from a single route. Once the calculation has been verified, we build a management dashboard and AI-based cost forecasting. Contact us.
