Good evening, ;-) That sounds indeed like exactly the thing that I would need!
However, I already tried a bit with the QIF format, reading the manual, then trying to manually fabricate some QIF file exactly with that intention - with no success so far. So if you have any knowledge of that format: Would you be able to just fabricate a little example file with one booking record in the way that you describe? I would be more than happy if you could do this! I think with this I would be more or less "done": First generate that table that I described, then write some (probably easy) conversion from the table to QIF - and import! With thanks and regards, Cornelis Am 18.08.2017 um 17:05 schrieb Derek Atkins: > Cornelis Bockemühl <corne...@bockemuehl.ch> writes: > >> Good morning, >> >> Does anybody know a way or a specific data format that allows to import >> bookings into Gnucash that have already their "counter booking" >> (probably not the correct bookkeeper's language...)? > QIF supports this by using the LCategory or L[Account] features to > specify the QIF Category (Income/Expense) or the QIF Account > (Asset/Liability) of the "other" account. > > The importer will allow you to map the QIF Categories and QIF Accounts > to GnuCash Accounts. The names do not need to match, although it's > obviously easier if they do. > >> Example: I have a list of bookings somehow like the following: >> >> Date Amount Text Account from >> Account to >> ------------------------------------------------------------------------------------ >> 11-08-2017 25.70 Birthday gift Giro >> Gifts >> 24-08-2017 2000.00 Salary for August Salary >> Bankaccount >> >> etc. etc. >> >> Of course the accounts "Giro", "Gifts", "Salary" and "Bankaccount" >> should exist in Gnucash already. > The accounts don't actually need to exist; the QIF importer will create > them if they don't. > >> So far I always prepare several lists, two for each of the main bank >> accounts, then I import them as CSV and then I have to more or less >> assign the "counter booking" for each single like manually because even >> after a couple of years the automatic assignment does not really do a >> really useful job. >> >> Any idea or proposal? > Use QIF? > >> Thanks and regards, Cornelis >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > -derek >
0x91FAB8DE.asc
Description: application/pgp-keys
signature.asc
Description: OpenPGP digital signature
_______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
