Specific instructions for Music Reports Statements

Music Reports statements are delivered as Excel files containing multiple tabs. Reprtoir cannot process multi tab Excel files directly. Each relevant tab must be exported separately as a CSV file.

Follow the steps below depending on the report type.

Music Reports (Amazon Cloud Player)

Open the Excel file in spreadsheet software such as Excel, LibreOffice, or Numbers.
Go to the tab named “Detail”.
Delete the first 2 rows.
Verify that the column headers are now located on row 1.
Export this tab as a CSV file.

The file is now ready to be uploaded to Reprtoir.

Music Reports (Amazon Music Unlimited)

Open the Excel file in spreadsheet software such as Excel, LibreOffice, or Numbers.
Go to the tab named “Detail”.
Delete the first 3 rows.
Verify that the column headers are now located on row 1.
Export this tab as a CSV file.

The file is now ready to be uploaded to Reprtoir.

Music Reports (Pandora)

Open the Excel file in spreadsheet software such as Excel, LibreOffice, or Numbers.
Go to the tab named “Detail”.
Delete the first 2 rows.
Verify that the column headers are now located on row 1.
Export this tab as a CSV file.

The file is now ready to be uploaded to Reprtoir.

Music Reports (SoundCloud)

Open the Excel file in spreadsheet software such as Excel, LibreOffice, or Numbers.
Go to the tab named “Monthly Statement Detail”.
Verify that the column headers are located on row 1.
Export this tab as a CSV file.
Go to the tab named “Cumulative Statement Detail”.
Verify that the column headers are located on row 1.
Export this tab as a second CSV file.

Each CSV file must be processed as a separate Royalty Statement Income.

Music Reports (TikTok)

Open the Excel file in spreadsheet software such as Excel, LibreOffice, or Numbers.
Go to the tab named “Detail”.
Delete the first 2 rows.
Verify that the column headers are now located on row 1.
Export this tab as a CSV file.

The file is now ready to be uploaded to Reprtoir.