Xero Expenses - VAT on mileage claims through expenses
Many are complaining about no VAT option on mileage claims through expenses. I can see why this would be timely to implicate as the fuel element changes and is different depending on fuel type and engine size.
But think for those that want to, we should at least have a VAT drop down. We could then create a new tax rate for each rate or even employee using expenses.
For example I have a director with a vehicle >2000cc Diesel I believe using the HMRC company car fuel rates this equates to 19p inclusive of VAT. Using the 45p for the first 10,000 miles the VAT is 3.1667p per mile. So I have created a code '7103 Mileage RK 45p' in the chart of accounts and added this to mileage under expenses so that RK knows which code to add to his mileage. Under code '7103 Mileage RK 45p' I have shown a default VAT of 7.037% of the 0.45p to give me the VAT of £3.1667. Obviously we could ask the employees to put in the fuel amount at 20% inclusive and the balance of the 45p at zero but not sure too many employees would do this.
The problem is with doing all this, still no VAT gets posted because there is no drop down for VAT and/or the VAT isn't coming through from the VAT default for the new code I have set up. I can't even adjust VAT via the bill option. Only option via the bill is to void it.
There are so many ways in which XERO could get this to work but to have no options but to make a manual adjustment via the VAT returns or journal seems a little wrong.
Also I have noted that I can't seem to run a nominal and add in columns 'Quantity' and 'unit price' so that I can create an excel download and easily work out the VAT without having to drill down to in to each transaction to see if 45p was used 5p for passengers or 25p. Can we have this added also to nominals? Thanks
Regina Yaldren
shared this idea
Hi everyone, thanks for your continued engagement with this idea. We know this has been a topic of conversation for a while, and we want you to know we've been listening about the challenges of claiming VAT on mileage in Xero Expenses.
We appreciate everyone who's shared their workarounds, like splitting the mileage claim into two separate lines. While we know this isn't an ideal solution, it's great to see how you're helping each other out here.
Your input is invaluable as we continue to evaluate the best way to address this. While we can't provide a specific timeline for a fix, please know that monitoring this is a priority for us. We'll be sure to keep you updated on any progress.
-
Alyson Wildman
commented
The rate claimable is often standard across the whole organisation so should be able to be pre-set. Users do not necessarily know what the claim rate is. Should be able to set a car mileage rate and a cycling mileage rate.