Data Loaded into Stage

Account Reconciliations requires that at a minimum, Local balances are loaded into Stage. If Account and/or Reporting balances are not loaded, OneStream will automatically translate the Local balances to the respective levels using the FX Rate Type selected within Global Options.

1. Load FX Rates for the current reconciling period using the FX Rate Type that was selected within the Account Reconciliation Global Options. For this example, the rates being used are as follows:
   

Note that the rates in the upper right, which are shown in grey, are included for clarification purposes only. OneStream calculates inverse rates.

2. Load Trial Balance data into Stage. Note that balances may be loaded at different levels, for different Source Accounts. The one exception being that Local balances must always be loaded.

3. OneStream will automatically translate the Account and Reporting level balances for Source Accounts loaded that do not load these level balances. Balances that are loaded, will hold and supersede any further translation.

1. 10,000 EUR * 1.00 = 10,000 EUR

2. 10,000 GPB * 1.09 = 10,900 CAD

3. 10,000 EUR * 1.52 = 15,200 CAD

4. Note that the loaded balances remain and that variances exist between translated values, even when the currency types are the same.