r/publishing • u/MarkMoreland • 4d ago

Royalty Dashboard

I have received a request from several of my authors for more detailed royalty reporting, showing format and channel, for example. Currently, my royalty reports are just ledgers, and I'm looking for some sort of spreadsheet template I can use to generate a dashboard to more visually display a breakdown of where revenue for a specific title or all of an author's titles are coming from?

I know there are paid services to track this sort of thing, but we only publish a few royalty-based titles a year, and it's not worth it for our small operation to use a service like Bibliosuite or MetaComet for just a few dozen titles of backlist and 3-4 new releases a year. So if I can replicate the end result of that with some pretty visuals, that would be ideal. I'm even willing to pay for a template if someone is selling something like that on Etsy or wherever.

0 Upvotes

50% Upvoted

2 comments sorted by

1

u/borbva 4d ago

Do you have a data/analytics team in-house? I'm a data analyst at a big publisher and your request sounds exactly like my whole job! If you don't have an in-house team, but are willing to pay an amount for this work, then maybe consider a freelance analyst? And if that would be too expensive, I would honestly just Google stuff and try to replicate some of the visuals yourself. There is a lot of free data visualisation content out there.

1

u/growltiger_nimbus 3d ago

Look into the BISG Proposed Standard Royalty Statement