(Another) GnuCash to Beancount converter

39 views
Skip to first unread message

Alen Šiljak

unread,
May 1, 2019, 8:03:06 PM5/1/19
to Beancount
Hi,

Just a quick info about a GnuCash -> Beancount converter I just completed. It can be found here:


along with the Ledger exported, which was adapted from piecash by adding a few parameters for filtering the data.
During the search through the group about some naming rules, I found another converter(s) that may have worked for others but would not handle all the cases I ran into during my book export. This script is using piecash for reading the GnuCash SQLite database.
Exporting to .bean with the script seems to work better than exporting to ledger and then converting to Beancount. I've adapted the script to the point that bean-check and fava report no issues whatsoever with my book.

Now I can (finally) again see a chart with my expenses. I'm a visual type and this helps immensely, compared to just numbers in the total count. I hope I can now move to checking some scenarios. This was not possible as GnuCash -> ledger -> beancount conversion was always resulting in some issues reported by fava/beancount. That probably means I need to double-check some records but I'm suspecting that everything works because Beancount allows multiple commodities in the account and my capital gains records from GnuCash are accepted as-is.

Anyways, just wanted to share the info. The script may be in the early stages but, as mentioned, it converts my book completely.

Martin Blais

unread,
May 1, 2019, 8:35:06 PM5/1/19
to Beancount

--
You received this message because you are subscribed to the Google Groups "Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beancount+...@googlegroups.com.
To post to this group, send email to bean...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/86861d54-53f5-4147-adac-f48a1e0901ff%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Alen Šiljak

unread,
May 1, 2019, 8:50:13 PM5/1/19
to Beancount
Thanks! I have a few more tools that I plan to adapt to Beancount data format(s).
They range from price downloaders, asset allocation, to the mobile app.
Baby steps

I need to check the docs to see how I can implement these as plugins or whatever extension mechanisms are supported. I see that you mention the asset allocation plugin at a few places so perhaps I'll start with that.

Martin Blais

unread,
May 1, 2019, 8:58:25 PM5/1/19
to Beancount
On Wed, May 1, 2019 at 8:50 PM Alen Šiljak <alen....@gmx.com> wrote:
Thanks! I have a few more tools that I plan to adapt to Beancount data format(s).
They range from price downloaders, asset allocation, to the mobile app.
Baby steps

SGTM
 

I need to check the docs to see how I can implement these as plugins or whatever extension mechanisms are supported. I see that you mention the asset allocation plugin at a few places so perhaps I'll start with that.

Sounds like you're a candidate for just diving in the source code; feel free to skip the docs.
Have fun,


 

--
You received this message because you are subscribed to the Google Groups "Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beancount+...@googlegroups.com.
To post to this group, send email to bean...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages