Re: [GNC] OFX import date questions

2022-12-31 Thread Phyllis Bruce
Hi Simon, the import had the proper transactions but was not matching a couple I had manually entered that were outside the default parameters. I thing I’ve got that sorted now. I’m running ver 4.13 of GC in Windows 11. I upgrade as soon as I know one has been distributed. O

Re: [GNC] OFX import date questions

2022-12-31 Thread Phyllis Bruce
Yes, David C- to me, date issued is the date I wrote the check. By date cleared, I meant the date on the statement which I assume is the date the bank cleared the transaction. I'm also going to take a leap and assume the OFX and QFX operate the same since the two are on the same line as OFX/QFX i

Re: [GNC] OFX import date questions

2022-12-31 Thread Simon Roberts
A side thought Phylls, I think your first observation was about some transactions that you had imported not showing up? If that's the case, what version of GnuCash are you running? I was running 3.8, which was the default from the Ubuntu Linux repositories. It was indeed failing to import some tra

Re: [GNC] OFX import date questions

2022-12-31 Thread David Carlson
Phyllis, Reconciliation does* not* always change the date to date cleared. In fact, the only date messed with during reconciliation is the reconciliation date. That date is always automatically set to the date used by the reconciliation process. In fact, that date has been the topic of other th

Re: [GNC] OFX import date questions

2022-12-31 Thread Phyllis Bruce
Thanks Jean and David, My thresholds are prolly set to the defaults. Another thing I will do is filter for "Unreconciled" before I start my reconciliation. I often have some withdrawals that don't occur within two months. If I know they're there, I can change the threshold to look for them. Sec

Re: [GNC] OFX import date questions

2022-12-30 Thread Simon Roberts
Thank you for the help to this point. I think I've worked out the date issue (very embarrassing, nothing to do with GC). Now I have a bunch more questions, but I'll ask them in dedicated threads to minimize confusion. I did notice that the CSV version of the transaction information contains two di

Re: [GNC] OFX import date questions

2022-12-30 Thread David Cousens
Phyllis, That is what the Import Matcher window immediately before import is about. There are some preferences you can alter (cautiously) the likely and unlikely match day thresholds in particular. The matcher choices should not always be regarded as the last word. I generally find it matches exi

Re: [GNC] OFX import date questions

2022-12-30 Thread David Carlson
I interpret the OP's question as that the date imported from the OFX file doesn't match the date printed on the statement. Some banks try to get fancy and print the date that you deposited a check on your statement but then use the date that the funds arrived from the clearing house or the date t

Re: [GNC] OFX import date questions

2022-12-30 Thread Jean L
This is not expected behavior. I never happens to me, in fact ofx import usually works just fine. There might be something off in your preferences. You could try to go into "import" and adjust the "likely match day" threshold and the "Unlikely match day threshold". Mine are set to 4 and 14, whic

Re: [GNC] OFX import date questions

2022-12-30 Thread Adrien Monteleone
That's a matching problem on the import if I recall correctly. You have to fix it there. I've seen threads on the topic, but since I don't use it, the details are not sticky in my brain. If I understand properly, GnuCash *should* be able to match existing transactions and simply set the 'c' fl

Re: [GNC] OFX import date questions

2022-12-30 Thread Phyllis Bruce
Jean and Adrien, I use QFX and reconciling is a pain! When I import and data from my bank and begin reconciliation I often find the GNC has ignored the existing unreconciled transactions and created new cleared ones. On Fri, Dec 30, 2022 at 3:51 PM Jean L wrote: > I don't think you can "tweak"

Re: [GNC] OFX import date questions

2022-12-30 Thread David Cousens
Simon, The OFX file will be the immediate position in the banks records at the time of download. What appears in a statement may be after completion of interbank clearances of funds and the dates in the statement may reflect when this occurred rather than when the transaction was first received by

Re: [GNC] OFX import date questions

2022-12-30 Thread Jean L
I don't think you can "tweak" the OFX import. OFX import relies on an external library (ofxlib I think?). Are the dates way off? I've never noticed anything weird like that in my own OFX imports (which I do a lot of) the dates seem to always coincide. This *could* be a problem with the OFX crea

Re: [GNC] OFX import date questions

2022-12-30 Thread Adrien Monteleone
I'll let others who use this feature provide more specific advice, but as to the general question of dates matching: I wouldn't expect my dates to match the bank's records. My dates would always be the date of the real-world transaction. The Bank's dates would be when the bank cleared it, whic

[GNC] OFX import date questions

2022-12-30 Thread Simon Roberts
Beginner/refugee from QuickBooks here (more context below if you care). I'm working in a scratch file, so I can do stupid things while learning without damaging anything "important". I'm working with importing my bank transactions using OFX format (though I've also tinkered with CSV, and am willi