Multi-Account Journal Entry Import from Excel Spreadsheet?

[Aaron Lee]

Hi Derek,

Thanks for the assistance.  I can't seem to get this working.
http://puu.sh/8jKvB.png

Is there something wrong with my mapping?
http://puu.sh/8jKkZ.png

*Gnu - XL2QIF*
Date - Date
Number - Check Number
Account - Payee
Debit - Debit
Credit - Credit
Description - Memo



On Tue, Apr 22, 2014 at 11:14 AM, Derek Atkins <derek at ihtfp.com> wrote:

>
> On Tue, April 22, 2014 2:09 pm, Aaron Lee wrote:
> > Hello,
> >
> > Looks like I'll need to find an excel => QIF converter.
>
> Cal2QIF?
>
> > 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?
>
> You must use names.  These can match the existing gnucash account names
> (including the hierarchy) -- or you can map the QIFAccount names to the
> GNCAccount names.
>
> > Googling for the past few days isn't getting me anything useful.  I
> wonder
> > if my google-fu has degraded...
> >
> > Thanks,
>
> -derek
>
> --
>        Derek Atkins                 617-623-3745
>        derek at ihtfp.com             www.ihtfp.com
>        Computer and Internet Security Consultant
>
>