# Sage 300 Foreign Currency Revaluation Calculator

> Source: https://netray.co/tools/sage-300-foreign-currency-revaluation-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Computes unrealized gain or loss at period end and realized gain or loss at settlement for an open foreign-currency AR or AP balance.

## Category

cost-finance

## Erp

Sage 300

## Industry

SMB Manufacturing

## Audience

- Controller
- GL accountant
- Treasury

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Open foreign-currency balance

**Key:** fc

**Type:** number

**Default:** 250000

**Min:** 0

**Step:** 5000

**Unit:** foreign units

#### Balance type

**Key:** kind

**Type:** select

**Default:** 1

**Options:**

##### Receivable (asset)

**Value:** 1

##### Payable (liability)

**Value:** -1

#### Rate at booking (home per foreign unit)

**Key:** orig

**Type:** number

**Default:** 0.78

**Min:** 0

**Step:** 0.0001

**Unit:** rate

#### Rate at period end

**Key:** end

**Type:** slider

**Default:** 0.81

**Min:** 0.6

**Max:** 1

**Step:** 0.005

**Unit:** rate

#### Rate at settlement

**Key:** pay

**Type:** number

**Default:** 0.8

**Min:** 0

**Step:** 0.0001

**Unit:** rate

**Outputs:**

#### Booked home-currency value

**Key:** booked

**Expr:** fc * orig

**Format:** currency

#### Revalued home-currency value

**Key:** reval

**Expr:** fc * end

**Format:** currency

#### Unrealized gain (loss) at period end

**Key:** unreal

**Expr:** kind * (reval - booked)

**Format:** currency

**Primary:** true

**Description:** A rising rate gains on a receivable and loses on a payable.

#### Realized gain (loss) at settlement

**Key:** real

**Expr:** kind * (fc * pay - booked)

**Format:** currency

**Primary:** true

#### Reversal of prior unrealized entry

**Key:** reverse

**Expr:** 0 - unreal

**Format:** currency

**Description:** Most systems reverse the revaluation in the next period before posting the realized result.

**Chart:**

#### Unrealized gain or loss by period-end rate

**Type:** line

**X:** end

**From:** 0.6

**To:** 1

**Steps:** 20

**Series:**

- unreal

**Disclaimer:** Illustrative arithmetic. Follow your accounting policy, the applicable standard and your ERP's revaluation settings for actual postings.

## Content

**Intro:** At every period end, open foreign-currency invoices need to be revalued to the closing rate. This calculator shows the unrealized gain or loss, the realized result when the invoice is finally paid, and the reversal, so you can check what Sage 300 or any ERP posts.

**Sections:**

#### How to use it

**Body:** Enter the open balance in the foreign currency, choose receivable or payable, and give the exchange rate at booking, at period end and at settlement, all quoted as home currency per one foreign unit. The unrealized result is the revalued value minus the booked value, with the sign flipped for payables. The realized result compares settlement value with what was booked.

#### The accounting logic

**Body:** A stronger foreign currency raises the home value of a receivable (a gain) and of a payable (a loss). The period-end revaluation is a non-cash entry usually reversed on the first day of the next period, so that when the invoice is paid the full difference between booking and settlement shows up as realized. The chart sweeps the closing rate so you can see sensitivity.

**Bullets:**

- Use the rate type your policy requires, such as spot or period average.
- Revalue monetary items only; do not revalue inventory or fixed assets.
- Check rate direction when your ERP quotes foreign per home.

#### Common mistakes

**Body:** The most frequent errors are inverted rate direction, revaluing the same invoice twice, and not reversing the prior accrual. When results look wrong, compare one invoice by hand with this calculator before reviewing the whole ledger. Also confirm which gain and loss accounts the ERP uses for realized and unrealized postings.

**Cta:** Netray can build a reconciliation report from your ERP that compares revaluation postings against open items.

**Faq:**

#### What is the difference between realized and unrealized?

**Answer:** Unrealized arises from revaluing open balances at period end and is usually reversed. Realized arises when the invoice is settled and the cash value differs from the booked value.

#### Why does the sign flip for payables?

**Answer:** If you owe foreign currency and it strengthens, you will pay more home currency, which is a loss. The same move produces a gain on a receivable.

#### Which rate should I use at period end?

**Answer:** Use the closing or spot rate your accounting policy specifies for monetary items, taken from the same rate source your ERP uses.

#### Does this replace the ERP routine?

**Answer:** No. It checks the arithmetic of a single balance. The ERP revaluation routine handles many documents, accounts and reversing entries according to its set-up.

## Search terms

sage 300 currency revaluation, unrealized fx gain loss calculator, foreign currency revaluation calculator, realized vs unrealized exchange gain, month end currency revaluation, fx revaluation journal entry

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json