Wrong date when importing OFX file from HSBC

[John Ralls]

> On Feb 3, 2015, at 12:21 AM, Diarmaid Lee <djlee97 at btinternet.com> wrote:
> 
> All the dates match at the moment because; 1) the bank has to be right as it is the source of information I am relying on, and 2) I imported and reconciled all transactions from money to gnucash so that they are all correct and match with the bank.
> 
> I have an idea now, that the issue is in the import process. Either with gnucash, or something I have done or am doing? I cannot think what though as the gnucash import is very good at guiding me through import proses.
> 
> Garbage in garbage out might not be so very far from that, in that, the import process (either me or gnucash) is making the garbage.
> 

Let's start over.

You have two sets of import files, OFX ones from your bank, which you imported to MS Money, and QIF files which you exported from MS Money to GnuCash. You originally reported that the dates displayed in GnuCash were all 1 day later than those displayed on HSBC's website; presumably they were all correct when displayed in MS Money.

I understand your first paragraph to mean that you have edited the dates in GnuCash to match those on the bank's website.

We can still analyze the problem: Please pick a transaction and examine it in both the OFX file which you got from the bank and the QIF file that you extracted from MS Money. Note that OFX passes a full date-time stamp with a timezone. Please report the following:

The date of the transaction on the bank's website.
The date, time, and timezone of the transaction in the OFX file.
The date of the transaction in the QIF file.

Confirm that the original date displayed in GnuCash for the transaction was a day later than the bank's website.

Regards,
John Ralls