[GNC] OFX import date questions

[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 the bank.
Clearnce times are generally a lot shorter with electronic clearances than they
used to be can sometimes be delayed. SInce this is a disagreement between OFX
records and statement both produced by the bank, they are best placed to explain
what such discrepancies are and why they occur.

David Cousens


On Fri, 2022-12-30 at 14:35 -0700, 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.