← All insights
Case study

Transnet (TNPA): Automating cargo dues collation across all ports

From manual, per-arrival data capture to one automated run that checks every vessel and port.

Client
Transnet (TNPA)
Practice area
Finance Transformation
Function
  • Revenue assurance
  • Port finance
  • Cargo dues collation
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
  • Alteryx
  • Alteryx Gallery
  • Excel

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.

Key takeaways

One automated run now checks every vessel, item and port, instead of capture per arrival.

Port teams run the report themselves on Alteryx Gallery, for one vessel or a date range.

Next steps named: a Tableau dashboard, duplicate checks, and new automations for the Real Estate and Litigation teams.

Finance Transformation

Talk to us about your Finance Transformation

Want business-led automation and AI solutions for your team?

60-minute session. Bring a process, we'll show you how we'd fix it.