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

[Jean Laroche]

> 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.