The RevRec Canvas
Book 20: Auditing manual changes cover

Home › Close and reconciliation

Book 20 · Alteryx workflows for SAP RAR

Auditing manual changes

Every hand-made change to a revenue contract or POB: who made it, whether it reached into a closed period, what it did to revenue, and whether its creator made it. Batch jobs and interfaces taken out, a ranked list to sample from, and a proof that no row of the change log was lost.

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

What the example shows

460 change rows classified. Nine changes after close and one unknown user stand out. Second workflow: who approved each change, with self-approvals, authority and limits, and approvals after the close.

What you get

  • The ebook: a 97-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (20_Manual_Changes_Audit.yxmd, 20b_Change_Approvals.yxmd)
  • Synthetic sample data (6 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 1Who changed it, when, and what it did
  2. Chapter 2The four files
  3. Chapter 3One timestamp, one user
  4. Chapter 4Who is a person?
  5. Chapter 5Timing against the close
  6. Chapter 6Reversals, impact, creator and priority
  7. Chapter 7Three lists and a proof
  8. Chapter 8Reading the result
  9. Chapter 9Moving it to your system
  10. Chapter 10Who approved it
  11. Chapter 11Exercises
  12. Appendix ATool-by-tool settings
  13. Appendix BOutput field dictionary
  14. Appendix CAnswer key

Look inside

Book 20: Auditing manual changes table of contents
Contents
Book 20: Auditing manual changes first page
First page