[GNC] OFX import date questions

[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 <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.
>