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
- 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.