Free Revenue Split Modeler

Split logic usually starts life in a spreadsheet, one tab per deal, rebuilt each cycle by the person who understands it. The arrangement works while it is one product and one partner. What it costs is answerability: six months later, a seller asks why a payout was what it was, and the honest response is that the tab has been edited since. Rates also drift apart, because a promotional 12% agreed in March survives in a formula nobody revisits, and the difference between the agreement and the arithmetic is only visible to whoever opens the file.

The default here shows the mechanism. On $5,000 of gross with $195 of deductions taken first, $4,805 is distributable, and a 10, 85 and 5 split allocates $480.50, $4,084.25 and $240.25. Apply the same percentages to the gross instead and the seller line reads $4,250, the platform $500 and the affiliate $250. The $195 has to land somewhere, and those two orderings put it in different pockets: deducting first spreads it across all three in proportion, so the seller absorbs $165.75 of it, while splitting first leaves the platform carrying the whole $195 out of its own share.

Over-allocation is the case worth deciding before production. Two fixed allocations of $80 against a $100 base come to $160, and the model normalizes them back to $100 rather than refusing the input, so each party receives less than the number in its agreement, and the banner that appears talks about percentages adding up, which is not the case you are in. A payout system has to resolve the same collision explicitly: which party is capped, which is paid in full, and who is told. Refunds run the same problem backwards, since money already paid out to three parties is recovered from whichever balance still has something in it.