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

Portfolio KAM TRANS

Trips, cargo and money in one ledger

A custom ERP where each trip, tonne of cargo and payment is recorded as a document and shows up straight away in the balances with the company’s counterparties.

Project

KAM TRANS

KAM TRANS · project Bulk and construction cargo
Client
A haulage company It carries bulk and construction cargo, on its own trucks and with hired carriers.
System
An in-house ERP for trips, stock, cash and settlements Used every day by logistics, accounting and management at once, with access split by role.
Our part
Process analysis, data structure and document flow, interface and back end Also access rights, testing and roll-out.
Stack
  • PHP
  • Laravel
  • Livewire
  • MariaDB
Settlements
Balances with every counterparty Clients, suppliers, carriers and staff, for any period.

The task

Carrier and broker, priced by hand

The company is both a carrier and a broker: some trips run on its own trucks, others on hired carriers. Prices, stock and money were kept in separate places and pulled together by hand.

Prices with many variables

The cost of a trip depends on the route, on the client and on what the amount covers: carriage, forwarding or forwarding fees. Price lists were kept separately, and each trip was priced by hand.

Stock by warehouse

Cargo is measured in tonnes, litres and pieces and kept in several warehouses. The company needed a separate balance for each item in each warehouse.

Who owes whom

Cash desks, client payments, settlements with carriers and staff. Answering the daily question of how much a counterparty owes the company, and how much the company owes them, meant pulling data from several sources.

Access by role, history kept

Logisticians work with trips but mustn’t see the company’s finances, and a posted document can’t be changed after the fact without leaving a trace.

Solution

One register for trips, goods and money

One register for all documents

Trips, goods received and dispatched, money in and out: different document types with their own forms, but one posting logic, one change history and one set of access rules.

The client’s rate applied automatically

The operator picks the client, the route and the truck, and the system applies the client’s rate for that pair of cities and calculates the amount. The route fields only offer directions the client has a price for.

Regular trips in one click

A document can be duplicated: the new trip starts with the previous one’s data already filled in.

Two statuses, in bulk

A document is first posted in the accounts, then separately marked as registered for tax. Both can be done for a whole selection of documents at once, with a report on each one.

A card for each counterparty

For each client, supplier, carrier, truck, employee, cash desk and warehouse, the system builds a card for any period: all operations, the turnover and the closing balance, split into the total, forwarding fees and forwarding.

A full change log

Each action is logged with its author, the time and exactly what changed. A posted document can’t be deleted, and the right to create, edit or see financial data depends on the user’s role.

Capabilities

What the system records

01 · 5

Documents

  • One register for documents of every type
  • Trip documents with route, truck and cargo
  • Goods received and dispatched
  • Cash documents for money in and out
  • Documents duplicated for regular trips

02 · 5

Prices and stock

  • Each client’s own price list by city-to-city route
  • Separate rates for hired carriers
  • Price applied by route and amount calculated automatically
  • Stock kept in tonnes, litres and pieces
  • Stock balances by warehouse

03 · 5

Settlements and reports

  • Two-stage posting: accounting status and tax status
  • Bulk operations on a selection of documents
  • Cards for counterparties, trucks, cash desks and warehouses, with a balance for any period
  • Directories of regions, cities, trucks, staff and counterparties
  • Filters, column settings and export to Excel

04 · 4

Access and control

  • Role-based access that limits financial data
  • Posted documents protected from deletion
  • Full change history for every record
  • Database backups from the admin panel

Result

Trips, cargo and money, linked together

The client’s route tariff is now applied automatically, so trips are no longer priced by hand and prices no longer diverge from the price list.

Trips, cargo and money are kept in one system and linked to each other. A counterparty card shows at once who owes whom, and the change log and protected posted documents make each entry traceable for inspection and audit.