quickbooks, the hellish task of converting csv files
Posted on 2009-04-03
I am trying to import my 2008 banking transactions into quickbooks. This is a pain because wells fargo will only allow me to get this data as a csv file. So I'm using IIF Creator by Big Red Consulting. It's an add-in compatible with excel 2004 for Mac. It works, but I can't figure out what fields in quickbooks I'm supposed to match the wells fargo categories to. It doesn't help that I'm a quickbooks n00b. I've set up QB 2009 for Mac using the consultant company type.
Can anyone help me figure this out? Not even the developer of the add-in was able to help me.
I tried it once and it worked but then quickbooks seems to have imported the information in the wrong places. For example all my bank transactions showed up as jobs with 0.00 due, and accounts payable shows some 3 billion dollars!
These are the wells fargo columns on the csv file:
Category: (like airlines/transportation, auto/gas, groceries)
Posting date: should be date, right?
Location: (san francisco, etc)
Description: This is the bulk of the data, details on the purchase, "CHECK CRD PURCHASE 12/09 YELLOW CAB OF SAN FRAN SAN FRANCISCO CA 446024XXXXXX1240 346840007876064
Payment Method: which wells fargo debit card / credit card was used (NOTE: I can download for each account separately if that is the best way)
As part of the add-in's conversion process, I have to line these columns up with columns in Quickbooks and I can't figure it out.