Page 1 of 1

Revaluing Foreign Currency Suppliers/Customers

Posted: 12 Jul 2010, 14:15
by NeilMacCormick
I have recently upgraded from Sage Instant to Sage 50 2010.
Once of the reasons for doing so was for the foreign currency option.
However, the software appears to only allow me to revalue the foreign currency bank accounts at month-end.
I can't see the option to revalue foreign currency supplier/customer balances at month-end.
It seems obvious to me that the option to revalue foreign supplier/customer balances would be included if available for foreign bank balances!
Does anyone have a solution for this?

Re: Revaluing Foreign Currency Suppliers/Customers

Posted: 22 Jul 2010, 15:56
by NeilMacCormick
The official reply from Sage was that revaluing foreign currency supplier/customer balances at month-end was only available in Sage 200 and above.

The only work around I can think of is to download the outstanding month end foreign values and original sterling amounts, restate the sterling values at the month end rate, then post the cumulative difference into 7906 and into nominal accounts in the balance sheet that net against trade debtors/creditors like 2101. Thereafter adjust every month for the changes in outstanding invoices and exchange rates.