Reports & Analytics

Reading and interpreting the Foreign Balances report

Understand what each column means and how to assess your currency exposure.

Jul 11, 2026

The Foreign Balances report is a key tool for managing currency risk and preparing accurate financial statements. Understanding its structure helps you spot concentrations of exposure and plan for settlement or hedging.

What the report shows

This report lists all outstanding balances (money owed to you and by you) in foreign currencies, along with their current value in your base currency. It does not include settled transactions—only open items that will affect your balance sheet and future cash flows.

Key columns

ColumnMeaning
Contact NameThe customer or vendor responsible for the balance.
CurrencyThe foreign currency in which the balance is held.
Balance in Foreign CurrencyThe amount due or owed in that currency.
Exchange Rate (Report Date)The rate used to convert to base currency at the report date.
Balance in Base CurrencyThe equivalent value in your company's base currency.
Days OutstandingHow long the balance has been unpaid (for aging analysis).
Balance TypeWhether it is a receivable (money owed to you) or payable (money you owe).

How it works in Usystems

  • Balances are recorded in the original foreign currency when the transaction is created.
  • At each report run, the system looks up the current exchange rate and recalculates the base-currency equivalent.
  • The result shows your net position in each currency and each relationship.

Common uses

  • Balance sheet preparation: Identify all foreign-currency items that must be reported.
  • Cash management: Plan currency conversions or settlements based on upcoming due dates and balances.
  • Risk assessment: Spot large balances in volatile currencies that may need hedging.
  • Aging analysis: Combine with "Days Outstanding" to find old, uncollected foreign balances.

Tips for interpretation

  • Watch totals by currency: Sum balances grouped by currency to see your net exposure in each.
  • Compare receivables vs. payables: If you have roughly equal amounts owed to you and by you in the same currency, you have natural hedging.
  • Currency concentration: High balances in a single currency indicate greater exposure to that currency's movements.
  • Settlement timing: If many balances are near their due date, plan for potential currency conversions.

Was this helpful?

More like this