A Simple Spreadsheet Template for Tracking Cover Song Royalties

A cover song royalty tracking spreadsheet needs at minimum eight columns: song title, original artist, licensing status, release date, distributor, platform breakdown, payout date, and cumulative total. Anything less and you lose the ability to answer basic questions like which covers are actually profitable after licensing costs. Below is a full template you can build in Google Sheets or Excel in under ten minutes, plus a worked example showing why the extra columns matter.

Once you’ve released more than four or five covers, mental tracking stops working. Streaming platforms report earnings on delayed, staggered schedules, licensing status varies release to release, and it becomes genuinely hard to remember which track is actually cleared versus still pending. A spreadsheet isn’t optional bookkeeping at that point — it’s the only way to know your real numbers.

Why do cover artists need a separate spreadsheet from original songs?

Cover songs carry a licensing dimension that original songs don’t, so tracking them the same way hides important information. An original song has one royalty stream tied to your own rights. A cover song has a licensing cost, a licensing status (pending, approved, denied), and a royalty stream that only starts flowing once that license is active — mixing these into a general «all my music» tracker makes it hard to see which releases are actually earning versus still stuck in moderation or licensing review.

What columns should the spreadsheet include?

The core template needs the following columns, in this order, to stay useful without becoming a chore to update.

Song title / Original artist — for search and quick identification
Distributor used — useful if you split releases across services or switch providers over time
Licensing status — pending, active, denied, expired
License cost — what you paid for mechanical licensing on this specific release
Release date — when the track went live on platforms
First payout date — when royalties first appeared, useful for benchmarking moderation and processing speed
Platform breakdown — separate sub-columns or a linked tab for Spotify, Apple Music, YouTube Music, Amazon Music, and others
Cumulative royalties to date — running total, updated each payout cycle
Net position — cumulative royalties minus license cost minus distribution fee, so you can see actual profit at a glance

That last column is the one most trackers skip, and it’s the one that actually tells you whether a given cover was worth releasing.

How do you calculate the «net position» column?

Net position is cumulative royalties minus every dollar you spent to release and license the track. For a cover released through Globex Music, that’s typically a $1 per-single fee plus the mechanical licensing cost, which is included automatically rather than requiring a separate application. Subtract that combined cost from your running royalty total, and you get a single number that tells you the moment a cover crosses from cost center to profit — something a raw «total earned» figure can’t show you on its own.

Worked example: tracking three covers over six months

Here’s how the spreadsheet plays out with real numbers, using typical payout patterns for a small but consistent independent catalog.

Cover A (released January, licensing approved within days, moderation cleared fast): $1 release cost, first payout of $14 arrived within about six to eight weeks, cumulative total by month six reached $61. Net position: +$60.

Cover B (released February, licensing pending for several weeks before approval): $1 release cost, first payout delayed to month three at $10, cumulative by month six at $38. Net position: +$37.

Cover C (released March, licensing denied, track pulled): $1 release cost, $0 royalties, listed as a loss in the spreadsheet at −$1. This row matters as much as the winners — it’s what tells you which songwriters or publishers to avoid re-attempting.

Across all three, total spend was $3 and total return was $99, a ratio that would look completely different — and far less clear — if these three rows were buried inside a general all-releases spreadsheet instead of isolated in a dedicated cover tracker.

How often should you update the payout columns?

Update the spreadsheet every time a distributor issues a payout, which for most services is monthly, and note the date alongside the amount. Globex Music processes payouts starting from $10 USD, so smaller or newer covers may sit in an accruing balance for a cycle or two before crossing the payout threshold — recording the accrual date, not just the payout date, prevents the false impression that a track earned nothing when it’s actually just below the minimum.

Should you track licensing costs against fees charged by other distributors?

Yes, if you’ve used more than one distributor over time, and this is where the spreadsheet earns its keep as a comparison tool, not just a ledger. A cover released through DistroKid carries no per-release fee but sits inside a $44.99/year plan; through TuneCore it’s a $24.99/year base subscription plus separate per-cover licensing fees and a 20% commission specifically on social platform monetization; through CD Baby it’s $9.95 per single plus a 9% royalty commission that applies indefinitely. Logging which platform each row went through lets you calculate, in the same net position column, what identical royalty totals actually netted you after each service’s cost structure — a comparison that’s meaningless without the spreadsheet in front of you.

What’s the simplest version of this template for a beginner?

If you’ve released fewer than five covers, a six-column version works fine: title, licensing status, release date, distributor, license cost, cumulative royalties. Expand to the full nine-column version once you’re managing enough releases that remembering licensing status by memory becomes unreliable — usually somewhere around the tenth or twelfth cover for most independent artists.

Key takeaway

The value of a royalty tracking spreadsheet isn’t the total at the bottom — it’s the net position column that turns a list of songs into a decision-making tool, showing you which covers, which licensing turnaround times, and which distributors are actually worth repeating.