Anthology Reporting Explaned

News

Anthology Reporting Explaned

Your reports explained.

As well as the PDF statement and invoices in the client reporting there are also several types of detailed CSV reports we supply (where you have data) and each one has defined columns and data types.

The structure for the file naming is:
{YYYYMMDD}-{Id}-{Report Abbreviation}-{Currency} {Report Name} for {Client Name}

Example: 20991201-1-DS-GBP Digital Sales for My Record Label

Description Report Abbreviation Document Type
Digital Sales DS CSV
Physical Sales PS CSV
Physical Articles PA CSV
Direct To Consumer Sales DC CSV
Neighbouring Rights NR CSV
Other Sales OS CSV
Service Charges SC CSV
Statement* T PDF
Invoice C,CV,M PDF
Self Bill Invoice S,SV,M PDF
Summary** SM PDF

Statement

Statement document shows the closing balance on your account at the end of the month and the movement within the month. The statement date is the reporting month, all self bills and invoices are dated the month following the statement date. Any VAT is already included in the Sales ( Self Bill Invoice) and Cost ( Invoice) figures shown on the statement.

Invoice

This document shows a breakdown of costs and VAT where applicable. The detail of the costs behind these figures can be found in the relevant CSV files, Physical Sales, Physical Sales Articles ( physical costs not related to sales),Digital Sales, Direct Sales, CMO Sales and Service Charges (In-house or third party recharges).

Invoice Description CSV file name Column Column Description
Digital Sales Dist Fee Digital Sales V dist_fee
Direct Sales Fee Direct To Consumer I dist_fee
Neighbouring Rights Fee Neighbouring Rights L commission_fee
Other Sales Fee Other Sales L commission_fee
Physical Consignment Return Dist Fee Physical Sales T consignment_returns_dist_fee
Physical Consignment Ship Dist Fee Physical Sales V consignment_ship_dist_fee
Physical Consignment Sold Dist Fee Physical Sales R consignment_credit_dist_fee
Physical Excess Stock Fee Physical Articles T excess_stock_charge
Physical Line Charge Fee Physical Articles W line_charge
Physical Promo Dist Fee Physical Sales X promo_dist_fee
Physical Returns Dist Fee Physical Sales P returns_dist_fee
Physical Sales Dist Fee Physical Sales M sales_dist_fee
Physical Scrap Stock Fee Physical Articles V scrap_stock_charge
Physical Vinyl Packaging Fee Physical Sales AF vinyl_packaging_fee
Service Charges Amount Service Charges J service_charge_amount

Self Bill Invoice

This document shows a breakdown of sales by type of sale and VAT where applicable. The detail of the sales behind these figures can be found in the relevant CSV files, Physical Sales, Digital Sales, Direct Sales and CMO Sales.

Self Bill Description CSV file name Column Column Description
Digital Sales Digital Sales U gross_income
Direct Sales Direct To Consumer H net_value
Neighbouring Rights Neighbouring Rights K gross_income
Other Sales Other Sales K income
Physical Sales Physical Sales AE net_turnover_inc_financial_adj

Summary

Summary is a summary of the trends for the month including sales by Sales Partner, Artist and Territory. This is not a financial document and does not show your closing balance for the month.

CSV Files

See below for the breakdown of CSV detailed data and expand to show all the details for every column:

Digital Sales

This report contains all the royalty transactions from the digital service platforms for the reporting period.

Table of Contents
Column Name Example Data Type Description
reporting_month 01/11/2023 DATE The month of the reporting period.
platform iTunes STRING The platform name for the related transaction.
sales_partner Match STRING The platform partner or subcategory for the transaction.
month_sold 01/09/2023 DATE The sold month period.
label Hello Records STRING The label name for the related release.
vendor_id 1328427951 STRING The platform’s proprietary id for the release.
upc 5037300000000 STRING The UPC for the related release.
isrc ISRC12345678 STRING The ISRC for the related asset.
catalogue_id MYCATNO1 STRING The known id name for the related release, usually the catalogue number.
release_artist My Artist STRING The artist name for the related release.
release_title My Title STRING The title for the related release.
track_artist My Artist STRING The artist name for the related asset.
track_title My Title STRING The title for the related asset.
channel_id v-abc123456789 STRING The channel id if supplied by the platform. (e.g., YouTube Channel Id).
channel_name My Channel Name STRING The channel name if supplied by the platform (e.g., YouTube channel name).
video_title My Title STRING The title name for the related asset if supplied.
media_type track STRING The type description for the transaction (e.g., Track).
country MX STRING The ISO2 territory code.
product FAM6 STRING The product type when supplied (e.g., Spotify Family Subscription).
channel Download STRING The channel name (e.g., Stream, Download, etc.).
other Any other info supplied of use. STRING This is populated when the platform supplies other data that does not fit in other columns (e.g., Composer).
mechanicals_paid Y STRING This defines if we know the platform to have paid the mechanical portion of the royalty for the transaction.
units 1 INTEGER The unit value for the transaction.
currency GBP STRING The currency.
gross_income 50 BIGNUMERIC The gross income received.
dist_fee 0 BIGNUMERIC The distribution fee for the transaction.
net_income 0 BIGNUMERIC The net income after distribution fee.
dist_rate_percent 0 NUMERIC The distribution rate percentage charged for the transaction.
currency GBP STRING The currency.
ex_rate 1 BIGNUMERIC The exchange rate used.

 

Physical Articles

This report contains detailed summary info of all physical articles in the catalogue including the closing stock, excess stock per release and warehouse and all non sales charges related to stock.

Table of Contents
Column Name Example Data Type Description
reporting_month 01/11/2023 DATE The month of the reporting period.
warehouse Universal Distribution UK STRING The warehouse for the transaction.
start_date 25/10/2023 DATE The date of the transaction start period.
end_date 23/11/2023 DATE The date of the transaction end period.
label Hello Records STRING The label name for the related release.
release_artist My Artist STRING The artist name for the related release.
release_title My Title STRING The title name for the related release.
catno MYCATNO1 STRING The catalogue number name for the related release.
upc 5037300000000 STRING The UPC name for the related release.
format_type CD Album STRING The format type for the release.
release_date 15/02/2010 DATE The release date for the release.
closing_stock 1 INTEGER The closing stock units at the end date for the period.
goods_in 1 INTEGER The goods received in units for the period.
goods_out 1 INTEGER The goods out in units for the period.
stock_adjustment 1 INTEGER The adjustment units for the period where stock may be booked on with wrong quantity or stock was damaged.
cumulative_sales 100 INTEGER The total sales all time.
consignment_ship_all_time 100 INTEGER The total consignment shipments all time.
consignment_sales_all_time 100 INTEGER The total consignment sales all time.
month_sales 50 INTEGER Sales for the reporting period.
previous_3_months_sales 75 INTEGER Sales for the last 3 months.
refurb_units 0 INTEGER The units that were refurbished for the period.
refurb_unit_charge 0 NUMERIC The refurb charge for the period.
excess_stock 0 INTEGER The excess stock for the period.
excess_stock_charge 0 NUMERIC The excess stock charge for the period.
scrap_stock 0 INTEGER The scrap stock for the period.
scrap_stock_charge 0 NUMERIC The scrap stock charge for the period.
line_charge 0 NUMERIC The line charge for the period.
refurb_unit_fee 0 NUMERIC The refurb fee per unit.
excess_stock_unit_fee 0 NUMERIC The excess stock unit fee.
scrap_stock_unit_fee 0 NUMERIC The scrap stock fee per unit.
line_charge_unit_fee 0 NUMERIC The line charge rate per line.
currency GBP STRING The currency.
ex_rate 1 BIGNUMERIC The exchange rate used.

 

Physical Sales

This report contains all the transactions from the warehouse related to sales, returns, consignment, and financial adjustments all broken down by release and customer.

Table of Contents
Column Name Example Data Type Description
reporting_month 01/11/2023 DATE The month of the reporting period.
warehouse Universal Distribution UK STRING The warehouse for the transaction.
start_date 25/10/2023 DATE The date of the start period.
end_date 23/11/2023 DATE The date of the end period.
label Hello Records STRING The label name for the related release.
catno MYCATNO1 STRING The catalogue number name for the related release.
upc 5037300000000 STRING The UPC name for the related release.
release_artist My Artist STRING The artist name for the related asset.
release_title My Title STRING The title name for the related asset.
format_type CD Album STRING The format type for the release.
release_date 23/09/2022 DATE The release date for the release.
dealer_price 12.98 BIGNUMERIC The dealer price for the release.
customer THATS ENTERTAINMENT STRING The customer (retailer) for the transaction.
country GB STRING The ISO2 territory code for the transaction.
sales_units 1 INTEGER The units sold for the transaction.
sales_value_net 10 BIGNUMERIC The net value of the units sold for the transaction.
sales_dist_fee 0 BIGNUMERIC The distribution fee of the units sold for the transaction.
returns_units 0 INTEGER The units returned for the transaction.
returns_value 0 NUMERIC The net value of the units returned for the transaction.
returns_dist_fee 0 BIGNUMERIC The distribution fee of the units returned for the transaction.
consignment_sales_units 0 INTEGER The units sold for the consignment transaction.
consignment_credit_dist_fee 0 BIGNUMERIC The credit back for distribution fee for sold consignment units.
consignment_return_units 0 INTEGER The units returned for the consignment transaction.
consignment_returns_dist_fee 0 BIGNUMERIC The distribution fee of the consignment units returned for the transaction.
consignment_shipment_units 0 INTEGER The units shipped for the consignment transaction.
consignment_ship_dist_fee 0 BIGNUMERIC The distribution fee for shipped for the consignment transaction.
promo_units 0 INTEGER The promotion units shipped for the transaction.
promo_dist_fee 0 BIGNUMERIC The promotion units shipped fee for the transaction.
freight_charge_units 0 INTEGER The freight units shipped for the transaction.
freight_charge_fee 0 NUMERIC The freight units shipped fee for the transaction.
financial_adjustment_units_in 0 INTEGER The financial adjustment units in. Financial Adjustments are used to correct the sold value when an invoice to a customer was at the wrong value.
financial_adjustment_value_in 0 NUMERIC The financial adjustment value in. Financial Adjustments are used to correct the sold value when an invoice to a customer was at the wrong value.
financial_adjustment_units_out 0 INTEGER The financial adjustment units out. Financial Adjustments are used to correct the sold value when an invoice to a customer was at the wrong value.
financial_adjustment_value_out 0 NUMERIC The financial adjustment value out. Financial Adjustments are used to correct the sold value when an invoice to a customer was at the wrong value.
net_turnover_inc_financial_adj 0 BIGNUMERIC The net turnover after financial adjustments.
sales_percentage 0 NUMERIC The shipment distribution rate percentage charged for the transaction.
sales_min_fee 0 NUMERIC The minimum shipment distribution fee per unit.
vinyl_sales_min_fee 0 NUMERIC The vinyl minimum shipments distribution fee per unit.
returns_percentage 0 NUMERIC The distribution rate percentage charged for the transaction.
returns_min_fee 0 NUMERIC The minimum returns distribution fee per unit.
vinyl_returns_min_fee 0 NUMERIC The minimum vinyl returns distribution fee per unit.
promo_percentage 0 NUMERIC The promo (no value charged to recipient for units) distribution rate percentage charged for the transaction.
promo_min_fee 0 NUMERIC The promo (no value charged to recipient for units) minimum distribution fee per unit charged for the transaction.
vinyl_promo_min_fee 0 NUMERIC The vinyl promo (no value charged to recipient for units) minimum distribution fee per unit charged for the transaction.
is_vinyl FALSE BOOLEAN Defines if the transaction was for vinyl.
is_amazon FALSE BOOLEAN Defines if the transaction was for Amazon.
currency GBP STRING The currency.
ex_rate 1 BIGNUMERIC The exchange rate used.

 

Direct Sales

This report contains all the direct sales transactions from the third parties suppliers EG. (direct to conusmer) for the reporting period.

Table of Contents
Column Name Example Data Type Description
reporting_month 01/11/2023 DATE The month of the reporting period.
label Hello Records STRING The label name for the related release.
release_artist My Artist STRING The artist name for the related release.
release_title My Title STRING The title for the related release.
upc 5037300000000 STRING The UPC for the related release.
catno MYCATNO1 STRING The catalogue number for the related release.
supplier_name The Music Shop STRING The supplier for the related transaction.
quantity 1 INTEGER The quantity for the transaction.
net_unit_value 10 BIGNUMERIC The unit value for the transaction.
net_value 10 BIGNUMERIC The net value for the transaction (units x unit value).
dist_fee 0 BIGNUMERIC The distribution fee for the transaction.
dist_rate 0 BIGNUMERIC The distribution rate percentage charged for the transaction.
dist_fee_min 0 BIGNUMERIC The minimum distribution fee per unit.
notes some notes STRING The notes or further details for the transaction.
currency GBP STRING The currency.
ex_rate 1 BIGNUMERIC The exchange rate used.

 

Other Sales

This report contains all the transactions for any other income types to report on for the reporting period.

Table of Contents
Column Name Example Data Type Description
reporting_month 01/11/2023 DATE The month of the reporting period.
supplier_name Townsend Music STRING The supplier who generated the transaction.
income_type Townsend Sales STRING The description for the income type (e.g., T-Shirt Sales).
label Hello Records STRING The label name for the related release.
release_artist My Artist STRING The artist name for the related release.
release_title My Title STRING The title name for the related release.
asset_artist My Artist STRING The artist name for the related asset.
asset_title My Title STRING The title name for the related asset.
upc 5037300000000 STRING The UPC name for the related release.
catno MYCATNO1 STRING The catalogue number name for the related release.
isrc ISRC12345678 STRING The ISRC for the related asset.
notes some notes STRING The notes if supplied for the related transaction.
income 50 NUMERIC The gross income for the related transaction.
commission_fee 0 NUMERIC The commission fee for the related transaction.
currency GBP STRING The currency.
ex_rate 1 BIGNUMERIC The exchange rate used.

 

Service Charges

This report contains all the service charges for the period.

Table of Contents
Column Name Example Data Type Description
reporting_month 01/11/2023 DATE The month of the reporting period.
recharge_id ABS77777 STRING The ID for the related service charge.
created_on 06/11/2023 DATE Date the service charge was created.
label Hello Records STRING The label name for the related release when supplied or required.
release_artist My Artist STRING The artist name for the related release when supplied or required.
release_title My Title STRING The title name for the related release when supplied or required.
asset_artist My Artist STRING The artist name for the related asset when supplied or required.
asset_title My Title STRING The title for the related asset when supplied or required.
upc 5037300000000 STRING The UPC for the related release when supplied or required.
catno MYCATNO1 STRING The catalogue number for the related release when supplied or required.
isrc ISRC12345678 STRING The ISRC for the related release when supplied or required.
notes some notes STRING The notes for the service charge when supplied or required.
service_charge_amount 1400 NUMERIC The amount for the service charge.
service_type Retail Marketing STRING The type of service charge (e.g., Retail Marketing, Courier).
supplier_name Absolute STRING The supplier of the service.
delivery_address My delivery address is supplied. STRING The delivery address when supplied or required.
currency GBP STRING The currency.
ex_rate 1 BIGNUMERIC The exchange rate used.

 

Neighbouring Rights

This report contains all royalties received for Neighbouring Rights income for the period.

Table of Contents
Column Name Example Data Type Description
reporting_month 01/11/2023 DATE The month of the reporting period.
survey_date 01/11/2023 DATE The month report from CMO.
report_from_date 01/11/2023 DATE The start month of the collection period from the CMO.
report_to_date 01/11/2023 DATE The end month of the collection period from the CMO.
label Hello Records STRING The label name for the related release when supplied.
cmo PPL STRING The CMO society name for the transaction.
rights_holder Hello Records STRING The rights holder when supplied by the CMO.
vendor_id ISCR1234 STRING The identifier used by the CMO when supplied.
isrc ISRC12345678 STRING The ISRC for the related asset.
track_artist My Artist STRING The artist name for the related asset.
track_title My Title STRING The title for the related asset.
country US STRING The ISO2 territory code.
info Optional data here. STRING Used to input any other info that gets supplied by the CMO.
gross_income 10 BIGNUMERIC The value of the payment received from the CMO.
commission_fee 0 BIGNUMERIC The commission fee for the related transaction.
net_income 0 BIGNUMERIC The net income after the commission fee.
commission_rate_percent 0 NUMERIC The commission rate percentage.
currency GBP STRING The currency.
ex_rate 1 BIGNUMERIC The exchange rate used.
Back To Top