Skip to contentOpen Music
Business.
← All tools

Workbench / Trace the payout

Royalty Split Calculator

Give every cent a destination.

Start with a single pool of money and the shares people already agreed to. See what each person receives, down to the cent.

On the benchOne royalty poolShares must total 100%

Side B / Story worksheet

Reconcile the publishing advance

Opens with a $500 balance, eligible credits of $200, $250, and $150, and an $80 line excluded from recovery. Switch the posting or export scenario; the participant split worksheet stays separate.

← Back to the interactive

One balance / Three periods

In this example, eligible credits reduce the balance first. The excluded line is tracked separately and cannot reduce it.

Output / Readout

The three-period ledger

Cash shown across the three periods$180.00
Advance balance and payout lines · USD
LinePeriod 1Period 2Period 3
Opening balance$500.00$300.00$50.00
Eligible credit posted$200.00$250.00$150.00
Applied to balance$200.00$250.00$50.00
Closing balance$300.00$50.00$0.00
Eligible payout shown$0.00$0.00$100.00
Excluded line shown$0.00$80.00$0.00
Cash shown$0.00$80.00$100.00

After period 2, the balance is $50.00. Changing when a credit posts can change an interim balance without changing the final total.

Open the separate participant split ↓

This model has one fictional balance and no new charges, fees, or adjustments. A statement line isn’t a bank deposit. Figures stay in this tab until you leave or reload.

Live worksheet / USD

Divide the pool

Fictional participants and pool. Change any field to try a different split.

Fictional statement / Reconcile the pool

Pool
$1,000.00
Allocated
$1,000.00
Unassigned
$0.00
See participant payouts ↓
Scenario inputs
Participant 1
Participant 2

Output / Readout

The receipt

Worked example / Total shares100%
1. Casey River · Songwriter · 60%
$600.00
2. Avery Moss · Songwriter · 40%
$400.00

Total distributed: $1,000.00. No cents left unassigned.

Method / Read the fine print

How this model works

Multiply the pool by each agreed share. Any cents left over after rounding down go to the largest fractional remainders, with ties settled in row order.

Assumptions and limits

This models one pool only. Run composition and recording income separately if their splits differ. A role label does not grant a right, establish ownership or determine which deductions should come out first.

Field notes / Common questions

Good to know

What happens if shares do not total 100%?

The worksheet shows the share total but does not display payouts until it sums to exactly 100%, with up to two decimal places per row.

How does it handle fractional cents?

It rounds each payout down, then gives leftover cents to the largest fractional portions first. If fractions tie, earlier rows take precedence.

Can I run a composition and a master split?

Yes, as separate scenarios. Enter the applicable money pool and the agreed shares for that particular income. This does not decide ownership.

Share