[GNC] Matcher for qfx files

[Dale Alspach]

Thanks. I found and installed the flathub of 4.1.

Dale

On Mon, Aug 3, 2020 at 4:17 PM John Ralls <jralls at ceridwen.us> wrote:

> Dale,
>
> ISTR a commit from last fall by Mike Alexander addressing exactly this
> issue, though I cannot now find it.
> Try GnuCash 3.9 or later.
>
> Regards,
> John Ralls
>
>
>
> > On Aug 3, 2020, at 12:23 PM, Dale Alspach <alspachde at gmail.com> wrote:
> >
> > The first stage of the import does not appear to be using ACCTID. I was
> > only asked once for each security which gnucash account to use though in
> a
> > few cases there were transactions for the same security in more than one
> > TIAA account. Worse the ACCTID information, which includes the contract
> > number, is not being displayed at this stage so this is nearly useless.
> It
> > may be that the next stage matcher uses the ACCTID information, but
> because
> > its memory was wiped with the upgrade I cannot tell.
> >
> > gnucash 3.8 is the current version in the package manager. Upgrading
> would
> > require finding another source for a built package, using a flatpak or
> > compiling it myself. I scanned through the release notes and bug reports
> > and did not see anything specifically related to this issue.
> >
> > A possibility is that TIAA has changed something in the qfx data. I did
> not
> > investigate this possibility.
> >
> > Dale
> >
> > On Sun, Aug 2, 2020 at 9:18 PM David Reiser <dbreiser at icloud.com> wrote:
> >
> >> It at least uses the <ACCTID>, which is matched via the
> >> outside-account-to-gnucash-account list. And imports of multiple TIAA
> >> contracts containing multiple instances of the same fund do work
> correctly
> >> if the links are set up correctly. I’m currently using gnucash 4.1, but
> I
> >> don’t recall problems with 3.8 specifically. There was one version where
> >> changes in the matcher resulted in requests to re-establish links to the
> >> various TIAA accounts and funds.
> >>
> >> I frequently have to undo my choices when I get one of those dialogs
> >> because I’m not careful enough at reading the exact language at the top
> of
> >> the dialog. I haven’t made many changes lately, but I think you’ll get a
> >> request to identify a security, but that usually also includes a
> statement
> >> about which TIAA contract is involved. Then (? hmm, not sure of the
> order…)
> >> it’ll ask you for a gnucash account to associate with a specific TIAA
> >> contract. Somewhere along the way, there’s a question about which
> account
> >> to associate income from the various contracts and/or funds. Most of
> that
> >> used to get rolled up inside the TIAA/CREF funds, but now at least one
> of
> >> our contracts splits out a special fee/credit that is something like the
> >> net difference between dividends and fees for several of the funds.
> >>
> >> If your employer hasn’t done an administrative change that would kick
> some
> >> extra transactions into your ofx stream (and there appears to be a lot
> of
> >> pressure from somewhere to do that), then having gnucash ask for
> additional
> >> matching info is a bit strange. One other possibility is that your
> >> employer’s plan has qualified for a better version of the same fund
> you’ve
> >> had for a while (R3 vs R2 fee levels, higher digit is lower fees). One
> >> example is CREF stock R3 (QCSTIX in public symbol world) vs CREF stock
> R2
> >> (QCSTPX).
> >>
> >> Since there have been a few import transaction matcher changes lately,
> I’d
> >> recommend giving gnucash version 4.1 a try if you can. I’m unfamiliar
> with
> >> the version availability in the linux prepackaged realm.
> >> --
> >> Dave Reiser
> >> dbreiser at icloud.com
> >>
> >>
> >>
> >>
> >>> On Aug 2, 2020, at 1:53 PM, Dale Alspach <alspachde at gmail.com> wrote:
> >>>
> >>> When importing a .qfx file does the matcher use the tags  <BROKERID>
> and
> >>> <ACCTID>?
> >>>
> >>> The issue is that I download transactions from TIAA which are from
> >> multiple
> >>> accounts but are in the same download. There are some mutual funds
> which
> >>> are held in more than one account.
> >>> I recently upgraded to gnucash 3.8. I started to do an import in
> gnucash
> >>> 3.8 (linux mint 20) and was asked to match a fund to an account but was
> >>> only given the cusip number. which refers to a security which could be
> in
> >>> any one of 3 gnucash accounts.
> >>> If I recall correctly older versions of gnucash gave the name of the
> fund
> >>> and the TIAA contract number.
> >>>
> >>> Dale
> >>
> >>
> > _______________________________________________
> > 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.
>
>