Search code examples
phpcsvquickbooks

PHP Class to export data to QuickBooks import format?


Seeing lots of SOAP/RDS stuff, but just want to dump some MySQL data and/or CSV files to IIF/QIF/OFX format and don't want to reinvent the wheel (laziness ensues).


Solution

  • You're not going to see much in the way of IIF/QIF/OFX imports for QuickBooks for good reason: IIF support is deprecated in QuickBooks, and QIF and OFX are not supported at all.

    You can see some additional information here: QuickBooks integration methods

    By far your best bet is to use the QuickBooks SDK and write a simple qbXML importer for yourself, or do the "right thing" and write a full SDK application using the Web Connector to import the data. qbXML is the transaction format supported by Intuit/the SDK, and the Web Connector provides an automated way to communicate with QuickBooks (both import and export of data).

    There is a set of PHP classes here for communicating with QuickBooks: QuickBooks PHP Framework

    Disclaimer: I'm the author of the code above. If you're still looking for IIF imports... get in touch with me as it's something I might be able to help you out with.