Platform · financial core

Three currencies, not two

The most common source of restatement we find in multi-currency groups is treating transaction, functional, and reporting currency as two things rather than three. It works for a while, produces an FX line nobody can explain, and eventually produces a prior-period adjustment.

Their QuickBooksas filed
1000 · Cash412,880.14
1200 · Accounts receivable286,401.00
2010 · Accounts payable(94,220.55)
4000 · Revenue(1,842,110.00)
6000 · Operating expense1,237,049.41
Trial balance0.00
erp.io shadow ledgercomputed
1000 · Cash412,880.14
1200 · Accounts receivable286,401.00
2010 · Accounts payable(94,220.55)
4000 · Revenue(1,842,110.00)
6000 · Operating expense1,237,049.41
Trial balance0.00

184 consecutive days tied · variance $0.00

Three currency layersRealised and unrealised separatedCTA posts to equity

What it does

Six things, specifically.

Transaction currency

The currency the invoice or bill was actually issued in, held on the document rather than converted on entry and lost.

Functional currency

The currency the entity operates and keeps its books in. Transactions convert to it at the transaction date rate, and that conversion is what the entity’s statements are built from.

Reporting currency

The group presentation currency, produced by translating each entity’s functional-currency statements — a different operation from transaction conversion and frequently conflated with it.

Realised and unrealised FX

Realised on settlement and unrealised on revaluation, posted to separate accounts rather than netted into one line that nobody can decompose.

Cumulative translation adjustment

Translation difference posting to equity where it belongs rather than being absorbed into an income account, which is the error that produces restatements.

Rate management

Daily, month-end average, and closing rates from a source you configure, with the rate used recorded on the transaction so a figure can be reproduced.

Why two layers is not enough

A company invoices a customer in euros. The entity keeps its books in pounds. The group reports in dollars. Those are three distinct currencies and each conversion between them is a different accounting operation with a different rate convention.

Systems that model only two — transaction and reporting — have to collapse one of those operations, and the collapse usually happens at translation. The symptom is an FX line that grows and cannot be decomposed into realised gains, unrealised revaluation, and translation difference, because those three were never recorded separately.

An FX line nobody can decompose is not an FX problem. It is three different accounting operations that were recorded as one.

The CTA mistake

Cumulative translation adjustment arises from translating an entity’s statements into a different presentation currency, and it belongs in equity. It is not income and it should never touch the income statement.

The error we most commonly find is CTA absorbed into an FX gain or loss account in the income statement, which overstates or understates earnings and is exactly the kind of thing a first audit surfaces. Correcting it retrospectively is a prior-period adjustment, which is why it is worth getting right before scrutiny arrives rather than after.

Recording the rate matters as much as using it

A converted figure that cannot be reproduced is a figure somebody has to trust. Every conversion records the rate used and its source, so a balance from eighteen months ago can be re-derived rather than accepted.

That is also what makes the audit conversation short. The question is always which rate was applied and why, and having it on the transaction answers it without an investigation.

Limits

Where this does not help.

Not hedge accounting

Forward contracts, hedge designation, and effectiveness testing under ASC 815 are a specialist area. We record the instruments; the designation and testing is work for your advisors.

Not local statutory filing

Multi-currency structure is handled. Filing statutory accounts in multiple jurisdictions under local GAAP is two decades of accumulated work we have not done.

It cannot fix historic treatment

Where CTA was previously posted to income, correcting it is a prior-period adjustment your CPA decides on. We will identify it and quantify it rather than silently reclassifying.

Questions

What people ask.

Where do rates come from?
A source you configure, with daily, month-end average, and closing rates held separately. The rate applied is recorded on the transaction so any figure can be reproduced.
How is unrealised FX handled?
Foreign-currency balances are revalued at period end with unrealised gain or loss posted to its own account, separate from realised gains on settlement.
Does CTA go to equity?
Yes, which is where it belongs. Posting it to an income account is the most common error we find and it is what produces prior-period adjustments at a first audit.
Can entities have different functional currencies?
Yes — that is the normal case in a group. Each entity keeps its books in its functional currency and translates to the group reporting currency.
Do you support hedge accounting?
We record the instruments. Hedge designation and effectiveness testing under ASC 815 is specialist work for your advisors and we do not automate it.

Find out where the FX line came from.

Tell us the entities and currencies and we will tell you where the treatment most often goes wrong.