[GNC] Transaction Date issues during import OFX file (TD Bank)

Tue Jan 11 17:57:51 EST 2022

And do you live in the Eastern Standard Time zone?

On Tue, Jan 11, 2022, 4:49 PM xraive . <xraive at hotmail.com> wrote:

> If I haven't mentioned it, I'm running GNUCASH Version: 4.9 Build ID:
> 4.9+(2021-12-18) on a Windows 10 PC.  The time settings on this PC are
> correct as far as I can tell.
>
> Thanks in advance.
>
> ------------------------------
> *From:* xraive . <xraive at hotmail.com>
> *Sent:* Tuesday, January 11, 2022 10:33 PM
> *To:* David Carlson <david.carlson.417 at gmail.com>; Jean Laroche <
> ripngo at gmail.com>
> *Cc:* gnucash-user at gnucash.org <gnucash-user at gnucash.org>
> *Subject:* Re: [GNC] Transaction Date issues during import OFX file (TD
> Bank)
>
> Sorry for the late response.  I tried removing [-5:EST] and the issue
> still persists. All the dates are still reported as one day earlier.  I
> imported the same file in MSMoney and the dates matched the banks if that
> helps.
>
> Thanks for your assistance so far.
>
> *From:* gnucash-user <gnucash-user-bounces+xraive=hotmail.com at gnucash.org>
> on behalf of David Carlson <david.carlson.417 at gmail.com>
> *Sent:* Tuesday, January 11, 2022 9:33 PM
> *To:* Jean Laroche <ripngo at gmail.com>
> *Cc:* gnucash-user at gnucash.org <gnucash-user at gnucash.org>
> *Subject:* Re: [GNC] Transaction Date issues during import OFX file (TD
> Bank)
>
> That -5 EST relates local time to universal time and may come into play if
> the local computer clock is not set to the local time zone.  Usually it
> clarifies the source time reference of the data.
>
> On Tue, Jan 11, 2022, 2:07 PM Jean Laroche <ripngo at gmail.com> wrote:
>
> > > I wonder what happens if the "[-5:EST]" gets removed.  The dates seem
> to
> > have 0200 as their time; subtracting 5 hours from that would return -3
> > o'clock (and presumably shift the date back one).
> >
> > You could do a test where you modify your OFX file to remove [-5:EST]
> > from all transactions (you can do that easily in an editor), then try to
> > import it and see whether this fixes the dates.
> >
> > After that the question is whether that [-5:EST] is valid or not.
> > Jean
> >
> >
> > On 1/11/22 11:59 AM, D. via gnucash-user wrote:
> > > But EFT transactions (which are the bulk of my txns these days)
> > shouldn't get shifted around much at all. I'd be miffed if every EFT
> entry
> > were a day off.
> > >
> > >
> > > -------- Original Message --------
> > > From: Gyle McCollam <gmccollam at live.com>
> > > Sent: Tue Jan 11 13:33:51 EST 2022
> > > To: "D." <sunfish62 at yahoo.com>
> > > Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> > > Subject: Re: Re: [GNC] Transaction Date issues during import OFX file
> > (TD Bank)
> > >
> > > I find my dates usualy do not agree with the bank dates.  I record
> > credit card bills when I pay them (electronically) and they are recorded
> by
> > the payee on the same date.  However, they usually hit my bank the next
> > banking day.  This isn't and shouldn't be a problem or concern.  Actual
> > physical checks take even longer to show up at the bank.  This is all
> > normal.
> > >
> > >
> > > Thank You,
> > > Gyle McCollam
> > >
> > > Gyle McCollam
> > >
> > > 609.680.2326                     Mobile
> > >
> > > gmccollam at live.com<mailto:gmccollam at gyleshomes.com
> <gmccollam at gyleshomes.com>>           email
> > >
> > > ________________________________
> > > From: gnucash-user <gnucash-user-bounces+gylemc=gmail.com at gnucash.org>
> > on behalf of D. via gnucash-user <gnucash-user at gnucash.org>
> > > Sent: Tuesday, January 11, 2022 1:20 PM
> > > To: David Carlson <david.carlson.417 at gmail.com>
> > > Cc: GnuCash <gnucash-user at gnucash.org>
> > > Subject: Re: [GNC] Transaction Date issues during import OFX file (TD
> > Bank)
> > >
> > > I'd be annoyed at the shift.
> > >
> > > I wonder what happens if the "[-5:EST]" gets removed.  The dates seem
> to
> > have 0200 as their time; subtracting 5 hours from that would return -3
> > o'clock (and presumably shift the date back one).
> > >
> > >
> > > -------- Original Message --------
> > > From: David Carlson <david.carlson.417 at gmail.com>
> > > Sent: Tue Jan 11 12:53:59 EST 2022
> > > To: "xraive ." <xraive at hotmail.com>
> > > Cc: Gnucash Users <gnucash-user at gnucash.org>
> > > Subject: Re: [GNC] Transaction Date issues during import OFX file (TD
> > Bank)
> > >
> > > Your bank creates the Ofx file.   Gnucash just accepts what they give
> > you.
> > > Sometimes it may appear to be incorrect when it is a misunderstanding
> > about
> > > whether transactions are posted on the same day they occur.
> > >
> > > Does it really make a difference?
> > >
> > >
> > >
> > >
> > > On Tue, Jan 11, 2022, 10:12 AM xraive . <xraive at hotmail.com> wrote:
> > >
> > >> I downloaded transactions from my bank (TD) in Canada and when I tried
> > >> importing the file into GNUCASH all the dates were set to one day
> > earlier
> > >> then the actual transactions.  I'm including sample transactions
> below.
> > >>
> > >> OFX file imported to GNUCASH
> > >>
> > >> <STMTTRN>
> > >> <TRNTYPE>DEBIT
> > >> <DTPOSTED>20210722020000[-5:EST]
> > >> <TRNAMT>-14.64
> > >> <FITID>21203175847980020
> > >> <NAME>Best Buy
> > >> </STMTTRN>
> > >> <STMTTRN>
> > >> <TRNTYPE>CREDIT
> > >> <DTPOSTED>20210726020000[-5:EST]
> > >> <TRNAMT>21.83
> > >> <FITID>21207193333980010
> > >> <NAME>Home Depot
> > >> </STMTTRN>
> > >>
> > >> Any help would be greatly appreciated.  If you need additional
> > information
> > >> please let me know.
> > >>
> > >> Thanks
> > >> _______________________________________________
> > >> 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
> > >> If you are using Nabble or Gmane, please see
> > >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > >> -----
> > >> 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
> > > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > > -----
> > > 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
> > > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > > -----
> > > 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
> > > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > > -----
> > > 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
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -----
> > 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>