The RevRec Canvas
Book 16: Forecasting revenue from RAR cover

Home › Reporting and analysis

Book 16 · Alteryx workflows for SAP RAR

Forecasting revenue from RAR

Turning the POB schedule into a 24-month revenue waterfall for planning, and proving that it ties: nothing lost, nothing made up, and the deferred revenue on the balance sheet in it.

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

What the example shows

Remaining revenue spread over 24 months and tied back to the waterfall to the cent. A second workflow compares it with what RAR posted three months later and explains every difference.

What you get

  • The ebook: a 72-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (16_Revenue_Forecast.yxmd, 16b_Forecast_vs_Actual.yxmd)
  • Synthetic sample data (4 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 already under contract
  2. Chapter 2The three files
  3. Chapter 3Dates, what is left, and how to forecast it
  4. Chapter 4One row per month: Generate Rows
  5. Chapter 5The waterfall and the cross tab
  6. Chapter 6Proving it ties, and listing what does not
  7. Chapter 7Reading the result
  8. Chapter 8Moving it to your system
  9. Chapter 9Forecast against actual
  10. Chapter 10Exercises
  11. Appendix ATool-by-tool settings
  12. Appendix BOutput field dictionary
  13. Appendix CAnswer key

Look inside

Book 16: Forecasting revenue from RAR table of contents
Contents
Book 16: Forecasting revenue from RAR first page
First page