Importing bookings with accounts fully assigned

[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.

-------------- 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/7a6bf0c4/attachment.sig>