Running the Foreign Balances report

The Foreign Balances report provides a snapshot of all money owed to you and by you in foreign currencies, along with their current values in your base currency. This is essential for understanding your company's currency exposure and for accurate balance sheet reporting.

Before you start

• You must have outstanding invoices, bills, or other balances recorded in foreign currencies.
• The report uses the current exchange rate, so results may change as rates fluctuate.
• Ensure your exchange rates are up to date in the system.

Steps

1. Go to Reports list. Open in Usystems

2. Search for or locate "Foreign Balances" in the available reports.

3. Click on the Foreign Balances report to open it.

4. The report will load with a default date (usually today's date). You can modify the report date, currencies, and apply other filters to narrow your view.

5. Review the balances displayed. The report shows:

   • Each outstanding balance in its original foreign currency
   • The balance's value in your base currency at today's exchange rate
   • Customer or vendor name for easy identification
   • Account or balance type (Receivable, Payable, etc.)

6. If needed, refine the filters and refresh the report to see a different view.

Tips & common mistakes

• Report date matters: The report shows balances as of the date you selected. Change the date to see balances as of a different point in time (e.g., month-end for reporting).
• Watch exchange rates: If rates have changed significantly since your last run, balances will shift even if no new transactions occurred.
• Currency concentration: Look for high balances in a single currency to assess exposure risk.

---