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