The RevRec Canvas
Book 33: Royalty-bearing revenue cover

Home › Reporting and analysis

Book 33 · Alteryx workflows for SAP RAR

Royalty-bearing revenue

Recognized revenue by title and period for the materials that carry an author royalty, returns netted in, with every revenue dollar shown as eligible, not eligible, unresolved or excluded, and a control that proves it.

  • Reporting and analysis
  • Intermediate
  • 91 pages
  • Tested workflows and sample data
$39Individual license · Team of five $117
Buy this bookTry the free Book 2 sample

What the example shows

The royalty base by title and period, with every revenue line in exactly one status. Second workflow: the half-year royalty statement, advances recouped and a minimum guarantee topped up, with the entry.

What you get

  • The ebook: a 91-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (33_Royalty_Revenue.yxmd, 33b_Royalty_Advances.yxmd)
  • Synthetic sample data (6 files) and an answer key, so you can check every number
  • Runs in Alteryx Designer 2023.1 or later; one zip, delivered by email right after payment

Contents

  1. Chapter 1The royalty base
  2. Chapter 2The data
  3. Chapter 3The extract and its keys
  4. Chapter 4The ISBN master
  5. Chapter 5The material, then the flag
  6. Chapter 6One status per line
  7. Chapter 7The base, the titles and the control
  8. Chapter 8Reading the result
  9. Chapter 9Moving it to your system
  10. Chapter 10From the base to the royalty statement
  11. Chapter 11Exercises
  12. Appendix ATool-by-tool settings
  13. Appendix BOutput field dictionary
  14. Appendix CAnswer key

Look inside

Book 33: Royalty-bearing revenue table of contents
Contents
Book 33: Royalty-bearing revenue first page
First page