The RevRec Canvas
Book 8: The RAR close pack: schedule, log, output cover

Home › Close and reconciliation

Book 8 · Alteryx workflows for SAP RAR

The RAR close pack: schedule, log, output

One workbook with the rollforward, the GL tie-out and a close checklist, built from the checks in Books 1 to 7.

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

What the example shows

A four-tab close workbook with seven checks per company. One manual JE breaks the tie-out. Two workflows and three datasets: checks that fail mid-close, a month of credit memos, and a close status with a sign-off line.

What you get

  • The ebook: a 72-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (08_Close_Pack.yxmd, 08b_Close_Status.yxmd)
  • 2 extra scenarios with their own data and answer keys
  • Synthetic sample data (12 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 1One workbook for the close
  2. Chapter 2The three files
  3. Chapter 3A rollforward for every contract
  4. Chapter 4Company totals and the GL figures
  5. Chapter 5Checks 1 to 6, one shape
  6. Chapter 6One workbook, one stream
  7. Chapter 7Reading the pack
  8. Chapter 8Moving it to your system
  9. Chapter 9Check 7 and a month that breaks
  10. Chapter 10A month of credit memos
  11. Chapter 11The close status
  12. Chapter 12Exercises
  13. Appendix ATool-by-tool settings
  14. Appendix BOutput field dictionary
  15. Appendix CAnswer key

Look inside

Book 8: The RAR close pack: schedule, log, output table of contents
Contents
Book 8: The RAR close pack: schedule, log, output first page
First page