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.
Convert your statement now — 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. |
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.
Your statement never leaves your browser. Parsing, normalization and workbook generation run in WebAssembly inside the tab. Nothing is uploaded; you can disconnect from the internet after the page loads and everything still works.
The tie-out proves the extraction, not the source. Where a statement carries printed totals, the extracted rows must sum to them to the cent or the discrepancy is shown. Machine exports like ASCAP's CSV carry no printed grand total, so they report as SELF-CONSISTENT — internal checks passed, with no stated total to reconcile against. That is normal for this format, not a defect.
That is simply how the portal packages the domestic electronic statement: one CSV inside a zip archive. You do not need to extract it — drop the zip into the converter as delivered and it will find the CSV inside.
Almost certainly COLLECTED-BY-OTHER rows. They show royalties collected by another party and are not part of your payment. The converter excludes them from your total and reports how much it excluded.
Performances from the third quarter of 2025, in ASCAP's qQyyyy format. It will usually be earlier than the distribution quarter on the same row, because distributions trail the performances they pay for.
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.
New to statement anatomy? Start with how to read a royalty statement.
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