-
Notifications
You must be signed in to change notification settings - Fork 0
Column Definitions: PRS Distribution Statement
The row number of the Performance data within this Statement.
The PRS Membership Number. Also known as an IPI. An IPI/CAE number is an international identification number assigned to songwriters and publishers to uniquely identify rights holders. The CAE system was replaced by the IPI system in 2001. These are typically 9-11-digit numbers and are assigned when a songwriter affiliates with a PRO. IPI/CAEs are often confused with PRO account numbers, so it is important to double-check that you are providing the correct number.
IPI stands for Interested Parties Information
CAE stands for Composer, Author, and Publisher (from the French éditrice)
e.g. 'P' for Publishing. There are two types of copyright in music. Publishing (P) and Master (M)
The distribution period that the data was collected for. The earnings in each Statement are not all generated in the reporting period, but they were collected together by PRS on behalf of the user within this period.
Distribution statements occur quarterly in April, July, October and December.
The number in this row has a year (Y), month (M), and an iteration (I).
YYYYMMI = 2020041 = The 1st April 2020 distribution.
In some cases there are two distributions. e.g. Online royalties only. If this occurred in April 2020 then the Distribution (posted) would be 2020042.
A text string that gives us detail on the source of the revenue. When paired with Usage Summary, this tells us where and how the tune was used.
e.g. Alliance Deezer France Limited Download / On Demand Streaming Service Single
tells us that the revenue came from a stream (streamed on demand and temporarily downloaded for that purpose) of the single tune on Deezer France.
e.g. German (GEMA) General & Broadcasting
tells is that the revenue came from a television broadcast in Germany. If the same programme was streamed on demand, the narrative would appear as German (GEMA) Online
One of a selection of categories that describes how a tune was used in order to generate the revenue for the row.
e.g. Online, Overseas, Music Supply Services, Radio, Television.
Complete list and definitions TBD.
Yet to see anything here. TBC.
The title of the tune as registered with PRS. e.g. Dead Beat
Amount earned for the Performance of the detailed in this row. Given in £ for GBP. Often fractions of pence e.g. 0.0224
Note: The amount here has no currency, but it is assumed that it is the currency which the user gets paid in since the total of this column matches with the amount that hits the user's bank account.
Percentage of the Work owned by the recipient of the Amount detailed in this row.
The Amount is given to the User for this Share of the Work.
e.g. if the Amount is £1.00 for a 50% Share, then the total earned from that Usage would be £2.00, and the other £1.00 would appear on the royalty statement of whoever owns the other 50%.
DD/MM/YYYY
When the performance took place.
For a gig, this would be the date of the gig. For a television usage, it would be the date of the broadcast. For online streaming, e.g. Spotify, it would be the start of the reporting period.
DD/MM/YYYY
When the performance ended.
For a gig this would be the same as the start date. For a television usage it would be the same as the start date (maybe unless the programme started before midnight and ended after) For online streaming it would the the close of the reporting period.
Some more detail about the usage. I believe that the title of this column comes from 'Production Header' as, when the Usage Summary is Television, you get a programme title.
e.g. Harry and Meghan: A Love Story
When the Usage Summary is Overseas, you get some kind of programmer data which may be a result of Overseas production header data being organised differently.
e.g. Netflix (2-4T18)
Combined with the Prod Header, this gives us information about the region and channel that the broadcast was consumed on.
e.g. BBC Lifestyle Africa, BBC1 Network, TV3 Denmark, Channel 5, Channel 5+24
When a TV programme gets made and a cue sheet is submitted to PRS, the production will have a ten-digit ID number
e.g. 7712942508
This will stay the same for the production regardless of the Broadcast Region.
The number of times the work was performed to generate the amount of royalties.
e.g. number of streams, number of plays (of a TV programme)
How much of the work was used to generate the royalty.
If this is a stream, this will probably be blank because to count as a stream a user must play 30s or more of the work.
If this is a TV usage, it will be the amount of the work that was used (as recorded in the cue sheet) multiplied by the Number of Perfs.
The first listed owner of the copyright (or percentage) of the work.
e.g. Birkin Richard John
It's fairly inconsistent though, even though it always points to the same account. In mine I appear as:
- Birkin Richard John
- Birkin Richard
- Richard John Birkin
Although IP1 is always me in my PRS Statements, it is not always the case that IP1 is the user.
It can also be a company e.g. Abbey Road Masters, Atmostphere Music Ltd, Sound Pocket Music
Another owner of the copyright (or percentage) of the work.
See IP1.
Another owner of the copyright (or percentage) of the work.
See IP1.
Another owner of the copyright (or percentage) of the work.
See IP1.
Note: there may be more than 4 owners of the copyright of the work, but only 4 are included in Statements.
The PRS-specific code for the work.
Note: A work can have multiple Tunecodes. Whenever a copyright holder changes some data for the work e.g. switching Publisher, PRS will generate a new Tunecode.
In this way, any future royalties will be distributed to the new publisher, and any old royalties that have come in since the change will be given to the old publisher. Supposedly.
This needs verifying.
International Standard Musical Work Code
e.g. T9212482809
An internationally recognised reference number for the identification of musical works.
No idea. But it's unusally the same as the Tunecode.
e.g. 5UFZXWYVJU4BKXIXKI1XXJ
TBC
e.g. 452872
Presumably an internal reference for PRS, referring to the invoice they sent to the company that notifies them of royalties owed.
e.g. GBP, EUR
Refers to the currency of the Invoice
e.g. 1.119
An amount in GBP that was paid in the past.
NOTE: Rows with data in the following columns will show empty data for Amount (performance revenue)
e.g. 0.69
An amount in GBP that is the new adjusted payment.
NOTE: Total of the rows in this column + Amount (performance revenue) = the amount the user receives in their bank account.
e.g. 100
A percentage share of the Work that has been changed.
e.g. 50
A percentage share of the Work that has been updated from a previous row where the % or amount was different.
e.g. Fixed Point Reconcilitation
A note about why they share was changed. Assuming these explanations are template and refer to something complicated we'll probably uncover later.
Believe is a global digital music company headquartered in France which provides digital solutions for artists and labels. Believe has several brands including TuneCore, Nuclear Blast, Naïve, Groove Attack and AllPoints. Believe is one of the world’s leading digital music companies.
Thanks to our innovative digital distribution and promotion technology, you can deliver all your releases across multiple format - Singles, EPs, Albums – on 350+ major stores, including local & specific platforms in the highest quality. All your content is checked by specialists before being sent to platforms and protected thanks to our highly effective anti-leaks process.
Besides digital distribution, we also offer global physical distributions thanks to an extensive network of physical distribution partners around the world and a team of locally based experts who are able to manage and optimize your physical distribution. Our team can help you distribute your physical records in stores in more than 50 countries.
These CSV statements look like this:
Time Travel Opps;"Richard J. Birkin";"Twinklebox";"3614599295791";"3614599295791";"TTO*11";"Time Travel Opps";"Twinklebox ";"GB-LE8-11-00002";"GB-LE8-11-00002";"TTO*11";"Time Travel Opps";" ";"";"";"2019-01-01";"2019-01-01";"Facebook / Instagram";"Worldwide";"Stream";"";"1";"EUR";"0.001997";"0.000000";"0.001997140200000";"0.7";"0.001397998140000";"0.0000000000000000000000000000000000"
The header rows are:
Label Name;"Artist Name";"Release title";"UPC";"Delivered UPC";"Release Catalog nb";"Release Producer";"Track title";"ISRC";"Delivered ISRC";"Track Catalog nb";"Track Producer";"Release type";"CSV_SONG_VERSION";"CSV_SONG_REMIXER";"Reporting month";"Sales Month";"Platform";"Country / Region";"Sales Type";"Streaming Subscription Type";"Quantity";"Client Payment Currency";"Unit Price";"Mechanical Fee";"Gross Revenue";"Client share rate";"Net Revenue";"Withholding Tax"
The name of the record label. e.g. Time Travel Opps
The name of the artist. e.g. Richard J. Birkin
The name of the release (album title, single title, EP title) e.g. Twinklebox
Universal Product Code. e.g. 3614599295791
Unsure why this is repeated. Assuming that in some cases Believe will use their own UPC above, and put the one they were given here. e.g. 3614599295791
I had asterisks in my catalogue numbers. e.g. TTO*11
nb presumed to mean nota bene i.e., note well.
Other examples are, TG141CD (Touch and Go CD release 141 (the first Shellac album)
I put the label name here. I can't remember why. This could be a person's name like Rick Rubin. e.g. Time Travel Opps
The title of the tune. e.g. Twinklebox
International Standard Recording Code. Probably the most important bit of data for us to link with the tune as it appears in PRS statements. e.g. GB-LE8-11-00002
Same assumption as with the Delivered UPC above. e.g. GB-LE8-11-00002
The catalogue number of the track. In case it's different than the catalogue number of the release. e.g. TTO*11
nb presumed to mean nota bene i.e., note well.
The track producer in case it's different to the producer of the release. e.g. Time Travel Opps
Can be music or video. e.g. Music release
In the case that this is a different version of an existing tune. e.g. a remix, remaster or instrumental. e.g. Haiku Salut Remix
The person/artist who did the remix if it is a remix. e..g Haiku Salut
Format YYYY-MM-DD e.g. 2019-01-01
Format YYYY-MM-DD e.g. 2019-01-01
Where the usage took place. e.g. Facebook / Instagram
e.g. Worldwide
The type of activity that generated the income. e.g. Stream
I don't have anything for this as far as I can see from my data.
The amount of times it was streamed/sold. e.g. 1
The currency that the income was received by Believe in. e.g. EUR
The price of the sale/stream. e.g. 0.001997
In the case of physical sales, the fee that should be applied. I don't have anything for this as I haven't done physical distribution with Believe. e.g. 0.000000
e.g. 0.001997140200000
Percentage as decimal. Typically digital vendors take a 30% cut. e.g. 0.7
Gross revenue multiplied by Client share rate. e.g. 0.001397998140000
e.g. 0.0000000000000000000000000000000000