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.
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
Output / Readout
The receipt
- 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.