How does the Auto Reconciliation Method work with Balance Comparison with Transaction Matching?
Summary:
We have a few reconciliations where we are receiving subledger balance by an integration we created and we want these reconciliations to auto reconcile assuming that the below conditions are met:
- Source and Subsystem balance tie
- 0.00 Unexplained difference
However, because these are Balance compare with TM formats, when the ending balance is systematically populated, we get the difference to be 0.00 but then the adjusted balance is causing an unexplained difference.
Is there a way to fully automate this so that when source and sub system tie, there is no unexplained difference? Like maybe populate the adjustment systematically if source and sub system tie?