Solved

quickbooks, the hellish task of converting csv files

Posted on 2009-04-03
1
1,259 Views
Last Modified: 2012-05-06
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              
                ?MCC=4121                     121042882DA90"

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.
0
Comment
Question by:ITn00b
1 Comment
 

Accepted Solution

by:
ITn00b earned 0 total points
ID: 24080106
I've determined after much research and experimentation I've determined that this is simply a place where no one should tread. It's astonishing to me, but that's how it is.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Hi, I've just fixed a problem with Sage 50 Accounts 2010 crashing when creating a new Company.  I've spent nearly 4 hours on it including three calls to the Sage helpdesk (they didn't work it out in the end - I did!) ... so I thought I'd share th…
If you need to import sales transactions from another system into Microsoft Dynamics GP as Sales Order Invoices, you may need to store some additional data related to the customer, the transaction, or the line items.  Even if your company is manuall…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now