Skip to main content
An Invalid sales file row is missing information Qlero needs to use it in royalty calculations. This guide covers the mapping manager’s repairs for unrecognised values, missing dates and exchange rates, then shows how to link sales to tracks and releases.
Fixing sales files requires view and write access to Sales Files (+ Sales Explorer). Linking or creating repertoire also requires view and write access to Repertoire & Agreements. If you don’t see Fix Now or the Map and Link Track controls, ask your administrator. See User access and roles.

​
Why a row is invalid

Open Income › Sales Files, select the file, then click Lines. Filter Line Status to Invalid and read Invalid Reason. Use Configure Columns to show that column if needed. A row can have more than one reason, so fixing one problem may leave another to resolve. An unrecognised sales value. The report contains a territory, sale type, format type, source, store, or currency that Qlero couldn’t recognise. For example, a provider’s territory value might need mapping to the country it represents. A reason such as Missing territory means the imported row has no recognised territory; the provider’s cell isn’t necessarily empty. An unmatched track or release. Unmatched ISRC means the incoming ISRC hasn’t matched a track. Unmatched release identifier means the barcode or catalogue number hasn’t matched a release. The repertoire may already exist under another identifier, or it may need creating. A missing date or exchange rate. A row needs both a Sale Date and a Transaction Date. Sales in another currency also need an exchange rate into the file currency. Missing any of these leaves the row invalid even when its repertoire is matched. Missing or unreadable data. Missing units, Missing gross amount, or Missing net amount means Qlero didn’t get the required number. Missing repertoire identifier means it has no identifier to match. These can need a corrected column mapping, parsing rule, or provider file rather than a value mapping. Use the reason to choose the repair. Creating another track won’t fix a missing amount, and changing an exchange rate won’t resolve an unknown ISRC.

​
How the mapping manager helps

On the file’s Overview, click Fix Now in the unmatched-lines notice. The mapping manager groups the information it can help resolve into categories. Only categories with missing information appear, so each file can show a different set. Territories, Sale Types, Format Types, Sources, Stores, and Currencies. Choose the Qlero value that each incoming value represents. One mapping can repair many rows using the same provider value. These mappings are saved for the file’s template and can also help future imports using it. Dates. Supply missing file defaults. See Sales file overview for how default dates apply. Exchange Rates. Supply the rate requested for a recognised currency. See Add or update exchange rates for how Qlero applies rates. Tracks and Releases. Link an incoming identifier to existing repertoire, or create the repertoire if it’s absent. A row with both an ISRC and a release identifier needs both matches; matching the release doesn’t replace the track match. Click Continue through the categories you need, then review Summary and click Save And Revalidate. Qlero saves the changes and starts revalidation. For example, fuga-streaming-2026-06.csv reports Nora Lane’s Midnight Run under an alternate ISRC. The track already exists in Qlero, so link the incoming code to it. Match the actual recording: a similar title alone isn’t enough when an artist has several versions.
Linking saves the incoming identifier as an alias on the track or release immediately. Future sales files from any source in your record company can match that alias. Leaving the mapping manager doesn’t undo the link. Choose Link only when that identifier should consistently mean the same repertoire.
1

Open the mapping manager

Open the mapping manager as described above. Click Tracks for an unmatched ISRC or Releases for an unmatched barcode or catalogue number.
2

Choose the existing track or release

Click Map beside the incoming repertoire, then click Link. Search Select Track To Link for Midnight Run by Nora Lane and select it. For a release, use Select Release To Link.
3

Save the link

Click Link Track or Link Release. A track link adds the incoming ISRC as an alias. A release link adds the incoming barcode and catalogue number when supplied. The item shows Mapped in the manager.
4

Revalidate the file

Click Continue through any remaining categories, then open Summary and click Save And Revalidate. Click Back To Overview after the success message. Wait for revalidation to finish, then click Lines.If the missing repertoire match was the only problem, the affected rows are now Valid. Clear the Invalid filter to see them again.
Link an unmatched ISRC to Nora Lane's Midnight Run track and revalidate the affected sales file rows. The manager groups repertoire by identifier, so one alias can resolve every invalid row using that code.

​
Create repertoire that is missing

Search for an existing match first. Create a new track or release only when the repertoire itself is absent. In Map, click Create. Qlero fills the form from the sales file. A track needs a name, artist, and ISRC; a release needs a name, artist, and a barcode or catalogue number. Correct incomplete details, then click Create Track or Create Release. The repertoire is saved immediately. Continue to Summary › Save And Revalidate to repair the file’s rows. Creating a track or release doesn’t guarantee it has a sales contract. Complete its contract participation before calculating royalties. The repertoire creation guide covers the rest of its details.

​
When a row stays invalid

The manager has nothing left to map. It can’t supply a missing amount or identifier. Read Invalid Reason, then correct the template’s column mapping or parsing rule and re-import to read the original sales file again. If the provider’s file needs correcting, import the corrected file as a new sales file. The Template glossary lists the required fields. Another reason remains. A row can need both a repertoire match and an exchange rate, for example. After revalidation, reopen Lines and check the remaining reasons. Newly recognised currencies may reveal a missing exchange rate to supply next. An identifier is already in use. Qlero blocks conflicting aliases. Find the track or release that owns the code. Link to it if it is the correct match; otherwise correct its identifier or alias before linking the intended repertoire. Another file still has the same invalid rows. Saving here queues revalidation for this file only. Follow Revalidate vs re-import to apply the change to another file.

​
Next steps

Use Sales row statuses to distinguish a remaining validation problem from a missing contract or a royalty-calculation issue.