Help Center / Reporting

Multi-Currency Reporting

What is this page about: Light lets you view reports in each entity's own local currency or translated into a shared group currency. This page explains the two currency options, when to use each one, how Group Crcy translation works, and how FX revaluations handle unrealized gains and losses separately from reporting.

On this page

  • What currency options are available on reports?
  • When should I use Entity Crcy vs. Group Crcy?
  • How does Group Crcy translation work?
  • How do FX revaluations work?

Light stores every transaction in three currency perspectives at once:

  • Transaction currency — the currency the original transaction was recorded in
  • Local (entity) currency — the functional currency of the entity that owns the transaction
  • Group currency — the company's shared base currency, used for cross-entity reporting

When running a report across multiple entities, you choose which of these perspectives to view using the currency selector, found on each individual report. Browse your reports in Light →

What currency options are available on reports?

Light gives every report a currency selector with two options:

Label Description
Entity Crcy Shows each entity's figures in its own functional currency
Group Crcy Shows all entities translated to the company's base (group) currency

The Group Crcy label also shows the group currency code (e.g. "Group Crcy EUR").

Entity Crcy can still be selected for entities with different functional currencies, but Light will flag it. On the General Ledger report, the whole report won't generate — Light shows a full warning instead: "The selected entities use different local currencies. Switch to Group currency, or narrow the selection to entities that share one local currency." On every other report, the mismatch shows as an inline error on the currency selector — "Selected entities have different currencies" — while the rest of the report body still renders. Switch to Group Crcy (or narrow the entity selection) to resolve this and compare across entities.

When should I use Entity Crcy vs. Group Crcy?

Use Entity Crcy when:

  • Reviewing a single entity's performance in its own operating currency
  • Running a report where FX translation isn't relevant

Use Group Crcy when:

  • Comparing multiple entities side by side
  • Running a consolidated report — the Subtotal, Eliminations, and Consolidated columns render in whichever currency you've selected
  • Reporting to group-level stakeholders who work in the base currency

Selecting multiple entities automatically defaults the currency selector to Group Crcy, though you can still switch it manually to Entity Crcy.

How does Group Crcy translation work?

Light does not re-translate balances at report time. The group-currency amount of every line is calculated and stored when the document posts, using the exchange rate in effect at that time. There are no translation rate settings to configure in the report UI — Light simply sums the stored group-currency amounts.

For consolidated reports, all per-entity columns, the Subtotal, and the Consolidated column render in whichever currency is selected — Entity Crcy or Group Crcy.

How do FX revaluations work?

FX revaluation is a period-close task that adjusts unrealized FX gains and losses on open balances — for example, a foreign currency receivable whose value has changed since it was recorded. It's separate from reporting and doesn't run automatically when you view a report.

To run an FX revaluation:

  1. Navigate to Accounting → Accounting periods
  2. Open the period you want to close and open the FX revaluation task
  3. In the task drawer, tick the entities you want to revalue
  4. Click Post revaluation — Light revalues open balances at the period-end closing rate, calculates the gain or loss per line, and generates the revaluation document dated at period end

Light posts FX revaluation entries to the ledger as accounting documents, and they appear in reports once posted.

Was this article helpful?

Book a demo