The RevRec Canvas
Book 50: Contract modifications: separate contract, prospective or catch-up cover

Home › Contracts and obligations

Book 50 · Alteryx workflows for SAP RAR

Contract modifications: separate contract, prospective or catch-up

Separate contract, prospective or catch-up. Classify every change to a contract the way the standards do, recompute revenue under the treatment it needs, and measure what RAR posted against it, POB by POB.

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

What the example shows

Nine modifications classified the way ASC 606 does, revenue to the cut-off recomputed under each treatment and compared with RAR POB by POB. An extension RAR booked as a catch-up instead of prospectively, and training posted on an unsigned change order, each measured to the cent. A second workflow chains modifications that build on each other, with a second dataset.

What you get

  • The ebook: a 116-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (50_Contract_Modifications.yxmd, 50b_Chained_Modifications.yxmd)
  • 1 extra scenario with their own data and answer keys
  • Synthetic sample data (10 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 a modification is, and what it is not
  2. Chapter 2One contract, three treatments
  3. Chapter 3The data
  4. Chapter 4The tests
  5. Chapter 5Classification
  6. Chapter 6Prospective arithmetic
  7. Chapter 7Catch-up, and the schedule for every treatment
  8. Chapter 8The revenue effect against RAR
  9. Chapter 9Moving it to your system
  10. Chapter 10Changes that build on each other
  11. Chapter 11A year of changes
  12. Chapter 12Exercises
  13. Appendix ATool-by-tool settings
  14. Appendix BOutput field dictionary
  15. Appendix CAnswer key
  16. Appendix DMonth by month

Look inside

Book 50: Contract modifications: separate contract, prospective or catch-up table of contents
Contents
Book 50: Contract modifications: separate contract, prospective or catch-up first page
First page