The RevRec Canvas
Book 12: Answering the auditor cover

Home › Close and reconciliation

Book 12 · Alteryx workflows for SAP RAR

Answering the auditor

The revenue population, proof that it is complete, the auditor's sample matched to it, and every sampled POB recalculated, in one PBC workbook.

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

What the example shows

487 extract lines cut to a 156-line population that ties to the trial balance, and a 20-item sample recalculated. A second workflow selects a sample yourself, by key items and monetary-unit sampling, with a proof anyone can re-perform.

What you get

  • The ebook: a 77-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (12_Answering_the_Auditor.yxmd, 12b_Sample_Selection.yxmd)
  • Synthetic sample data (5 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 1What the auditor asked for
  2. Chapter 2The four files
  3. Chapter 3From extract to population
  4. Chapter 4Proving the population is complete
  5. Chapter 5Matching the auditor's sample
  6. Chapter 6Recalculating the sampled POBs
  7. Chapter 7One PBC workbook
  8. Chapter 8Reading the result and answering the auditor
  9. Chapter 9Moving it to your system
  10. Chapter 10Selecting the sample yourself
  11. Chapter 11Exercises
  12. Appendix ATool-by-tool settings
  13. Appendix BOutput field dictionary
  14. Appendix CAnswer key

Look inside

Book 12: Answering the auditor table of contents
Contents
Book 12: Answering the auditor first page
First page