Exporting royalty statements to CSV

Download your royalty statements as CSV files to analyze earnings in a spreadsheet, prepare for tax season, or keep detailed financial records.

Before you start

You must have at least one paid royalty statement (statements appear after your first payout is processed)
A spreadsheet application like Excel, Google Sheets, or Numbers to open the CSV file

Download a statement

Go to Royalties from the main menu
Navigate to the Statements tab
Find the statement period you want to download
Click the download button (arrow icon) next to the statement

The system will generate your CSV file. For smaller statements, the download starts immediately. For larger statements, you will see a progress indicator while the file is being prepared.

What happens during export

Instant downloads

For most statements, the CSV is ready instantly. A dialog appears with a Download button to save the file.

Large statement processing

For statements with many line items, the system processes the export in the background:

A “Preparing Export” dialog appears
The system generates the file (this may take a few moments)
Once ready, a Download button appears
Click Download to save the file

CSV column reference

Each row in the CSV represents a single line item from your royalty statement. Here is what each column means.

Basic columns

Column	Description	Example
`pay_period`	Payment period in YYYYMM format	`202601`
`label`	Your label name	`Midnight Records`
`retailer`	Platform name	`Spotify`
`territory`	Country or region code	`US`, `GB`, `DE`
`type`	Transaction type	`Stream`, `Download`, `UGC`
`cat`	Catalog number	`MR-2026-001`
`upc`	Release UPC barcode	`840123456789`
`release`	Release title	`Neon Skyline`
`isrc`	Track ISRC code (a unique identifier for each track)	`USRC12400001`
`track_artist`	Artist name	`Luna Rivera`
`track_title`	Track title	`Golden Hour`
`track_version`	Version or remix information (blank if none)	`Acoustic Version`
`track_count`	Number of tracks	`1`
`purchase_qty`	Number of streams or sales	`4523`
`dsp_transaction_date`	Transaction date from the platform	`2026-01-15`
`dsp_statement_id`	Statement reference ID	`SP-2026-0001`

Revenue columns

Column	Description	Example
`gross_usd`	Gross revenue in USD (after statement provider fees are deducted)	`18.09000000`

LabelGrid fee columns

Column	Description	Example
`platform_fee_rate`	LabelGrid platform fee rate based on your plan	`0.05000000` (5%)
`platform_fee_usd`	LabelGrid platform fee amount (shown as a negative value)	`-0.90450000`
`ugc_fee_rate`	User-Generated Content fee rate for UGC platforms	`0.20000000` (20%)
`ugc_fee_usd`	UGC platform fee amount (shown as a negative value)	`-1.74400000`
`total_labelgrid_fee`	Total of all LabelGrid fees (negative value)	`-2.18000000`
`net_revenue_usd`	Your final earnings after all fees	`17.18550000`

Technical specification

If you are integrating this CSV into accounting software or a finance backend, here are the exact format details.

Property	Value
Encoding	UTF-8
Delimiter	Comma (`,`)
Quote character	Double quote (`"`)
Escape character	Backslash (`\`)
Line ending	LF (`\n`)
Header row	Always present as the first row
Total columns	23 (fixed order, see column reference above)

Data types and precision

Column group	Type	Precision
`pay_period`	String	`YYYYMM` (6 characters)
`dsp_transaction_date`	String	`YYYY-MM-DD` (10 characters)
`purchase_qty`	Integer	Whole number
`gross_usd`, `*_fee_usd`, `net_revenue_usd`	Decimal	Up to 8 decimal places
`platform_fee_rate`, `ugc_fee_rate`	Decimal	Up to 8 decimal places (e.g., `0.05000000` = 5%)
All other columns	String	Variable length

Revenue formulas

platform_fee_usd  = -1 × platform_fee_rate × gross_usd
ugc_fee_usd       = -1 × ugc_fee_rate × gross_usd
total_labelgrid_fee = platform_fee_usd + ugc_fee_usd
net_revenue_usd   = gross_usd + total_labelgrid_fee

Notes for automated parsing

Empty fields: track_version and cat may be empty (two consecutive commas)
Text quoting: Fields containing commas or quotes are enclosed in double quotes. Double quotes within field values are removed during export.
Large exports: Exports over 150 MB are split into multiple CSV files (each with its own header row) and delivered as a ZIP archive
Sorting: Rows are ordered by pay_period descending, then by dsp_transaction_date descending

Understanding fees in the CSV

How net revenue is calculated

net_revenue_usd = gross_usd + total_labelgrid_fee

Since fees are negative values, they reduce your gross amount. For example:

	Amount
Gross revenue	$18.09000000
Platform fee (5%)	-$0.90450000
UGC fee	$0.00000000
Net revenue	$17.18550000

UGC platform fees

The UGC fee applies only to User-Generated Content platforms like YouTube, TikTok, and SoundCloud. For standard streaming platforms like Spotify or Apple Music, the ugc_fee_rate and ugc_fee_usd columns will show 0.00.

Fee inclusion notice

Fees are included in CSV exports starting from the October 2024 statement period. Earlier statements show revenue data without the fee breakdown columns.

Download a sample CSV

Want to see what the export looks like before downloading your own? Download our sample file:

Download sample CSV

The sample contains placeholder data showing typical line items across multiple platforms and territories.

Tips for working with the data

Opening in Google Sheets

Go to Google Sheets
Click File → Import
Upload your CSV file
Select “Comma” as the separator
Click Import data

Opening in Excel

Open Excel
Click File → Open and select the CSV file
Excel will automatically detect the comma-separated format

Common analysis ideas

Filter by retailer to see earnings per platform
Pivot table by territory to find your strongest markets
Sum net_revenue_usd to verify your total statement amount
Sort by purchase_qty to find your most-streamed tracks
Group by release to compare album performance

Troubleshooting

Export is taking too long

Large statements with many line items may take longer to generate. The system polls for up to 5 minutes. If the export times out:

Close the dialog
Wait a few minutes
Try downloading again

”Export in Progress” error

Only one export can process at a time. Wait for any current export to finish, then try again.

CSV shows unexpected characters

Make sure your spreadsheet application is set to UTF-8 encoding when importing. This ensures artist names and track titles with special characters display correctly.

Missing fee columns

Fee columns (platform_fee_rate, platform_fee_usd, etc.) are only available for statement periods from October 2024 onward. Earlier periods show revenue data without the fee breakdown.