The RevRec Canvas
Book 37: Revenue by customer cover

Home › Reporting and analysis

Book 37 · Alteryx workflows for SAP RAR

Revenue by customer

Every GL revenue line for the quarters FP&A asked for, with the customer found directly, through the partner map or from the legacy list, descriptions, quarter labels, size bands and flags, summed by customer and quarter, and proved complete against the revenue control.

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

What the example shows

265 revenue lines matched to customers by three routes, with a completeness check. A second workflow measures customer concentration and runs the 10 % major-customer test.

What you get

  • The ebook: a 75-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (37_Revenue_By_Customer.yxmd, 37b_Customer_Concentration.yxmd)
  • Synthetic sample data (9 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 1Revenue by customer
  2. Chapter 2The eight files
  3. Chapter 3The population
  4. Chapter 4Route 1: the customer list, and the left join
  5. Chapter 5Routes 2 and 3: the partner map and the legacy list
  6. Chapter 6Descriptions, size bands and flags
  7. Chapter 7Four outputs and the completeness proof
  8. Chapter 8Reading the result
  9. Chapter 9Moving it to your system
  10. Chapter 10Customer concentration
  11. Chapter 11Exercises
  12. Appendix ATool-by-tool settings
  13. Appendix BOutput field dictionary
  14. Appendix CAnswer key

Look inside

Book 37: Revenue by customer table of contents
Contents
Book 37: Revenue by customer first page
First page