The RevRec Canvas
Book 1: The RAR rollforward cover

Home › Close and reconciliation

Book 1 · Alteryx workflows for SAP RAR

The RAR rollforward

Contract assets, contract liabilities and remaining performance obligations, built in Alteryx from SAP RAR data.

  • 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

110 contracts netted by contract. Netting by POB would overstate contract assets by 17,114.28. Now with three workflows and three datasets, including a messy quarter with seven planted problems for the controls to catch.

What you get

  • The ebook: a 97-page PDF that walks through the workflow tool by tool
  • 3 tested Alteryx workflows (01_RAR_Rollforward.yxmd, 01b_Next_Quarter.yxmd, 01c_One_Contract.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 1What the rollforward has to prove
  2. Chapter 2Contract balances in plain terms
  3. Chapter 3The three extracts
  4. Chapter 4The position of every obligation
  5. Chapter 5Netting by contract
  6. Chapter 6The rollforward and the migration table
  7. Chapter 7Revenue from the opening liability
  8. Chapter 8Remaining performance obligations
  9. Chapter 9Running it, checking it, and moving it to your system
  10. Chapter 10Proving nothing was left out
  11. Chapter 11Two more quarters: a messy one and a different business
  12. Chapter 12The next quarter
  13. Chapter 13One contract, month by month
  14. Chapter 14Exercises
  15. Appendix ATool-by-tool settings
  16. Appendix BOutput field dictionary
  17. Appendix CAnswer key

Look inside

Book 1: The RAR rollforward table of contents
Contents
Book 1: The RAR rollforward first page
First page