Multi-Account Journal Entry Import from Excel Spreadsheet?
Aaron Lee
alazyguy at gmail.com
Tue Apr 22 14:09:02 EDT 2014
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
>
More information about the gnucash-user
mailing list