The RevRec Canvas
Book 48: Billings to revenue: contract balances, the bridge and the GL tie cover

Home › Reporting and analysis

Book 48 · Alteryx workflows for SAP RAR

Billings to revenue: contract balances, the bridge and the GL tie

The bridge finance asks for. Why billings and revenue differ every month, explained by the contract liability and the contract asset, proved to the cent and tied to the GL.

  • Reporting and analysis
  • Beginner
  • 92 pages
  • Tested workflows and sample data
$39Individual license · Team of five $117
Buy this bookTry the free Book 2 sample

What the example shows

42 contracts in two companies over twelve months, each rolled forward and netted into contract liabilities and contract assets, billings bridged to revenue through both balances, the balances tied to the GL, eight exception rules, and the 10,500.00 that netting by POB would add to both balances. A second workflow builds the bridge for every quarter and the year, and a quarter-end scenario adds four contracts that move the quarters.

What you get

  • The ebook: a 92-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (48_Billings_Bridge.yxmd, 48b_Quarter_Bridge.yxmd)
  • 1 extra scenario 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 1Why billings and revenue differ
  2. Chapter 2Three contracts by hand
  3. Chapter 3The data, and one row per month
  4. Chapter 4Rolling forward and netting
  5. Chapter 5The bridge
  6. Chapter 6Tying to the GL
  7. Chapter 7Eight rules
  8. Chapter 8Netting by POB, and the control
  9. Chapter 9Moving it to your system
  10. Chapter 10Quarters and the year
  11. Chapter 11Four contracts at the quarter end
  12. Chapter 12Exercises
  13. Appendix ATool-by-tool settings
  14. Appendix BOutput field dictionary
  15. Appendix CAnswer key

Look inside

Book 48: Billings to revenue: contract balances, the bridge and the GL tie table of contents
Contents
Book 48: Billings to revenue: contract balances, the bridge and the GL tie first page
First page