Chapter 7 of 8Page 2 of 6

Advanced

Multi-currency

Pay participants commission in their own currency with dated rate rules, frozen exchange rate snapshots, measure currency rules and FX adjustments.

updated: applies-to: 1.1.2.0

This page applies to version 1.1.2.0; the current product version is 1.2.0.0.

Bitta Commission calculates and posts commission in company local currency (LCY). The Multi-currency module adds what international teams need: foreign-currency sources measured through dated rate rules, settlement lines paid in the participant's own currency, frozen exchange rate snapshots as evidence, and FX adjustments for realized, unrealized and rounding differences. This page shows you how to configure Commission Currency Setup, settle in a participant's currency and record the FX effects.

Before you start

  • Switch on Multi-currency in Commission Feature Management. Switching it on turns on Multi-Currency Enabled and Capture Source Rates. When the company has no currency setup yet, it also sets Settlement Currency Source to Pay Group Then Participant and turns on Classify Correction FX; the rate date rules keep their defaults. See Optional modules.
  • Maintain exchange rates on the standard Currency Exchange Rates page. Snapshots are read from there. A missing rate stops the conversion with BAA-CURRENCY-RATE-MISSING.
  • Set the currency of each foreign-paid participant on the participant version. See Participants.
  • You need finance-wide access. Without it, Commission Currency Setup stops with BAA-FINANCE-SCOPE.

Step 1: Configure Commission Currency Setup

Open Commission Currency Setup.

Commission Currency Setup card with Multi-Currency Enabled, Settlement Currency Source, the Rate dates group and the Evidence group
Step 1: currency setup for participant-currency settlement.
Field What it does
Multi-Currency Enabled Lets settlements convert LCY commission into the participant or pay group currency. When off, a participant whose currency differs from LCY cannot be settled. Turning it on requires the module.
Settlement Currency Source Pay Group Then Participant, Participant Only or Pay Group Only. Pay groups settle only in LCY, so Pay Group Only pays every line in LCY and the other two options use the participant currency.
Reporting Currency Code The currency statements and analysis may show. Blank uses the additional reporting currency of the general ledger, or LCY.
Source Rate Date Rule The date that selects the rate for a foreign source document. Default Source Posting Date. A document's own currency factor is kept when it has one.
Settlement Rate Date Rule The date that converts a settlement line into the payment currency. Default Settlement Cutoff Date.
Payment Rate Date Rule The date used to realize the FX difference of a paid line. Default Payment Date, the actual pay date from the payroll acknowledgement.
Capture Source Rates Freezes a rate snapshot for every foreign-currency source fact at capture, with the calculation rate variance against the exchange rate table.
Calculation Rate Tolerance % Differences between the document factor and the rate table below this percentage record no variance.
Classify Correction FX Separates the rate effect from the commission correction when a correction changes the source currency or rate.

Step 2: Measure foreign-currency sources

A source in LCY is measured as it is. A foreign-currency source is measured only while multi-currency is enabled and an Active measure currency rule exists for its measure. Choose Measure currency rules to open Measure Currency Rules and add a rule per measure.

Measure Currency Rules list with Measure Code, Effective From, Target Currency Role, Rate Date Rule, Use Document Factor and Status
Step 2: how a measure converts foreign-currency sources.
Field What it does
Measure Code The measure the rule applies to.
Effective From, Effective To The source dates the rule covers. Blank Effective To is open-ended.
Target Currency Role, Target Currency Code The currency the measure normalizes to, normally LCY or the processing currency.
Rate Date Rule The source posting date, the source document date or the period end date.
Use Document Factor Uses the source document's currency factor instead of the exchange rate table.
Unit of Measure Code The unit a quantity measure counts after conversion.
Status Only Active rules are used.

Step 3: Settle in the participant's currency

  1. Create and refresh the settlement as usual. Each line of a foreign-currency participant is converted at the settlement rate date through one frozen rate snapshot per settlement and currency. Open Settlement Lines to see the conversion:
    • Payment Currency Code is the currency the participant is paid in. Blank means LCY.
    • Payment Exch. Rate Factor is the frozen factor: payment currency units per one unit of LCY.
    • Payment Rate Date is the date whose rate was used, normally the settlement cutoff.
Settlement Lines of a frozen settlement with Payment Currency Code, Payment Exch. Rate Factor and Payment Rate Date for a foreign-currency participant
Step 3: the frozen conversion on each line.
  1. Freeze and export the settlement. The LCY amounts stay the ledger amounts. The payroll-ready export carries the payment currency, factor, rate date and payment amount of each converted line. See Settle commission and Payroll-ready export.

Step 4: Record FX effects

  1. On the frozen or posted Commission Settlement, use the Foreign exchange actions:

    • Calculate realized FX compares the paid foreign amount at the pay-date rate with the cutoff rate for every foreign-currency payroll line and records rounding, realized FX and the reversal of unrealized FX.
    • Revalue open FX revalues unpaid foreign-currency amounts at a revaluation date on or after the cutoff and records unrealized FX.
    • Create FX proposal creates the accounting proposal that posts the unposted FX adjustments in LCY.
  2. On the FX proposal, choose Validate proposal, Approve proposal and Post to G/L. Set Realized FX Gain Account No. and Realized FX Loss Account No. on Commission Posting Setup first, or the proposal stops with BAA-FX-ACCOUNT. Unrealized FX Gain Account No., Unrealized FX Loss Account No. and FX Rounding Account No. are optional; when blank, those effects post to the realized accounts. See Commission accruals.

Currency corrections

  • Correct payment rate on Settlement Lines records that a frozen foreign-currency line should have used another date's rate. The line is not changed; the difference is recorded as a Settlement Rate Variance with your explanation. The action is available only on a line with a payment currency, and the Currency Correction dialog asks for the Rate Date and an Explanation.
  • Record participant currency change on Commission FX Adjustments opens Currency Correction, which records that a participant's home currency changes on an Effective Date, together with the open eligible balance that will convert into the new currency at the next settlement. The new currency itself is set on the participant version.

FX evidence

  • Commission FX Rate Snapshots lists every frozen rate with its purpose (Source Capture, Measurement, Settlement, Payment, Revaluation or Correction), the rate date and the rule that chose it, the factor, the exchange rate table factor beside it and a Hash status. Capture source rates freezes snapshots for foreign-currency source facts that have none yet.
  • Commission FX Adjustments lists each effect by Adjustment Type: Calculation Rate Variance, Settlement Rate Variance, Realized FX, Unrealized FX, Unrealized FX Reversal, Rounding, Source Revaluation, Currency Change or Commission Correction, with a plain-language explanation and whether it is posted.

NOTE

Commission Multi-Company Consolidation totals each company in its own local currency. Amounts are not converted across companies. See Multi-company setup.

For the current limits of multi-currency, see Known limitations.

What's next

Test plan changes before you publish them: What-if scenarios.

// next step

Ready to try Bitta Commission?