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.
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.
Output / Readout
The three-period ledger
| Line | Period 1 | Period 2 | Period 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
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.