Specific instructions for Music Reports Statements

Music Reports

Music Reports provides Excel (.xls) files with multiple tabs, a format that Reprtoir cannot process directly. Follow the steps below to make these files compatible with the system.

General Steps:

1. Open the file in spreadsheet software (Excel, LibreOffice, Numbers, etc.).
2. Apply the specific modifications for each type of report (see below).
3. Export the required tabs in CSV format.

Specific Modifications by Report:

• "Music Reports (Amazon Cloud Player)": delete the first two rows then export the "Detail" tab in CSV format.
• "Music Reports (Amazon Music Unlimited)": delete the first three rows then export the "Detail" tab in CSV format.
• "Music Reports (Pandora)": delete the first two rows then export the "Detail" tab in CSV format.
• "Music Reports (SoundCloud)": Export the "Monthly Statement Detail" and "Cumulative Statement Detail" tabs each into separate CSV files.
• "Music Reports (TikTok)": delete the first two rows then export the "Detail" tab in CSV format.

The file is now ready to be imported into Reprtoir.