Importing bookings with accounts fully assigned

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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0x91FAB8DE.asc
Type: application/pgp-keys
Size: 3120 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20170818/4da6abfa/attachment.bin>
-------------- 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/20170818/4da6abfa/attachment.sig>