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.
Statement export file contains the following columns:
• 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) |