The RevRec Canvas
Book 34: Preparing reconciliation uploads cover

Home › Reporting and analysis

Book 34 · Alteryx workflows for SAP RAR

Preparing reconciliation uploads

One period's manual journals on the contract-liability accounts, enriched with product and customer attributes, written in the exact layout an account-reconciliation tool imports, and proved equal to the GL, account by account.

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

What the example shows

One period’s GL postings turned into a clean reconciliation upload that ties by account. A second workflow reads the tool’s import log back: 14 rows rejected, two processed twice, one never arrived.

What you get

  • The ebook: an 85-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (34_Recon_Upload.yxmd, 34b_Import_Check.yxmd)
  • 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 1An upload the reviewer can trust
  2. Chapter 2The six files
  3. Chapter 3Clean and scope
  4. Chapter 4Make every lookup unique
  5. Chapter 5Enrich without losing a line
  6. Chapter 6The upload and its proof
  7. Chapter 7Exceptions and the layout check
  8. Chapter 8Reading the result
  9. Chapter 9Moving it to your system
  10. Chapter 10What the tool did with the file
  11. Chapter 11Exercises
  12. Appendix ATool-by-tool settings
  13. Appendix BOutput field dictionary
  14. Appendix CAnswer key

Look inside

Book 34: Preparing reconciliation uploads table of contents
Contents
Book 34: Preparing reconciliation uploads first page
First page