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 ." <[email protected]> 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 <[email protected]> on >behalf of David Carlson <[email protected]> >Sent: Tuesday, January 11, 2022 9:33 PM >To: Jean Laroche <[email protected]> >Cc: [email protected] <[email protected]> >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 <[email protected]> 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 <[email protected]> >> > Sent: Tue Jan 11 13:33:51 EST 2022 >> > To: "D." <[email protected]> >> > Cc: "[email protected]" <[email protected]> >> > 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 >> > >> > [email protected]<mailto:[email protected]> email >> > >> > ________________________________ >> > From: gnucash-user <[email protected]> >> on behalf of D. via gnucash-user <[email protected]> >> > Sent: Tuesday, January 11, 2022 1:20 PM >> > To: David Carlson <[email protected]> >> > Cc: GnuCash <[email protected]> >> > 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 <[email protected]> >> > Sent: Tue Jan 11 12:53:59 EST 2022 >> > To: "xraive ." <[email protected]> >> > Cc: Gnucash Users <[email protected]> >> > 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 . <[email protected]> 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 >> >> [email protected] >> >> 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 >> > [email protected] >> > 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 >> > [email protected] >> > 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 >> > [email protected] >> > 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 >> [email protected] >> 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 >[email protected] >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 >[email protected] >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 [email protected] 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.
