The RevRec Canvas
Book 19: The go-live tie-out cover

Home › Close and reconciliation

Book 19 · Alteryx workflows for SAP RAR

The go-live tie-out

Proving that legacy deferred revenue arrived in RAR at transition, contract by contract, and taking the legacy total to the RAR total with every difference named.

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

What the example shows

Legacy against RAR deferred revenue, bridged to zero, including a contract loaded twice. Second workflow: the first month in parallel, January revenue in legacy against RAR, per tie group.

What you get

  • The ebook: an 83-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (19_Go_Live_Tieout.yxmd, 19b_First_Month.yxmd)
  • Synthetic sample data (5 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 1What the go-live has to prove
  2. Chapter 2The three files
  3. Chapter 3Tie groups from the map
  4. Chapter 4Each side, summed per group
  5. Chapter 5Comparing the groups
  6. Chapter 6The bridge
  7. Chapter 7Reading the result
  8. Chapter 8Moving it to your migration
  9. Chapter 9The first month
  10. Chapter 10Exercises
  11. Appendix ATool-by-tool settings
  12. Appendix BOutput field dictionary
  13. Appendix CAnswer key

Look inside

Book 19: The go-live tie-out table of contents
Contents
Book 19: The go-live tie-out first page
First page