The RevRec Canvas
Book 31: Accruing unscheduled revenue cover

Home › Contracts and obligations

Book 31 · Alteryx workflows for SAP RAR

Accruing unscheduled revenue

Revenue RAR is still waiting to schedule, estimated at month end: dated on purpose, spread by day over the access period, capped, converted, and with every row left out given a reason and a control.

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

What the example shows

217 unscheduled items. 185 accrued day by day over the access period, 32 excluded with a reason. Second workflow: the look-back a month later, accrual against what RAR scheduled.

What you get

  • The ebook: an 89-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (31_Unscheduled_Accruals.yxmd, 31b_Accrual_Lookback.yxmd)
  • Synthetic sample data (9 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 1Revenue that is waiting for an event
  2. Chapter 2The seven files
  3. Chapter 3Cleaning and dating the report
  4. Chapter 4Six lookups that cannot lose a row
  5. Chapter 5One reason per row, and the accrual
  6. Chapter 6The lookup gaps and the population control
  7. Chapter 7Reading the result
  8. Chapter 8Moving it to your system
  9. Chapter 9A month later: the look-back
  10. Chapter 10Exercises
  11. Appendix ATool-by-tool settings
  12. Appendix BOutput field dictionary
  13. Appendix CAnswer key

Look inside

Book 31: Accruing unscheduled revenue table of contents
Contents
Book 31: Accruing unscheduled revenue first page
First page