How to import from Gnucash?
Posted: Wed Jul 29, 2015 6:41 pm
I have about 4 years of full records and another 3 years of sparse records from Gnucash, and I've been trying to import them properly into MMEX.
My data is all in English, and because Gnucash is double-entry, is all a set of transfers. That can be mapped fairly easily to categories in some cases, but for transfers between accounts rather than externally (for example, withdrawing cash from my savings account) it seems a bit of a hassle to import.
Also, my accounting methods mean I've used split transfers fairly liberally. For example, if I pay for a meal using a credit card and my colleagues pass me their portions in cash (or vice-versa), that's a split transaction, and there's more of those than I'd care to admit.
What's the most painless way to import?
So far what I've seen is that CSV (which I can export to from Gnucash losslessly, verified by my own sampled testing) does not support either split transfers or transfers between accounts.
Does QIF support both or either? Because I don't have a direct Gnucash QIF export, just a convertor someone wrote half a decade ago, and don't grok the format. I'll write my own simple convertor if I have to, but would need to know whether it supports both splits and transfers.
For reference, if it matters, I'm using 1.2.2 on Linux. I have no qualms going to a developmental version if needed.
My data is all in English, and because Gnucash is double-entry, is all a set of transfers. That can be mapped fairly easily to categories in some cases, but for transfers between accounts rather than externally (for example, withdrawing cash from my savings account) it seems a bit of a hassle to import.
Also, my accounting methods mean I've used split transfers fairly liberally. For example, if I pay for a meal using a credit card and my colleagues pass me their portions in cash (or vice-versa), that's a split transaction, and there's more of those than I'd care to admit.
What's the most painless way to import?
So far what I've seen is that CSV (which I can export to from Gnucash losslessly, verified by my own sampled testing) does not support either split transfers or transfers between accounts.
Does QIF support both or either? Because I don't have a direct Gnucash QIF export, just a convertor someone wrote half a decade ago, and don't grok the format. I'll write my own simple convertor if I have to, but would need to know whether it supports both splits and transfers.
For reference, if it matters, I'm using 1.2.2 on Linux. I have no qualms going to a developmental version if needed.