Specific instructions for The State51 Conspiracy Statements

The State51 Conspiracy

The State51 conspiracy provides malformed CSV files that contain duplicate and empty columns with the same header name. You need to remove these to ensure our mapper can correctly match the data. Follow the procedure below to make these files compatible with the system:

1. Open the CSV file in spreadsheet software such as Excel, LibreOffice, Numbers, etc.
2. Delete the following empty columns from the downloaded Statement. These columns are duplicates. Keep the first one and delete the second one:
   • Total
   • Tax Unit
   • Tax Total
   • Unit Net
   • Total Net
   • Mech Base
   • Mech Unit
   • Mech Total
   • Tot Net - Mech
   • Deduct 1
   • Deduct 2
   • Unit Rlty
   • Share Base
   • Royalty
3. Save

The saved file is now ready to be uploaded to Reprtoir.