[GNC] Account setup for reports

[Fred Tydeman]

I wrote a REXX program (Perl would also work) to do text processing on a
QIF file, creating a new QIF file.

The Quicken QIF transaction:

^
D1/ 7'16
T75.60
CX
Pdr. miller
Mfjt cleaning
L[fjt-tex-check]/fjt:160107

gets turned into:

^
D1/ 7'16
T75.60
CX
Pdr. miller
Mfjt cleaning
L[fjt-tex-check]
S[fjt-tex-check]
Efjt cleaning
$75.60
S#:fjt:160107
$0

I used it on one Quicken account (with lots of different Classes) and then
imported that into Gnucash
into an existing account.  This is the same set of transactions as was
imported a year ago with an
older version of Gnucash when I first started using Gnucash.  The dummy
splits were added to the
existing transactions.  Also, the  Memo field got imported to the real
split.

On Wed, Apr 27, 2022 at 8:42 PM David T. <sunfish62 at yahoo.com> wrote:

> That's an interesting idea. I can't imagine it would involve too much--
> swapping the slash with a line feed and the appropriate account strings. I
> don't recall the QIF format that exactly, though, to be sure.
>
> David
>
> On April 27, 2022 9:56:29 PM EDT, Fred Tydeman <tydeman.fred at gmail.com>
> wrote:
>>
>> Has someone written a program to transform a *.QIF file into another *.QIF
>> file with
>> the Quicken class data (the text after the '/' in the Cat field) into dummy
>> split transactions
>> with the class data as the account on dummy split?
>> Since a gnucash transaction can have multiple splits, that is a way to tag
>> a transaction with many tags/classes.
>> And, since the tag/class data is gnucash accounts, they can be a hierarchy.
>>
>> On Wed, Apr 27, 2022 at 5:09 PM Fred Tydeman <tydeman.fred at gmail.com> wrote:
>>
>>  Thank you.  Comment 6 with the dummy accounts added as $0 splits seems
>>>  good enough for my needs.
>>>
>>>  On Wed, Apr 27, 2022 at 2:44 PM flywire <flywire0 at gmail.com> wrote:
>>>
>>>  https://lists.gnucash.org/pipermail/gnucash-user/2022-February/099807.html
>>>>  is part of a discussion on classes.
>>>>
>>>>
>>> ------------------------------
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> ------------------------------
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>>