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 channels with different structures (retail, direct, digital, distribution), applies complex royalty calculation rules per contract, and generates reports automatically.

Outcome

Hundreds of contracts, thousands of titles and hundreds of authors processed without manual intervention. Zero errors since implementation. Monthly closing time reduced from days to minutes.

Stack used

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

Got a similar project?

Talk to the team