Skip to main content
J
jayemmee
June 15, 2020
Solved

Looking for UK sample IIF Invoice files

  • June 15, 2020
  • 1 reply
  • 0 views

I am using QB Desktop Pro 2020 and am trying to import Invoices (and Bills) from spreadsheets.

I suspect it will have to be an IIF file so I downloaded the IIF_Import_Kit zip file but these example files are all dated 2005/6 and contain sales tax not VAT

Can anyone please point me to a sample IIF file for UK invoices and bills with VAT  

Best answer by jayemmee
@Ashleigh1 wrote:

Hello jayemmee, 

 

Welcome to the Community page, 

 

 

This is not something that is supported anymore by Quickbooks and you cant convert a .xls file to a .iff file either. 

 

 

 

 

Hi @Ashleigh1 

 

My QB still allows me to import IIF files and if I remember correctly (I used them a long time ago - I first started using QB back in 1998 when I lived in the USA), an IIF file is just a tab-separated text file with a very specific format 

Excel can save files as tab-separated so I should be able to edit IIF files in Excel,  if I had the right file structure.


In the absence of any UK samples being provided - I used the age old method of trial and error and managed to simplify the sample IIF file in the kit enough to get it working for importing UK invoices with or without VAT.

1 reply

Fiat Lux - ASIA
Fiat Lux - ASIA
June 15, 2020

If you are not familiar with IIF, utilize the trial period of these importer tools

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

The template should be like this:

Invoice

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    Y#########Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonCabinets10Cabinets1000              Non
Anne's Bakery01/09/2020100    Y#########Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonHardware10Hardware50              Non
John's Barber Shope02/09/2020101    Y#########John's Barber Shope1 Main Street  AnytownNY12345USAJohn's Barber Shope1 Main Street  AnytownNY12345USA(999) 888-8888          NonBlueprints1Blueprints500              

Non

 

 

 

Bill

VendorTransaction DateRefNumberBill DueTermsMemoAddress Line1Address Line2Address Line3Address Line4Address CityAddress StateAddress PostalCodeAddress CountryVendor Acct NoExpenses AccountExpenses AmountExpenses MemoExpenses ClassExpenses CustomerExpenses BillableItems ItemItems QtyItems DescriptionItems CostItems ClassItems CustomerItems BillableUnit of MeasureAP AccountCurrencyExchange Rate
Bell Telephone01/09/202012301/10/2020Net 30Office TelephoneBell Telephone1 Main Street  NewtonNY12345USA Telephone1000Sales Line              
Bell Telephone01/09/202012301/10/2020Net 30Office TelephoneBell Telephone1 Main Street  NewtonNY12345USA Telephone500Service Line              
Ajax Lumber01/09/202040001/10/2020Net 30RepairsAjax Lumber200 Smith Street  AnytownNY11111USA Repairs750Front Door              
J
jayemmeeAuthor
June 15, 2020

Thanks for your prompt reply, unfortunately you appear to have given me examples of spreadsheets (not IIF files) for the US version and not UK with VAT.

 

The the two products

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2


also seem to work with US version QB as again using Sales Tax and not VAT 

Fiat Lux - ASIA
Fiat Lux - ASIA
June 15, 2020

The products support QB Desktop US, UK, CA, and older AU version. The template is not in IIF format, but in XLS. As of 2008, company 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. The workaround is using the following fields:

* Sales Tax Code (set to a valid tax or VAT code) on each line

* Is Tax Included - optional flag to include the tax in the amount on all transaction lines

 

You should explore the trial period of those products. 

Terms & ConditionsAccessibility statement