ADA

How to get the data:

Multi-tab monthly statements are emailed to labels from ADA in Excel format. If you aren't receiving your monthly statements from ADA, reach out to your ADA label rep.

We recently upgraded the ADA importer so that it will ingest data from more tabs in their reports. Previously, our system accepted the following tabs: Sales, International Physical Sales, International Physical Returns, Downloads, Streams, International Digital, Excess Storage, Amazon Vinyl Packaging, and Sync Licensing. Our recent upgrade to the ADA importer added the following tabs: Returns, Return Proc, Label Order, Marketing, Ex-US Expenses, Ex-US Cash Disc, Amazon Damage Allowance, and Advertising.

Please note - ADA has a history of inserting unexpected tabs that we haven't seen before (and are unable to import as a result) - and we know of ADA tabs including "Sync Licensing", "D2C Physical", and "Mfg" that are inconsistent and similarly cannot be imported as a result. Please double check your files and use the manual transaction creator for anything that the importer is unable to ingest!

Please note! If you are accounting for territory-specific ADA data such as "ADA UK", you'll want to use our territory specific ADA importers. To do so, you'll want to confirm each tab with royalty-bearing transactions in your ADA reporting (for example, "Digital Sales" or "Expenses") and import your reporting with the corresponding importer that maps that tab - for example, the "Digital Sales" tab of ADA UK reporting can be accounted for using the ADA UK (Digital Sales) importer. If you have any questions or concerns regarding territory-specific ADA accounting, please reach out to our support team.

Importing into IC:

In IC, navigate to Royalties -> Data Imports
Select the ADA importer from the dropdown menu
- For reporting from other ADA divisions (i.e. ADA Latina), please use the corresponding ADA importer
This importer requires timestamps to be entered manually
For Timestamp use the reporting month, for Paid Timestamp use one month after reporting month (ie Timestamp: 7/15/20 -- Paid Timestamp: 8/15/20)