Multi-Account Journal Entry Import from Excel Spreadsheet?

[Aaron Lee]

Hello,

Looks like I'll need to find an excel => QIF converter.

Is there any documentation on what format my data must be in?  Though I
guess that would be dependent on the converter I use.
Can I use account codes, or must I use account names?

Googling for the past few days isn't getting me anything useful.  I wonder
if my google-fu has degraded...

Thanks,


On Tue, Apr 22, 2014 at 7:50 AM, Derek Atkins <warlord at mit.edu> wrote:

> Hi,
>
> Aaron Lee <alazyguy at gmail.com> writes:
>
> > Hello all,
> >
> >
> > I am trying to use GnuCash to account for myself as an individual using
> the
> > accrual method of accounting.
> > I was hoping to be able to import a multi-account journal entry made in
> an
> > excel spreadsheet directly into GnuCash.
> >
> >
> > Unfortunately, I am having trouble doing this with csv import.
>
> That's because CSV does not support multi-split transactions.  It only
> supports a basic (single debit, single credit) transaction.
>
> The only importer that supports split transactions is QIF.
>
> > Does anyone have any ideas as to what I can do?  The QIF format does not
> > support multi-accounts, does it?
>
> Yes, it does.
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>        Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>        Member, MIT Student Information Processing Board  (SIPB)
>        URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>        warlord at MIT.EDU                        PGP key available
>