Use buy/sell exchange rates instead of mid-rate
Use buy/sell exchange rates instead of mid-rate when generating invoice items from bill items that have been assigned to a customer.
Currently when entering a bill in foreign currency you have ability to assign the expense to a customer.
When generating a corresponding invoice the mid-rate from XE.com is used to convert the bill item FX amount into home currency. The mid-rate is always inherently wrong, as nobody has the ability to buy or sell currency at that rate.
This means that we have to manually find the correct buy exchange rate, do a calculation and then change the amount in the invoice.
We could edit exchange rate but that is more painful and affects accounting as well.
We propose that Xero should use the buy rate for the bill-assign-invoice conversion process. This makes it less likely that our businesses lose money by using incorrect exchange rates.
Hi 👋 your idea is being looked into by our Community team. We'll be in touch soon to update you once your idea has been reviewed.
Did you know you can join our Xero Research panel to be involved in early testing and research? Find out more and sign up through our website 🙂