Skip to main content
Discuss your project Custom business systems & automation

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

JET DP Trans · project Freight across Europe
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.