Foreign Bank Revaluation

Summary

How to revalue a foreign currency bank account in Sage 50 Accounts when using the Foreign Trader feature.

Description

Your balance sheet report shows bank account balances as assets. Foreign currency bank accounts fluctuate in value with exchange rates. For example, €5000 equals £3333.33 at 1.5 but £2857.14 at 1.75.

Use the Foreign Bank Revaluation Wizard to recalculate the base currency on your foreign currency bank accounts. This adjusts their value on your balance sheet and posts exchange rate gains or losses to your profit and loss. If you post a transaction before the revaluation date with a different exchange rate, and we'll revalue this transaction too.

Resolution

Foreign bank Revaluation Wizard

  1. From the menu toolbar, select Modules
  2. Hover over Wizards then click Foreign Bank Revaluation.
  3. If prompted to close any open windows, click Yes.
  4. Choose the required currency.
  5. Select the bank accounts you want to revalue.
  6. Select Next. 
  7. Enter the revaluation date and revaluation exchange rate.
  8. Select Next.
     TIP: The revalulation wizard will revalue the balance from the start of your accounts, up to the data you enter here. 

    The exchange rate is the amount of foreign currency that makes up one unit of the base currency. For example, using a base currency of pounds sterling, if a pound is worth 1.2 euros, the exchange rate is 1.2.
    The foreign bank revaluation wizard, step 2.

  9. Click Post to finalise the revaluation.
    The foreign bank revaluation wizard, step 3.

Foreign bank revaluation reversal

  1. Click Bank accounts on the left. 
  2. Double-click on the bank account to open it.
  3. On the left click, Revaluations.
  4. Highlight the revaluation you'd like to reverse and click Show Balances.
  5. The option to click Reverse will now show and once you click Reverse, the valuation will disappear.
  6. Click Save.
Image

Foreign bank revaluation postings

See our Foreign Bank revaluation postings article for more information on what posts when you run this process. 

Upgrade your licence

Growing business? Add more companies, users, or employees to your licence with ease. Leave your details and we’ll be in touch.

Image

Solution Properties

Solution ID
200427112218186
Last Modified Date
Fri Jul 11 13:53:14 UTC 2025
Attributes
Product Details
Modules: Bank feeds
Modules: Foreign Currency
Views
0