Thanks for your response but I just tried from both locations and I still have the same issue.
________________________________ From: john <[email protected]> Sent: Wednesday, January 12, 2022 5:25 AM To: xraive . <[email protected]> Cc: Mark Sutton <[email protected]>; [email protected] <[email protected]> Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank) Are you using our AIO bundle downloaded from https://sourceforge.net/projects/gnucash or https://github.com/gnucash/GnuCash, perhaps after linking through 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 . <[email protected]<mailto:[email protected]>> wrote: I'm in the Eastern Standard Time - Time zone in (GMT-5). ________________________________ From: gnucash-user <[email protected]<mailto:[email protected]>> on behalf of Mark Sutton <[email protected]<mailto:[email protected]>> Sent: Tuesday, January 11, 2022 10:55 PM To: [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> 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 ." <[email protected]<mailto:[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]<mailto:[email protected]>> on behalf of David Carlson <[email protected]<mailto:[email protected]>> Sent: Tuesday, January 11, 2022 9:33 PM To: Jean Laroche <[email protected]<mailto:[email protected]>> Cc: [email protected]<mailto:[email protected]> <[email protected]<mailto:[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]<mailto:[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]<mailto:[email protected]>> Sent: Tue Jan 11 13:33:51 EST 2022 To: "D." <[email protected]<mailto:[email protected]>> Cc: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[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]><mailto:[email protected]> email ________________________________ From: gnucash-user <[email protected]<mailto:[email protected]>> on behalf of D. via gnucash-user <[email protected]<mailto:[email protected]>> Sent: Tuesday, January 11, 2022 1:20 PM To: David Carlson <[email protected]<mailto:[email protected]>> Cc: GnuCash <[email protected]<mailto:[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]<mailto:[email protected]>> Sent: Tue Jan 11 12:53:59 EST 2022 To: "xraive ." <[email protected]<mailto:[email protected]>> Cc: Gnucash Users <[email protected]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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.
