Sync Revenue Tracking Spreadsheet: Fees, Splits, and Follow-Ups

Why Sync Money Gets Lost Without a Tracker

Sync income arrives unevenly: an upfront fee this month, a backend PRO payment nine months later, a renewal option next year, and a co-writer who needs a wire for 25%. Without a single source of truth, freelancers underbill, miss options, and cannot answer tax questions. A spreadsheet is enough until deal volume forces a proper royalty system.

As of July 2026, many composers still live in Google Sheets or Excel successfully—if columns are disciplined and updated when contracts move. Fancy software does not fix forgotten cue sheet credits. ^[1]

Recommended Columns (Core Sheet)

Add a second sheet for pitches that are not yet deals: contact, date sent, materials, response, and convert-to-deal_id when won. Separating pipeline from money prevents optimistic double counting.

Modeling Splits Without Drama

Create a writers table: person, role, PRO affiliation, default split, payment details (secure storage—do not put full bank data in a shared sheet). On each deal row, either reference a split template (e.g., “standard trio 40/30/30”) or override with deal-specific percentages that sum to 100% of the writer side you control.

Publisher shares, library shares, and agent commissions need their own columns so “gross fee” never gets confused with “what hits your account.” Example: $10,000 license, 20% library, 10% agent on remaining, then co-writer splits on the rest—calculate stepwise and store each intermediate value for auditability.

When money arrives, record the net deposit and allocate to people with payment dates. Unpaid co-writer liabilities should appear as obligations, not vanish because the brand paid you.

PRO and Backend Income

Performance royalties are not the license fee. They depend on cue sheets, performances, and society rules. Track estimated vs actual carefully—use actual statement line items when available. Columns for statement period, society, amount, and matched deal_id keep backend from becoming mystery money. ^[2]

If a placement should generate performances and nothing appears after a reasonable cycle, your next_action is “verify cue sheet / registration,” not “assume theft.” Many misses are paperwork.

Weekly and Quarterly Workflows

Dashboard ideas

Sum paid YTD, unpaid invoices, pipeline weighted by stage probability (be conservative), and top clients by revenue. Charts are optional; correct totals are not.

Sheets vs Dedicated Tools

Stay on spreadsheets while you can filter and not lose rows. Move to purpose-built royalty platforms or lightweight CRM+accounting when multiple territories, sub-publishers, or staff need permissions. Whatever you use, export CSVs regularly—vendor lock-in is real.

Security: restrict edit access, enable 2FA on the Google/Microsoft account, and keep tax IDs out of overly shared tabs. For GDPR/CCPA-sensitive personal data, minimize what you store. This is operational guidance, not legal advice.

• Currency Store currency code per deal; convert only in reporting columns with a dated FX rate note.
• Retainer work Track hours or monthly retainers on a separate sheet so they do not distort per-cue averages.
• Kill fees Log unpaid speculative rounds with kill fee terms so scope creep is visible.
• Options Calendar option windows—expired options are free money left on the table.

Minimal Template to Start Today

Create three tabs: Deals, Pitches, People. Freeze header rows, data-validate status fields, and color-code Paid (green), Overdue (red), Pending (yellow). Add a fourth tab Notes for narrative context you refuse to cram into cells. Backup weekly to a second drive.

Do not wait for the “perfect” schema. Start with ten columns and expand when a real deal proves a field is missing. The habit of logging beats the fantasy of an all-knowing database you never open.