Skip to content

Multi-Currency Accounting

Multi-Currency Accounting controls how Pinkapple ERP records, converts, revalues, and reports transactions in currencies other than the organization's base currency.

Workspace Reference

WorkspaceHow Users Reach ItWhat Users Usually Do There
Currency UsedAdministration -> Financial Setup -> Currency UsedActivate currencies and review base currency state.
Exchange RatesAdministration -> Financial Setup -> Exchange RatesMaintain approved rates by currency pair and effective date.
Back-Office Posting And GL JournalsAccounting -> OperationsPost and review foreign-currency accounting entries.
Financial ReportsAccounting -> Operations -> Financial ReportsReview base-currency statements and foreign-currency exposure where available.
Service WorkspacesLoans, Deposits, Billing, POS, Wallets, Payments, and other operational modulesCapture transactions in permitted currencies and review converted values.

Key Concepts

ConceptMeaning
Base currencyThe main reporting currency used for financial statements.
Transaction currencyThe currency used for a specific transaction.
Exchange rateThe approved rate used to convert a transaction currency into the base currency.
Foreign currency exposureA balance that remains open in a currency different from the base currency.
RevaluationThe period-end process of updating base-currency value for foreign currency balances.

Currency Setup

Administrators should maintain currencies from Financial Setup.

Good setup includes:

  • Enabling only currencies the tenant actually uses.
  • Setting clear currency names and codes.
  • Approving currencies before users post with them.
  • Maintaining denominations where cash handling depends on the currency.

Exchange Rates

Exchange rates determine how foreign currency amounts are translated into the base currency.

Users should maintain rates with:

  • Currency pair.
  • Effective date.
  • Rate.
  • Approval status.
  • Source or note where required by policy.

The system should use the most recent approved rate available for the transaction date. If no valid rate exists, foreign-currency posting may be blocked.

Posting In Foreign Currency

When a user posts in a foreign currency, the transaction keeps both:

  • The original transaction-currency amount.
  • The translated base-currency amount used for base reporting.

Users should confirm the selected currency and rate before posting. A correct amount in the wrong currency is still a serious accounting error.

Revaluation

Foreign currency balances may need revaluation at period end. Revaluation compares the current base-currency carrying value with the value implied by the latest approved rate.

Revaluation may create:

  • Unrealized foreign exchange gain.
  • Unrealized foreign exchange loss.
  • Adjusted base-currency carrying value for the exposed balance.

Finance users should run or review revaluation before closing periods that include material foreign currency exposure.

Realized Gains And Losses

Realized gains or losses occur when a foreign-currency item is settled. For example, a foreign-currency receivable collected at a different rate from the original posting may create a realized exchange gain or loss.

Reporting

Financial statements normally present in the base currency. Operational reports may allow users to filter by transaction currency, base currency, or both.

When reviewing multi-currency reports, users should distinguish:

  • Original currency exposure.
  • Base-currency equivalent.
  • Unrealized revaluation movement.
  • Realized settlement movement.

Good Practice

  • Keep exchange rates current.
  • Approve rates before users post foreign-currency transactions.
  • Revalue material foreign currency balances before period close.
  • Separate realized and unrealized exchange results where finance policy requires it.
  • Review large exchange differences before finalizing reports.

Common Problems

ProblemWhat To Check
Foreign-currency posting is blockedCurrency is not enabled or no approved rate exists for the date.
Converted amount looks wrongExchange rate direction or effective date.
Revaluation is unexpectedly largeOld rate, wrong rate, or incorrect foreign balance.
Statement does not match operational reportOne report is showing base currency while another shows transaction currency.

Pinkapple ERP by Stat Solutions Network