Skip to content
← For small businesses

Enter your idea

For small businesses: Accounting features

Categories

(thinking…)

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.

45 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Hayden Haney shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
submitted  ·  AdminKelly Munro (Community Manager, Xero) responded  · 

Thanks for sharing and supporting here, everyone.

For those that aren't already across, though manual at present you could run the Account Transactions report to manually reconcile against your filed VAT returns.

We appreciate the process could be more automated. Though this isn't something we have immediate change planned around atm, we'll update you here if there's any news.

Show previous admin responses (1)

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • John Allison commented  ·   ·  Report

    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  ·   ·  Report

    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,

  • Sue Smith commented  ·   ·  Report

    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.

  • Sally Farrant commented  ·   ·  Report

    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  ·   ·  Report

    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  ·   ·  Report

    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  ·   ·  Report

    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.

  • Sue Lupton commented  ·   ·  Report

    Date stamp transactions to a VAT return so we know what transactions have been included on any particular VAT return