Skip to main content
U
user04032022
March 4, 2022
Solved

Big Red Consulting - IIF - VAT code

  • March 4, 2022
  • 2 replies
  • 0 views

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. 

Best answer by Ashleigh1

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. 

2 replies

A
Ashleigh1Answer
March 4, 2022

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
Fiat Lux - ASIA
March 4, 2022

@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

 

Terms & ConditionsAccessibility statement