What the example shows
Shipping, handling and fee revenue in two companies classified by what was on the order behind each GL line. Bundles opened through a four-level kit list, rejections dated to the day the fee posted, replacement orders traced to their originals, and a control that ties A + B + C + Review back to the ledger in each currency. A second workflow rolls the next month forward with lighter rules and a year-to-date mix in USD. A third, 51c, spreads the revenue on digital-only orders over the term of their digital products, by whole months and by day, and sets that waterfall against what was reported.
What you get
- The ebook: a 154-page PDF that walks through the workflow tool by tool
- 3 tested Alteryx workflows (51_Order_Composition.yxmd, 51b_Monthly_Roll.yxmd, 51c_Digital_Waterfall.yxmd)
- 1 extra scenario with their own data and answer keys
- Synthetic sample data (22 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 1The question the ledger cannot answer
- Chapter 2The data
- Chapter 3Scope, and the order behind each line
- Chapter 4Every item, on the right date
- Chapter 5Walking the kits
- Chapter 6One category per order, back on every line
- Chapter 7Reading the result
- Chapter 8The month after: 51b
- Chapter 9The digital waterfall: 51c
- Chapter 10Moving it to your system
- Chapter 11Exercises
- Appendix ATool-by-tool settings: the main workflow
- Appendix BTool-by-tool settings: 51b
- Appendix CTool-by-tool settings: 51c
- Appendix DOutput field dictionary
- Appendix EAnswer key
Look inside


