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.
