[GNC] Comenity Bank OFX Exports

[David Carlson]

Update on Comenity Petco imports:

They do offer a CSV-like export option but it turns out that their version
makes every value positive and has another column assigning words like
payment, charge, interest and a few others to those values, so it either
requires some pre-processing or post-processing for GnuCash imports to work.

This does suggest that a nice enhancement to the Generic import would be to
allow some editing of import data during the import process.   I am not
quite ready myself to put forth such a suggestion,  but I will throw it out
as food for thought.



On Sun, Aug 15, 2021, 8:52 AM Greg Feneis <mfeneis at gmail.com> wrote:

> IIRC, there is a setting in GnuCash that allows the user to compensate for
> when the FI does this. The setting is likely not in preferences, since it's
> going to need to be per account. Maybe see if the account has some setting
> that will help?
>
> Kind regards, Greg Feneis
> (Pixel 3)
>
>
> On Sat, Aug 14, 2021, 18:02 David Carlson <david.carlson.417 at gmail.com>
> wrote:
>
> > My wife recently opened a Comenity Bank Petco credit card and their web
> > presence apparently reverses the values for charges and payments in their
> > OFX exports, compared to other credit cards.  This surprises me since
> they
> > must have many other cards that presumably would not be reversed in their
> > OFX exports, if they offer them.
> >
> > 1. I would like suggestions of references to other Comenity cards with
> > correct OFX exports (if any exist) to mention if I decide to ask them to
> > correct the problem, or
> >
> > 2. Is there an easy way to preprocess OFX transaction import files to
> > reverse the signs of every transaction?
> >
> > 3.  Their export files also include references to external corrections
> not
> > included in the files so GnuCash has to indicate that the missing
> external
> > correction exists.  I am not sure if I want to keep those references
> > either, so is there an easy preporcess way to delete those?  If not, can
> > the OFX generic import show the references during the import process?
> One
> > of those references looks like this:
> > <CORRECTFITID>obfuscatedidentifier
> >             <CORRECTACTION>REPLACE
> >
> > Other information that I found on the internet suggests that one would be
> > wise to avoid Comenity cards in general, which is probably why this is
> the
> > only Comenity card that we have.
> > --
> > David Carlson
> > _______________________________________________
> > 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.
> >
> _______________________________________________
> 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.
>