Migration to gnucash

Balazs Gaal balazs at gaal.eu
Tue Jan 3 09:40:52 EST 2017


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?

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)


regards
Balazs Gaal



More information about the gnucash-user mailing list