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

Big Red Consulting - IIF - VAT code

I am using Quickbooks 2010 UK Version and Excel 2010. I am trying to create and import IIF files using Big Red Consulting IIF Transaction Creator Pro. How can we create an IIF file for a bill that has VAT? VAT should appear in the Total VAT box and VAT code should be shown in the Split section. I managed to get the VAT amount shown but VAT code is not appearing. Please see the attachment. 

Solved
Best answer March 04, 2022

Accepted Solutions
Ashleigh1
QuickBooks Team

Big Red Consulting - IIF - VAT code

Hello User04032022, 

 

Welcome to the Community page, 

 

We dont support iif files in Quickbook desktop, you can look at this article here that tells you more and status that we dont support iif files. 

View solution in original post

2 REPLIES 2
Ashleigh1
QuickBooks Team

Big Red Consulting - IIF - VAT code

Hello User04032022, 

 

Welcome to the Community page, 

 

We dont support iif files in Quickbook desktop, you can look at this article here that tells you more and status that we dont support iif files. 

Fiat Lux - ASIA
Level 15

Big Red Consulting - IIF - VAT code

@user04032022 

I am not familiar with the app you are using. Afaik, as of 2008, Intuit dropped support for setting Tax1Total and Tax2Total via the QBSDK. Users that have been using these fields to set GST/PST (Canada) or VAT (UK) will not longer have access to these fields once they upgrade to QuickBooks 2008 or later. Our clients have been using another importer tool and prepare their data in XLS format. The workaround is using the Sales Tax Code field to set the VAT code on each line.

 

CustomerTransaction DateRefNumberPO NumberTermsClassTemplate NameTo Be PrintedShip DateBillTo Line1BillTo Line2BillTo Line3BillTo Line4BillTo CityBillTo StateBillTo PostalCodeBillTo CountryShipTo Line1ShipTo Line2ShipTo Line3ShipTo Line4ShipTo CityShipTo StateShipTo PostalCodeShipTo CountryPhoneFaxEmailContact NameFirst NameLast NameRepDue DateShip MethodCustomer MessageMemoCust. Tax CodeItemQuantityDescriptionPriceIs PendingItem Line ClassService DateFOBCustomer Acct NoSales Tax ItemTo Be E-MailedOtherOther1Other2Unit of MeasureAR AccountCurrencyExchange RateSales Tax Code
Anne's Bakery01/09/2020100    Y15/09/2020Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonCabinets10Cabinets1000              Non
Anne's Bakery01/09/2020100    Y15/09/2020Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonHardware10Hardware50              Non
John's Barber Shope02/09/2020101    Y15/09/2020John's Barber Shope1 Main Street  AnytownNY12345USAJohn's Barber Shope1 Main Street  AnytownNY12345USA(999) 888-8888          NonBlueprints1Blueprints500              Non
Main St Bank03/09/2020102    N16/09/2020Main St Bank1 State Street  AnytownNY12345USAMain St Bank1 State Street  AnytownNY12345USA(888) 888-8888          NonDoor1Door300              Non

 

Explore this importer tool. If you need other clarifications, you may contact their Support.

https://transactionpro.grsm.io/qbd

 

Need to get in touch?

Contact us