Load your RAR postings, the reconciliation keys and a trial balance. The check ties them by company and account, sets aside run-0 postings, cleans leading zeros and duplicate keys, and tells you which accounts still need a look.
CSV exports work, up to about 500 MB each on a computer (about 100 MB on a phone). The sample from Book 2 is loaded so you can see a result first; loading your own file replaces it.
| Company | Account | RAR raw | Run 0 (not posted) | RAR to ledger | General ledger | Difference | Status |
|---|
The steps the Book 2 workflow runs, drawn from the result above. Load your own files and it redraws with your numbers. Tap any icon to see the fields it uses and what happens to the data there.
This check shows which accounts are off. The Alteryx workflow in Book 2 traces every difference to the posting, the key and the run, and you can run it on your own extract every month.