What the example shows
42 contracts in two companies over twelve months, each rolled forward and netted into contract liabilities and contract assets, billings bridged to revenue through both balances, the balances tied to the GL, eight exception rules, and the 10,500.00 that netting by POB would add to both balances. A second workflow builds the bridge for every quarter and the year, and a quarter-end scenario adds four contracts that move the quarters.
What you get
- The ebook: a 92-page PDF that walks through the workflow tool by tool
- 2 tested Alteryx workflows (48_Billings_Bridge.yxmd, 48b_Quarter_Bridge.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
- Chapter 1Why billings and revenue differ
- Chapter 2Three contracts by hand
- Chapter 3The data, and one row per month
- Chapter 4Rolling forward and netting
- Chapter 5The bridge
- Chapter 6Tying to the GL
- Chapter 7Eight rules
- Chapter 8Netting by POB, and the control
- Chapter 9Moving it to your system
- Chapter 10Quarters and the year
- Chapter 11Four contracts at the quarter end
- Chapter 12Exercises
- Appendix ATool-by-tool settings
- Appendix BOutput field dictionary
- Appendix CAnswer key
Look inside


