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

john jralls at ceridwen.us
Wed Jan 12 00:25:10 EST 2022 

Are you using our AIO bundle downloaded from https://sourceforge.net/projects/gnucash <https://sourceforge.net/projects/gnucash> or https://github.com/gnucash/GnuCash <https://github.com/gnucash/GnuCash>, perhaps after linking through https://www.gnucash.org? <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 . <xraive at hotmail.com> wrote:
> 
> 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.
> _______________________________________________
> 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.

More information about the gnucash-user mailing list