Skip to main content
A
Adam Donaldson
January 11, 2022
Question

Importing VAT via iif files into QB Desktop

  • January 11, 2022
  • 1 reply
  • 0 views

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

Rubielyn_J
Rubielyn_J
January 12, 2022

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!

Terms & ConditionsAccessibility statement