How to Check Author Royalty Statements Against Book Sales
A paperback and an ebook share a title. They can still carry different royalty terms, and a title-level total can hide a format billed under the wrong rule.
What to pull
Use Excel sales, terms and statements or export sales and royalty lines from your distributor and rights systems. Keep ISBN, format, rate basis and dates.
How to check it
Match each eligible sale to its format and terms. Apply the documented base and tiers. Separate advances, reserves and earlier adjustments.
Select the relevant sheets in Jolene.pro and run this check.
Which lines differ from the supplied royalty terms? Show the affected amounts and source rows.
What to do with the result
Give the rights team the transactions and the applicable term for each exception before they finalize the statement.
Verify signed agreements and royalty policies before changing a statement.