importing files into GnuCash

[David]

Doug, I have been using CC for about 2 weeks now, having migrated from Q2015. 
I had to experiment for a few days with the export/import process.  I set up
a folder in Documents and named it GnuCash and inside there I made a folder
for the real data.  I made another I call Empty accounts. 

I  Empty_Account.gnucash
<http://gnucash.1415818.n4.nabble.com/file/n4676079/Empty_Account.gnucash>  

You can look at it.  Basically it just sets up your placeholder accounts so
that once you import your accounts it is easy to assign them into the
placeholder account [top level account]. 

Use mine or make your own as I do not have Business or Investment accounts. 
Once you have it created save it in a folder called Empty because you may
need to use it several times before you are happy with the results, also you
may need to add Placeholder accounts for Investments and Business Accounts. 
Or you can go through the new file process and choose the standard Business
and Investment accounts, and tailor it to your needs and then save it to the
Empty folder for reuse with no data in it.

For the QIF export from Quicken, choose the date range to export, and then
ONLY check Transactions in the list, gnucash will make accounts from that
when it imports because the transactions have the what Q calls accounts like
Checking, Savings etc. and the transactions have all the what Q calls
Categories which gnucash will create Accounts for them  Once imported you
assign these accounts to the placeholder accounts such as Expenses, Income
etc.

To Import in gnucash, open the Empty file first, then File > Save as [I
saved to Documents > GnuCash > DavidAnn folder with a file name the same. 

Now start the QIF import in gnucash.  I just went through the screens and
did not change anything on any of the screens, just got to the point where
the import was complete.

The first thing I did was go to the Imbalance Account in gnucash and try to
figure out what that was all about.  I feel after several tries to make
adjustments in gnucash, it was easier to go back into Quicken and fix the
problems several at a time.  I would then delete the just created .gnucash
files in the DavidAnn folder, fix things in Quicken, and start the
Export/Import process over. Kept doing that until I got a zero balance in
gnucash in the Imbalance Account, opened it and it was still full of odd
entries that netted to zero.  I then deleted all of them from gnucash.

After that I began assigning the Accounts to the placeholders.  Once done,
here is what i am left with in the Accounts tab of gnucash:

Accounts.png
<http://gnucash.1415818.n4.nabble.com/file/n4676079/Accounts.png>  

There is a Down Arrow on right top of the Accounts tab that performs the
"columns" function of Q.  I chose to un-check the Description column and
just Check the Placeholder column.  That made it a lot easier to assign
accounts to these Placeholders.

Hope that helps a little.



--
View this message in context: http://gnucash.1415818.n4.nabble.com/importing-files-into-GnuCash-tp4676014p4676079.html
Sent from the GnuCash - User mailing list archive at Nabble.com.