VAT late claims report
Hi,
Something that would be very helpful as an accountant, is the ability to run a report for a given date which shows all the transactions where the VAT was claimed/paid on a later return. I know that the VAT reconciliation report doesn't work with MTD.
Happy to discuss to help with this.
Hi everyone, we appreciate why you’d like a report that provides visibility of VAT late claims to streamline your reconciliation processes, especially around year-end and for monthly VAT returns.
Currently, it's possible to use the Account Transactions report to manually reconcile against filed VAT returns, although we get the desire for a more automated solution.
This isn’t on the team’s roadmap at present, however this is something we'll continue to consider how we accommodate these needs in future planning for tax reports in Xero. I'll be sure to let you know if there is any movement to share, here.
-
Jennifer Cardno
commented
It would be really useful to have a Late claims VAT report. This would really help for reconciling the VAT at the year-end - a report showing any Late VAT claims at the year-end date. At the moment, we have to manually go through the VAT returns to identify any late claims.
-
Elsa Passagne
commented
Hello,
VAT on services is claimable up to 6 months before the day of registration, would it be possible to have a special VAT code for it or find a way to include it on the first VAT return? -
John Allison
commented
Is there any chance Xero are re-considering adding this feature? It is unnecessarily time-consuming at the moment - particularly with clients on monthly VAT returns
-
Monique Wolvekamp
commented
You can see from the comments below that this is really and very unpractical way and time consuming at best. Moreover I believe at least the transaction report should have a filter of entry date so we can set the date to after the date of filling. In all fairness I love Xero but this is really doing my head in and is a sure disadvantage to any accounting software out there,
-
Judy Diamond
commented
would like to see a marker on each bill or sales invoice that you go into, to show whether it already appears on a vat return that has been finalised
-
Judy Diamond
commented
Having to run the Account Transactions report to compare with the Transactions by VAT box tab of your VAT return is very long winded. We need this kind of info all the time eg when we do a movemybooks conversion. all other systems seem to have it.
-
Sue Smith
commented
Hi,
I am also finding the late claims report for VAT very difficult to go through. As i use tracking categories - all my amendments outside the current quarter run back through the late claims. So i have a difference but cannot easily get to where the differences are. It would be good if Xero would say split out late claims from adjustments - that do not affect VAT and the transactions that you are claiming which is what is making the difference. checking this through would be so much easier.
-
Jo Brown
commented
To show VAT Period Claim on individual transactions so that you are able to trace back to the correct VAT returns
-
Richard Millington
commented
Currently, to find any transactions not included in a VAT return it's a case of comparing two reports which depending on the amount of transactions can take a lot of time.
Could a filter be added into reports so you can clearly see this information quickly and then action any corrections (if needed)?
Software like sage and VT clearly show a reconciliation mark to show it's been included so seeing this information takes seconds..
-
Ami Wegrzyn
commented
It would be very helpful to be able to run a VAT transaction report which shows if the transactions were included in a VAT return and if so which return it was claimed. That way when we are completing year end accounts we know which VAT transactions have been included or not included in a VAT return, showing any differences, if any.
-
Sally Farrant
commented
I really need to be able to reconcile the MTD vat with the ledger balance and it's so laborious to do this
-
Diane Mitchell
commented
Good morning
I agree with the above as I do find the reports very limited when reconciling, especially at the year end. It would be beneficial to be able to run a report showing which transactions have been reconciled.
I have a difference between the VAT paid at the year end to the VAT showing on the Trial Balance and other than ticking off every transaction there is no other way to find out where the differences are. -
Matthew Baker
commented
When running a VAT return for a non-uk country you have to run the sales tax report. But this report is driven off of a date range only and unlike the UK VAT return it doesn't mark as "filed" transactions you have previously reported on so we are missing the late claims functionality of the UK VAT return. Can we have a sales tax report with the ability to bring in late claims to the report so transactions do not go unfiled.
Currently the only option is to run the report for previous periods to check that nothing has changed. -
Lynsey Thomson
commented
Perhaps also to have a column available from the TB transactions which shows what VAT return each item has been on or due to be on if VAT return not run. I think both this and the Late VAT claims report would be a great help.
-
Nikki Goodwin
commented
A report showing a summary of transactions not yet included in a VAT return, particularily for late claims
-
Sue Lupton
commented
Date stamp transactions to a VAT return so we know what transactions have been included on any particular VAT return