wehuberconsultingllc.com

wehuberconsultingllc.com random header image

Using VBA to create import files for QuickBooks

January 24th, 2008 · No Comments · QuickBooks, programming

A couple of years ago I created some spreadsheets to help me migrate data into QuickBooks. I set up a worksheet that followed the IIF format and then saved it as a tab delimited file. The biggest problem was that one row of data required three rows in the IIF format. If you try and [...]

[Read more →]

Tags: ··

Importing invoices into QuickBooks using AutoIt Script

October 4th, 2007 · No Comments · QuickBooks

For several years I have successfully used the QuickBooks IIF format to import bills, checks, and employee hours. I have been less successful with invoices and I was unable to import payments. Several times I considered writing a C# or VB program to import the data but I backed off because it looked like it [...]

[Read more →]

Tags: ·