Introduction
This article explains how to use the Royalty Statement CSV included in each statement package, including how it can be used with the FUGA Platform’s Royalty Accounting System and a complete definition of every column and accepted values to support accurate reconciliation and downstream royalty distribution.
Overview
Each statement package contains a detailed royalty CSV file. This file can be uploaded to FUGA’s Royalty Accounting System, or used for further downstream royalty distribution.
Please find an overview of the headers and their descriptions, below:
| Column | Header | Description |
|
A |
Sale Start date |
First date of the reporting month |
|
B |
Sale End date |
Last date of the reporting month |
|
C |
DSP |
DSP name |
|
D |
Sale Store Name |
Some DSPs have multiple store-front names |
|
E |
Sale Type* |
Sale type (streaming, downloads) |
|
F |
Sale User Type** |
User type (premium, ad-supported) |
|
G |
Territory |
Country where the stream or download was generated in ISO-2 |
|
H |
Product UPC |
Universal product code (FUGA will also report the UPC for asset sales) |
|
I |
Product Reference |
FUGA Product ID |
|
J |
Product Catalog Number |
Catalog number |
|
K |
Product Label |
Label name attached to the product uploaded in FUGA |
|
L |
Product Artist |
Artist name on a product level |
|
M |
Product Title |
Product title (Album, EP, Single) |
|
N |
Asset Artist |
Artist name on a track level |
|
O |
Asset Title |
Track name |
|
P |
Asset Version |
Track version |
|
Q |
Asset Duration |
Track duration in seconds |
|
R |
Asset ISRC |
Track ISRC code |
|
S |
Asset Reference |
FUGA Asset ID |
|
T |
Asset/Product |
Indicates if the sale refers to an Asset (track) or Product (album) |
|
U |
Product Quantity |
Total number of streams / downloads |
|
V |
Asset Quantity |
Total number of streams / downloads |
|
W |
Original Gross Income |
Royalties reported by the DSP |
|
X |
Original currency |
Currency reported by the DSP |
|
Y |
Exchange Rate |
Royalty exchange rate to EUR |
|
Z |
Converted Gross Income |
Original Gross Income converted to EUR (column W x column Y) |
|
AA |
Contract deal term |
Your royalty share |
|
AB |
Reported Royalty |
Converted Gross Income x contract deal term (column Z x column AA) |
|
AC |
Currency |
Currency reported to you by FUGA |
|
AD |
Report Run ID |
FUGA’s Report Run ID |
|
AE |
Report ID |
FUGA’s Report ID |
|
AF |
Sale ID |
FUGA’s Sale ID (every individual reported sale is given an ID by FUGA) |
|
AG |
Audio Format*** |
The audio format of a track |
|
AH |
DSP Unit ID |
DSP ID assigned to the entity |
|
AI |
DSP Container ID |
DSP ID assigned to an entity containing the Unit |
|
AJ |
DSP Collection ID |
DSP ID assigned to the vendor/owner of the Unit and/or Container |
*Sale Type values in column E can be one of the following ENUMs: Streaming, Download, Video Stream (Audio), Premium Download, Physical, Synch, Video Stream (Audio + Video), Ringtone, Video Stream (Video), Background Music, Video Download, Jukebox, Breakage, 3rd Party, Other, Licensing, Neighbouring Rights, Non-interactive Stream
**Sale User Type values in column F can be one of the following ENUMs: Premium, Trial, Ad-supported, Promo, Bundle, Other, User generated content, Partner-provided, DUO, Student, Family Plan
***Audio Format values in column AG can be one of the following ENUMs: <Blank> (for regular tracks) or Dolby (for Dolby Atmos tracks)
Support
If you require assistance interpreting a field or correcting an import issue, contact your FUGA representative or reach out via our support channel at royalties-support@fuga.com.