Exchange Rate Calculation Wrong

 Hi,

 

I have a credit note which I need to process and refund. It is for $1149 and Sterling value of £887.12. The exchange rate, to the max decimal places Sage allows is, 1.295202 however when I enter that it is setting the base value as £887.11 however when you do this conversion on a calculator you get 887.1203101909972 which is clearly £887.12 to the nearest penny. Therefore when I refund the credit note it is showing the foreign bank account as £887.11 (base value) when it should be £887.12. How can I find out what rate I should use so that Sage will work this out correctly so I can ensure my bank account will balance when I reconcile it?

Thanks