The Royalty trial balance shows, by Payee/ISBN/Item hierarchy, all calculated advances, royalties and other balances and currency for each contract.
The B/F return provisions and the current period returns provisions (return provisions – returns provision reversal) display under the ‘Balances B/F’ heading and the ‘Current Period’ heading.
Balances are shown for the current period, brought forward from the previous periods, the amount to be paid, and the resultant carried forward total. A breakdown subtotal is displayed for each payee and grand total by currency. Field “Pending for previous period close” would be “Y” to show that the previous period must close before generating the AP invoices for the current period.
- In the menu, expand Publishing Modules > Rights & Permission > Royalty Reports > Royalty Balance and double-click Royalty Trial Balance E-report. RYR061 Royalty Trial Balance Spreadsheet panel appears.
The Trial balance report has the following selection criteria.
- Period
- Exclude (you can select to exclude zero balances or zero movements or both)
- Payment frequency range
- Company range
- Royalty group range
- Payee range
- Agent range
- Enter the above selection criteria as required for the report and click OK. This program generates an excel spreadsheet that is stored in the network directory specified in the document exchange system.
