Foreign Currency Invoicing – End-to-End Accounting & GL Impact

Foreign Currency Invoicing – End-to-End Accounting & GL Impact

This document provides a complete, end-to-end explanation of foreign currency invoicing:

• Operational flow from Sales Order to Payment
• Detailed General Ledger (GL) postings at each stage
• Unrealized vs. Realized Foreign Exchange (FX) treatment
• FX Gain and FX Loss Scenarios
• ERP screen-to-GL mapping
• Validation and audit checkpoints

Base Example

End-to-End Foreign Currency Invoicing Example: With Complete General Ledger Impact & Validation

This section presents a single, continuous accounting flow that shows how a foreign currency sale impacts the General Ledger from start to finish. All entries are displayed in general ledger format, and the total debits always equal the total credits.

Transaction Overview

• Customer Invoice: €1,000
• Base Currency Value at Invoice: $1,170
• Inventory Cost: $600

1. Sales Order Creation (Non-Posting Stage)

Process

• Create a Sales Order for an EUR customer
• Set exchange rate (multiplier) on Sales Order header
• Add line items and confirm pricing

Accounting Impact

No GL entry is created

Sales Orders are purely operational documents.

Validation

• Customer currency = EUR
• The exchange rate is visible on the header
• No journal entry generated

2. Shipment & Inventory Accounting (COGS Recognition)

When goods are shipped, inventory is relieved using FIFO cost.

GL Entry – Shipment

Debits = Credits = $600

Key Notes

• Inventory and COGS are always valued in base currency
• The exchange rate has no impact at this stage

Validation

• Inventory reduced by FIFO cost
• COGS increased by the same amount

3. Invoice Posting (Foreign Currency Exposure Begins)

Invoice Details

• Invoice Amount: €1,000
• Exchange Rate: 1.17
• Base Currency Value: $1,170

GL Entry – Invoice Posting

Debits = Credits = $1,170

Key Accounting Principle

• Revenue is fixed at invoice posting
• AR represents the foreign currency exposure

Validation

• AR = Foreign amount × Invoice rate
• Revenue equals AR in base currency

4. Period-End Unrealized FX Revaluation

If payment is not received by period end, AR must be revalued.

Period-End Rate

• Closing Rate: 1 EUR = 1.19 USD

Revaluation Calculation

• Revalued AR: €1,000 × 1.19 = $1,190
• Current AR: $1,170
• Unrealized FX Gain: $20

GL Entry – Unrealized FX Gain

Debits = Credits = $20

Validation

• AR equals foreign balance × closing rate
• FX posted to unrealized account only

5. Reversal of Unrealized FX (Next Period)

At the start of the next accounting period, unrealized FX is reversed automatically.

GL Entry – Unrealized FX Reversal

AR returns to the original invoice value of $1,170.

6. Payment Receipt – FX Loss Scenario

Payment Details

• Payment Received: €1,000
• Exchange Rate: 1.15
• Cash Received: $1,150

FX Calculation

• AR Cleared: $1,170
• Cash Received: $1,150
• FX Loss: $20

GL Entry – Payment with FX Loss

Debits = Credits = $1,170

Validation

• AR cleared to zero
• Cash matches the bank receipt
• FX loss isolated in P&L

7. Payment Receipt – FX Gain Scenario

Payment Details

• Payment Received: €1,000
• Exchange Rate: 1.20
• Cash Received: $1,200

FX Calculation

• AR Cleared: $1,170
• Cash Received: $1,200
• FX Gain: $30

GL Entry – Payment with FX Gain

Debits = Credits = $1,200

Final Ledger (After Full Cycle)

Trial Balance Impact Summary

Total Debits = Total Credits = $2,940

Profitability View (Correct Accounting)

How to Validate Postings in the ERP

Invoice Validation

• AR equals invoice base value
• Revenue equals AR
• Exchange rate matches invoice header

Payment Validation

• AR fully cleared
• Cash posted at the payment rate
• Difference posted to FX Gain/Loss
• Revenue untouched

Inventory Validation

• FIFO cost used
• No currency conversion applied to inventory

8. Versa ERP Screen-to-GL Mapping (Field-Level Guidance & Screenshot Reference)

This section maps Versa ERP screen fields to their accounting impact, aligned with the process described in this document. Screenshot references correspond to the functional areas typically shown in Versa UI (Sales Order, Shipment, Invoice, Revaluation, and Receive Payment screens).

A. Versa Sales Order Screen

Navigation: Sales → Sales Orders → Create / Edit Sales Order

Screenshot Mapping:

• Sales Order Header → Currency & Exchange Rate section
• Line Items Grid → Unit Price shown in foreign currency

Validation: No accounting preview or GL posting available at this stage

B. Versa Shipment / Fulfillment Screen

Navigation: Sales → Shipments → Create Shipment

Screenshot Mapping:

• Shipment Confirmation Screen → Posting Preview
• Inventory Cost sourced from Product → Inventory tab

GL Impact:

• Debit: Cost of Goods Sold
• Credit: Inventory

C. Versa Invoice Screen

Navigation: Sales → Invoices → Create Invoice / Generate from Shipment

Screenshot Mapping:

• Invoice Header → Currency & Exchange Rate section
• Invoice Totals Panel → FCY vs BCY values
• Posting Preview → AR & Revenue lines

D. Versa Period-End Revaluation Screen

Navigation: Accounting → Period-End → Foreign Currency Revaluation

Screenshot Mapping:

• Revaluation Run Screen → AR balances by currency
• Generated Journal Preview → Unrealized FX lines

E. Versa Receive Payment Screen

Navigation: Sales → Invoices → Receive Payment

Screenshot Mapping:

• Receive Payment Screen → Exchange Rate field
• Invoice Application Grid → Applied FCY amount
• Posting Preview → FX Gain/Loss line

9. Full GL Lifecycle Summary

10. Validation & Audit Checklist

✔ Revenue never changes after invoice posting
✔ Inventory is never revalued for FX
✔ Unrealized FX reverses automatically
✔ Only payment creates realized FX
✔ AR always equals foreign balance × active exchange rate

Final Accounting Principle

Foreign currency accounting is an Accounts Receivable valuation problem, not a revenue problem.
ERP systems handle this by:

• Locking revenue at the invoice
• Revaluing AR at period end
• Recognizing FX differences cleanly at payment

This ensures accurate financial reporting, audit compliance, and clear FX visibility.