Why Streaming Counts and Royalty Statements Differ: A Reconciliation Worksheet

Use a worksheet to trace missing stream counts, late reports, contract deductions and payment differences from the dashboard to the artist statement.

A streaming dashboard shows activity. A distributor’s sales report assigns quantities and amounts to rows. An artist statement applies an agreement to those amounts and explains the resulting balance. To investigate a difference, start with one recording, one service and one usage period. Ask where the first unexplained difference appears.

There are two comparisons to make. First compare counts with comparable counts. Then trace reported money through the royalty calculation and payment records. A listener count, a stream count, a royalty amount and a bank deposit each answer a different question.

Ten reasons streaming numbers and royalty statements differ

1. The periods have different boundaries

Write down the usage dates, time zone, report issue date and statement period. A release’s all-time count may include activity well beyond the period under review. Spotify for Artists uses UTC. Qlero’s accounting period identifies when sales were booked, while its Sales CSV can show the underlying sale dates. Spotify’s counting rules · Qlero’s reporting-delay guide

2. The dashboard counts activity

Spotify counts a song stream after at least 30 seconds of play. A song appearing on several releases contributes to each release’s total. Adding album and single totals can therefore count the same activity twice. Select a track-level measure and record its definition before comparing it with the distributor’s reported usage. How Spotify counts streams

An activity count alone does not specify a payment. Spotify describes a monthly streamshare calculation for rightsholders. What an artist receives downstream depends on the artist’s agreement. Spotify’s royalty explanation

3. A row represents a different measure

Read the provider’s file specification. Does the row report units, revenue, a fee, an adjustment or an amount already net of fees? Identify detail and summary rows before adding them. DDEX’s Sales and Usage Reporting standard supports the exchange of usage, sales and revenue information. Use the actual file’s profile and definitions to interpret a column. DDEX Sales and Usage Reporting

Keep separate columns for reported units and reported income. A euro amount cannot resolve a difference of 100 plays until the missing or differently classified rows have been identified.

4. Market and subscription mix differ

Two periods can show the same number of plays and different income. Spotify describes streamshare by country and explains how subscriptions and advertising contribute revenue. Compare like territories and service categories where the report identifies them. If the necessary breakdown is absent, ask the provider for it and leave the explanation open. Spotify for Artists royalties guide

5. A report or revision arrived after the cutoff

Check which provider files actually entered the statement run. A store may report a sale late or correct a previous period. Keep its file identity, version, usage dates and receipt date together. Establish whether the new file supplements or replaces the earlier one before combining quantities. How earlier sales reach a Qlero statement

In Qlero, the Sales Files overview shows imported totals and row counts. A Ready file can still contain invalid rows. Inspect the relevant rows and the periods that included the file. Sales-file details

6. The report refers to another recording or release

Compare the recording identifier, version, artist credit and provider reference. IFPI distinguishes an ISRC for a recording from product identifiers for releases. A recording identifier alone does not prove the applicable ownership or share. IFPI identifier guidance

In Qlero’s documented import example, the ISRC matches the track and the source title supplies a description. Preserve the raw identifier and leave an ambiguous row unresolved until the distributor or catalog record supports a match. Qlero’s import example

7. The agreement changes the amount due to the artist

Find the clause that defines the royalty base and the rate or share that applies. Check participation, permitted deductions, reserves and recoupment separately if they apply. Distinguish a fee already taken upstream from a separate contract deduction. Applying the same fee twice would understate the result.

Qlero’s calculation guide follows a sales row through base, participation and terms. Its statement summary also includes costs, payments and other transactions. Calculated royalties and the closing balance can differ. Royalty calculation · Statement breakdown

8. The statement covers another right

Identify whether the payment concerns a sound recording or a musical work. Spotify describes distinct recording and publishing royalty routes. The MLC’s tracking tools concern mechanical royalties attributable to musical works within its mandate. SoundExchange describes a separate sound-recording collection role. A label’s control of a recording alone does not establish a publishing share. Spotify royalties · The MLC’s income tracking · SoundExchange FAQs

9. Currency, fees and corrections change the amount

Record original currency and amount, conversion rate and direction, converted amount, fees and signed corrections. Check whether a reported fee was already deducted. Keep a reversal linked to its original row and preserve both source references. Qlero’s Sales Files overview exposes the file’s exchange rates for review. Sales-file documentation

10. Payment follows a different clock

Record statement release, payable balance, payment reference and settlement evidence separately. In Qlero’s manual payment-run workflow, the bank transfer is arranged externally and executing the run records the payment as Paid. Tipalti payees follow a separate external flow. Use the appropriate provider or bank evidence to resolve a cash discrepancy. Manual payment runs

A reconciliation worksheet for one discrepancy

Use five steps: align the comparison, locate the supporting report, reconcile its rows, apply the agreement and record the outcome. Make a copy of the following fields for each case.

• Activity: service, dashboard metric, recording/version, territory, usage dates, time zone, extraction date and count.
• Report: provider, file ID/version, source row references, reporting period, comparable units and any subsequent corrections.
• Money: right type, currency, reported gross or net amount, individual adjustments, contract base and calculated royalty.
• Balance and cash: opening position, entries applied, balance before payment, payment reference and settlement evidence.
• Finding: amount or units explained, difference still open, evidence, responsible person and next action.

Worked example: the count and money checks

Suppose a track dashboard shows 1,240 plays and a distributor’s first report shows 900 comparable units. Assume the same recording, dates, territory and count definition. The initial difference is 340 units. A later, separately identified supplement adds 200 units for that cohort. The reconciled report count is 1,100, leaving 140 units unresolved. Ask the provider to account for those units. The difference alone supplies no price or amount owed.

Now inspect a separate fictional money line. Assume the distributor reports EUR 120 before a 10% fee. Under this example’s agreement, the remaining EUR 108 is the royalty base, the artist earns 25%, and EUR 20 of eligible earnings is applied to an outstanding advance. With full participation and no other entries, the calculated royalty is EUR 27, and EUR 7 remains before any payment conditions. If EUR 108 is already reported after that fee, start there and charge it only once. Nothing in the example confirms that EUR 7 reached a bank or assigns money to the unresolved 140 units.

A case note for that example could read: “140 units open on the identified track and usage period. File 2 explains 200 units. Ask the distributor whether the remaining activity falls outside the file’s count definition or belongs to another report. Owner: royalty operations. Keep the case open until the supporting rows or an explanation arrive.” Replace every placeholder with the actual source and row references before raising a real query.

For rate interpretation after the counts align, see how to read Spotify amounts per stream. For a version or identifier exception, use the track identifier reconciliation guide.

Frequently asked questions

Should the stream count match the statement exactly?

Comparable quantities can be reconciled when the service, event definition, recording, territory and dates align. A count and a payable amount have different units. Compare each with the corresponding source.

Is there a fixed payout per stream?

A single universal rate cannot reproduce a Spotify statement. Start with the reported rightsholder income and the applicable agreement. The denominator and market mix matter when interpreting an effective average.

Why might my dashboard show more streams?

Check all-time versus period data, duplicated release totals, the update time and the reports included at cutoff. Record the outstanding difference after each known cause is removed.

Can a lower payout still be correct?

Yes. A documented fee, different royalty base, recoupment or currency conversion may explain it. Reproduce the calculation before accepting any of those explanations.

What distinguishes master and publishing income?

The recording and underlying composition are separate. Establish which right, recipient and agreement the statement covers before comparing amounts.

How do I check for missing reports?

Keep an expected-file register by source and usage period. Match it against the file versions actually used. Ask for the missing report or written confirmation of its status.

Could an incorrect ISRC cause a mismatch?

It can point a row to a different recording or leave it unresolved. Compare original delivery and report records. A similar title is insufficient grounds to assign the income.

Can a distributor payment summary replace the detailed report?

Use payment advice to reconcile cash. Request the underlying detail when the summary does not identify tracks, usage dates or the basis needed to allocate royalties.

Which records belong in Qlero and which belong with finance?

Use Qlero’s documented Sales CSV and statement views for royalty detail. Reconcile the result to finance’s ledger and bank or provider records. Confirm the requirements of your own accounting process. Qlero statement downloads

When should I raise a discrepancy?

Escalate when a material difference remains after the comparable rows and calculation have been checked. Give the provider the recording, usage dates, file version, row IDs, amount or units in question and a specific request. Check the applicable agreement for any notice requirements.

For the next investigation, keep the completed worksheet with the original reports. Use Qlero’s sales-file import guide and statement reconciliation guide for the corresponding operational steps. To discuss your own reporting workflow, bring a redacted example to a Qlero demo. The integrations overview is further product reading.