Importing bookings with accounts fully assigned

Cornelis Bockemühl cornelis at bockemuehl.ch
Sun Aug 20 08:06:20 EDT 2017


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 <cornelis at 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
>>>
>>
>> _______________________________________________

>> gnucash-user mailing list
>> gnucash-user at 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.
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: OpenPGP digital signature
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20170820/3e5b5484/attachment.sig>


More information about the gnucash-user mailing list