The [-5:EST] is in fact the problem. I think GNC posts in UTC. They even change that when daylight saving time comes into effect. I either made the change in vi or wrong a sed script. I'll have a look at what I did.
On Tue, Jan 11, 2022 at 12:06:04PM -0800, Jean Laroche 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.
