Migration to gnucash

[Derek Atkins]

Hi,

Balazs Gaal <balazs at gaal.eu> writes:

> Hi,
> I am considering to migrate my personal finance administration from a
> simple old tool to gnucash. (Some other options are also evaluated,
> but thus far gnucash functionality seems to be the best fit)
> The old system is based on double entry bookkeeping and in spite of
> its simplicity it provides a lot of functionality. Why I am to step
> forward is that it is lacking multi-currency support and handling of
> investments is quite awkward.
> When migrating to gnucash I can choose between two strategies
> a) I move the closing balances only and load them as starting balances or,
> b) I migrate all the transactions from the very beginning.
> I would prefer to proceed according to strategy b) because in such a
> manner I would have the complete history in one tool. The problem is,
> however, that I haven't found any option in gnucash which would
> support the automatic import of batch transaction (tens of thousands
> of transactions). Or did I miss something?
>
> So, my question is: Is there any tool to import a batch of
> transactions into gnucach completely automatically?

It depends on your definition of "completely automatically".  All
GnuCash importers require some human intervention, if for no other
reason than to map the "import accounts" to "gnucash accounts".

> The input information is available in an EXCEL table with the headings:
> Date
> Number
> Transaction description
> To account
>>From account
> Reconciliation flag
> Amount
> Comment (if any)
> (or in any format, EXCEL's "save as" function would support, such as
> CSV, XML, etc)

Try Calc2QIF and then use GnuCash's QIF importer?

> regards
> Balazs Gaal

> 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