Can I import a QIF into an existing account?

[Charles Day]

On Sat, Feb 23, 2008 at 5:27 PM, Aaron Whitehouse <lists at whitehouse.org.nz>
wrote:

> https://answers.launchpad.net/ubuntu/+source/gnucash/+question/25474
>
> I have tried to find the answer to this question from Google and
> searching the mailing lists, but I can't see it anywhere.
>
> I used to use MS Money and would download the month's transaction data
> in QIF format. I would then open MS Money and import that month's
> transactions into the Cheque account that I had set up. MS Money would
> then go through, identify possible duplicates, guess which categories
> the expenses were and ask the user to make any necessary changes
> before lumping them into that Cheque account with the rest of the
> transactions.
>
> In Gnucash 2.2.1, it seems that when I import a QIF file, it adds
> itself as a completely new account.
>

Is there any way to import a list of transactions from a QIF file into
> an existing account?
>

Yes. You need to use account, category, and payee/memo mappings to get the
imported transactions to go into the right GnuCash accounts. There are three
steps in the importer that help you do this. The interface isn't the
friendliest at the moment, I'm afraid, but once you've created the mappings,
they'll be saved for future imports so you don't have to go through the
whole process again. I'd suggest that you turn on the QIF documentation
pages to get more help as you go along.. Go into the preferences
(Edit->Preferences), then pick "Online Banking", and make sure "Show
documentation" is checked.

Once you've got that working, the importer will try to find any potential
duplicates and will give you a chance to review them and accept/reject them
individually.

I would also suggest upgrading your GnuCash when you get a chance. Many QIF
importer bugs have been fixed recently.

Cheers,
Charles

Regards,
>
> Aaron
>
> --
> FSF Associate Member: 5632
> http://www.fsf.org
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>