Music Reports
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:
- Open the file in spreadsheet software (Excel, LibreOffice, Numbers, etc.).
- Apply the specific modifications for each type of report (see below).
- 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.
Updated about 8 hours ago