Formula for Difference
Hi all,
Based on my understanding, the difference header in Reconciliation Summary page is calculated by the below mentioned formula in ARM. Please correct me if I'm wrong:
Account Analysis:
Source System Balance - Explained Balance = Difference
Balance Comparison:
Source System Balance - Subsystem Balance = Difference
Users are requesting a specific setting in the Difference formula in Account Analysis Method - given below:
Source System Beginning Balance + Net Activity - Source System Balance = Difference
The reason for this is - there are some accounts every month whose Net Activity is Zero (basically balance is same for both previous and current month) and when it is Zero, they would like to skip that account to "Explain" the Source System Balance. I've let them know about the Copy Transactions from Prior Reconciliation. But they don't seem to have impressed with that.