Perpendis Royalty tools
Array tools Sign in

DistroKid earnings TSV: every column, and a clean Excel export

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

DistroKid's bank export is a raw line dump — one row per store, country, month and track, often tens of thousands of rows, with earnings quoted to twelve decimal places. This page documents exactly what is in that file, and the free converter turns it into a clean, reconciled Excel workbook without your statement ever leaving your browser.

Drop your DistroKid export straight into the converter

CSV, TSV or the zip DistroKid emails for large reports — format detection is automatic, and parsing runs locally in your tab. No account needed to see your results.

Drop your DistroKid TSV here — free

Where to find the file in DistroKid

Go to distrokid.com/bank and click "SEE EXCRUCIATING DETAIL", then Download. If your report has fewer than 50,000 records, the file downloads immediately as a CSV. At 50,000 records or more, DistroKid generates the report in the background and emails you a link (also available at distrokid.com/bank/priority); the generated report is delivered as a .zip containing a .csv and stays available for seven days. You can drop the zip into the converter as-is — it is unpacked locally.

The current layout: 15 columns (post-July 2025)

Since roughly July 2025 the export is a comma-delimited CSV with every field double-quoted. The header carries these 15 columns, in this order:

#ColumnWhat it contains
1Date InsertedDate the row was added to your bank, YYYY-MM-DD.
2Reporting DateDate DistroKid received or posted the store's report, YYYY-MM-DD.
3Sale MonthMonth the activity actually happened, YYYY-MM.
4StoreThe DSP, e.g. "Spotify", "Apple Music", "YouTube (Ads)".
5ArtistArtist name; may contain several comma-separated names inside the quotes.
6TitleTrack or album title.
7ISRCTrack identifier; may be blank on album rows.
8UPCRelease identifier, 12–13 digits.
9QuantityUnits (streams/downloads); an integer that can be negative on adjustments.
10Team Percentage0–100 — your split's share of this row.
11Source Type"Song" or "Album".
12Country of SaleTwo-letter ISO country code.
13Songwriter Royalties Withheld (USD)Decimal, usually 0.00000.
14Earnings (USD)High-precision decimal, e.g. 0.002642885330 — nine to twelve decimal places.
15Recoup (USD)Usually empty; recoupments when present.

Source: DistroKid Help: Saving your earnings information as a spreadsheet file — transcribed and checked against the engine's parser on 2026-08-16.

One caveat worth knowing: rows are inclusive of your share receivable, so on split releases the Team Percentage must be applied to reach your payable share — the converter surfaces the column so nothing is hidden.

The older "bank details" TSV

Before the July 2025 cut-over the same download produced the famous tab-separated .tsv in latin-1 encoding, with unquoted fields — essentially the same layout minus Date Inserted and Recoup (USD), and with a Song/Album column where Source Type now sits. The converter detects each file by header fingerprint, so old and new exports can go into the same session and come out as one normalised dataset.

What the converter does with it

Every row is normalised into a common earnings schema — period, store, territory, track, units, amount — and summed in exact decimal arithmetic, never floating point, so twelve decimal places of Spotify micro-earnings do not drift. The output is a six-sheet Excel earnings tape: Summary, Tie-Out, By Period, By DSP, Top Tracks and the full line items, plus a normalised CSV if you prefer to run your own analysis.

What the parser actually saw

Tested on a real 9,053-row export in the current post-July-2025 15-column layout (Date Inserted … Recoup (USD)). Earnings values carry 9–12 decimals; YouTube rows often report $0.002–0.003 per play. Header-fingerprint detection means the older 13-column TSV is recognised too.

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

Frequently asked questions

Why doesn't the total match what I withdrew?

DistroKid's bank works on an accrual basis: rows are grouped by reporting date, while withdrawals happen whenever you request them, so a withdrawal will rarely equal the sum of any one report window. The By Period sheet makes the accrual picture explicit.

Why does Excel mangle the file when I open it directly?

Excel parses Earnings (USD) as floating point and rounds the display, turns long UPCs into scientific notation, and (on legacy TSVs) can garble latin-1 characters in artist names. Converting to a proper workbook first sidesteps all three.

Related pages

DistroKid is one of four distributor layouts the engine reads natively. The other three are documented column by column in the same way:

Background reading: how to read a royalty statement — or go straight to the converter, which takes all of these in one session.

Ready when you are

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

Convert your statement now — free