The RevRec Canvas
Book 51: Physical, digital or mixed: classifying shipping and fee revenue by order cover

Home › Reporting and analysis

Book 51 · Alteryx workflows for SAP RAR

Physical, digital or mixed: classifying shipping and fee revenue by order

Classify shipping, handling and fee revenue by what was on the order behind each GL line. One category per order, every bundle opened, every rejection dated, and a control that ties A + B + C + Review back to the ledger.

  • Reporting and analysis
  • Intermediate
  • 154 pages
  • Tested workflows and sample data
$39Individual license · Team of five $117
Buy this bookTry the free Book 2 sample

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

  1. Chapter 1The question the ledger cannot answer
  2. Chapter 2The data
  3. Chapter 3Scope, and the order behind each line
  4. Chapter 4Every item, on the right date
  5. Chapter 5Walking the kits
  6. Chapter 6One category per order, back on every line
  7. Chapter 7Reading the result
  8. Chapter 8The month after: 51b
  9. Chapter 9The digital waterfall: 51c
  10. Chapter 10Moving it to your system
  11. Chapter 11Exercises
  12. Appendix ATool-by-tool settings: the main workflow
  13. Appendix BTool-by-tool settings: 51b
  14. Appendix CTool-by-tool settings: 51c
  15. Appendix DOutput field dictionary
  16. Appendix EAnswer key

Look inside

Book 51: Physical, digital or mixed: classifying shipping and fee revenue by order table of contents
Contents
Book 51: Physical, digital or mixed: classifying shipping and fee revenue by order first page
First page