Secretly Distribution
Direct Connection
You can now set up a direct connection for your Secretly Distribution data, and your Secretly reports will be automatically imported into IC, just like a regular data import.
How to set it up:
- In IC, navigate to Account -> Account Settings
- Scroll down to the Direct Connections menu, click on the Secretly Distribution link in the box pictured below, and follow the instructions on the next page.
Otherwise, here's how to get the data
- Secretly monthly statements are emailed to labels directly as .zip files.
Importing into IC
- In IC, navigate to Royalties -> Data Imports
- Unzip the Secretly .zip
- There are three main documents in the .zip for import. Each file type has its own dedicated importer:
- physpd.csv uses Secretly (Income) Physical
- digpd.csv uses Secretly (Income) Digital
- whfees.xlsx uses Secretly (Expense) Warehouse Process
Timestamps
- Secretly importers require the timestamp and paid timestamp to be entered manually.
- For the Timestamp use the month + year in .the zip name + any day in that month (we often use the 15th as a default).
- For the Paid Timestamp use the following month of that in the .zip name - we use the month following the report, as Secretly makes payouts on a one month lag.
- For example, files that are delivered in a .zip with the name RCRD0922.zip would have the following timestamps:
Timestamp: 09/15/22
Paid Timestamp: 10/15/22
Additional Info
- .whfees.xlsx files will typically be named with the month following the one used in the .zip name (for RCRD0922.zip, the file would be named RCRDwhfees100622.xlsx). When importing, follow the same instructions as above.
- On occasion, warehouse fees will only be reported as a .pdf file - if this is the case with your reporting, these warehouse fees must be entered manually into IC.
- Additional freight + shipping expenses can be found in the Quickbooks file (RCRB120620qb.xlsx) included in every monthly .zip. These expenses must be entered manually by transferring the expenses to an IC additionals doc and then imported using the bulk transaction importer.
- Secretly reports their physical expenses via #000 transactions in Chargeback reports. These expense transactions have a default catalog number of #000, with the actual catalog number reflected in the "Title Description", which can be used to sort the expense items to their correct release during Import Cleanup.
- Other files that may be be included in a Secretly monthly .zip and should be imported are: Chargebacks, Stock Out Fees, Returns Process, Logistic Storage, Excess Storage, Amazon Rebate. All of these file types have their own dedicated importer and can be found via the importer drop down menu.

Legacy Info
Secretly changed its documents layout in July 2018. Any files prior to that date must use the Secretly (Income) Legacy Physical (pre July 2018) & the Secretly (Income) Legacy Digital (pre July 2018) importers .