QuickBooks Transaction Import
November 1, 2007 4:57 PM Subscribe
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?
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?
Best answer: 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
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
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
Response by poster: 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
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
Response by poster: 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
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
This thread is closed to new comments.
posted by ChefQuix at 7:57 PM on November 1, 2007