ASCAP delivers its quarterly domestic electronic statement from the member portal as a zip file containing a CSV — 41 columns, laid out in ASCAP's own published file-format specification (March 2024 version). Drop the zip straight into the converter, unopened: it detects the layout, maps every column, and hands back a normalized Excel earnings tape.
Drop the .zip exactly as ASCAP delivered it — no unzipping, no re-saving, no header surgery. Combine it with MLC, distributor and publisher statements in the same run if you like.
Drop your ASCAP CSV here — freeMembers download statements from the ASCAP portal under Earnings > Statements. The domestic electronic statement arrives as a zip archive holding one CSV, distributed quarterly. Its layout is genuinely documented — ASCAP publishes a file-format PDF — but the document is a PDF of field definitions, not something you can sort, filter or pivot. The converter reads all 41 columns; the table below explains the ones that decide what you were paid and why.
| # | Column | What it holds |
|---|---|---|
| 1–2 | DISTRIBUTION YEAR / QUARTER | The quarter ASCAP paid you in — not the quarter the performances happened. |
| 9 | PERFORMANCE SOURCE/BROADCAST MEDIUM | Statement category: radio, TV, audio streaming, live and so on. |
| 10–11 | MUSIC USER GENRE / MUSIC USER | The type of licensee, then the specific station, service or venue. |
| 13–14 | PERFORMANCE START / END DATE | MM/DD/YYYY, with no leading zeros — 1/5/2024, not 01/05/2024. |
| 15 | SURVEY TYPE | Census, Sample or Library — whether the play was counted or statistically sampled. |
| 17–18 | SERIES OR FILM/ATTRACTION · PROGRAM NAME | For audiovisual rows: the series or film, then the episode or air date. |
| 19–20 | WORK ID · WORK TITLE | ASCAP's work identifier and the registered title. |
| 23 | NUMBER OF PLAYS | Play count for the row. |
| 24 | PERFORMANCE TYPE (USAGE) | How the work was used — feature, background, theme, etc. |
| 25–26 | DURATION · PERFORMING ARTIST | HH:MM:SS timing and the featured performer. |
| 28 | EE SHARE | Entitled Earner Share — your percentage of the work on this row. |
| 29 | CREDITS | ASCAP's internal performance credits; negatives carry a "-" sign. |
| 30 | DOLLARS | The money for the row. This is the column the earnings tape sums. |
| 33–35 | ADJUSTMENT INDICATOR / REASON / ORIGINAL DATE | "Y" marks a correction to an earlier distribution, with the reason and original date. |
| 36 | ROLE TYPE | OWNER-COLLECTOR, ADMIN-SUBPUB, COLLECTED-BY-OTHER or LEGAL EARNER/SUCCESSOR — see below. |
| 37 | TYPE OF RIGHT | PR, MR or SR; performing right (PR) is the default on ASCAP statements. |
| 38 | TERRITORY | Two-letter territory code. |
| 41 | PERFORMANCE QUARTER | When the performances happened, as qQyyyy — e.g. 2Q2025. |
Source: ASCAP Domestic Electronic Statements File Format (PDF, March 2024) and ASCAP statement guides — transcribed and checked against the engine's parser on 2026-08-16.
The converter maps all 41 columns, not just these. Several populate only for certain row types: SRE rows (Serious, Recital or Educational — column 22's classification code) leave the broadcast fields empty, while day-part codes, network service and premium credits appear only on non-SRE rows. Empty cells in those columns are the spec working as designed, not a broken file.
Column 36 is the one that quietly breaks naive spreadsheet sums. Rows marked COLLECTED-BY-OTHER are royalties on your works that were collected by a different party — a co-publisher or administrator — and are shown for information only. That money is not in your remittance. Sum the DOLLARS column across every row and you will "earn" more than ASCAP paid you. The converter excludes COLLECTED-BY-OTHER rows from your total, counts them separately, and tells you it did so — the exclusion is printed in the output, never silent.
Each row carries a DISTRIBUTION YEAR and QUARTER (when ASCAP paid) and a PERFORMANCE QUARTER (when the plays occurred), the latter formatted qQyyyy — 3Q2024 means the third quarter of 2024. Because distributions trail performances, the two routinely differ; the earnings tape keeps both so you can pivot by either. Dates elsewhere in the file are MM/DD/YYYY with leading zeros dropped, which is exactly the sort of thing Excel's date guessing gets wrong on import — another reason to let a parser built to the spec do it.
Built to ASCAP's published 41-column specification. The parser applies the ROLE TYPE rule: COLLECTED-BY-OTHER rows are excluded from your total and reported as a warning with the count, because that money was collected by another party. PERFORMANCE QUARTER arrives as 'qQyyyy' (e.g. 1Q2026) and is normalised to a date.
Parsing runs in your browser — files are never uploaded. What the tie-out does and does not prove.
The 41-column layout on this page is the domestic electronic statement. ASCAP's foreign/eStatement export is a different, 26-column layout; unrecognised layouts fall back to the generic header mapper, which labels its mapping so you can check it before trusting the numbers.
ASCAP pays the performance side of a composition. The same song’s mechanical and publisher-routed income arrive on different statements, documented here:
Background reading: how to read a royalty statement — or go straight to the converter, which takes the ASCAP zip alongside the rest.
One normalized dataset, a six-sheet Excel earnings tape, and a clear note on anything the parser excluded or could not read. Free, in your browser.
Convert your statement now — free