Exporting data sources to QuickBooks

Mar 28, 2006 7 Replies

I run an ecommerce site and would like to be able to write PHP code to export all of our order data into a format that can be imported into QuickBooks 2006. However, I have not been able to find a source to fully explain the QuickBooks file format or any processes surrounding it. Can anyone help me with this and/or point me to a source to read up on this so that I can write our export code?



I have downloaded the SDK, however, what I am really looking for is details on a file format that I could export all of our order invoices to so that QuickBooks can import them. We have thousands of orders and I am trying to move us away from an in-house developed software solution to something more standardized such as QuickBooks but to do that I have to get everything into QuickBooks in as streamlined a way as possible.

Actually, I think what I may be looking for is a way to export to the IIF file format for import into QuickBooks, but I don't know if this file format is outdated.

You definitely need the SDK or a program that uses it (either

formatting link
or
formatting link
The IIF format is limited, not supported by Intuit and (unlike the SDK) can create errors in QB files. Upgrades to the SDK or QB do not break add-ons using the SDK. Intuit and many add-on developers support the SDK at
formatting link

Mike Block - QuickBooks Tax Cut C.P.A. Intuit paid me to make QuickBooks better!

formatting link

IIF works okay, but requires manual importing from within the QB user interface. It is also on the chopping block and me be removed from future versions of QB. You'll probably regret it if you spend time developing an IIF solution.

The SDK allows you to push orders into QB from your application using COM and XML. It has robust error handling.

That is easy. Use your Mac or Linux box as a terminal and run QuickBooks under a remote Windows Terminal Server.

Mike Block - QuickBooks Tax Cut C.P.A. Intuit paid me to make QuickBooks better!

formatting link
formatting link

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required