Until this is fixed so *.OFX can be imported, I have developed this workaround. ( For information only.)
Issue: HSBC UK - Business will only download statements on *.OFX or CSV format. QB-UK-Desktop Premier 2021 will not import *.OFX currently, despite the help file saying otherwise, only *.QBO.
Workaround: The QBO XML type format is almost the same as OFX but with an added INTU.BID field and account type field changed to CHECKING (from DDA supplied by HSBC) plus another minor changes.
It used to be possible to just rename the file from *.ofx to *.qbo, with any working value put into INTU.BID but now there HAS to be a valid and matching INTU.BID entry to ensure its a participating financial institution and any whitespace or typos mean it will not import and will error out.
HSBC is listed as one of the very few UK participating institutions and it probably works fine on the Online version so it HAS to have a valid INTU.BID number.
This can be found in the FIDIR.txt file of your QB installation or you can use this link. (UK only)
https://ofx-prod-filist.intuit.com/qb3000-uk/data/fidir.txt
The solution is to use a 3rd party solution (I used BANK2QBO) to convert the *.ofx to *.qbo and force the software to use 'Bank INTU.BID=10596' (in the case of HSBC UK Business) and change the currency to £. I also changed the date display format to DD/MM/YY but this is probably not effecting the conversion.
Seems to import fine now but haven't fully tested.
PS. I used to be (and still am sometimes) a programmer, so found it easy to solve but I fear until this is sorted, its an issue that needs fixing.
