Quickbooks and Excel

A great combination !

Importing stock parts, with Cost and Sales price – QB2012

I have quickly put together a simplified IIF template for importing stock parts. This is tested with QB2012 UK and is for experimentation only. Some headers may need to be altered for other versions of QB.

You need first to open the IIF template with excel. You must keep the headers as they are (Row 1)  and  change the the following  :-

1)Name of you stock part (in Name Column – col B)

2)Income account associated with item (ACCNT column – col H). This must already have been created in QB

3)Expense account associated with item (COGS – Col J). This must already have been created in QB

4)Price – under PRICE column

5)Cost – under COST column

When you have finished , save  and accept the text  delimited format. This is important.

Then, on the Quickbooks menu, go to File – Utilities – Import – IIF files and browse to the saves IIF template. Please make sure that you close and save the template first.

If you do it correctly, then you could import hundreds of items this way.

Please note that, before experimenting,  you must do a backup.


Stock import IIF file – simplified


June 23rd, 2013 Posted by | IIF imports | no comments

update on BACS tools

I have now written tools to use with the following :-

-Barclay Direct IP

-Albany (formerly ALBACS)

-RBS/Nat West Bankline

I am also working on combining the BACS tools with the Email Remittance Advice tool so that everything is run from within one tool.

For those not familiar with my Remittance Advice tool, it is a utility that generates a bulk list with Amounts, Invoice numbers , etc extracted from a particular payment run. The list can then be emailed automatically without any need to attach pdf Remittance Advices.


June 16th, 2013 Posted by | supplier BACS | no comments