What the example shows
2,660 postings tied to the trial balance. Leading zeros, duplicate keys and run-0 postings cause the gaps. Two workflows and three datasets: a messy close, a second currency, and a tie-out by period.
What you get
- The ebook: a 67-page PDF that walks through the workflow tool by tool
- 2 tested Alteryx workflows (02_Tying_RAR_to_the_GL.yxmd, 02b_Open_Items_by_Period.yxmd)
- 2 extra scenarios 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
- Chapter 1Two ledgers that should agree
- Chapter 2The three files
- Chapter 3The RAR side
- Chapter 4The ledger side
- Chapter 5The comparison
- Chapter 6Reading the result
- Chapter 7Clearing what is left
- Chapter 8Moving it to your system
- Chapter 9What the tie-out cannot see on its own
- Chapter 10A messy close and a second currency
- Chapter 11Period by period
- Chapter 12Exercises
- Appendix ATool-by-tool settings
- Appendix BOutput field dictionary
- Appendix CAnswer key
Look inside


