To correctly extract the data from your royalty statements it's necessary to define which field is contained in each column of your uploaded spreadsheet. To do this, you should enter in the column where Label Engine can look to find each of the following items of data:

ISRC: This is a 12-digit alpha-numeric code that is a unique identifier for a track

UPC: Also called EAN or Barcode, this is a 10-to-14-digit numeric code that is a unique identifier for a release

Label: This is the name of the label that the music was released on. It's ok if it's not shown the exact same way as your label is entered in Label Engine.
​
Cat #: Catalogue number, this is your own unique identifier for a release, typically 3 digits to represent the label name and 3 digits to represent the release number. Not all stores return this identifier in royalty statements.
​
Artist: The name of the artist that produced a track. You should use the track artist instead of the release artist if possible.
​
Track: The title of the track. You should use the track title instead of the album title if possible.
​
Mix: The name of the particular mix of the track. Sometimes this will be included along with the title in the format Track Title (Mix Title), in which case you can leave this column blank.
​
Remixer: The name of the artist that created the particular mix of the track. This is rarely included by stores but is useful to perform allocations.
​
Territory: The country of residence of the person who made the purchase. This is usually a 2- or 3-digit country code or a country name.
​
Store: The name of the store where the sale took place. This is usually only included if you are getting a statement from a distributor or aggregator.

The following columns are used for importing YouTube royalty data, you can leave them blank if you are not dealing with YouTube reports.
​
Video: An 11-digit alphanumeric code that identifies the YouTube video from which revenue was made.
​
Channel: A 22-digit alphanumeric code that identifies the YouTube channel from which revenue was made.
​
Asset: For YouTube, this is a 22-digit alphanumeric code, or list of codes separated by | symbols that identifies the YouTube asset from which revenue was made, however this can also be used to match a general item identifier from other stores (max 22 characters). If you upload an asset file this id will be cross-referenced to use the information from the asset file for the given royalty. When matching against other royalties, a match on asset id will override any other field i.e. it will match even if the isrc or upc are different.
​
Quantity: This is the number of copies that were purchased or a count of streams or views. This must be an integer. If this column is left blank it will be assumed that the quantity is 1.
​
Royalty: This is the total earned for the given royalty. Look for a monetary value, usually 'net total' or 'royalties owing'. If your spreadsheet does not contain a royalty column but contains a quantity column, you can click 'No Royalty Column?' to specify a total value for the statement and the royalty value will be calculated automatically.
​
+ Royalty: Additional royalty column. The contents of this column will be added to the royalty, to help deal with statements that list two separate royalty values.