cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
rtenergyltd
Level 2

MTD and VAT report

Please help me as I really can't understand what is happening, and if it is correct or not.

 

So I registered for MTD for quarter April-June, I have confirmed all transactions from that period and I can't understand how VAT is calculated in the system. it shows as follows: 

Collected on sales : £3,922.70

PAID ON PURCHASES : -£5,674.69

VAT due  £9,597.390

 

Why it is the sum of those two? shouldn't that be the difference ? How much I have to pay to HMRC?

Solved
Best answer August 07, 2023

Accepted Solutions
GeorgiaC
QuickBooks Team

MTD and VAT report

Hi rtenergyltd, thanks for checking that. In this case, we'd recommend contacting our support team on 0808 234 5337 (8am - 7pm, Mon - Fri, free from UK mobile & landlines) for further assistance. The agents here will be able to set up a secure screen share using our SmartLook software to view your report and help to identify the cause of the negative balance.

View solution in original post

5 REPLIES 5
GeorgiaC
QuickBooks Team

MTD and VAT report

Hi rtenergyltd, thanks for posting on the Community. 

 

The total vat due (Box 5 - Net VAT to pay or reclaim) is the total of Box 3 (Total output tax due) minus Box 4 (VAT reclaimed in the period on purchases and other inputs (including acquisitions in Northern Ireland from EU member states). 

 

As you have a negative amount paid on purchases, this is calculating correctly: (£3,922.70) - (-£5,674.69) =  £9,597.390.

 

A negative amount in box 4 can be caused by exceptions. For example, if you've previously filed an expense transaction in QuickBooks with VAT on, and have later deleted this as it was incorrect. 

 

If you need any further help understanding the figures, get back to us below. :) 

rtenergyltd
Level 2

MTD and VAT report

Thank you for your reply. How can I change from negative to positive the amount from box 4? 

GeorgiaC
QuickBooks Team

MTD and VAT report

Hi rtenergyltd, are there any exceptions showing when preparing your VAT return and if so, are these genuine? If you're unsure, we'd recommend getting your bookkeeper or accountant to review your VAT return with you. 

rtenergyltd
Level 2

MTD and VAT report

Hi Georgia,

 

There is nothing showing on exception report. Have looked for any double entries in expenses  lists in Chart of Accounts. I still get minus on VAT report for spent on purchases. Don't know what type of transfer could be double enter or under what account type it may be.

 

Could you please help with any advise as I don't want to delete something that I actually  need.

 

 

GeorgiaC
QuickBooks Team

MTD and VAT report

Hi rtenergyltd, thanks for checking that. In this case, we'd recommend contacting our support team on 0808 234 5337 (8am - 7pm, Mon - Fri, free from UK mobile & landlines) for further assistance. The agents here will be able to set up a secure screen share using our SmartLook software to view your report and help to identify the cause of the negative balance.

Need to get in touch?

Contact us