Quickbooks and Excel

A great combination !

IIF import – journal example

If you are trying to import transactions  through IIF for the first time, I would recommend the import of a journal as a first step. Intuit provides guidance in the Quickbooks help file and have templates for download.

If we look  at the template provided in the link below, we find a rather complex text file with plenty of column and row headers. The reason it is complex is because the template is designed to cater for all eventualities.

Download Intuit’s typical journal template

If you are a beginner, you might be put off. Therefore I have trimmed to template to basics only. My simplified template can be downloaded from the link  below. It will work on QB UK 2010 and 2012 .

Download my trimmed journal template

Steps are as follows :-

1)Extract zip file and open with excel

2)Substitute the nominal accounts with your own accounts which already exist on your Quickbooks . Make sure the spelling is exactly the same.

3)Put in your figures . Do not forget the minus sign for credit. Total must be nil

4)Save as a text delimited file, keeping the workbook in that format

5)Open Quickbooks and go to File – Utilities – Import – IIF Files and browse to the saved file. If QB cannot see it , change the file type to “all files”

6)Select the file and click ok . The data should be imported in a fraction of a second.

If successful, you can experiment with more rows, etc.


March 19th, 2013 Posted by | IIF imports | no comments

Demystifying IIF imports

Quickbooks’s IIF import feature is one of the utilities which is very often under-used. The reason is due to its apparent complexity. Yet it is a very easy and reliable way to import transactions.

Most users are quite comfortable with importing excel data. However, such excel imports are limited to lists such as stock items, customers information, etc. You cannot import transactions through the excel import feature. You need to use the IIF import when it comes to transactions.

IIF stands for Intuit Interchange Format but it is no more than a text format . In fact it is a delimited text file. It can be created in excel and saved as such. I will elaborate on this in my next post in this category.

March 18th, 2013 Posted by | IIF imports | no comments

Enterprise has finally landed in the UK!

Yes, a UK version was released in 2012. It was  Quickbooks Enterprise version 12 which handles UK VAT.

Now version 13 is out and I have tested it with Windows 8. It works very smoothly and I will add further comments later.

March 17th, 2013 Posted by | quickbooks enterprise | no comments


Welcome to my blog which is aimed at those who like using Quickbooks. I hope to be able to share some tips and encourage others to share their experience. The focus will be on the UK versions but , as Quickbooks is to a large extent universal, there is no reason to exclude other versions.

Please also view my About page by clicking the link at the top right of this page.


March 16th, 2013 Posted by | general | no comments