The RevRec Canvas
Book 2: Tying RAR to the general ledger cover

Home › Close and reconciliation

Book 2 · Alteryx workflows for SAP RAR

Tying RAR to the general ledger

Proving that RAR postings reached the ledger, account by account, and explaining every difference that is left.

  • Close and reconciliation
  • Intermediate
  • 67 pages
  • Tested workflows and sample data
$39Individual license · Team of five $117
Buy this bookTry the free Book 2 sampleFree tie-out check

What the example shows

2,660 postings tied to the trial balance. Leading zeros, duplicate keys and run-0 postings cause the gaps. Two workflows and three datasets: a messy close, a second currency, and a tie-out by period.

What you get

  • The ebook: a 67-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (02_Tying_RAR_to_the_GL.yxmd, 02b_Open_Items_by_Period.yxmd)
  • 2 extra scenarios with their own data and answer keys
  • Synthetic sample data (10 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 1Two ledgers that should agree
  2. Chapter 2The three files
  3. Chapter 3The RAR side
  4. Chapter 4The ledger side
  5. Chapter 5The comparison
  6. Chapter 6Reading the result
  7. Chapter 7Clearing what is left
  8. Chapter 8Moving it to your system
  9. Chapter 9What the tie-out cannot see on its own
  10. Chapter 10A messy close and a second currency
  11. Chapter 11Period by period
  12. Chapter 12Exercises
  13. Appendix ATool-by-tool settings
  14. Appendix BOutput field dictionary
  15. Appendix CAnswer key

Look inside

Book 2: Tying RAR to the general ledger table of contents
Contents
Book 2: Tying RAR to the general ledger first page
First page