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 <rip...@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@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@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@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.
