Importing Quicken transactions to QuickBooks 2010

1,240 views

I purchased your all converters package today. I am trying to import Quicken transactions in the form of a QIF file which include a 4 digit number as a category and 2 digit number as a class into QuickBooks 2010. The category number from Quicken matches the account number, but not the name, in QuickBooks. The classes are named the same in Quicken and QuickBooks, and classes need to be brought over to QuickBooks.

I've tried using the QIF2QBO converter directly, as well as a two-step process using QIF2CSV then CSVIIF.  No luck.

Can you help, please? I need to do this on a recurring basis, so converting the Quicken file to QuickBooks is useful only the 1st time.  I have attached a small sample of the transactions.  Actual import is a couple thousand lines.

Thank you,

John

asked May 2, 2014 by anonymous

13 Answers

John,

Thank you for sending all details. I'm working on your request today and send you another update shortly.

answered May 2, 2014 by sergiy

John,

Here is a new product for you to try: BANK2IIF

Download it here: http://www.propersoft.net/downloads/BANK2IIF_setup.exe

Please register with your ACCESSALL registration code.

Try to load the QIF file and then on the Account Mapping enter the account NAME for the bank account as you have in Quicken.

QIF Categories will be transformed to the expense accounts.

Please try with small number of transactions first to make sure it works for you as needed.

I will also review QIF2CSV and CSV2IIF to work together.
 

answered May 2, 2014 by sergiy
Sergiy,

Thank you so much for your prompt response. With this new converter, transactions now come into the QuickBooks bank account ok. But the Quicken category/class combination (format xxxx/xx) is being treated by QuickBooks as a unified new account name rather than as a QuickBooks account number and class name. Can that be resolved by adding account number and class name to the IIF account fields? My research into the IIF file parameters indicated that should be possible.

Thanks very much again.

John
answered May 2, 2014 by anonymous
John,

I see what you mean - let me make adjustments and I will get back to you.

answered May 2, 2014 by sergiy
John,

Please try new version (download from below and install over existing version):

http://www.propersoft.net/downloads/BANK2IIF_setup.exe

answered May 2, 2014 by sergiy
Sergiy,

I think that has got it. Have not fully tested, but will get back if any further issue.

Thank you very much.

John
answered May 2, 2014 by anonymous
That's great John.

answered May 2, 2014 by sergiy
Sergiy,

Sorry – but have two more issues. Most critical is that IIF file created from QIF file is not bringing over split line detail. Appears that IIF file is showing entire transaction with the first line category/class only, and ignoring other split line details.

Other issue is that memo field is brought over only if not a split line transaction in Quicken.

Please help if you can – again. Thanks for anything you can do with this.

I have attached the sample QIF and IIF files.

John
answered May 2, 2014 by anonymous
John,

Yes, the splits need to be supported. Let me see what I can do and I will get back to you.


answered May 2, 2014 by sergiy
Thanks
answered May 2, 2014 by anonymous
Welcome to Propersoft Q&A, where you can ask questions and receive answers from other members of the community.

Ask conversion expert:

I have:

I need to convert to or import into: