QuickBooks Transaction Import

November 1, 2007 4:57 PM

I want to import transactions into QuickBooks. Anyone have a template .csv file used to import large numbers of invoices at a time?

We manually enter a large number of invoices into QB each month. The data is spit out of another database, which could easily spit the data into csv files (for import into QB) if we only knew precisely what QB wanted. We're using QBPro 2005 and Excel 2003.

Anyone do this already, and perhaps have some suggestions or templates that could help?

posted by quinoa to computers & internet (6 comments total)

I don't know about a .csv template, but our company uses this QODBC driver to import our invoices into QuickBooks from a MySQL database. It's very slow, and finicky as well, but it does the job. Unfortunately it's not free, however they have a 30 day free trial.
posted by ChefQuix at 7:57 PM on November 1, 2007

http://www.bigredconsulting.com/AboutCreator.htm
posted by joshwa at 7:58 PM on November 1, 2007

http://support.quickbooks.intuit.com/archive/faqs/docs/w_iiffiles2.html

This link is to many, many different template IIF files which I think are exactly what you're looking for. You could probably spit it out as CSVs and just save as an IIF in Excel, I'd think.
posted by crinklebat at 8:00 PM on November 1, 2007

If you have the budget and the time you should think about pushing the data directly into Quickbooks using the QBXML markup. Intuit have a developer network which offers a SDK for doing this.

If your software developers can export to .csv they should be able to see their way to exporting to this format, data parsed through QBXML will create entries in realtime as they are created in the source database.

In my company we use a plugin in FileMaker to format the databse data and push to QB.
posted by clarkie666 at 10:47 PM on November 1, 2007

Thanks, Crinkle. I suspect that's exactly the resource I was looking for. I'd poked around the QB support site and hadn't found it, so thanks for pointing me in the right direction.

After I get a chance to test this out (may be a week or two) I'll come back and let you know if it worked.
posted by quinoa at 8:32 AM on November 5, 2007

Okay, so I got a file from the link crinklebat pointed out. I modified the file appropriately to match our invoice data structure, and I imported it...hooray! However, while I can see the transaction itself, the invoice doesn't show up properly within QB. Not showing on P&L Reports for example.

QB, unfortunately, doesn't support transaction imports.

I tech support how imported transactions are different from manually-entered transactions, and they're unable to offer any support or guidance.

Still stuck!
posted by quinoa at 3:47 PM on November 7, 2007