What the example shows
110 contracts netted by contract. Netting by POB would overstate contract assets by 17,114.28. Now with three workflows and three datasets, including a messy quarter with seven planted problems for the controls to catch.
What you get
- The ebook: a 97-page PDF that walks through the workflow tool by tool
- 3 tested Alteryx workflows (01_RAR_Rollforward.yxmd, 01b_Next_Quarter.yxmd, 01c_One_Contract.yxmd)
- 2 extra scenarios 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
- Chapter 1What the rollforward has to prove
- Chapter 2Contract balances in plain terms
- Chapter 3The three extracts
- Chapter 4The position of every obligation
- Chapter 5Netting by contract
- Chapter 6The rollforward and the migration table
- Chapter 7Revenue from the opening liability
- Chapter 8Remaining performance obligations
- Chapter 9Running it, checking it, and moving it to your system
- Chapter 10Proving nothing was left out
- Chapter 11Two more quarters: a messy one and a different business
- Chapter 12The next quarter
- Chapter 13One contract, month by month
- Chapter 14Exercises
- Appendix ATool-by-tool settings
- Appendix BOutput field dictionary
- Appendix CAnswer key
Look inside


