Roster vs Spreadsheets: When It's Time to Make the Switch

Spreadsheets can be a practical starting point. As data formats, deals and review requirements become more complex, evaluate whether the process still gives your team clear, reliable records.

When spreadsheets work

If you have one or two artists on simple royalty deals — no advances, no producer points, no co-writers — a spreadsheet is fine. You can manually enter DSP data, calculate a single split, and send a PDF statement. It takes time, but it works.

When spreadsheets break

The problems start when any of these happen:

• Multiple DSP formats. Every distributor exports data differently. Normalising Spotify, Apple, Amazon, and others into a single format — every month — becomes a job in itself.
• Complex splits. A release with a label share, an artist royalty, producer points, and two co-writers has five calculations to get right. Every period. For every release.
• Recoupment. Tracking advances against royalties across multiple releases, some ring-fenced and some cross-collateralised, is where spreadsheets become dangerous. One formula error and your artist is either underpaid or kept in recoupment incorrectly.
• Version control. When two people update the same spreadsheet — or maintain separate copies — there's no reliable source of truth.
• Audit trail. If an artist disputes a number, can you show exactly how it was calculated? Spreadsheets don't record their own history.

The risk isn't just getting a number wrong. It's not knowing that you got it wrong — until an artist notices.

What changes when you switch

1. 1Logic-based data import. Upload supported royalty CSVs. Roster recognises common columns and helps you review mapping and exceptions before processing. Check your exact export format during preflight.
2. 2Splits. Keep reviewed contributor and split records together. Check which terms apply to each accounting period before approving calculations.
3. 3Recoupment. Keep advances and costs with the relevant release records. Review balances and the configured recoupment scope for the period.
4. 4Statements. Prepare statements for review. Check totals and exceptions before approval and artist notification.
5. 5Artist access. Portal access means artists can see their own statements, balances, and history without you sending PDFs.

How to know if it's time

You should switch when:

• Statement day takes more than a few hours
• You've had at least one dispute caused by a calculation error
• You have advances to recoup and you're not 100% confident in the balance
• Multiple people touch the royalty spreadsheet
• You've thought about hiring someone just to do this work