Specific instructions for Broken Silence Statements

Broken Silence

Broken Silence statements contain multiple sections in a single file, mixing physical, digital, and summary blocks. Only the physical sales summary section is compatible with this statement template.

All other sections must be removed so that the file contains one single, clean data table starting at row 1.

These modifications are required because the source file structure does not follow a strict tabular format.

File preparation steps

Follow these steps carefully:

1. Open the CSV file in spreadsheet software such as Excel, LibreOffice, or Numbers.
2. Locate the row containing the exact label “summary physical sales”.
3. Keep this row and all rows that belong to the “summary physical sales” table.
4. Delete all rows above this section, including national, international, and digital statements.
5. Delete all rows below the last line of the “summary physical sales” table, including totals, comments, or empty rows.
6. Verify that the column headers of the “summary physical sales” table are now located on row 1.
7. Save the file in CSV format, keeping the original delimiter and encoding.

Do not rename, reorder, or modify the column headers.

The file is now ready to be uploaded to Reprtoir.