Articles

How is a foreign currency receivable remeasured at month-end, and what does skipping it cost?

A monetary item in a foreign currency is remeasured at the closing rate at every period-end. The entry moves profit between months, not the total, and a controller who skips it misstates both.

A US company invoices €1,000,000 when the euro is worth $1.10 and books a receivable of $1,100,000. At month-end the rate is 1.06, so the receivable must be remeasured to $1,060,000 and a loss of $40,000 goes to the income statement. The customer pays the next month at 1.08, the loss reverses by $20,000, and the realised loss is $20,000. Skipping the month-end entry overstates the month’s result by $40,000, 12.9% of the correct figure.

The assumptions

Illustrative export invoice, functional currency US dollar
ItemValue
Invoice amount€1,000,000
Rate at invoice date (USD per EUR)1.10
Rate at month-end1.06
Rate at settlement, next month1.08
Month-one operating profit before FX$350,000

The receivable is a monetary item, so it is remeasured at the closing rate at every period-end until it is settled, and each difference goes to profit or loss. Interest, discounting and tax are left out.

Step 1: book the invoice at the spot rate

Receivable = foreign amount × spot rate at the transaction date

Excel: =B2*B3

€1,000,000 × 1.10 = $1,100,000. Debit receivable, credit revenue.

Step 2: remeasure at month-end

Unrealised FX result = foreign amount × (closing rate − booking rate)

Excel: =B2*(B4-B3)

€1,000,000 × (1.06 − 1.10) = −$40,000. The receivable falls to $1,060,000; the loss is booked in month one. Revenue stays at $1,100,000, because the sale is recorded at the rate on the day it happened.

Step 3: settle and reverse

Result by month, in US dollars
Month 1Month 2Total
With month-end remeasurement−40,000+20,000−20,000
Without remeasurement0−20,000−20,000
Error in month 1 profit+40,000−40,0000

The customer pays €1,000,000 × 1.08 = $1,080,000. Against the $1,060,000 carried, that is a gain of $20,000 in month two. The full realised loss is $20,000, the same either way. Skipping the entry moves $40,000 of loss out of month one and into month two, so month-one profit is $350,000 instead of the correct $310,000, and month two is $40,000 lower.

What if: the invoice is hedged with a forward at 1.09

With a forward sale of €1,000,000 at 1.09 booked through profit or loss as well, the forward is worth €1,000,000 × (1.09 − 1.06) = $30,000 at month-end. Month one shows −40,000 on the receivable and +30,000 on the forward, a net −10,000. In month two the receivable gains $20,000 and the forward loses $20,000, a net 0. The total is −10,000, which is the gap between the booking rate 1.10 and the forward rate 1.09 on €1,000,000.

The common mistakes

Takeaway

Questions readers ask

How do you remeasure a foreign currency receivable at month-end?

Multiply the foreign amount by the difference between the closing rate and the booking rate. On €1,000,000 booked at 1.10 and closing at 1.06, that is a loss of $40,000 in profit or loss.

Is the month-end FX loss on a receivable real?

It is unrealised until settlement and reverses if the rate recovers. Here the customer pays at 1.08, so $20,000 reverses and the realised loss is $20,000.

What happens to profit if the controller skips the remeasurement?

Month-one profit is overstated by $40,000, 12.9% of the correct $310,000, and month two is understated by the same amount. The total over the two months is unchanged.

The workbooks behind this article

The free companion files for The Financial Controller hold a month-end close with a double-booked accrual and unrecorded freight, the cut-off checklist and a leverage covenant with an add-back cap. The cut-off figures in this article are a separate illustration and are not in them. No account and no email address.

Open the companion files →

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

Reading guide: corporate finance, valuation and markets → · All 1908 articles →