Royalty Dashboard

[u/MarkMoreland]

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.

[u/growltiger_nimbus]

Look into the BISG Proposed Standard Royalty Statement