[GNC] OFX import date questions

[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, which I 
believe means that two dates less than 4 days apart are considered a 
good match, while dates more then 14 days apart are a "no match" and 
there's a continuous in between. Hover over the + sign to get a help 
balloon.

If that's not the issue, there has to be a reason why GC does not 
consider the transactions you've entered for a match. The issue is 
either a date mismatch or an amount mismatch. If you let GC enter the 
transaction for you (instead of matching the existing one) can you see a 
mismatch between the dates and amounts of each transaction?

On 12/30/2022 2:20 PM, Phyllis Bruce wrote:
> 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 <ripngo at gmail.com> wrote:
>
>     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 created by your bank. If
>     you're a
>     programmer, you might want to write a small program to edit the
>     OFX file
>     before importing (I have to do that for citibank because of unique ID
>     issues).
>
>     J
>
>     On 12/30/2022 1:35 PM, Simon Roberts wrote:
>     > 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 willing to use that if it
>     > solves my problem).
>     >
>     > I imported some transactions using OFX. Several things surprised
>     me, but
>     > the one that I think needs resolving first is that the
>     transaction dates do
>     > not match the bank statement.
>     >
>     > Earlier I tried the CSV import and saw there were *two* date fields
>     > (presumably difference between being received and being acted on?
>     >
>     > Can someone tell me what I should do to fix this? Is there a way
>     to "tweek"
>     > the OFX import, or do I need to use CSV? Or is this something
>     else entirely
>     > that's gone amiss?
>     >
>     > Thanks for any hints,
>     > Cheers,
>     > Simon
>     >
>     > Background in case it's relevant:
>     >
>     > I'm a refugee from Intuit, and very early in my learning process.
>     >
>     > I"m not a bookkeeper, I'm a programmer. Conversely, my
>     bookkeeper isn't a
>     > software person--she would have continued paying the annual
>     ransom to
>     > Intuit but I'm sick of their hostage taking. Of course this
>     means I need to
>     > do a decent part of the legwork for this transition.
>     >
>     > Of course because I'm not a bookkeeper, I don't understand the
>     accounting
>     > side of this stuff, and likely won't know how to ask/phrase the
>     questions.
>     >
>     > Neither of us are going to be great at searching the
>     documentation since it
>     > seems like the terminology is different between GC and QB (and I
>     don't
>     > really know the terminology anyway)
>     >
>     > So, please forgive the idiot question, and if the simple answer to a
>     > question is RTFM, we're very happy to do so, but likely are
>     asking as we've
>     > failed to find the relevant part of said references.
>     >
>     > Anyway, thanks for your indulgence :)
>     > _______________________________________________
>     > 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
>     > -----
>     > 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
>     -----
>     Please remember to CC this list on all your replies.
>     You can do this by using Reply-To-List or Reply-All.
>