The CSV version of your financial statement provides a detailed breakdown of every transaction within a given royalty collection period. We recommend you use the Pivot table feature in Excel to pull out specific information about your earnings from big data sets.
This step-by-step tutorial makes it easy to read the CSV Statement using Pivot tables:
1. Open the CSV File in Excel
2. Click the top left corner and select the entire sheet
3. Click on the 'Insert' tab in the top bar menu
4. A window will pop up, please make sure you select the same options as the image below:
5. A new empty tab will open with the section where you can add your filters from the right-hand side menu. Type the data you’re looking for in the field name (the values in the first row of the .csv file) and drag and drop it into the desired box (rows, columns, or value). You can add more than one value under each box:
Pro Tip: If you want to see how much artists generated in each territory, for each product, in that specific statements period, you need to input the following:
Rows
BUNDLE_ARTIST
BUNDLE_TITLE
Columns
TERRITORY_OF_SALE
Values
DISTRIBUTED_AMOUNT
As a result, a table will automatically be created retrieving only specific data from the original .csv file:
For more help understanding what each column means in your CSV files, check out our CSV Statement Glossary