Skip to main content
The Royalty Payouts Report aggregates the royalty amounts captured on shipped order lines so finance teams can settle what is owed to each payee for a given ship-date window. The report reads the frozen royalty value that was stamped onto each line at sale time, so payouts always reflect what the customer was actually billed — not whatever the per-item royalty happens to be today.
This report is available only when the royalty feature is enabled for your tenant. If you don’t see Royalty Payouts under Reports, contact your administrator.
Go to FULFILL™ → Reports → Royalty Payouts in the sidebar. The report runs automatically when the page opens, using the current calendar month as the default Ship Date range — so finance lands on a populated report without first having to click anything.

​
Filters

FilterDescription
Ship Date FromStart of the ship-date window (inclusive). Defaults to the first of the current month.
Ship Date ToEnd of the ship-date window (inclusive). Defaults to the last day of the current month.
PayeeOptional. Match royalty payee name (partial match).
Customer IDOptional. Restrict to a single customer.
Item CategoryOptional. Restrict to a single item category.
Click Run Report to refresh results after changing any filter.
Cancelled, Draft, and Deleted orders are always excluded from totals — you do not need a filter for these.

​
Summary Tiles

After a run, four summary tiles appear above the grid:
TileDescription
Total RoyaltyThe sum of all frozen royalty amounts in the selected window
Total Line SubtotalThe sum of line subtotals (price × quantity) for the same lines
LinesThe number of order lines aggregated
Distinct PayeesThe number of unique royalty payees in the result

​
Payee Grid

The main grid shows one row per royalty payee, with these columns:
ColumnDescription
PayeeThe royalty payee name. Click the expand arrow to see breakdowns.
Total RoyaltyThe total royalty amount owed to this payee for the window
Total Line SubtotalThe total line subtotal across the payee’s lines
LinesThe number of lines contributing to this payee

​
Detail Breakdown

Expand any payee row to see two side-by-side breakdowns:
  • By Customer — Royalty totals grouped by the customer that bought the items. Use this when a payee needs an explanation of which customers drove their total.
  • By Item Category — Royalty totals grouped by item category. Use this when reconciling against category-level commission agreements.
Each breakdown shows columns for the dimension, Royalty, and Lines.

​
Exporting

Click Export CSV in the grid ribbon to download a CSV containing the master rows — one row per payee, including their totals. This is the file shape AP typically loads when cutting payout checks.
The CSV export contains the payee summary rows only. The customer and category breakdowns shown in the expanded detail panel are not included in the export.

​
Result Truncation

For protection against runaway queries, the backend caps a single report at 100,000 aggregated lines. If your date range matches more lines than the cap, a warning appears above the summary tiles telling you how many lines were aggregated versus how many matched.
When the report is truncated, the totals shown do not represent the full window. Narrow the Ship Date range (for example, run a month at a time) and re-run until the warning is gone.

​
Best Practices

  • Run the report monthly with default Ship Date filters to match a standard finance close cycle
  • Use the Customer ID filter when reconciling a specific customer’s invoices against their commission statement
  • Export the CSV once finance signs off — the same payee row going to AP is exactly what was on screen, with no further transformation
  • If the truncation warning appears, split the window into smaller ranges rather than trying to bypass the limit