Educational worksheet

Royalty reconciliation practice dataset

Synthetic catalog with duplicates, unmatched recordings, inconsistent shares, currency difference and a late adjustment.

This is not a substitute for a document drafted by a qualified local professional.

Exercise

Import
Match
Exception queue
What remains unresolved

Synthetic practice dataset

Fictional catalog. Keep licensed customer information out of exercises. A corrected row is not a legal ruling on ownership. The MLC example in sources is U.S. digital mechanical scope only.

Work	Recording	Share on file	Planted issue
River Light	River Light (main)	50/50	none
River Light	River Light (radio edit)	50/50	duplicate title — confirm identifiers
Night Bus	Night Bus	100 writer A	unmatched recording on statement B
Glass Harbour	Glass Harbour	40/40/20 vs 50/50	inconsistent share
Copper Wire	Copper Wire	50/50	currency difference USD vs EUR
Late Window	Late Window	50/50	late adjustment in period 2

For each issue, write: how you found it, what evidence is needed, and what remains unresolved.