Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
J
John46
November 30, 2019
Question

Why am I getting false journal entries when submitting VAT spreadsheet?

  • November 30, 2019
  • 1 reply
  • 7 views
No text available

1 reply

J
John46Author
November 30, 2019

The problem appears to be Quickbooks taking the data from the submission spreadsheet (e.g. total sales for the VAT quarter) and adding it to quickbooks as a new sale (or cost) therefore messing up the data by adding spurious journal entries.

 

This also happened last time I tried to submit VAT. It was even worse then, so this is some kind of progress...

MariaSoledadG
MariaSoledadGQuickBooks Team
QuickBooks Team
November 30, 2019

Hi John46,

 

Let's make sure that you're using MTD so you can successfully submit your VAT without any issues. Allow me to share a few information about this.

 

Starting in April 2019, all eligible UK VAT-registered businesses will have to keep their financial records in a digital form and submit their VAT returns using the approved software.

 

If you're still using a spreadsheet with XML files, this is the main reason why it's messing up your data.

 

Please check these articles for more information:

I have this article in case you have other questions about QuickBooks Online (QBO): VAT.

 

Post a comment below if you need anything else. I'll be here to help.

J
John46Author
November 30, 2019

Thanks for your reply. MTD is switched on.

 

The bridging software is designed to allow spreadsheets to be uploaded. It should work without messing up the rest of my data.

 

 

 

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement