I have a client that is setting up a UK entity with USD functional currency that will need to file UK VAT returns. We really want to use Xero as we have lots of integration and procedures set up for it for another GBP entity, but Xero cannot handle UK VAT + non-GBP functional currency (despite customers asking for it for at least 8 years!). Has anyone come up with a workaround for this scenario? I'm wondering about having two Xero instances, one in USD for all of the records, and another in GBP into which we will simply enter GBP converted totals for the VAT return each quarter (although I guess this might breach MTD rules). Any thoughts/suggestions please?
Replies (7)
Please login or register to join the discussion.
Set it up in Xero as GBP functional currency, then use one of the reporting apps to report in USD. Given you have a connected entity I'm assuming you'll want to report on these entities together so a reporting app will capture both easily.
Lots of choices here, if reporting in Xero doesn't work (see other comments), Spotlight, Fathom and Futrli all good options
Actually you don't need another app to report in USD - as long as you have the multi-currency version of Xero - you can just run the P&L and Balance Sheet in USD using the "more options" dropdown on the reports.
True! I'd forgotten you can do this - it's under the old (blue) reports rather than the new ones
Whether reporting in Xero or using an app the reporting in USD would revert the FX movements you'd see when reporting in GBP