The RevRec Canvas
Book 24: Explaining the waterfall movement cover

Home › Close and reconciliation

Book 24 · Alteryx workflows for SAP RAR

Explaining the waterfall movement

From one month-end waterfall to the next: every POB's change in deferred revenue explained by its postings, every gap classified, bundle contracts judged as a whole, and three controls that prove nothing was lost or counted twice.

  • Close and reconciliation
  • Advanced
  • 97 pages
  • Tested workflows and sample data
$49Individual license · Team of five $147
Buy this bookTry the free Book 2 sample

What the example shows

The month-over-month waterfall change matched to postings, with bundle contracts judged at contract level. Second workflow: the quarter roll-forward, with revenue from the opening balance and from billings.

What you get

  • The ebook: a 97-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (24_Waterfall_Variance.yxmd, 24b_Quarter_Rollforward.yxmd)
  • Synthetic sample data (8 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 1Explaining the waterfall movement
  2. Chapter 2The four files
  3. Chapter 3The waterfall, both months
  4. Chapter 4The postings
  5. Chapter 5The comparison
  6. Chapter 6Contracts and the bundle rule
  7. Chapter 7Outputs and the three controls
  8. Chapter 8Reading the result
  9. Chapter 9Moving it to your system
  10. Chapter 10From the month to the quarter
  11. Chapter 11Exercises
  12. Appendix ATool-by-tool settings
  13. Appendix BOutput field dictionary
  14. Appendix CAnswer key

Look inside

Book 24: Explaining the waterfall movement table of contents
Contents
Book 24: Explaining the waterfall movement first page
First page