Understanding your .CSV export file

Understanding your .CSV export file

Listed below are the corresponding Column Names and a description of that each name means or refers to. Four additional columns have been recently added:

Mechanical Withholding
US Tax withholding
US Tax withholding Percentage
US Tax withholding compliancy status. Please refer to their corresponding descriptions below.


BASEWARE STATEMENT EXPORT LAYOUT (TRACKS AND RELEASES)


Statement export file contains the following columns:

 


PRODUCT_UPC Release UPC
PRODUCT_CATALOGUE_NUMBER Release catalog number
TRACK_ISRC_CODE Track ISRC
LABEL Label name
RELEASE Release title
TRACK_TITLE Track title
TRACK_ARTIST Track artists (comma separated)
REMIXER_NAME Remixers (comma separated)
REMIX Remix name
TERRITORY Country code (ISO 3166-1 alpha-3 standard)
PURCHASE_STATUS Item status at time of purchase (new release/exclusive/general content)
FORMAT Audio format
DELIVERY Delivery method
TRANSACTION_DATE Transaction date
CONTENT_TYPE/td> Content type (single/release)
TRACK_COUNT Number of tracks in a release at time of purchase (1 for track sales)
GROSS_CONTENT_REVENUE Gross lossless audio format revenue
GROSS_WAV_REVENUE Gross lossless audio format revenue
PAID_PRICE Gross revenue total (Gross content revenue + gross lossless audio format revenue)
NET_CONTENT_REVENUE Label's content revenue share (gross content revenue multiplied by label's % share per your contract)
NET_WAV_REVENUE Label's lossless audio format revenue share (gross lossless audio format revenue multiplied by 50%)
MECHANICAL_WITHHOLDING Mechanical withholding (For all Non-USA sales, amount is Paid Price multiplied by 10%)
US_TAX_WITHHOLDING Required US income tax withholding on content sales occurring in the USA (Tax withholding % *(Net Content Revenue + Net Lossless Revenue)
WITHHELD_AMOUNT Withheld amount (Mechanical withholding + US Income tax withholding)
US_TAX_WITHHOLDING_PERCENT Required US Income tax withholding percent
US_TAX_WITHHOLDING_COMPLIANCY_STATUS US Income tax withholding compliancy status (1 = compliant, 0 = non-compliant)
NET_TOTAL Total label's revenue share (label's content revenue share + label's lossless audio format revenue share - withheld amount)
SALE_TYPE Sale type (Sale/Void)
Have more questions? Submit a request
Powered by Zendesk