# SAP Foreign Currency Valuation Worksheet

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

## Short answer

Open item list with historic and closing exchange rates that calculates unrealized gain or loss, for checking an FAGL_FCV valuation run.

## Category

sap

## Erp

SAP ECC / S/4HANA

## Audience

- General ledger accountant
- Treasury analyst
- SAP FICO consultant

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Document number

**Key:** doc

**Type:** text

#### Customer or vendor

**Key:** partner

**Type:** text

#### Item type

**Key:** type

**Type:** select

**Options:**

- Receivable
- Payable
- Bank
- Loan

#### Currency

**Key:** fccy

**Type:** select

**Options:**

- EUR
- GBP
- INR
- CNY
- ZAR
- JPY

#### Amount in foreign currency

**Key:** fc

**Type:** number

#### Posting rate (to local)

**Key:** hist

**Type:** number

#### Closing rate (to local)

**Key:** close

**Type:** number

#### Local value at posting

**Key:** lc_hist

**Type:** number

**Expr:** fc * hist

**Format:** currency

#### Local value at closing

**Key:** lc_close

**Type:** number

**Expr:** fc * close

**Format:** currency

#### Unrealized gain or loss

**Key:** unreal

**Type:** number

**Expr:** lc_close - lc_hist

**Format:** currency

**Rows:**

**Doc:** 1800004512

**Partner:** Rheinmetall Supply GmbH

**Type:** Receivable

**Fccy:** EUR

**Fc:** 120000

**Hist:** 1.085

**Close:** 1.072

**Doc:** 1900007730

**Partner:** Pune Forgings Pvt

**Type:** Payable

**Fccy:** INR

**Fc:** 4500000

**Hist:** 0.012

**Close:** 0.0119

**Doc:** 1800004600

**Partner:** Midlands Aero Ltd

**Type:** Receivable

**Fccy:** GBP

**Fc:** 64000

**Hist:** 1.27

**Close:** 1.295

**Doc:** 1900007811

**Partner:** Shenzhen Boards Co

**Type:** Payable

**Fccy:** CNY

**Fc:** 880000

**Hist:** 0.1385

**Close:** 0.1372

**Doc:** 0100000091

**Partner:** EUR bank account

**Type:** Bank

**Fccy:** EUR

**Fc:** 55000

**Hist:** 1.08

**Close:** 1.072

**Totals:**

#### Total at posting rates

**Key:** lc_hist

**Agg:** sum

**Format:** currency

#### Total at closing rates

**Key:** lc_close

**Agg:** sum

**Format:** currency

#### Net revaluation difference

**Key:** unreal

**Agg:** sum

**Format:** currency

**Notes:** The last column is the change in local value. For assets (receivables, bank) a positive number is a gain. For liabilities (payables, loans) a positive number is a loss, because the debt grew, so interpret the sign by item type. Enter rates as local currency per one unit of foreign currency. SAP valuation uses the rate type and date set in the valuation method, check these in FAGL_FCV.

## Content

**Intro:** At month end open foreign currency items are revalued at the closing rate and the difference is posted as an unrealized gain or loss. This worksheet recomputes that difference line by line, so you can check a valuation run or prepare a manual journal.

**Sections:**

#### How to use the worksheet

**Body:** Enter or paste your open items: the foreign amount, the rate at posting and the rate at the closing date, both quoted as local currency per unit of foreign currency. The sheet computes the local value then and now, and the difference. Export to Excel and compare it with the output of your valuation run by account. Differences point to a rate type mismatch, a missing rate, or items that were cleared after your extract date.

#### Sign conventions that confuse everyone

**Body:** The arithmetic is the same for every item: closing local value less posting local value. The meaning differs. A receivable worth more in local currency is a gain. A payable worth more in local currency is a loss, since you owe more. Net the two sides to see exposure. A natural hedge, where a euro receivable offsets a euro payable, shows a small net result even when each side is large.

#### How SAP valuation works

**Body:** The valuation run, FAGL_FCV in new general ledger and F.05 in the classic ledger, picks open items and balances, applies a valuation method with an exchange rate type and key date, and posts adjustment entries. These are normally reversed at the start of the next period, with the real exchange difference calculated when the item is cleared. Check that exchange rates for every currency exist for the key date, since a missing rate is the most common cause of an incomplete run.

#### Common mistakes

**Body:** Common mistakes include entering rates inverted, using the average rather than the closing rate where policy says otherwise, revaluing balance sheet items in the wrong currency role, and forgetting bank accounts held in foreign currency. Another is running valuation before all postings are final, so late invoices are not revalued. Rerun, or post a supplementary valuation after late items arrive.

**Cta:** If you want rate checks and valuation comparisons run automatically against your ERP, we can scope a read only validation with you.

**Faq:**

#### Which SAP transaction runs foreign currency valuation?

**Answer:** FAGL_FCV is used with the new general ledger. The older F.05 handles classic valuation of open items and balances. Both use a valuation method set in configuration. Run it in test mode first and review the log.

#### What rate should I use for closing?

**Answer:** Use the rate type and date required by your accounting policy, often the month end spot rate from your treasury rate source. Whatever is chosen should match the exchange rate type set in the SAP valuation method.

#### Why is my result different from the SAP run?

**Answer:** Common reasons are different rate types, a missing rate for a date, items cleared after the extract, partial payments, and valuation areas with different rules. Compare totals by account, then drill into the largest differences.

#### Are these gains realized?

**Answer:** No. They are unrealized revaluation differences on open items. The realized difference is calculated and posted when the item is cleared by payment, at the then current rate.

## Search terms

sap foreign currency valuation worksheet, fagl_fcv check template, fx revaluation excel template, unrealized exchange gain loss calculator, open item revaluation worksheet, month end fx revaluation, sap f.05 valuation check, foreign currency payable revaluation

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