Perpendis Royalty tools
Array tools Sign in

TuneCore sales report columns explained — and exported to Excel

By Perpendis · Published 16 Aug 2026 · Reviewed 16 Aug 2026

TuneCore delivers one CSV per month, 21 columns wide, mixing downloads, streams and YouTube Content ID revenue in local currencies with exchange rates applied per row. This page documents every column, and the free converter merges a whole year of monthly files into one reconciled Excel workbook — without any file leaving your browser.

Drop a month — or a whole year of months

Each monthly CSV is detected by header fingerprint and merged into one normalised dataset. Parsing runs locally in your tab; no account needed to see results.

Drop your TuneCore CSV here — free

Where to find the file in TuneCore

In your TuneCore account go to Money & Analytics → Sales Report and use "Download Monthly Sales Reports" (or "Download This Report" from a filtered sales view). Monthly files follow the naming convention tunecore-musicsales-<reporting_period>.csv. Payout amounts are always settled to USD in the final columns, whatever currency the store reported in.

The 21-column layout, documented

#ColumnWhat it contains
1Sales PeriodPeriod when the music was sold in the store.
2Posted DateDate the report appeared in your TuneCore account.
3Store NameDigital store that paid for the reported period.
4Country of SaleTerritory of the store where the sale occurred.
5ArtistArtist name of the release, song or ringtone.
6Release TypeAlbum, Song or Ringtone (a single reports as Song).
7Release TitleTitle of the album, song or ringtone.
8Song TitleSong name if sold as a song; empty for full-album sales.
9LabelLabel on the release.
10UPCTuneCore-generated UPC.
11Optional UPCYour own UPC, if you supplied one.
12TC Song IDTuneCore-generated song ID.
13Optional ISRCYour own ISRC, if you supplied one.
14Sales TypeDownload or Stream — the split every analysis wants first.
15# Units SoldUnits in a reporting day, as reported by the store.
16Per Unit PricePrice of one unit in the store country's currency.
17Net SalesStore payout after its cut × units; can be negative (see below).
18Net Sales CurrencyCurrency of Net Sales.
19Exchange RateConversion rate into USD.
20Total EarnedAmount received in your TuneCore account after exchange.
21CurrencyAlways USD.

Source: TuneCore Help: Finding and understanding my sales reports — transcribed and checked against the engine's parser on 2026-08-16.

Since July 2023 postings, YouTube Content ID revenue is merged into the YouTube store rows and adds three columns that stay blank for every other store: Video ID, Commission Rate and Policy Type. Rows with values there are Content ID revenue, and fields that do not apply to Content ID (Optional UPC, Optional ISRC) are left blank on those rows.

Why some rows are negative

A negative Net Sales value is usually a Spotify Discovery Mode commission — the promotional discount clawed back against the streams it generated. These are genuine earnings adjustments, not errors, and the converter keeps them as signed amounts so your totals reflect what you were actually paid. Two other quirks worth knowing: Song Title and Artist can legitimately be empty on Album rows, and iTunes reports albums of ten tracks or fewer as individual track sales, so one album purchase can appear as many Song rows.

What the converter does with it

Every monthly file is normalised into a common schema — period, store, territory, track, units, USD amount — with Downloads and Streams kept distinguishable via Sales Type and Content ID rows flagged. Amounts are summed in exact decimal arithmetic, and the output is a six-sheet Excel earnings tape (Summary, Tie-Out, By Period, By DSP, Top Tracks, full line items) plus a normalised CSV.

What the parser actually saw

No public TuneCore file exists to test on — the parser was built to the help-centre column dictionary (all 21 columns) and verified on a spec-conformant fixture, including the Sales Type column that distinguishes downloads from streams. If your file has a column we haven't seen, it is preserved in the output's extras field, never dropped.

Parsing runs in your browser — files are never uploaded. What the tie-out does and does not prove.

Frequently asked questions

Which column is my actual money?

Total Earned — the USD amount credited to your TuneCore balance after the exchange rate is applied. Net Sales is the pre-conversion store payout in local currency.

Related pages

TuneCore’s monthly CSV is the tidiest of the four distributor layouts the engine reads natively. The other three each have their own quirks, documented here:

Background reading: how to read a royalty statement — or go straight to the converter, which merges a year of monthly files in one session.

Ready when you are

Drop your TuneCore monthly reports — and any other distributor statements — into the free converter. Everything is parsed locally; nothing is uploaded.

Convert your statement now — free