Wrong date when importing OFX file from HSBC

Diarmaid Lee djlee97 at btinternet.com
Mon Feb 2 15:58:05 EST 2015


Yes, I looked at QIF and OFX files from the bank. All the dates match 
those on gnucash.

On 02/02/15 19:20, John Ralls wrote:
>> On Feb 2, 2015, at 10:34 AM, Diarmaid Lee <djlee97 at btinternet.com> wrote:
>>
>> Hello John,
>>
>> Please excuse my ignorance, but how would I do that.
>>
> Please remember to copy the list on all replies by using “Reply All”.
>
> Never mind. I checked the QIF format and it doesn’t do times, only dates, so my hypothesis is wrong. Since QIF provides only dates, perhaps the dates in the QIF format don’t match the bank: Please examine the QIF file in any text editor and try to match some of the transactions to the bank’s website and see if they agree.
>
> Regards,
> John Ralls
>
>> On 02/02/15 14:52, John Ralls wrote:
>>>> On Feb 1, 2015, at 1:06 PM, Diarmaid Lee <djlee97 at btinternet.com> wrote:
>>>>
>>>> Hi,
>>>>
>>>> I am hoping you can help me. I am in the UK, using Gnucash 2.6.1 on Linux Mint 17.1 Xfce 64-bit. I am new to Linux and Gnucash, previously I have been using ms money on Vista.
>>>>
>>>> I can navigate my way around a computer, but not very proficiently.
>>>>
>>>> I have managed to import all my files from ms money successfully. I used QIF files, only because this file was first on the gnucash import list.
>>>>
>>>> I then realised that using OFX would be more familiar to me. I know now that OFX is what I'd been using to import bank transactions to money. (My bank is HSBC).
>>>>
>>>> My problem is that all the transaction dates are a day late. eg. all dates that are 19th on the bank web site, come up as 20th in gnucash. Very confusing!
>>>>
>>>> I'm hoping it is just a setting somewhere that I am not aware of. I have looked online but I can find nothing that I can understand to fix this problem for me.
>>>>
>>>> Hope this makes sense.
>>> The only reason for that that comes to mind is that there is a timezone difference between the imported transactions and your present location. Could you paste in a single transaction from one of the QIF files that you imported?
>>>
>>> Regards,
>>> John Ralls
>>>



More information about the gnucash-user mailing list