The RevRec Canvas
Book 43: Aging deferred revenue: FIFO layers, buckets, exceptions and the tie to the ledger cover

Home › Close and reconciliation

Book 43 · Alteryx workflows for SAP RAR

Aging deferred revenue: FIFO layers, buckets, exceptions and the tie to the ledger

Say how old the contract liability is, contract by contract: net each contract, let recognition release the oldest billings first, age what is left from its billing date, find the balances that should have gone, and tie the result to the ledger.

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

What the example shows

55 contracts in two companies netted into contract liabilities and assets, every liability split into FIFO layers by invoice and aged into five buckets. A stopped schedule, an orphan credit memo and a one-invoice ledger difference are found and explained. A second workflow rolls the aging from one month-end to the next, and a messy-month scenario adds four problems to find.

What you get

  • The ebook: a 101-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (43_Deferred_Aging.yxmd, 43b_Aging_Roll.yxmd)
  • 1 extra scenario with their own data and answer keys
  • Synthetic sample data (8 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 1How old is the deferred revenue?
  2. Chapter 2The data
  3. Chapter 3The cut-off and the scope
  4. Chapter 4Billings into invoices
  5. Chapter 5The contract position
  6. Chapter 6FIFO layers
  7. Chapter 7Summary and exceptions
  8. Chapter 8Control, ledger and reading the result
  9. Chapter 9Moving it to your system
  10. Chapter 10The aging roll
  11. Chapter 11A messy month
  12. Chapter 12Exercises
  13. Appendix ATool-by-tool settings
  14. Appendix BOutput field dictionary
  15. Appendix CAnswers to the exercises

Look inside

Book 43: Aging deferred revenue: FIFO layers, buckets, exceptions and the tie to the ledger table of contents
Contents
Book 43: Aging deferred revenue: FIFO layers, buckets, exceptions and the tie to the ledger first page
First page