Calculate royalties with repeatable payout logic

Royalty payout calculations need traceable source revenue, versioned rules, understandable statements, and evidence for later disputes.

Start Free Try Sample Data

Details

What to know

Royalty workflow model

Use products or catalog items as the revenue dimension, payees as the recipients, and rules as the royalty terms.

Import source revenue for the royalty period.
Map revenue rows to products and payees.
Use effective dates for contract or rate changes.
Create calculation runs that preserve the rule context used for that period.

What to show reviewers

Reviewers need more than the final royalty amount. They need source totals, rule logic, adjustments, and statement output.

Payee totals by period.
Line-level allocation evidence.
Refund and adjustment context.
Statement files and structured exports.

Reference Tables

Fields and checks

Worked royalty example

Use this example to test whether a royalty period has enough evidence for review.

Input	Example value	Calculation note
Catalog revenue	USD 8,500.00	Imported revenue rows mapped to the royalty-bearing product.
Royalty rate	12%	Stored as a rule scoped to the catalog item or contract metadata.
Adjustment	USD -125.00	Correction row included in the same review period.
Base formula	(8,500.00 - 125.00) x 0.12	Produces USD 1,005.00 as the calculated obligation.

Spreadsheet before / Allocora after

Royalty work becomes easier to defend when each total can be traced to source rows and rule history.

Spreadsheet before	Allocora after	Why it matters
Catalog sales pasted into a monthly sheet.	Revenue events are imported with source identifiers.	A reviewer can trace each royalty amount back to the source row.
Contract rates typed into formulas.	Royalty rates are versioned rules with effective dates.	Rate changes are preserved for historical periods.
Manual statement templates.	Statements are generated after run review.	Payee-facing explanations stay tied to calculation output.
Disputes require rebuilding the sheet.	Audit history links revenue, rules, runs, and statements.	Later questions can be answered from retained evidence.

Examples

Sample CSV rows and formula

These rows show royalty source data with a catalog identifier and adjustment.

Sample royalty CSV rows

external_revenue_id,transaction_date,amount,currency,revenue_type,external_product_id,metadata_contract_id
sale_2044,2026-05-05,8500.00,USD,sale,catalog_album_01,contract_alpha
adj_2044,2026-05-20,-125.00,USD,adjustment,catalog_album_01,contract_alpha

Simple royalty formula

royalty_basis = 8500.00 - 125.00
royalty_due = royalty_basis * 0.12
royalty_due = 1005.00

Feedback

Was this page helpful?

Send a note if a step is unclear, missing, or out of date.

Email Support

Apply this in a workspace

Start free, use sample data, then replace examples with your own revenue rows when the workflow is clear.

Start Free Browse Docs