The RevRec Canvas
Book 40: Deferrals by customer segment cover

Home › Reporting and analysis

Book 40 · Alteryx workflows for SAP RAR

Deferrals by customer segment

The waterfall knows the ship-to and nothing else about the customer. Resolve every ship-to to a channel and a market through three customer sources in priority order, keep what cannot be resolved in plain sight, and prove that the segmented deferred balance ties back to the waterfall to the cent.

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

What the example shows

A deferred waterfall split by segment through three customer sources and tied back to the total. Second workflow: each segment rolled forward a month, with fixed ship-tos kept apart from billings and revenue.

What you get

  • The ebook: an 84-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (40_Segment_Deferrals.yxmd, 40b_Segment_Rollforward.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 1Who the deferral is owed to
  2. Chapter 2Five files, and what is wrong with them
  3. Chapter 3From text months to numbers
  4. Chapter 4Three sources, one candidate list
  5. Chapter 5One winner per ship-to
  6. Chapter 6Every waterfall row, once
  7. Chapter 7The work list, the summary and the control
  8. Chapter 8Reading the result
  9. Chapter 9Moving it to your system
  10. Chapter 10The segment roll-forward
  11. Chapter 11Exercises
  12. Appendix ATool-by-tool settings
  13. Appendix BOutput field dictionary
  14. Appendix CAnswer key

Look inside

Book 40: Deferrals by customer segment table of contents
Contents
Book 40: Deferrals by customer segment first page
First page