Thanks Derek: I finally managed myself do do the thing that I want to do - at least for a little test import!
This is the QIF file that I generated manually for my bookings: ======================================= !Type:Bank D11/08/17 T-25.70 PBirthday gift LGifts ^ D24/08/17 T2000 PSalary for August LSalary ^ ======================================= With this the program first asked a few question (like preferring European or American style date format, bank account to use, and what to use for "Gifts" and "Salary" - and in the end the bookings ended up in exactly the right locations. The rest is now probably adapting the L "categories" exactly to my account structure - and I am done - and MUCH faster than I ever was! ;-) Because converting a simple CSV into the above QIF file format is indeed no magic. Regards, Cornelis Am 18.08.2017 um 12:18 schrieb Cornelis Bockemühl: > 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 <[email protected]> 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 >> > > > _______________________________________________ > gnucash-user mailing list > [email protected] > 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.
signature.asc
Description: OpenPGP digital signature
_______________________________________________ gnucash-user mailing list [email protected] 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.
