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

Importing VAT via iif files into QB Desktop

Can anyone help. I have simple bills (UK) with total amount, VAT and net amount. So far the only way that I've worked out how to bring the VAT amount into QB Desktop via the iif file is to have the total amount in the TRNS line and then two line items (SPL) - one with the net amount and the other with the VAT.....then import into QB Desktop and manually adjust the VAT code for the SPL with the net amount so that the VAT is automatically calculated, and then delete the second line item in QB that has the VAT code. This feels tortuous....the client will move to QB online in a few months but does anyone know an easier way to import total amount, net amount and VAT for a bill?

Thanks

Adam

1 REPLY 1
Rubielyn_J
QuickBooks Team

Importing VAT via iif files into QB Desktop

Hello there, @Adam Donaldson

 

In QuickBooks Desktop, you can import vendor bills using IIF files. 

 

Now, if you wish to import the total amount, net amount, and VAT for a bill, you can continue doing what you have been doing. This is the only option to complete the task that you want.

 

Otherwise, you can check for other third-party apps to help you with importing bills. To look for an importing tool using Desktop, click on this link: QuickBooks third-party apps.

 

In addition to that, let me share these articles to help export and import data in QuickBooks:

 

 

Fill me in if you have other questions about importing bills in QuickBooks. I'll be happy to help you. Stay safe and have a good day!

Need to get in touch?

Contact us