12-10-2021 07:40 PM
My background is with HFM and BlackLine, so I am still learning the ropes with OneStream. Does the Account Recs module allow for ledger to OneStream reconciliations? I'd really like to manage our ledger reconciliation process in OneStream if possible. My vision would be to take the ledger extract, load it into OneStream and then take a OneStream Extract and the two should net to zero. Has anyone implemented a similar process?
12-11-2021 10:01 AM
Yes, you can do source G/L account reconciliations.
The solution sources the same Trial Balance loaded into your Actual scenario pulling the source account data from the Stage table.
As a result there is no potential for imbalance between the ending balance in any given account and the Account Reconciliations tool. In fact, if the Actual scenario is reloaded during the close process will flag any individual source accounts that have changed will be flagged in Account Reconciliations.
12-14-2021 04:57 AM
I think Account Reconciliation is an overkill for what you're trying to do. I assume you just want to check if your onestream extract is matching to the GL balances, ie., not missing any transactions. If this is the case we do a similar process on a daily scheduled basis and this is what we do: