The RevRec Canvas
Book 3: Posting run errors, caught before close cover

Home › Close and reconciliation

Book 3 · Alteryx workflows for SAP RAR

Posting run errors, caught before close

Proving that every RAR reconciliation key reached the ledger, and finding the cause and the fix when it did not.

  • Close and reconciliation
  • Advanced
  • 69 pages
  • Tested workflows and sample data
$49Individual license · Team of five $147
Buy this bookTry the free Book 2 sample

What the example shows

Reconciliation keys traced to the GL, including reruns, reversed documents and partial transfers. Second workflow: twelve months of posting runs, recurring causes and owner aging.

What you get

  • The ebook: a 69-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (03_Posting_Run_Errors.yxmd, 03b_Error_Trend.yxmd)
  • 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

  1. Chapter 1Where postings get lost
  2. Chapter 2The five files
  3. Chapter 3Both sides by key and account
  4. Chapter 4Comparing gross, not net
  5. Chapter 5Reading the posting run log
  6. Chapter 6One row per key, and a verdict
  7. Chapter 7The work list
  8. Chapter 8Fixing, preventing, and moving it to your system
  9. Chapter 9Which errors keep coming back?
  10. Chapter 10Exercises
  11. Appendix ATool-by-tool settings
  12. Appendix BOutput field dictionary
  13. Appendix CAnswer key

Look inside

Book 3: Posting run errors, caught before close table of contents
Contents
Book 3: Posting run errors, caught before close first page
First page