What the example shows
55 contracts in two companies netted into contract liabilities and assets, every liability split into FIFO layers by invoice and aged into five buckets. A stopped schedule, an orphan credit memo and a one-invoice ledger difference are found and explained. A second workflow rolls the aging from one month-end to the next, and a messy-month scenario adds four problems to find.
What you get
- The ebook: a 101-page PDF that walks through the workflow tool by tool
- 2 tested Alteryx workflows (43_Deferred_Aging.yxmd, 43b_Aging_Roll.yxmd)
- 1 extra scenario with their own data and answer keys
- Synthetic sample data (8 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 1How old is the deferred revenue?
- Chapter 2The data
- Chapter 3The cut-off and the scope
- Chapter 4Billings into invoices
- Chapter 5The contract position
- Chapter 6FIFO layers
- Chapter 7Summary and exceptions
- Chapter 8Control, ledger and reading the result
- Chapter 9Moving it to your system
- Chapter 10The aging roll
- Chapter 11A messy month
- Chapter 12Exercises
- Appendix ATool-by-tool settings
- Appendix BOutput field dictionary
- Appendix CAnswers to the exercises
Look inside


