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.
[GNC] CVS import success/issues
In preparation for a move from Mac to Linux, I went to move from my circa 2015 version of Quicken for Mac to GnuCash. Sadly that version lacks QIF support and couldn't even be imported correctly into the latest PC Quicken. It does, however, have the option to view all transactions in one list and export the current list to a CSV file with Quicken-isms describing the transactions. Long story story: I was able to write a program to translate 99% of my 24 years of transactions into a format digestible by GnuCash's CSV import. The remainder, mostly Split, Add and Remove shares, were best dealt with by hand anyway. Along the way I ran into a few issues that might not have been reported. There's a question at the end. 1) Large files will blow up the program a crash that gives no clue of the issue on MacOS. On a PC it gives a popup with a cryptic message that I think amounts to a too many threads error. I got around this by outputting to per year files for most years and smaller for a few select ones. The crash would normally happen at the point of selecting the import configuration. 2) Multiple back to back imports will also crash the program. I got around this by exiting and restarting between imports. 3) The Num field, which I translated, for better or worse, from Quicken's similar field, had an issue where entries which did not have a Num entry would be given one. My limited experimentation with this seemed to indicate that when a split with no Num followed an entry on the same date that had a Num, it would inherit the previous entries Num. 4) The match algorithm is a bit too greedy in pairing splits. If you have a sequence of splits that describe two transactions that have the same date and description, they will be merged into a single transaction. This often came up with transactions like end of the month dividends or interest payments. If the algorithm encountered two splits that balance out in amounts, followed by two more that also balanced themselves, would not it be better to make them two separate transactions? This can be gotten around by artificially altering the transaction's description or by tedious manual editing. 5) When pulling in a lot of transactions at once, it seems that random entries get deselected in the match list. I wasn't able to predict the behavior though. 6) I wasn't able to get the Cleared field to work. If it was anything but "n" the split would be ignored. I'm not sure what the intention was on this, but it might be worth documenting. And now for the question: I'm using version 4.5 and was not able to get the Trail Balance Report to show equal totals after a security Sell transaction, despite making Capital Gain/Loss entries. Is the technique described in 9.7.1.2 still supported? I tried the example in 9.7.2.1 and it gave me with an imbalance, but did it in my existing file. If it's supported I'll make a clean file and experiment with it more. Thanks. Lisa ___ 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] Balance not updating
Hi Nike, Glad you have resolved your problem. Unless this problem is happening often, it is not worth spending any time trying to fix. It may have been caused by something other than a GnuCash program problem, such as a hardware or operating system problem. Regards, Chris Good -Original Message- From: Vinayak Vatsal Sent: Sunday, 15 August 2021 11:59 PM To: Chris Good Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Balance not updating Thanks for the suggestion. This problem seems to have mysteriously disappeared. It persisted through one full session, and an eventual crash, but relaunching GnuCash seems to have fixed it. I don’t really know what happened; maybe some transient data corruption? > On Aug 13, 2021, at 7:14 PM, Chris Good wrote: > > Message: 1 > Date: Wed, 11 Aug 2021 08:53:14 -0700 > From: Vinayak Vatsal > To: gnucash-user@gnucash.org > Subject: [GNC] Balance not updating > Message-ID: <435ff31b-9eb2-4c06-90e3-51b6d8081...@mac.com> > Content-Type: text/plain; charset=utf-8 > > Hello, > > I have recently encountered the following problem: > > Importing OFX transactions into one of my credit card accounts results > in an error, where the correct credit or withdrawal is shown, but the > balance column just comes up as zero. > > This is a recent thing, and I suspect it has something to do with the > fact that the credit card was recently issued (the old one expired) > and there?s a new ID number somewhere that is confusing. > > I tried things like changing the account ID to some random value and > reimporting, and also just importing a CSV file with the same data, > but the problem persists. > > I can manually enter transactions without any problem. > > Any ideas how to fix this? > > Thank you. > > Nike > > > Hi Nike, > > I'm not sure I understand your problem, but maybe your transactions > are being imported into a different account than you are expecting. > > If you go into Tools, "Import Map Editor", and select "Online", you > can see the accounts that you have previously selected to match the > bank id's in your .ofx files. > If you delete the incorrect match, your next ofx import will ask you > to select the matching account again. > > If I'm not understanding your problem, perhaps a partial screen dump > would help us understand? > > Regards, Chris Good > ___ 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.