One more clarification: Thanks to Derek for the crucial hint regarding the L line: Without this I would have never managed to get the result!
What I finally managed to generate on my own is to fabricate manually a synthetic minimum import file that really works. Am 20.08.2017 um 06:49 schrieb Cornelis Bockemühl: > 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. > > > _______________________________________________ > 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.
