Solved

Filing VAT online - VAT 100 doesn't match taxes Screen, and Taxes Screen doesn't reflect ALL VAT

Forum|Forum|6 years ago
March 29, 2020
1 reply
0 views

Hi There,

I'm moving from Desktop Pro to Online Plus.... Had to do this as you're not supporting Payroll in Desktop after 5th April! 2020.

The VAT screen shows 1 figure,... The VAT100 report shows a figure almost £4K less. When I run a Blaance Sheet as at 29th February, the end of my VAT Period, it matches my Desktop version, but is al;mot £1k more than the Taxes screen.. So I have 3 different figures.

How do I know which one will be filed with HMRC with MTD?

Balance sheet shows £15,372.84-

Taxes Screen shows £14,274,56

VAT100 shows £11,927.18

Vat 100 should show every un-filed transaction up until the closing date for that VAT period

Taxes Screen should show every un-filed transaction up until the closing date for that VAT period. Not sure what it's doing...

Balance sheet shows every un-filed VAT transaction for that VAT period..

Let me know?

Rosco

QuickBooks Online

Best answer by GeorgiaC

Hi RoscoPC,

Thanks for the detail, the figure which shows on the Taxes screen and the figure against Box 5 when selecting 'Prepare return' should be the same figure and is the total amount which is owed or to be reclaimed by HMRC.

If this figure does not match the figures in the VAT 100 report for the given period then the likely cause of this is exceptions. These exceptions are not accounted for in the VAT 100, but the report will show the following message on the footer:

'Transactions in a previous VAT period were changed after filing. Before filing this period''s VAT, check the exception report to confirm that the transactions are correct.'

You can then view the exceptions by running the exception report, which should equal the difference.

There are several reasons why the VAT control account on the balance sheet does may not match the total amount due on the VAT return. These include:

- Previous VAT returns on the system not recorded as paid

- You have transactions which are posting directly to the VAT control account

- You have no exceptions on your current return

- You don't have any transactions dated after the current period

Please get back to us below if you are still unable to resolve the discrepancies. 🙂

Adrian_A

Thanks for the details, Rosco.

The reporting of VAT depends on the date of the transactions and if it's an accrual or cash basis.

For example, if the accounting method of the transaction is accrual and dated March, the filing period would be February.

We'll have to make sure that the transactions were entered in QuickBooks.

I've added these articles that talk about reporting VAT to HMRC:

Just let me know if there's anything else that I can help. I'll always be right here!

RoscoPCAuthor

Both desktop and Online are set as Accrual.

Items that are tax dated before the 29th February, I.E. irrespective of DUE date, and are not filed should be included in the VAT report and the VAT 100 report.

By Simply removing the from date and leaving the to date as 29th February, I would get the right result.

However you have still not explained what will actually be sent to HMRC electronically. Please let me know of the 3 amounts which one will it send?

(I'm thinking currently I will have to resort to using my desktop version for filing VAT and only use Online for Payroll? Not ideal... And means the VAT is not accurate online, not ideal for an accounting system!)