Are you using our AIO bundle downloaded from https://sourceforge.net/projects/gnucash <https://sourceforge.net/projects/gnucash> or https://github.com/gnucash/GnuCash <https://github.com/gnucash/GnuCash>, perhaps after linking through https://www.gnucash.org? <https://www.gnucash.org/?>
This appears to be the behavior of a bug in libofx where the offset is applied in the wrong direction, i.e. a GMT offset of -5 hours is added to GMT making 2021-07-21T02:00:00 into 2021-07-20T21:00:00 when it should be subtracted making 2021-07-22T07:00:00. That bug is supposed to be patched in the GnuCash 4.9 AIO packages. Regards, John Ralls > On Jan 11, 2022, at 4:48 PM, xraive . <xra...@hotmail.com> wrote: > > I'm in the Eastern Standard Time - Time zone in (GMT-5). > > ________________________________ > From: gnucash-user <gnucash-user-bounces+xraive=hotmail....@gnucash.org> on > behalf of Mark Sutton <m...@lazo.ca> > Sent: Tuesday, January 11, 2022 10:55 PM > To: gnucash-user@gnucash.org <gnucash-user@gnucash.org> > Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank) > > what time zone are you in? 2:00AM (whether GMT, or EST) is still yesterday if > you are GMT-8 ? > > On January 11, 2022 2:33:08 PM PST, "xraive ." <xra...@hotmail.com> wrote: >> 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....@gnucash.org> on >> behalf of David Carlson <david.carlson....@gmail.com> >> Sent: Tuesday, January 11, 2022 9:33 PM >> To: Jean Laroche <rip...@gmail.com> >> Cc: gnucash-user@gnucash.org <gnucash-user@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 <rip...@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 <gmccol...@live.com> >>>> Sent: Tue Jan 11 13:33:51 EST 2022 >>>> To: "D." <sunfis...@yahoo.com> >>>> Cc: "gnucash-user@gnucash.org" <gnucash-user@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 >>>> >>>> gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email >>>> >>>> ________________________________ >>>> From: gnucash-user <gnucash-user-bounces+gylemc=gmail....@gnucash.org> >>> on behalf of D. via gnucash-user <gnucash-user@gnucash.org> >>>> Sent: Tuesday, January 11, 2022 1:20 PM >>>> To: David Carlson <david.carlson....@gmail.com> >>>> Cc: GnuCash <gnucash-user@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....@gmail.com> >>>> Sent: Tue Jan 11 12:53:59 EST 2022 >>>> To: "xraive ." <xra...@hotmail.com> >>>> Cc: Gnucash Users <gnucash-user@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 . <xra...@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@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@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@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@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@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@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@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@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@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@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.
