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.
Thanks for submitting your idea on Xero Product Ideas. We appreciate you taking time to let us know how we could improve Xero for you.
Your feedback will soon be reviewed by our Community team, and in the meantime this can begin to build support with votes from other community members.
If you're interested to see recent releases or get a pulse on what's coming soon see The Long and Short of it. 🙂