GNOME Bugzilla – Bug 636340
Date offset while importing OFX with standard time EST
Last modified: 2018-06-29 22:48:42 UTC
When importing OFX file with standard time (after daylight saving has ended) the import date is offset by 1 day. For example, a transaction reported by the bank to have occurred on Dec. 1, 2010 at midnight is recorded with date Nov. 30 in GnuCash: Importing OFX file containing such entries: ... <DTSERVER>20101202210623[-5:EST] ... <STMTTRN> <TRNTYPE>DEBIT <DTPOSTED>20101201000000[-5:EST] <TRNAMT>-83.00 <FITID>201012010018920184A <NAME>NONE OF BUGZILLA'S BUSINESS </STMTTRN> ... would end up showing date of Nov. 30 in GnuCash. System is running Ubuntu 10.04, problem also confirmed on Windows running portable version of GnuCash 2.2.9. Locale is Montreal, Canada. Many thanks, Benoit P.
Created attachment 175756 [details] OFX test file This is a sample file when importing into GnuCash the entries have the dates offset by 1 day.
I have also had this problem for a while (perhaps since the DST switch; I didn't note exactly when). Nearly all of my transactions across 3 different banks show up as being one day off. I haven't analyzed my QFX file as the original poster has, however. But I would imagine that it is the same issue. I am using v2.4 of GnuCash.
I may have left Gnucash open during the change of time. This seems to be related to bug #137017
I get the same problem. Version 2.4.0 and 2.4.3 on Windows XP Pro 32 bit, with timezone GMT. The behaviour I get with different OFX files' date formats: Date Format GnuCash Imported Date ----------- --------------------- <DTPOSTED>20110217000000 16/02/2011 <DTPOSTED>20110217000000[-5:EST] 17/02/2011 I have tested two credit cards and two UK banks (current accounts) and all except one use the first format. The one with the [-5:EST] is Barclays Bank, which, oddly, is the only one that is interpreted by GnuCash correctly. It doesn't seem to matter what time of day it is. I imagine this will become more prominent with the new Update and Reconcile functionality.
Yesterday libofx version 0.9.13 was released which includes a patch to improve timezone handling. When this version hits your system (or if you are in a position to build it yourself) please test if this is still an issue.
GnuCash bug tracking has moved to a new Bugzilla host. The new URL for this bug is https://bugs.gnucash.org/show_bug.cgi?id=636340. Please continue processing the bug there and please update any external references or bookmarks.