Portfolio JET DP Trans
What each truck earns, in two currencies
A custom system for a haulage company that records each trip with its costs and shows the financial result by truck, client and employee.
Project
JET DP Trans
- Client
- The transport arm of JET DP It carries freight across Europe and works in zloty and euro at the same time.
- System
- Fleet and finance management: trips, costs, cash desks, settlements and driver pay Multi-currency from the start: every amount in its own currency and in the base one.
- Our part
- Process analysis, data structure and document flow, multi-currency and payroll logic, reporting Also the interface and back end, testing and roll-out.
- Stack
-
- PHP
- Laravel
- Livewire
- MariaDB
- FullCalendar
- Currencies
- PLN and EUR Each kept separately and rolled up into the base currency.
The task
Profit hidden across spreadsheets
A carrier’s profit is the invoice total minus what a particular truck cost over the same period. That data was scattered, and working out what each truck had earned took days of merging spreadsheets.
Trips separate from costs
Trips were kept in one place, fuel and repairs in another, and driver pay was calculated by hand. The result per truck couldn’t be seen without pulling it all together.
Two currencies
Clients are invoiced in zloty and in euro, costs arise in both, and part of the money is exchanged. The accounts had to be kept in each currency and still roll up into the base one.
Driver pay by the day
Pay is accrued per day, at a rate that depends on the truck and the period, and only for days actually spent on a trip. Days off count separately, and overlapping trips have to be caught.
One page for management
Management needed one page with the company’s result for the period, opening into detail by truck, client, supplier, employee and cash desk.
Solution
One register, two currencies, one report
One register for all documents
Trips, goods received and issued, money in and out, and currency exchange. Each document stores its amount in its own currency and converted to the base one, so any total can be seen in PLN, in EUR or combined.
A trip carries its costs
A trip records the route, client and amount, plus the truck, trailer, driver, start and end dates, paid and empty kilometres and fuel use. The price comes from the client’s rate for that direction.
Costs by category
Fuel, parts, tolls, fines, taxes and administrative costs are recorded by category and tied to a truck or an employee.
A calendar per driver
Trips show as events on the month, days off are marked with one click and overlapping trips are highlighted. From the calendar the system counts the days worked and pays them at the truck’s daily rate for that period.
The main report on one page
The company’s result for the period, with tabs by truck, client, single client, supplier, employee and cash desk. For each truck: invoiced amounts, mileage, fuel, driver pay and costs, which together give its profitability.
Cards, files and a full history
Every counterparty, truck, cash desk and warehouse has a card for any period with all operations and the closing balance. Invoices, receipts and scans attach to documents, all actions are logged, posted documents can’t be deleted and financial data is limited by role.
Capabilities
From trip to driver pay
01 · 6
Documents and currencies
- One register for documents of every type
- Multi-currency accounts in PLN and EUR, converted to the base currency
- Currency exchange documents
- Two-stage posting: accounting status and tax status
- Bulk operations on a selection of documents
- Files and scans attached to documents
02 · 6
Trips and fleet
- Trips with route, truck, trailer, driver and dates
- Paid and empty kilometres and fuel use
- Each client’s own rates by direction, and carrier tariffs
- Cost categories: fuel, parts, tolls, fines, taxes, pay and more
- Items and stock by warehouse
- Odometer log per truck
03 · 3
Drivers and pay
- Daily pay rates per truck, with periods of validity
- Driver calendar with trips, days off and highlighted overlaps
- Days worked and pay calculated automatically
04 · 5
Reports and control
- Summary report with tabs by truck, client, supplier, employee and cash desk
- Cards for counterparties, trucks, cash desks and warehouses, with a balance for any period
- Role-based access that limits financial data
- Posted documents protected from deletion, full change history
- Filters, column settings and export to Excel
Result
Every truck’s result, for any period
A trip, its costs and the driver’s pay are now recorded together, so the result for each truck can be seen for any period, with no spreadsheets to merge by hand.
Every amount is stored in its own currency and in the base one, so nobody converts between zloty and euro by hand any more. The system works out driver pay from the calendar, and the summary report gives management all the figures on one page, from fleet profitability to the balance of each cash desk.