The RevRec Canvas
Book 23: The waterfall and the posting table cover

Home › Close and reconciliation

Book 23 · Alteryx workflows for SAP RAR

The waterfall and the posting table

What RAR still has to recognize, POB by POB, proved against the inception-to-date postings on the deferred revenue account, with a check that every waterfall row adds up on its own.

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

What the example shows

The deferred revenue waterfall tied POB by POB to inception-to-date postings. Second workflow: the waterfall and the posting table tied to the GL balance, POB by POB.

What you get

  • The ebook: an 86-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (23_Waterfall_to_Posting.yxmd, 23b_Waterfall_to_GL.yxmd)
  • Synthetic sample data (4 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 waterfall and the ledger
  2. Chapter 2The three files
  3. Chapter 3The waterfall stream
  4. Chapter 4The posting population
  5. Chapter 5The POB master and the posting summary
  6. Chapter 6The reconciliation
  7. Chapter 7Reading the result
  8. Chapter 8Moving it to your system
  9. Chapter 9The waterfall on the balance sheet
  10. Chapter 10Exercises
  11. Appendix ATool-by-tool settings
  12. Appendix BOutput field dictionary
  13. Appendix CAnswer key

Look inside

Book 23: The waterfall and the posting table table of contents
Contents
Book 23: The waterfall and the posting table first page
First page