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]>
Sent: Tue Jan 11 13:33:51 EST 2022
To: "D." <[email protected]>
Cc: "[email protected]" <[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]> email
________________________________
From: gnucash-user <[email protected]> on behalf of
D. via gnucash-user <[email protected]>
Sent: Tuesday, January 11, 2022 1:20 PM
To: David Carlson <[email protected]>
Cc: GnuCash <[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]>
Sent: Tue Jan 11 12:53:59 EST 2022
To: "xraive ." <[email protected]>
Cc: Gnucash Users <[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]> 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]
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.
_______________________________________________
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.
