The RevRec Canvas
Book 25: Contract costs: capitalizing commissions cover

Home › Contracts and obligations

Book 25 · Alteryx workflows for SAP RAR

Contract costs: capitalizing commissions

From the deferred revenue waterfall to the commission asset: a term for every POB, the one-year practical expedient applied at exactly twelve months, straight-line amortization to the cut-off, a control that proves every POB landed in one bucket, and a tie to the GL that says which POB the ledger got wrong.

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

What the example shows

Commission assets by POB with the one-year expedient. One 12-month POB was capitalized by mistake. Second workflow: an impairment test per contract, with the entry.

What you get

  • The ebook: an 87-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (25_Contract_Costs.yxmd, 25b_Impairment_Test.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 1Commissions as an asset
  2. Chapter 2The four input files
  3. Chapter 3The waterfall and the term
  4. Chapter 4Rates and POB types
  5. Chapter 5One bucket per POB
  6. Chapter 6Proving the population
  7. Chapter 7The GL tie and the exceptions
  8. Chapter 8Reading the result
  9. Chapter 9Moving it to your system
  10. Chapter 10Testing the asset for impairment
  11. Chapter 11Exercises
  12. Appendix ATool-by-tool settings
  13. Appendix BOutput field dictionary
  14. Appendix CAnswer key

Look inside

Book 25: Contract costs: capitalizing commissions table of contents
Contents
Book 25: Contract costs: capitalizing commissions first page
First page