Calculatort

How does accounting software convert a foreign invoice, and what creates a realized FX gain or loss?

Be the first to rate this page.

Accounting software books a foreign-currency invoice at the exchange rate on the invoice date, then compares that booked value with the exchange rate on the date it is actually paid; any difference between the two dollar figures is a foreign currency gain or loss, a concept the IRS says taxpayers may need to recognize under Internal Revenue Code Section 988. A EUR5,000 invoice booked at 1.0800 USD per EUR1 and paid later at 1.0650 records a $75.00 realized gain.

What foreign invoice fx gain loss accounting means

The IRS states that a taxpayer may need to recognize foreign currency gain or loss on certain foreign currency transactions, and points to Section 988 of the Internal Revenue Code and its regulations, alongside its general translation rule to use the spot rate prevailing when an item is received, paid, or accrued, rather than one rate applied to the entire life of an invoice. This is a different question from the yearly-average translation this site's own IRS guide describes for income spread evenly through a year; a single invoice booked on one date and paid on another uses two specific spot rates for two specific dates, with the gap between them producing the gain or loss, not one averaged rate covering the whole period.

Invoice amountEUR5,000
Spot rate on invoice date1.0800 USD per EUR1
Booked value$5,400.00
Spot rate on payment date1.0650 USD per EUR1
Realized gain$75.00

How does accounting software convert a foreign invoice, and what creates a realized FX gain or loss?: worked example

A EUR5,000 invoice is booked as a US-dollar payable on the invoice date, when the spot rate is 1.0800 USD per EUR1: 5,000 times 1.0800 is $5,400.00 booked. The invoice is paid 45 days later, when the spot rate has moved to 1.0650: 5,000 times 1.0650 is $5,325.00 actually needed to settle the same EUR5,000 obligation. Because fewer dollars were needed to pay the euro-denominated bill than were originally booked, the business records a $75.00 realized foreign currency gain: $5,400.00 minus $5,325.00.

How to calculate foreign invoice fx gain loss accounting

Booked value = invoice amount in foreign currency times the spot rate on the invoice date. Settlement value = the same foreign-currency amount times the spot rate on the payment date. Realized gain or loss = booked value minus settlement value; a positive result is a gain because fewer dollars were needed to settle the obligation than were originally booked, and a negative result is a loss because more dollars were needed.

Use the relevant inputs with these related Calculatort pages: currency conversion formula guide · IRS yearly-average rate guide · currency conversion tool.

Common mistakes

Do not apply one exchange rate to both the invoice date and the payment date and expect no gain or loss to appear, record the gain or loss against revenue or expense instead of as a separate foreign currency gain or loss line, or assume every accounting package handles the invoice-date-versus-payment-date translation automatically without confirming which spot-rate source it is pulling from and on which date.

Where this calculation stops

This illustrates the mechanics of booking-date versus payment-date translation; it does not determine the invoice's tax character, does not apply functional-currency rules for a business whose books are kept in a currency other than the US dollar, and does not replace Section 988's own regulations or a tax professional's review of a specific transaction.

A second case where the rate moves the other way, producing a loss

A EUR12,000 invoice booked at 1.0500 USD per EUR1 records $12,600.00. If the euro strengthens by the payment date, to 1.0700, settling the same EUR12,000 obligation now costs $12,840.00: 12,000 times 1.0700. Because more dollars were needed to pay the bill than were originally booked, the business records a $240.00 realized foreign currency loss: $12,600.00 minus $12,840.00, a negative result this time rather than the positive gain in the main example.

Checking the loss example by recovering the original invoice amount

To verify the $12,840.00 settlement figure, divide it back by the same 1.0700 payment-date rate: 12,840.00 divided by 1.0700 returns exactly 12,000.00, confirming the euro invoice amount was carried through the settlement calculation correctly. The same check applies to the booked figure: 12,600.00 divided by 1.0500 also returns 12,000.00, so both the booking and settlement legs independently reconstruct the same underlying EUR12,000 obligation, which is what should always be true regardless of which direction the rate moved between the two dates.

Realized gain or loss versus an unrealized, period-end revaluation

If the EUR5,000 invoice from the main example is still unpaid when a reporting period closes, some accounting software revalues the open payable at that closing date's spot rate rather than waiting for actual payment. At an illustrative period-end rate of 1.0700, the EUR5,000 payable is worth $5,350.00, $50.00 below the $5,400.00 booked figure. That $50.00 is an unrealized gain, reported for the closing period but not yet locked in, since the invoice has not actually been paid; only the eventual payment-date rate determines the final realized figure, which the worked example above shows lands at a different number, $75.00, once the invoice is actually settled.

What changes if the accounting software's functional currency is not the US dollar

The worked example above assumes a business whose books are kept in US dollars translating a euro-denominated invoice. A business whose functional currency is itself the euro would book that same invoice at its face value with no translation gain or loss at all, since the invoice and the books already share one currency; the gain or loss in this guide's example exists specifically because the invoice currency and the books' functional currency differ. Confirming which currency a specific set of books is kept in is a precondition for this calculation, not a detail that can be assumed from where a business is located.

A common mistake: netting the gain or loss into the original expense account

Recording the $75.00 gain from the main example as a reduction of whatever expense or cost-of-goods account the original EUR5,000 invoice was coded to, rather than as a separate foreign currency gain or loss line, understates that expense account and can misstate a margin calculation built from it, such as the gross-margin figure this site's own margin guide describes. Keeping the translation gain or loss in its own account preserves both the original expense at its booked dollar value and a clear, separately reviewable record of how much of the year's results came from currency movement rather than from the underlying business transaction itself.

Why the spot-rate source matters as much as the formula

The IRS states it has no official exchange rate and generally accepts any posted exchange rate used consistently, a rule this site's own IRS yearly-average guide covers for income spread through a year and that applies equally here to a single invoice's booking-date and payment-date rates. Accounting software that pulls its spot rate from one data provider for the invoice date and a different provider for the payment date can produce a gain or loss figure that is really measuring a difference between two providers' rate feeds rather than a genuine market movement; using the same rate source consistently for both legs of one invoice keeps the calculated gain or loss attributable to the currency market alone.

Source and verification

The IRS states that a taxpayer may also need to recognize foreign currency gain or loss on certain foreign currency transactions, directing taxpayers to Section 988 of the Internal Revenue Code and its regulations, alongside the general rule to use the spot rate prevailing when an item is received, paid, or accrued. Read the named source. Verify the source date and the controlling statement, agreement, payroll record, or accounting record before relying on the illustrated result.

Enter your values, review the result, then use it with confidence.

Rate this page

Be the first to rate this page.