There are occasions where the foreign balance of a bank account in Sage 50 Accounts correctly shows zero, but the sterling balance doesn't. This is due to exchange rate variations in the bank account activity. You need to revalue your bank account using the Foreign Bank Revaluation wizard.

Reset the base currency balance

 TIP: If the foreign currency balance is not showing as zero and should be, you need to post a bank payment or bank receipt first in order to bring the balance to zero and then run the Foreign Bank Revaluation as above to zero the base currently balance. 

To set the base currency balance to zero, you can run a Foreign Bank Revaluation to adjust your base currency balance by using an exchange rate of 1.

1. On the menu bar click Modules, then click Wizards.
2. Click Foreign Bank Revaluation.
3. Click your foreign bank account, then click Next.
4. Click Exchange Rate and enter 1, then click Next.
5. Confirm the new Sterling balance is zero then click post. 
6. If you are prompted to update your Exchange Rates click No.

The base balance of this bank now shows as zero.

[BCB:259:UKI - Personal content block - Anth:ECB]