Forum Discussion

NolanPopow's avatar
NolanPopow
New Contributor II
3 years ago

Account Reconciliation Tool (RCM) - Discover / Discovery - Is it possible to manually add line items

Hi all,   We've recently implemented RCM and I have one issue I'm trying to figure out. Certain accounting teams want to do reconciliations (for SOX controls) on certain accounts that have always...
Methodology
  • HeatherB_AAS's avatar
    HeatherB_AAS
    3 years ago

    One final option to consider (another workaround). You could create a temporary data source that uses a flat file source and load to the same import step containing the regular balances. Within the flat file, load the $0 balances for just those accounts you need. 

NolanPopow's avatar
NolanPopow
New Contributor II
3 years ago

Hi Heather,

 

That could be a good solution for some, but turning off zero suppression for stage would result in hundreds of new reconciliations that we have never brought in from SAP. 

I did find a helpful workaround from one of our consultants (Michael Malandra from Direct Analytics). We can create a new account group in the RCM manually, then add a 0 balance account to it as the target. This will create a 0$ account reconciliation, then all we have to worry about is if that account ever gets loaded with an ending balance to get rid of the manual account group we setup as a workaround.

Related Content