Fixing Unallocated Revenue

Overview

If your Royalty Run doesn't get marked as Completed, but instead shows up as Unallocated Revenue, this means some transactions in your Revenue Reports weren't able to be linked to a payee statement via your contracts.

The most common cause for this, is that there are transactions in your revenue reports for assets that are either:

  • NOT covered by any existing or active contract.

  • Covered by an existing contract but missing terms to assign it.

  • Covered by an existing contract with duplicate terms.

  • Covered by more than one contract with the same terms.


Prerequisites

Before being able to access and fix unallocated revenue in your royalty runs, please ensure the following conditions are met:

  1. Your account has "editor" permissions for Royalty Accounting.


How To: Fix Unallocated Revenue

1

Download the Unallocated Revenue Report

From the Royalty Run flagged with Unallocated Revenue, click to open the options menu, and select Download Unallocated. This will download a CSV file of the unallocated revenue.

2

Identifying The Errors

Open the CSV file in your spreadsheet app of choice.

A single release/track can have a large amount of unallocated transactions, but all transactions can be fixed by addressing the error. We suggest you use a UNIQUE formula to get the unique UPCs/ISRCs that need to be addressed.

3

Reset The Royalty Run

After you've corrected the errors (such as adding missing contracts, correcting duplicated or missing terms, or deactivated redundant contracts), click to open the options menu on the affected royalty run again, and select Reset to retry the run.

If all errors were corrected, your royalty run should update to Completed. If not, you may need to repeat the above steps to see if something else is causing the unallocated revenue warning.


Additional Resources


Next Steps & Future Releases

  • Automated FX rate updates from trusted sources.

  • Enhanced filtering for unprocessed reports.

Last updated

Was this helpful?