The RevRec Canvas
Book 18: Unbilled revenue and accruals cover

Home › Close and reconciliation

Book 18 · Alteryx workflows for SAP RAR

Unbilled revenue and accruals

Revenue recognized ahead of billing, netted by contract, aged and tied to the GL contract asset, and a review of the manual accruals that should have reversed or count RAR revenue twice.

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

What the example shows

A contract asset that ties to the GL and is still 15.4% overstated by stale and duplicate accruals. A second workflow tests the October contract asset against the invoices of November and December.

What you get

  • The ebook: an 82-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (18_Unbilled_Accruals.yxmd, 18b_Subsequent_Billing.yxmd)
  • Synthetic sample data (4 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 1Unbilled revenue at the close
  2. Chapter 2The three files
  3. Chapter 3The contract position and its age
  4. Chapter 4Accruals and their reversals
  5. Chapter 5Looking each accrual up in RAR
  6. Chapter 6The GL and the reconciliation
  7. Chapter 7Reading the result
  8. Chapter 8Moving it to your system
  9. Chapter 9Was it billed?
  10. Chapter 10Exercises
  11. Appendix ATool-by-tool settings
  12. Appendix BOutput field dictionary
  13. Appendix CAnswer key

Look inside

Book 18: Unbilled revenue and accruals table of contents
Contents
Book 18: Unbilled revenue and accruals first page
First page