The Challenge
The Container Royalty Central Collection Fund was jointly created by the International Longshoremen’s Association (ILA) and USMX to solve a longstanding problem: container royalty fees — paid by transoceanic carriers for every container loaded and unloaded at ILA-serviced ports — were calculated and tracked in a fragmented, largely manual process. With fees assessed across five distinct funds, dozens of carriers, and ports spanning the entire U.S. East and Gulf Coasts, the margin for error was enormous and the administrative burden was unsustainable.
A System Built for the Complexity of Maritime Finance
We designed and built a multi-role enterprise web application to manage the full royalty lifecycle — from cargo manifest import to invoice generation to QuickBooks disbursement. The system handles the complete data pipeline: carriers upload voyage manifest files via FTP, the application parses and validates the data, calculates royalty charges against a rule-based fund rate engine, generates invoices, and exports bills and payments to QuickBooks Enterprise — all with minimal human intervention.
The application supports granular role-based access for every stakeholder: CRCCF administrators with full visibility across all ports and carriers, port operators managing their own station data, and carrier users tracking their voyages, invoices, and filings — each seeing only what they’re authorized to see.
The Architecture Behind the Automation
The system was architected around a structured Oracle database with a comprehensive stored procedure layer, ensuring all data access is controlled, auditable, and protected. A timer-driven Enterprise Service Bus handles automated charge generation, invoice creation, and accounting system synchronization on a scheduled basis — removing the need for manual trigger points in the financial workflow.
Weight adjustments, moratoriums, supplementary charges, and credit memos are all handled within the system, with a full audit trail maintained for every change.
Built to Evolve
The application has been in continuous operation since 2013 — adapting to changing fund rules, carrier requirements, and reporting needs with each passing year. It has also spawned additional projects, including a damaged container tracking system, demonstrating how a well-architected platform becomes a foundation rather than a fixed deliverable.
The Result
Over 80,000 ILA members across 14 East and Gulf Coast ports benefit from a royalty process that is accurate, transparent, and fully auditable. Carriers, ports, and fund administrators all operate from the same authoritative data — and the manual bottlenecks that once defined this industry function have been replaced by an automated pipeline that runs reliably, billing cycle after billing cycle.