Skip to main content
Adaptive Insights
Knowledge @ Adaptive Insights LLC, a Workday company.

Create Weighted-Average Translation Accounts

Explains how to create a general ledger or custom account using the weighted-average translation setting.

Audience: Administrators who manage the model. 

Weighted-Average Translation (WAT) is an account setting for cumulative accounts. A master formula pulls the data from a periodic account into the cumulative account. Weighted-Average Translation then converts the currencies on the delta at the average periodic exchange rate. This provides a weighted-average conversion. Additional settings: Balance Reset and Balance Transfer at Reset provide automated data flows.

In general, use the Weighted-Average Translation setting for cumulative accounts that use periodic account data. See Weighted-Average Translation Walkthrough.

Before You Begin

How You Get There

Compass.png From the nav menu, select Modeling. From the Accounts menu, choose, General Ledger Accounts or Custom Accounts

Required Settings for Weighted-Average Translation

If the Weighted-Average Translation setting is inactive or unavailable, check the following:

  • The account must have no child accounts.
  • Type: Cumulative.
  • Plan By and Actuals By: Delta.
  • Actuals Overlay: Enable actuals.
  • Display As: Currency for custom accounts. This is not editable for general ledger accounts.
  • Master Formula: reference a source account (generally a periodic account with an average exchange rate).
  • Data Entry Type: Standard.

If the account that receives the balance, isn't available in the drop-down, check that it has all the settings and requirements outlined above and these additions:  

  • Master Formula: Enter 0 (zero).
  • Time rollup (for custom accounts only): Value in last time period.
  • Level/Dimension rollup (for custom accounts only): Sum of rolled up values.
  • Weighted-Average Translation: Selected.
  • Reset Balance: Not selected.
  • Transfer Balance on Reset: Not selected.

Create Weighted-Average Translation Accounts

Watch the video (2 m 56 s):

Create a Weighted-Average Translation (WAT) Account
 

From the accounts page:

  1. Select a cumulative account that has no child accounts. 
    Or select the cumulative parent account of the new account and select creatAccount.png Create New. Cumulative automatically sets for Type. Don't change it.
  2. In the Account Details section:
    • Planned by and Actuals by: Select Delta for both. If Actuals by is locked, scroll to the Actuals Overlay setting and select Enable actuals to unlock it. 
      This setting applies the exchange rate to the delta, rather than the accumulated, or the periodic total. 
    • Time Rollup: For custom accounts only. If it's a recipient account, choose Value in last time period.
    • Level/Dimension Rollup: For custom accounts only. If it's a recipient account, choose Sum of rolled-up values.

       YTD Account Details.png
  3. In the Data Type section:
    • Display As: For custom accounts, choose Currency. For general ledger accounts, this is a read-only setting.
      This displays the value as a number in each rollup level's currency.
       
    • Master Formula: Enter a formula that references the periodic account. 
      The formula populates the account values with the other accounts' data, rather than data entry. If it's a recipient account for weighted-average balance transfers, enter zero. The formula adds zero to the initial balances entered on the related sheet and accumulates the transfers received.  
       
    • Weighted-Average Translation: Select the checkbox.
      This setting converts the delta by the selected exchange rate before accumulating it. This method keeps the exchange rate affect aligned with the periodic account's data. 
       
    • Reset Balance (optional and available if you select Weighted-Average Translation): Select the checkbox and select the time interval. Available intervals are based on your model's calendar setup. Options generally include Month, Quarter, Year. Don't select this checkbox for recipient accounts.                                                                              This setting lets the account accumulate and reset to zero.  
       
    • Transfer Balance at Reset (optional and available if you select Reset Balance): Select the checkbox and choose the account that receives the balance.
      This setting transfers the account balance to the selected account.
       
    • Exchange Rate Type: To avoid currency conversion errors, choose the same exchange rate type of the account you reference in the Master Formula field. If this is a recipient account, choose the same exchange rate as the account that is transferring the balance. In general, choose Avg: Average Monthly or any custom rate that is a periodic average.

      YTD Net  Data Type.png
       
  4. Select adminSaveDetail.png Save.
  • Was this article helpful?