- Client
- Transnet (TNPA)
- Practice area
- Finance Transformation
- Function
- The problem in one line
- Capturing cargo dues orders by hand, per arrival, made checking revenue completeness slow and open to error.
- The outcome in one line
- An automated collation report now covers single vessels, many vessels or a date range, for every port, in one run.
- Technologies used
Background
Cargo dues are charged on all cargo, whether commodities or containers, full or empty, at every port owned, controlled or managed by the National Ports Authority.
Collation checks that revenue is complete, meaning cargo dues were paid for all cargo landed or shipped. It has four steps: data gathering, exception generation, mismatch management and finalisation.
Ports compile the collation report when ships arrive. It checks that cargo offloaded matches what the client paid for through shipping agents. Differences are followed up with agents or clients.
The Challenge
Customers submit cargo dues orders. These are checked against the outturn report from the port terminals. If exceptions appear, an exception report is generated through the Customer Relationship Management (CRM) system.
Cargo dues order data is captured into the CRM by hand, per arrival. This is tedious and repetitive. The biggest problem is the high volume of data, which varies in complexity from commodity to commodity.
- Manual, repetitive capture of cargo dues order data per arrival.
- High data volume, with complexity that varies by commodity.
- Time-consuming, inefficient verification.
- Risk of human error; items or ships can be missed.
- No central view of reconciled revenue across ports.
The Solution
A solution built in Alteryx automates the collation process and cuts manual work and human error. It blends the outturn reports and cargo dues orders into an automated exception report in Excel. Data preparation and profiling features let the Finance team combine and analyse orders and outturns.
The process is automated across all ports and gives one view of reconciled revenue at TNPA level. Checks run per row, per vessel and across all ports at the same time, with extra logic for outer-anchorage vessels.
The solution sits on Alteryx Gallery, where team members at each port can run a collation report for a single vessel or arrival number, several, or a date range.
Business requirements also named: integration with SAP and other finance tools, security and compliance (encryption, access controls, audit logs), scale as the Finance Department grows, and analytics and reporting.
The Impact
- Less manual work and human error.
- More complete checks.
- A unified TNPA view of reconciled revenue.
- Easier for non-technical users.
- Can scale.