The RevRec Canvas
Free tool

Does your RAR tie to the general ledger?

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.

Your files never leave this page. Everything runs in your browser; nothing is uploaded.

1. Load the three files

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.

Check which columns were used

2. Result

CompanyAccountRAR rawRun 0 (not posted)RAR to ledgerGeneral ledgerDifferenceStatus
The table above plus the other entries, ready to open in Excel.

3. How the check got there

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.

Find out why, not just where

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.

  • The full workflow, sample data and an answer key
  • A second currency and a tie-out period by period
  • A control report you can hand to a reviewer