Multi-Account Journal Entry Import from Excel Spreadsheet?

Derek Atkins warlord at MIT.EDU
Tue Apr 22 10:50:16 EDT 2014


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