Multi Currency Bank Statement load and Auto reconciliation

Hi, just wondering if anyone has a solution to a problem I am having with Multi-Currency bank statements and exchange gains and losses ? Using 'mostly' delivered functionality, we have created a job which will import a bank statement, auto reconcile and generate the external transactions and associated journals. This allows the user to simply log on each morning into the the book to bank reconciliation page without having to run any prior processes themselves and complete the entire Bank to GL reconciliation on a daily basis for numerous accounts.

The problem I am having is in relation to a multi currency bank account where the base currency is sterling, but the transaction currency can relate to any currency available.  The Bank statement Table and Payment Table only hold transaction currency and do not hold base currency information. So if I make a payment using one exchange rate and the bank actually make a payment in another, although the transactions amount will be the same, the exchange rate at which we are charged by the bank, against the exchange rate we have processed the payment at, are different. Therefore we