5.3.4 Calculate weighted average rates for plug entries

Use the Weighted Rate Calculations task component to calculate weighted average Transfer Rates and Add-On Rates for Balance Reconciliation plug entries.

To match source instrument records with target plug entries by currency, select Currency as an explicit matching dimension.

For functional-balance reconciliation, optionally exclude Currency when the plug entries use the ledger functional currency. The processor considers source records across currencies and converts their balances to the ledger functional currency using the applicable exchange rates before calculating the weighted average rate.

For entered-balance reconciliation, include Currency as a matching dimension when the plug entries use local currency. The processor matches each plug entry only with source records in the same currency.

Weighted Average Rate = Σ(Source Balance × Source Rate) ÷ Σ(Source Balance)

Figure 5-27 Configure weighted rate calculation parameters

Figure 5-28 Select Currency as a matching dimension