Royalty Engine — Internal System

Custom system that replaced spreadsheets for royalty calculation at a Portuguese publisher.

Challenge

Contract management and royalty calculation were being done in spreadsheets, with dozens of different rules per sales channel. A manual process, error-prone, consuming tens of hours every month.

Solution

We built an internal system in Laravel that automates the entire pipeline: imports sales data from multiple sources (GfK, physical stores, direct sales, e-commerce), applies complex royalty calculation rules per contract, and generates reports automatically.

Outcome

770+ contracts, 1,459 titles, 435 authors and 12,569 royalty rules processed in 2025. €414K calculated in royalties (€281K payable). Zero errors since implementation. Monthly closing time reduced from days to minutes.

Stack used

PHP · Laravel · MySQL · SQL Server · ETL for sales channels (GfK, retail, direct sales)

Got a similar project?

Talk to the team