[GNC] OFX import date questions

[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 existing transactions
very well but occasionally something throws a spanner in the works and you get a
mismatch so I check the settings and checkbox settings carefully before
importing. I quite  often find one or two of the matchers suggestions which I
have to override or soem that it can't match. Fortunately they seem to be the
same transactions month to month.  If the date you entered a transaction in
GnuCash is significantly different from the date the bank records it at then the
probability that it will be matched is lowered. 

David Cousens


On Fri, 2022-12-30 at 16:20 -0600, 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.
> > 
> _______________________________________________
> 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.