Does anyone know if QuickBooks can import a csv file containing payroll data?

I am working with a programmer that says that I can import a text file containing an employees name, date worked, the amount of hours worked and at what rate and then have it all be computed automatically so that all I need to do is import it into QuickBooks 2009 and it will look just like I entered it manually. The employeeswill be using a web based time clock which is where the data will come from.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

From a CSV file, no you're not able to import and employee data. You can enter some employee data with an .iif file. I would enter one employee by hand with all the fields you want to import filled out. Then go to FILE>Utilities>Export>Lists to iif and select Employee List.

An .iif file is a text (Tab delimited) file which means it can be open by Word or Excel. I suggest Excel as it will be easier to read. You can then see what fields you entered manually exported as those are the ones you imported.

You can go here: to find out more about .iif files and formats. There are also add on apps that will create the file for you, but again I'd do the export first to see if it's worth buying an add on. You can find more add ons at

Other than .iif the only way you can enter any employee data is to some actual programing, and you'd still be limited to what you can import.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Tony GiangrecoCommented:
I agree, We looked into this same type of process a few years ago and were limited to IIF files also.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.