The statement view page provides an interactive online view of the details associated with a statement that was generated in a royalty run for a specific publisher.

A PDF version of the online statement can be downloaded directly from this page by selecting the "PDF Version" icon or text.

An electronic version of the statement that is formatted per MCPS reporting requirements can be downloaded directly from this page by selecting the "Electronic Format" icon or text. Note that all statements (AP1, DVD1, and AVP) are reported in one electronic file to MCPS. Each online statement provides access to the same combined electronic format file.

Statement account information is pulled from information entered into the system as follows:

Name and address of company

Pulled from name and addressed configured for the Payor that is associated with the royalty run.

Account Number

Pulled from "Payor Supplier Code" variable configured for the Payor that is associated with the royalty run.

Reporting Period

Pulled from the reporting period that is associated with the royalty run. This is automatically created by the application and cannot be edited.

Scheme Code

Notes the specific type of MCPS report that is generated. This is automatically determined and created by the application and cannot be edited.

• DVD1 for DVD products
• AP1 for non DVD products
• AVP for Audio Visual products

MCPS address

MCPS address information is set within the system and cannot be edited by the user.

The statement detail lists products with their associated details and sales activities. Users can quickly access an album for an associated line by selecting the album name. Additionally, the associated MCPS license details can be accessed by selecting MCPS ID for that line.

Catalog #

Notes the catalog number being reported for the specific transaction line. The Catalog # variable is pulled from the "Album" page which is accessed and configured by accessing an album through the "Catalog" tab.

Album Title

Notes the catalog number being reported for the specific transaction line. The Catalog # variable is pulled from the "Album" page which is accessed and configured by accessing an album through the "Catalog" tab.

MCPS ID

Notes the MCPS ID of the catalog number that is being reported for the specific transaction line. The MCPS ID variable is pulled from the "MCPS License" page for the associated product which is accessed and configured through the "UK Licenses" tab of an album.

Format

Notes the format of the product that was sold and is being reported on the transaction line. The format is determined by sales that are imported into the system and reported in a royalty run period.

Release Date

Notes the release date of the product that is being reported on the transaction line. The release date variable is pulled from the "Product" page which is accessed and configured through the "Main" tab of an album.

Country

Notes the country where sales occurred for a specific transaction line. Countries are reported in a standard two letter code following the ISO 3166 standard.

Gross

Notes the gross number of units sold for a specific transaction line.

Prior(-)

Notes the number of negative units that were carried forward into the current reporting period for the product associated with a specific transaction line. Prior negative units are displayed with a negative sign (-) in the statement and are deducted from the gross units.

Promo

Notes the number of promotional units for the current reporting period for the product associated with a specific transaction line. Promo units are considered to be any sale that is either flagged as a free good or is flagged as a promo price tier with zero associated dollars. Promo units are displayed with a negative sign (-) in the statement and are deducted from the gross units.

Returns

Notes the number of return units for the current reporting period for the product associated with a specific transaction line. Return units are displayed with a negative sign (-) in the statement and are deducted from the gross units.

Net Royalty Units

Notes the total number of royalty bearing units for the product associated with a specific transaction line. Net Royalty Units = Gross + Prior(-) + Promo + Returns.

Retentions

Notes the number of retentions held for the product associated with a specific transaction line. The number of retentions held is determined by the country of sale, the sales channel, number of reporting periods completed for a specific product, and retention settings for the specific MCPS product license.

• Retentions are only taken on sales for Great Britain
• Retentions are only taken on retail based channel sales (standard retail channel). Mail order, club, military and direct channel sales do not have retentions taken from them.
• Retentions are only taken during the first four reporting periods of a product.
• The standard retention rate is noted in the "MCPS" page of the "Admin" tab.

Retentions that are taken are reported as a negative number and are deducted from the net royalty units. In the fifth reporting period of a product, all held retentions are released and reported as a positive number and added to the net royalty units.

TV Retentions

Notes the number of retentions held for a product that is TV advertised with a specific transaction line. Retentions held and released are identical to standard retentions noted above.

Net

Notes the net number of units that is reported for a product on a specific transaction line. Net = Net Royalty Units + Retentions + TV Retentions.

Price

Notes the price that is associated with the units being reported for a specific product and territory. The cross reference table below can be used to determine how prices are reported on statements:

Deleted	Sales Territory	Sales Channel	Pricing Mode (Admin Page)	Price Reported on Statements
N	GB	Standard Sales (Channel is Retail)	Published Dealer Price	Wholesale - Product setting
N	GB	Standard Sales (Channel is Retail)	Sales Document Price	Wholesale - Sales file
N	GB	Non Standard Sales (Channel is Military, Club, Mail Order or Direct)	Published Dealer Price	Retail - Product setting
N	GB	Non Standard Sales (Channel is Military, Club, Mail Order or Direct)	Sales Document Price	Retail - Sales file
Y	GB	Standard Sales (Channel is Retail)	Published Dealer Price	Retail - Sales file
Y	GB	Standard Sales (Channel is Retail)	Sales Document Price	Retail - Sales file
Y	GB	Non Standard Sales (Channel is Military, Club, Mail Order or Direct)	Published Dealer Price	Retail - Sales file
Y	GB	Non Standard Sales (Channel is Military, Club, Mail Order or Direct)	Sales Document Price	Retail - Sales file
N	Non GB	Standard Sales (Channel is Retail)	Published Dealer Price	*Wholesale - Product setting
N	Non GB	Standard Sales (Channel is Retail)	Sales Document Price	*Wholesale - Sales file
N	Non GB	Non Standard Sales (Channel is Military, Club, Mail Order or Direct)	Published Dealer Price	Retail - Product setting
N	Non GB	Non Standard Sales (Channel is Military, Club, Mail Order or Direct)	Sales Document Price	Retail - Sales file
Y	Non GB	Standard Sales (Channel is Retail)	Published Dealer Price	Retail - Sales file
Y	Non GB	Standard Sales (Channel is Retail)	Sales Document Price	Retail - Sales file
Y	Non GB	Non Standard Sales (Channel is Military, Club, Mail Order or Direct)	Published Dealer Price	Retail - Sales file
Y	Non GB	Non Standard Sales (Channel is Military, Club, Mail Order or Direct)	Sales Document Price	Retail - Sales file
*Price is adjusted if net units exceed export allowance.

Price Type

Notes the price type that is being reported within the statement

• Published dealer price (wholesale) = D
• Retail price = R
• Deleted product sales = I (Uses net unit level price from sales files)

Adj?

Notes if a specific transaction line is an adjustment. Adjustments can only be made on gross units and are added into the system through the physical sales template.

Comments

Notes comments associated with an adjustment line. Comments can only be made on adjustment lines and are added into the system through the physical sales template at the time adjustment units are being entered.