The RevRec Canvas
Book 27: Revenue by period: MTD, QTD and YTD cover

Home › Close and reconciliation

Book 27 · Alteryx workflows for SAP RAR

Revenue by period: MTD, QTD and YTD

and YTD Month, quarter and year to date from one GL revenue population, tied to the trial balance account by account, with a control on the header join and a list of every reversed document.

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

What the example shows

Three views of one revenue population, reversals flagged, each tied to the trial balance. Second workflow: the same revenue on a 4-4-5 calendar, with a check of the calendar itself.

What you get

  • The ebook: an 81-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (27_Period_Summaries.yxmd, 27b_445_Calendar.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 1Revenue by period
  2. Chapter 2The three files
  3. Chapter 3One population
  4. Chapter 4The headers and the join control
  5. Chapter 5Three views from one population
  6. Chapter 6The trial balance and the ties
  7. Chapter 7Reversals and the cut-off
  8. Chapter 8Moving it to your system
  9. Chapter 9The 4-4-5 view
  10. Chapter 10Exercises
  11. Appendix ATool-by-tool settings
  12. Appendix BOutput field dictionary
  13. Appendix CAnswer key

Look inside

Book 27: Revenue by period: MTD, QTD and YTD table of contents
Contents
Book 27: Revenue by period: MTD, QTD and YTD first page
First page