Re: [GNC] Comenity Bank OFX Exports
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 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 > 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: > > obfuscatedidentifier > > 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@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@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@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.
Re: [GNC] Comenity Bank OFX Exports
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 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: > obfuscatedidentifier > 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@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@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.
Re: [GNC] Comenity Bank OFX Exports
I do have a Comenity card, but I've not downloaded ofx files. I just checked and I do have the option of Excel which is CSV format. You might be able to get it to import properly. Dan On August 14, 2021 9:01:54 PM David Carlson 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: obfuscatedidentifier 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@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@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.