TEMPLATEROYALTIES · TEMPLATE · 9 MIN
Royalty statement files, six distributors, one shape
A royalty statement maps onto recording, store, territory, units, and revenue. Do not invent a publishing column.
Royalty Lens · updated Sep 2026
The exports do not share headers. DistroKid tends to give you a store and an earnings column. TuneCore’s total earned is the figure most files are built around. CD Baby often splits downloads from streams. Symphonic and AWAL add territory and a product type. UnitedMasters sometimes separates a campaign from organic. Read the header you were sent. Do not assume last quarter’s file still uses it.
Map each row onto one shape: recording title, artist, ISRC, store, territory, product (stream, download, or other), units, and the revenue the file says was paid. If a fee is broken out, keep it in its own column so you do not subtract it twice.
Do not create a publishing or neighbouring column from a distributor export. Those payments are not in this file. Royalty Lens keeps the mapping you confirm. It does not log into the distributor, and it does not move the money.
STATEMENT MAP Recording title: Artist: ISRC: Store / DSP: Territory: Product (stream, download, other): Units: Revenue the file says was paid: Fee, if the file breaks it out: Leave a field blank when the export has no such column. Do not add publishing or neighbouring rights here.