[GNC] Transaction Date issues during import OFX file (TD Bank)

Tue Jan 11 19:48:41 EST 2022

I'm in the Eastern Standard Time - Time zone in (GMT-5).

________________________________
From: gnucash-user <gnucash-user-bounces+xraive=hotmail.com at gnucash.org> on behalf of Mark Sutton <mes at lazo.ca>
Sent: Tuesday, January 11, 2022 10:55 PM
To: gnucash-user at gnucash.org <gnucash-user at 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 ." <xraive at 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.com at gnucash.org> on behalf of David Carlson <david.carlson.417 at gmail.com>
>Sent: Tuesday, January 11, 2022 9:33 PM
>To: Jean Laroche <ripngo at gmail.com>
>Cc: gnucash-user at gnucash.org <gnucash-user at 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 <ripngo at 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 <gmccollam at live.com>
>> > Sent: Tue Jan 11 13:33:51 EST 2022
>> > To: "D." <sunfish62 at yahoo.com>
>> > Cc: "gnucash-user at gnucash.org" <gnucash-user at 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
>> >
>> > gmccollam at live.com<mailto:gmccollam at gyleshomes.com>           email
>> >
>> > ________________________________
>> > From: gnucash-user <gnucash-user-bounces+gylemc=gmail.com at gnucash.org>
>> on behalf of D. via gnucash-user <gnucash-user at gnucash.org>
>> > Sent: Tuesday, January 11, 2022 1:20 PM
>> > To: David Carlson <david.carlson.417 at gmail.com>
>> > Cc: GnuCash <gnucash-user at 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.417 at gmail.com>
>> > Sent: Tue Jan 11 12:53:59 EST 2022
>> > To: "xraive ." <xraive at hotmail.com>
>> > Cc: Gnucash Users <gnucash-user at 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 . <xraive at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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.