OFX file import - Wrong transaction amounts.
Anthony G. Williams
tonyandness at gmail.com
Thu May 28 06:07:35 EDT 2015
On 28/05/2015 07:47, Plutocrat wrote:
> DoctorKeo wrote on Wednesday, 27 May, 2015 09:00 PM:
>> Hi - I must be missing some setting somewhere, as the import goes
>> well from
>> my bank (HSBC) BUT any transactions over 1000, are a 1000 times too
>> small -
>> £1,200.00 is treated as £1.20. I think it is the comma in the
>> Any suggestion please
> I would start by looking at your country/locale/language settings.
> Some countries use a comma instead of a decimal point.
> If your OFX file is using a decimal point, then I'm guessing your
> computer and/or Gnucash should also be set to a locale which uses that
> gnucash-user mailing list
> gnucash-user at gnucash.org
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
Thanks for your suggestions - I tracked the problem down, amazingly,
HSBC does not comply with the Open Financial Exchange Specification
1.0.2 (OFX) - they include a spurious comma to mark the thousands.
Their tech department first claimed that the OFX download file was to
their standard - not the International one - and then decided that that
was not the best thing for a World Bank to say, and are 'looking into it'
More information about the gnucash-user