Can I upload my excel doc to quick books VAT returns page?

wtpotter · ‎May 27, 2019

emmam6 · ‎October 04, 2023

Hello Community Users, we just wanted to pop in and add an update to this thread. If you need to file via a spreadsheet you can do that through QuickBooks Online using the bridging software. We have included a help article on how to do that which includes a how to video but we have also added the main steps below.

Go to Taxes, and then select VAT (Take me there).
Select the Returns tab.
Look for the open return and select the ▼ dropdown arrow under the Action column.
Select Submit with a spreadsheet.
Select Browse to open and upload your file.
Select Next.
Using the dropdown, select the sheet with a summary of all 9 boxes.
On your computer, open the spreadsheet and make a note of which cell the final figure for Box 1 is in.
Back in QuickBooks, map your spreadsheet to the 9 boxes. Map the first cell (Box 1) and we’ll do the rest for you.
Select Review return.
When you’re ready submit, select the box to declare that the info is true and complete.
Select Submit to HMRC.
Select Done.

Any questions on this please feel free to add them onto this thread. We'd be happy to help you.

View solution in original post

Kristine Mae · ‎May 27, 2019

Hello there, Wtpotter.

Your VAT return is based on the transactions entered in the system. We're unable to upload an excel or CSV file on the VAT return page.

I've got you a helpful article as a future reference: Submit a VAT return in QuickBooks.

We're just right here for you if you have more questions.

emmam6 · ‎October 04, 2023

Hello Community Users, we just wanted to pop in and add an update to this thread. If you need to file via a spreadsheet you can do that through QuickBooks Online using the bridging software. We have included a help article on how to do that which includes a how to video but we have also added the main steps below.

Go to Taxes, and then select VAT (Take me there).
Select the Returns tab.
Look for the open return and select the ▼ dropdown arrow under the Action column.
Select Submit with a spreadsheet.
Select Browse to open and upload your file.
Select Next.
Using the dropdown, select the sheet with a summary of all 9 boxes.
On your computer, open the spreadsheet and make a note of which cell the final figure for Box 1 is in.
Back in QuickBooks, map your spreadsheet to the 9 boxes. Map the first cell (Box 1) and we’ll do the rest for you.
Select Review return.
When you’re ready submit, select the box to declare that the info is true and complete.
Select Submit to HMRC.
Select Done.

Any questions on this please feel free to add them onto this thread. We'd be happy to help you.

Topics

Training

Community

Resources

Can I upload my excel doc to quick books VAT returns page?