Multi-Account Journal Entry Import from Excel Spreadsheet?

[Derek Atkins]

Hi,

Aaron Lee <alazyguy at gmail.com> writes:

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

This page of the dialog is saying "all the transaction in this file are
for Account "C:\Users\alazguy\Desktop\testest" -- you probably want to
change that to something more reasonable.  Note that this is a
QIFAccount name, not a GNC Account.  Later on in the import process
there is a page to map QIFAccounts to GNC (Asset/Liability) Accounts.
There's also a place to map QIFCategories to GNC (Income/Expense)
Accounts.

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

You probably don't want to make the "account" number the payee.

Apparently there is no way to set QIFCategory of QIFAccount via the
macro, so you may need to process the file by hand.  But putting an
account name as the Payee is *probably* wrong.  The Payee is generally,
well, the Payee!  The person or company to whom (or from whom) the money
went (came).

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

-derek

> 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
>

-- 
       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