I am having a huge problem with this. We process lots of invoices in euros and USD and when the payments come through the bank these are taken at the exchange rate through the bank on the day in GBP. The xe rate that is allocated to the invoice is not matching and therefore I need to find a way of taking off this xe rate to be able to reconcile the invoices without having to do a manual calculation and readjust each invoice individually.
I am having a huge problem with this. We process lots of invoices in euros and USD and when the payments come through the bank these are taken at the exchange rate through the bank on the day in GBP. The xe rate that is allocated to the invoice is not matching and therefore I need to find a way of taking off this xe rate to be able to reconcile the invoices without having to do a manual calculation and readjust each invoice individually.