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 
>> transaction.
>> Any suggestion please
> I would start by looking at your country/locale/language settings. 
> Some countries use a comma instead of a decimal point.
> http://www.dfa.cornell.edu/treasurer/cashoperations/cashmanagement/internationalfunds/conversion.cfm 
> 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 
> too.
> P.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> 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'

Thanks again


More information about the gnucash-user mailing list